Data Engineer
Millennium Software and Staffing Inc
Job Description
We are hiring a Power BI Snowflake Developer to build and optimize data solutions that drive business insights. The role involves designing dimensional data models, developing ELT/ETL pipelines, and managing Snowflake data warehouse objects. You will create efficient SQL transformations, ensure data quality, and enhance performance.
On the BI side, you will design Power BI semantic models, develop DAX measures, and deliver interactive dashboards. Collaboration with stakeholders to translate business needs into technical solutions is key. Ideal candidates have strong experience in Snowflake, Power BI, SQL, and data modeling, with the ability to work in an agile, fast-paced environment.
Mandatory Requirements: 2–5 years of experience in data warehousing and dimensional modeling (star/snowflake schema, SCDs, surrogate keys) Hands-on experience with Snowflake (SQL development, data transformations, warehouse objects) Strong expertise in advanced SQL (queries, views, stored procedures, performance tuning) Experience building Power BI semantic models (datasets, Power Pivot) Proficiency in DAX for KPIs, measures, and business calculations Experience with Power Query (M) for data connectivity and light transformations Proven ability to design interactive Power BI dashboards and reports Experience with ETL/ELT pipelines and data integration from multiple sources Strong understanding of data quality, validation, and reconciliation processes Knowledge of performance optimization (Snowflake + Power BI) Ability to work in Agile environments and collaborate with stakeholders Strong analytical, problem-solving, and communication skills