Data Analytics Engineer

We are seeking a skilled and proactive Data Analytics Engineer to design, build, and maintain our organization’s analytics and data ecosystem, while supporting data-driven solutions built on the Microsoft Power Platform. This role is critical to delivering reliable, scalable data pipelines and analytics solutions that support reporting, insights, and operational workflows across departments. The successful candidate will have hands-on experience in data modeling, transformation, and analytics engineering, strong SQL proficiency, Python scripting skills, and the ability to collaborate effectively with both technical and non-technical stakeholders. They will translate business needs into well-structured datasets, analytical outputs, and Power Platform solutions such as Power BI, Power Apps, and Power Automate that leverage analytics outputs. Major Responsibilities: Core Analytics & Data Engineering - 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. Analytics & Reporting Enablement - 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. Power Platform Enablement (Secondary Scope) - 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. Collaboration & Continuous Improvement - 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.

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 transformation and scripting; Experience with Microsoft Power Platform (Power BI, Power Apps, Power Automate); Experience in designing and maintaining analytics-ready datasets and data models; Ability to troubleshoot data quality, performance, and pipeline issues; Strong collaboration skills with both technical and non-technical stakeholders; Experience documenting analytics solutions, datasets, and integration patterns; Ability to mentor junior team members and contribute to team knowledge development.