Data Warehouse & BI Engineer/Architect
Data BI Architect
Roles and Responsibilities
Conceptualize, design and build enterprise data warehouses
Create and maintain optimal ETL pipelines to populate operational repositories and warehouses.
Author reports and visually smart dashboards using Tableau
Perform the role of a technical steward and assist Data Governance team maintain the glossary and lineage of the terms in the warehouse
Adhere to and enforce database development and data delivery standards
Identify poorly performing SQL queries and optimize for performance
Work closely with the business teams, business analysts to understand requirements and produce high quality deliverables
Support data issues with production applications.
Monitor and manage the health of the database servers
5+ years of experience in dimensional data modeling, ETL development, and data warehousing
5+ years of PLSQL/T-SQL development experience on SQL Server (preferred) /Oracle/Sybase
Excellent knowledge of SQL
Experience with Tableau or comparable experience with other BI visualization tools such as Microsoft Power BI, Tibco SpotFire etc.
Experience with integration of data from multiple data sources.
Bachelor’ s degree or higher in Computer or Information Science
Ability to effectively communicate with both business and technical teams
Experience in asset management industry is preferred
Experience with master data management tools (Markit EDM, Informatica MDM) is a plus
Experience with big data tools: Hadoop, Spark, Kafka, etc. is a plus
Ability to work and thrive under pressure in a fast paced, mission critical environment
Detail oriented with excellent communication skills