Data Analyst

STULZ Air Technology Systems, Inc.
Frederick, United States of America
18 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Frederick, United States of America

Tech stack

Microsoft Windows
Business Analytics Applications
Data analysis
Business Software
Information Systems
Data Dictionary
Data Governance
Data Warehousing
Database Queries
Document-Oriented Databases
Python
SQL Azure
MySQL
Performance Tuning
Power BI
SharePoint
SQL Stored Procedures
SQL Databases
Scripting (Bash/Python/Go/Ruby)
Freeform SQL
Model-Driven Development
Microsoft Power Automate
Snowflake
Software Application Programming
Powerquery
Data Layers
Information Technology
Data Analytics
Powerapps
Redshift

Job description

Designs, develops, and maintains enterprise data analytics solutions, business intelligence dashboards, and Microsoft Power Platform applications that drive decision-making across manufacturing operations, engineering, finance, and executive leadership. Partners with cross-functional stakeholders to transform complex data into trusted, scalable, and user-friendly products by performing the following duties., * Design, develop, and maintain enterprise dashboards, KPI scorecards, and decision-support reporting in Power BI using SQL, DAX, and Power Query to enable executive and operational decision-making.

  • 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).
  • Use Python or similar scripting languages for data analysis, automation, integration, and quality validation tasks.
  • Champion self-service analytics by consolidating recurring ad-hoc requests into governed, scalable dashboards and apps, and by enabling business users through training and documentation.
  • Validate, QA, and document data products to ensure accuracy, reliability, security, and adoption; support data governance and modernization of legacy data assets.
  • Other duties as assigned.

Requirements

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions., * 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.

Certificates, Licenses, Registrations:

  • 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.

Language Skills:

  • Ability to read, write, and communicate fluently in English; strong written and verbal communication skills for translating technical concepts for non-technical stakeholders.
  • Ability to read and interpret technical documentation, data dictionaries, schema diagrams, and business requirements documents.

Mathematical Skills:

  • 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.

Apply for this position