Analytics Engineer

• Design and develop data serving and semantic layers to support business needs ranging from traditional reporting to reverse ETL and LLM/AI implementations.
• Develop data models for use by analysts and applications from across the business using modern dimensional modeling practices to efficiently serve accurate, consistent data.
• Build and maintain robust, scalable data pipelines to extract, transform, and load (ETL, ELT) data from various sources into the data platform using both batch processing and event-driven patterns.
• Create efficient, performant data models to support business requirements and analytics needs.
• Implement and automate data quality checks and monitoring to ensure data accuracy and drive observability.
• Manage, troubleshoot and optimize existing data infrastructure, including cloud-based solutions and on-premises systems.
• Leverage cloud data platforms (Fabric, Databricks, Snowflake, etc.) for data storage, processing, and analysis.
• Work closely with data analysts, data scientists, and business stakeholders to understand their data needs and deliver solutions.
• Identify and resolve data-related issues and challenges for technical and non-technical stakeholders.
• Support company-wide projects ranging from server migrations to mergers and acquisitions as a data and systems expert.
• Automate data processes to improve efficiency and reduce manual effort.
• Implement modern concepts like metadata-driven pipelines and Infrastructure-as-Code that will play a key role in a scalable, resilient data platform.
• Document data processes, architecture, and workflows.

• Collaborate with stakeholders to understand business requirements and translate them into scalable and efficient data analytics solutions.
• Possess in-depth knowledge and hands-on experience with Microsoft Fabric ecosystem (Lakehouse, PySpark/SQL notebooks, data pipelines, and deployment pipelines).
• Understanding Microsoft Dynamics as a data source a big plus.
• Design data models that bridge the Fabric Lakehouse, Power BI semantic models, and reporting layers, ensuring consistency between raw, curated, and business-facing data.
• Optimize data models to support efficient data storage, retrieval, and analysis, ensuring data integrity, accuracy, and reliability.
• Knowledge of Fabric capacity (CU) optimization a big plus.
• Implement data integration pipelines using Microsoft Fabric and other relevant tools to extract, transform, and load data from various sources into a unified data platform.
• Create visually appealing and interactive dashboards, reports, and visualizations using Microsoft Power BI and DAX language, enabling users to gain valuable insights from data.
• Identify performance bottlenecks and implement optimizations to improve data processing, query performance, and overall system efficiency.
• Collaborate with cross-functional teams, providing technical leadership and guidance to data engineers, analysts, and other stakeholders to ensure successful project delivery.
• Keep abreast of the latest advancements in data analytics technologies (Microsoft based and others) and industry trends, continuously enhancing your expertise and applying best practices in solution design and implementation.

Data Analytics Engineer

• Develop and maintain ETL processes to support data ingestion, transformation, and integration.
• Work with various file formats (TXT, CSV, XML, JSON, YAML) to ensure seamless data processing.
• Implement and optimize ETL workflows using EasyMorph, Databricks, Azure Data Factory, Talend, and Apache Nifi.
• Write clean, efficient, and maintainable code using Python, C#, or Java.
• Ensure data quality, accuracy, and integrity across ETL pipelines.
• Collaborate with data engineers and analysts to define and refine ETL requirements.
• Troubleshoot and resolve ETL failures, ensuring minimal downtime and impact.
• Follow test-driven development (TDD) methodologies to improve reliability and maintainability.
• Maintain and document ETL processes, providing insights and recommendations for improvements.

See all jobs on JobTailor

Analytics Engineer

Data Analytics Engineer

Associate ETL Engineer