Data Analytics Engineer

Jobtailor; Deutschland; Vor Ort; EUR 65.000 - 90.000; Vollzeit

Zusammenfassung

Jobtailor is seeking a Data Analytics Engineer to design and maintain analytics-ready datasets and data models for reporting and advanced analytics. You will optimize SQL and ETL/ELT pipelines, build dashboards in Power BI, and enable Power Apps and Power Automate integrations.

You will collaborate with cross-functional teams to translate requirements into reusable analytics, ensure data quality, and support ad-hoc analysis while mentoring junior members.

Qualifikationen

• Bachelor’s degree or equivalent in a STEM field.
• 3–5 years in data analytics engineering or related roles.
• Advanced SQL with CTEs, window functions, complex joins, and performance optimization.
• Python for data manipulation, pipeline scripting, and automation tasks.
• Experience with ETL/ELT pipelines and data warehousing concepts.
• Hands-on with Power BI, Power Apps, and Power Automate.
• Strong communication and teamwork skills.
• Certifications such as Power BI Data Analyst, Azure Data Engineer, Power Platform Functional Consultant, dbt Analytics Engineering preferred.

Aufgaben

• Design, build, and maintain analytics-ready datasets and data models for reporting, dashboards, and analytics.
• Develop and optimize data transformation logic for performant outputs.
• Support curated analytics layers for reusable insights across teams.
• Troubleshoot data quality, performance, and pipeline issues affecting analytics.
• Collaborate with stakeholders to translate requirements into datasets, metrics, and visualizations.
• Enable downstream consumption via reporting tools and dashboards.
• Assist ad-hoc analysis and exploratory data needs as required.
• Support analytics-driven solutions using Power BI, Power Apps, and Power Automate.
• Design and maintain data integrations for Power Platform consumption.
• Collaborate with Power Platform developers to optimize analytics outputs for apps and automation.
• Help troubleshoot data issues impacting Power Platform apps, flows, and reports.
• Work with cross-functional teams to improve analytics workflows and delivery.
• Contribute to continuous improvement of analytics practices and usability.
• Document analytics solutions, datasets, and integration patterns.

Kenntnisse

Advanced SQL

Python

Git

Power BI

Power Apps

Power Automate

ETL/ELT pipelines

Data warehousing

Dimensional modeling

Star/Snowflake schema

Data modeling

SQL performance tuning

Self-service analytics

Ausbildung

Bachelor’s degree in Computer Science, Data Science, Information Systems, Statistics, or related STEM field

Equivalent combination of education, certifications, and experience

Tools

dbt

Azure

Microsoft 365

Power Platform

Jobbeschreibung

Responsibilities

• Design, build, and maintain analytics-ready datasets and data models to support reporting, dashboards, and advanced analytics.
• Develop and optimize data transformation logic to ensure performant and reliable analytical outputs.
• Support the creation of curated analytics layers that enable consistent and reusable insights across teams.
• Troubleshoot and resolve data quality, performance, and pipeline issues impacting analytics delivery.
• Partner with business and technical stakeholders to translate analytical requirements into datasets, metrics, and visualizations.
• Enable downstream consumption of analytics outputs through reporting tools and dashboards.
• Support ad-hoc analysis and exploratory data needs as required.
• Enable and support analytics-driven solutions built using Power BI, Power Apps, and Power Automate.
• Design and maintain data integrations that allow Power Platform solutions to consume analytics datasets efficiently.
• Collaborate with Power Platform developers to ensure analytics outputs are structured and optimized for application and automation use cases.
• Assist in troubleshooting data-related issues impacting Power Platform apps, flows, and reports.
• Work closely with cross-functional teams to improve analytics workflows and delivery processes.
• Contribute to continuous improvement of analytics practices, performance, and usability.
• Document analytics solutions, datasets, and integration patterns to support maintainability and knowledge sharing.
• Write and maintain SQL-based data transformations and automated data quality tests to ensure data integrity.
• Mentor junior team members and contribute to team knowledge development and technical growth.

Requirements

• Bachelor’s degree in Computer Science, Data Science, Information Systems, Statistics, or a related STEM field; or an equivalent combination of education, certifications, and professional experience.
• 3–5 years of experience in data analytics engineering, analytics development, or related roles supporting enterprise analytics solutions.
• Advanced SQL proficiency, including CTEs, window functions, complex joins, and query performance optimization.
• Proficiency in Python for data manipulation, pipeline scripting, and automation tasks.
• Experience with Git version control for collaborative development and code management.
• Experience designing and maintaining ETL/ELT pipelines and data warehouse solutions.
• Strong understanding of data warehousing concepts, dimensional modeling, and star/snowflake schema design.
• Hands-on experience working with Power BI and integrating analytics datasets into Power Apps and Power Automate solutions.
• Strong understanding of data modeling, analytical datasets, and how analytics outputs are consumed by reporting tools and applications.
• Familiarity with Microsoft 365 and Azure Entra ID for secure access to analytics and Power Platform solutions.
• Experience collaborating with Power Platform developers to support analytics-driven apps, reports, and automations.
• Strong communication and teamwork skills, with the ability to explain analytical concepts to non-technical audiences.
• Experience supporting business users and analysts by enabling self-service analytics and data-driven innovation.
• Certifications such as (preferred but not required):
• Microsoft Certified: Power BI Data Analyst Associate
• Microsoft Certified: Azure Data Engineer Associate
• Microsoft Certified: Power Platform Functional Consultant Associate
• dbt Analytics Engineering Certification