Data Analyst

Jobtailor; Frederick (MD); On-site; USD 90,000 - 130,000; Full time

Job summary

Jobtailor is seeking a data analytics engineer to design, develop, and maintain enterprise analytics solutions, BI dashboards, and Power Platform applications for manufacturing operations and leadership.

You will partner with cross‑functional teams to transform complex data into trusted, scalable products, build semantic data models, and deliver end‑to‑end analytics using SQL, Python, and Power Platform.

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Engineering, Mathematics, or a related field; Master’s degree preferred.
• 3-5 years of progressive experience in data analytics, business intelligence, analytics engineering, or a closely related field.
• Advanced proficiency in SQL (complex queries, joins, performance tuning, stored procedures) and demonstrated experience with Power BI (DAX, Power Query, semantic modeling, dashboard architecture).
• Hands‑on experience with Python for data analysis, scripting, or automation; experience designing and maintaining dimensional data models and semantic layers.
• Experience building applications with Microsoft Power Apps and automating workflows with Power Automate is strongly preferred; familiarity with Dataverse, SharePoint, or Microsoft 365 data sources is a plus.
• Manufacturing, supply chain, or operations industry experience is a plus.
• Microsoft certifications such as PL‑300 (Power BI Data Analyst), PL‑400 (Power Platform Developer), or DP‑900/DP‑203 are preferred but not required.
• Ability to read, write, and communicate fluently in English; strong written and verbal communication skills for translating technical concepts for non‑technical stakeholders.
• Strong quantitative and analytical skills; ability to apply concepts of basic statistics, percentages, ratios, and proportions to practical business situations and to validate data accuracy across reporting solutions.

Responsibilities

• Design, develop, and maintain enterprise data analytics solutions, BI dashboards, and Power Platform applications across manufacturing operations, engineering, finance, and leadership.
• Partner with cross‑functional stakeholders to transform complex data into trusted, scalable products by performing duties.
• Build, deploy, and maintain custom business applications using Power Apps and automate workflows with Power Automate to streamline processes.
• Develop and maintain semantic data models, dimensional structures, and reusable reporting layers as the trusted source of truth.
• Partner with Engineering, Operations, Finance, and Product stakeholders to gather requirements, define KPIs, and deliver analytics end to end.
• Write, optimize, and maintain complex SQL queries, stored procedures, and data extracts against enterprise data warehouses and cloud platforms.

Skills

SQL

Power BI

Python

Power Apps

Power Automate

Semantic modeling

Dashboard architecture

Education

Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Engineering, Mathematics, or a related field

Master’s degree preferred

Tools

Snowflake

Azure SQL

Redshift

MySQL

Dataverse

SharePoint

Job description

Responsibilities

• Design, develop, and maintain enterprise data analytics solutions, business intelligence dashboards, and Microsoft Power Platform applications that drive decision‑making across manufacturing operations, engineering, finance, and executive leadership.
• Partner with cross‑functional stakeholders to transform complex data into trusted, scalable, and user‑friendly products by performing the following duties.
• Build, deploy, and maintain custom business applications using Microsoft Power Apps (canvas and/or model‑driven) and automate workflows using Power Automate to streamline manufacturing and back‑office processes.
• Develop and maintain semantic data models, dimensional structures, and reusable reporting layers that serve as the trusted source of truth across the organization.
• Partner with Engineering, Operations, Finance, and Product stakeholders to gather requirements, define KPIs, and deliver multi‑workstream analytics solutions end to end.
• Write, optimize, and maintain complex SQL queries, stored procedures, and data extracts against enterprise data warehouses and cloud platforms (e.g., Snowflake, Azure SQL, Redshift, MySQL).

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Engineering, Mathematics, or a related field; Master’s degree preferred.
• 3-5 years of progressive experience in data analytics, business intelligence, analytics engineering, or a closely related field.
• Advanced proficiency in SQL (complex queries, joins, performance tuning, stored procedures) and demonstrated experience with Power BI (DAX, Power Query, semantic modeling, dashboard architecture).
• Hands‑on experience with Python for data analysis, scripting, or automation; experience designing and maintaining dimensional data models and semantic layers.
• Experience building applications with Microsoft Power Apps and automating workflows with Power Automate is strongly preferred; familiarity with Dataverse, SharePoint, or Microsoft 365 data sources is a plus.
• Manufacturing, supply chain, or operations industry experience is a plus.
• Microsoft certifications such as PL‑300 (Power BI Data Analyst), PL‑400 (Power Platform Developer), or DP‑900/DP‑203 are preferred but not required.
• Ability to read, write, and communicate fluently in English; strong written and verbal communication skills for translating technical concepts for non‑technical stakeholders.
• Strong quantitative and analytical skills; ability to apply concepts of basic statistics, percentages, ratios, and proportions to practical business situations and to validate data accuracy across reporting solutions.