Senior Data Engineer

Creative Financial Staffing, LLC; East Lansing (MI); On-site; USD 125,000 - 155,000; Full time

Benefits offered by this job

Free healthcare options

Retirement plan with match

3.5 weeks PTO

Job summary

Creative Financial Staffing, LLC is seeking a Data Engineer to design and maintain scalable data pipelines for an enterprise data warehouse. You will work with Microsoft Fabric, OneLake, and Power BI to transform raw data into actionable insights.

Collaboration with analysts and stakeholders is essential to deliver clean datasets and robust analytics capabilities. The role emphasizes SQL expertise, data modeling, and governance within an agile environment, with a competitive compensation package

Qualifications

• Proficient in SQL with tuning and optimization.
• Experience with enterprise data warehouses and ETL/ELT.
• Knowledge of data modeling (star/snowflake) and governance best practices.
• Strong analytical thinking and collaboration in agile teams.

Responsibilities

• Build and maintain robust data pipelines for ingestion, transformation, and integration.
• Develop and optimize ETL/ELT workflows using Microsoft Fabric Data Factory.
• Write advanced SQL queries, stored procedures, and functions for high-performance data ops.
• Architect and manage data warehouse solutions using Fabric Data Warehouse and OneLake.
• Partner with analysts to deliver clean, actionable datasets for reporting.

Skills

SQL

Advanced SQL

Data modeling

Analytics

Agile

Communication

Tools

Azure Data Factory

OneLake

Databricks

Power BI

Microsoft Fabric

Job description

Position:

Data Engineer

Job Type:

Permanent or Contract-to-Hire

Salary:

$125,000 – 155,000

Benefits:

Free Healthcare options, Retirement Plan w/ match, 3.5 Weeks PTO, etc.

Location:

East Lansing, MI area (Onsite)

Why You Should Apply:

• Outstanding culture with a family-oriented feel, where technology is highly valued.
• Competitive compensation and benefits package with $0 cost healthcare options.
• Work in a modern environment with the latest tools, collaborative spaces, and a strong focus on professional growth.

Job Summary:

We are seeking a Data Engineer with strong SQL skills and hands-on experience working with enterprise data warehouse environments. This role will play a key part in building and maintaining scalable data solutions using Microsoft Fabric and Power BI. If you’re passionate about transforming raw data into meaningful insights and enjoy collaborating across teams to support analytics initiatives, this could be a great fit.

Responsibilities of the Senior Data Engineer:

• Build and maintain robust data pipelines for ingestion, transformation, and integration across diverse systems.
• Develop and optimize ETL/ELT workflows using Microsoft Fabric Data Factory.
• Write advanced SQL queries, stored procedures, and functions to support high-performance data operations.
• Apply best practices in data modeling for enterprise-scale data warehouse environments.
• Architect and manage data warehouse solutions using Microsoft Fabric’s Data Warehouse and OneLake.
• Ensure consistency, reliability, and scalability of data across reporting and analytics platforms.
• Work closely with developers to structure data for efficient Power BI usage, including semantic modeling and partitioning.
• Collaborate with business analysts and stakeholders to gather requirements and deliver clean, actionable datasets.
• Provide guidance on SQL optimization, data governance, and reporting standards.

Preferred Experience of the Senior Data Engineer:

• Advanced SQL skills, including query tuning, indexing, and performance optimization.
• Experience with enterprise data warehouse architecture and implementation.
• Proficiency with Azure Data Factory, OneLake, Databricks, Data Warehouse, and Power BI.
• Solid understanding of data modeling techniques (e.g., star schema, snowflake schema, normalization).
• Experience with data integration, data orchestration and data ingestion
• Familiarity with ETL/ELT processes and orchestration frameworks.
• Strong analytical thinking and problem-solving capabilities.
• Excellent communication and collaboration skills.
• Comfortable working in agile, fast-paced environments.
• Bonus: Experience with real-time analytics and large-scale data processing.
• Bonus: Experience with Microsoft Fabric