Data Engineer (BI focus)
Core
Design data warehouse models, build ETL pipelines, and develop Power BI reports for business-ready reporting in financial services.
Role type
BI-focused Data Engineer
Builds
Data warehouse models, source-to-target pipelines, Power BI reports
Domain
Financial services, Data Engineering, Business Intelligence
Required skills
Power BI (Desktop/Service, Power Query, DAX), SQL, Data Warehousing (Kimball, Star/Snowflake schemas, SCDs), dbt, Relational Data Warehouses (Redshift, SQL Server)
Preferred skills
AWS
Responsibilities
Design dimensional models (facts, dimensions, star schemas, SCDs), Build and maintain source-to-target pipelines using dbt and SQL, Develop Power BI reports from scratch, Work with stakeholders to capture requirements and write technical specifications, Build data validation, reconciliation, and quality controls, Tune SQL and models for performance
Seniority
Mid-Senior (4+ years experience)
