Data Analyst Data Warehouse Analytics and BI
Core
Build and maintain a production data warehouse and BI stack to harmonize data from disparate ERPs and deliver trusted reporting across finance, operations, and inventory.
Role type
Senior Data Analyst / Analytics Engineer
Builds
Production analytics stack, Power BI dashboards, and harmonized data models
Domain
Retail/Commercial services, Power BI, Snowflake, dbt
Deliverable
production ML models | dashboards & analysis
Required skills
SQL (complex queries, optimization), Power BI (DAX, data modeling, calculation groups), dbt, cloud data warehousing (Snowflake/OneLake), data reconciliation, stakeholder communication
Preferred skills
AI tools for analytics acceleration, Power Apps integration
Technologies
Snowflake, Power BI, dbt, Fivetran, SQL
Responsibilities
Develop and optimize Power BI reports and semantic models; Write and tune complex SQL queries; Build and refactor dbt models for data harmonization; Reconcile disparate source system definitions; Monitor data pipelines and resolve quality issues; Partner with stakeholders to translate business questions into reliable reporting
Seniority
Mid-level, hands-on IC