Data and Analytics Engineer

This is a fully remote position, open to applicants in Illinois.

📋 Description

• Design and implement contemporary data platforms utilizing Microsoft Fabric and Databricks.

• Build and enhance data ingestion, transformation, and orchestration pipelines by applying ELT/ETL best practices.

• Develop scalable lakehouse architectures for analytics, reporting, and downstream data products.

• Convert business and analytical requirements into technical data models.

• Write, optimize, and fine-tune SQL and Spark transformations for large-scale analytical workloads.

• Implement version control, CI/CD principles, and code review standards within data engineering workflows.

• Create intricate Power BI data models and enterprise-grade semantic layers.

• Develop interactive reports and dashboards that facilitate client decision-making.

• Create, optimize, and conduct peer reviews of DAX formulas.

• Integrate various data sources into Power BI.

• Ensure data quality, reliability, and usability throughout the analytics platform.

• Empower self-service analytics through reliable datasets and dashboards.

• Collect requirements from client stakeholders, communicate technical concepts, and manage expectations effectively.

• Provide guidance to clients on Power BI solutions and data platform strategies.

• Investigate emerging tools and trends in the field.

• Assist marketing and business development initiatives as a technical specialist.

• Facilitate training sessions and support platform adoption and changes.

• Foster strong client relationships and proactively identify opportunities for added value.

• Collaborate with project managers, architects, and consultants.

• Ensure that solutions adhere to performance, scalability, security, and maintainability standards.

• Contribute to documentation, reusable patterns, knowledge sharing, retrospectives, and data platform standards.

• Maintain a minimum utilization rate of 75%.

⛳️ Requirements

• Bachelor’s degree from an accredited institution.

• Over 5 years of combined experience in data engineering, analytics engineering, and/or BI consulting.

• Practical experience with Microsoft Fabric and/or Databricks; both are strongly preferred.

• Advanced skills in Power BI, encompassing complex data modeling, DAX authoring, and performance optimization.

• Experience with Power BI dataset modeling at an enterprise level and embedding/API scenarios.

• Strong SQL capabilities, including performance tuning and analytical query design.

• Experience in designing analytics data models, such as star schemas, semantic models, and lakehouse patterns.

• Ability to integrate data from various sources into data platforms and BI tools.

• Proven success in a client-facing consulting role, working autonomously and managing stakeholder expectations.

• Strong written and verbal communication skills; data-driven, precise, and client-ready.

• Preferred: experience in migrating or modernizing legacy data warehouses to lakehouse architectures.

• Preferred: experience in integrating data platforms with downstream applications or external APIs.

• Preferred: consulting experience across multiple clients, industries, or verticals.

• Relevant certifications preferred: Azure Solutions Architect, Azure Data Engineer, Microsoft Fabric (DP-600/DP-700), or Databricks certifications.

• Preferred: familiarity with advanced analytics use cases, including AI/ML model integration, predictive dashboards, or advanced statistical analysis.

🏝️ Benefits

• Fully remote work environment.

• Quarterly in-person team experiences.

• Competitive compensation.

• Opportunities for professional development.

• Comprehensive benefits package.

• Unlimited time off.

• 100% covered health insurance, including medical, dental, and vision plans for you and your family.

• Competitive 401(k) plan with a 4% match.

• Educational assistance.

• Technology stipend.

• Discounts on various goods and services.