Data Engineer

Cornerstone Global Partners (CGP Group); Schaumburg (IL); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading analytics solutions provider is looking for a Data Analytics Engineer in Schaumburg, Illinois. This role is crucial for designing innovative analytics solutions using Microsoft Fabric and collaborating with stakeholders to ensure data needs are met. Candidates should have over 5 years of experience with Microsoft Fabric and a strong background in SQL and data analytics. This position offers the opportunity to work in a fast-paced environment, ensuring high-quality analytics assets are delivered to drive business decisions.

Qualifications

• 5+ years of hands-on experience with Microsoft Fabric in an enterprise analytics environment.
• 4+ years of experience designing and delivering data analytics or BI solutions.
• Strong experience with SQL and relational database technologies.

Responsibilities

• Design, develop, and implement analytics solutions leveraging Microsoft Fabric.
• Develop SQL queries and transformation logic to extract, load, and transform data.
• Partner with business stakeholders to gather and document analytics requirements.

Skills

Hands-on experience with Microsoft Fabric

SQL and relational database technologies

Experience with Power BI or comparable visualization tools

Education

Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field

Tools

Microsoft Fabric

Power BI

SQL Server

Job description

The Data Analytics Engineer plays a critical role in designing, developing, and supporting enterprise analytics solutions built on Microsoft Fabric. This position bridges business requirements and technical execution by translating data needs into scalable, secure, and high-quality analytics assets.

The role combines hands-on development with cross-functional collaboration to ensure analytics solutions are reliable, governed, and aligned with business priorities.

Key Responsibilities

Analytics Engineering & Microsoft Fabric Development

• Design, develop, and implement analytics solutions leveraging Microsoft Fabric, including Power BI, OneLake, semantic models, and data pipelines.
• Build and maintain data models including relational, dimensional, star, and snowflake schemas.
• Develop SQL queries and transformation logic to extract, load, and transform data from multiple sources.
• Create dashboards, reports, scorecards, and visualizations for operational and executive audiences.
• Administer and support enterprise Fabric environments, including workspace design, security, and lifecycle management.

Data Quality, Governance & Standards

• Establish and enforce analytics standards and best practices within the Fabric ecosystem.
• Conduct regular data profiling and quality assessments.
• Support metadata management, lineage, data security, and governance controls.
• Perform routine audits of analytics assets and ensure compliance with internal policies.

Business Collaboration

• Partner with business stakeholders to gather, document, and refine analytics requirements.
• Translate business questions into actionable data solutions.
• Prepare process flows, data flow diagrams, and technical documentation.
• Lead and support User Acceptance Testing (UAT) efforts to validate analytics deliverables.

Testing & Delivery

• Develop and execute test plans including unit, integration, system, and regression testing.
• Document test results and collaborate on issue resolution.
• Support production deployments, enhancements, and ongoing optimization.

Project & Stakeholder Management

• Contribute to project planning, scope definition, and milestone tracking.
• Communicate progress, risks, and dependencies to technical and business stakeholders.
• Respond to analytics-related user issues in alignment with service expectations.

Qualifications

Required

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field.
• 5+ years of hands-on experience with Microsoft Fabric in an enterprise analytics environment.
• 4+ years of experience designing and delivering data analytics or BI solutions.
• Strong experience with SQL and relational database technologies (e.g., SQL Server, Oracle, or similar).
• Experience developing analytics using Power BI or comparable visualization tools.

Preferred / Plus

• Experience with Snowflake, Databricks, or modern cloud data platforms.
• Experience with DBT or similar transformation frameworks.
• Experience working in regulated or highly governed environments.
• Familiarity with data security, role-based access control, and analytics governance models.