Description

Own the design, development, and optimization of complex SQL Server queries, stored procedures, and reporting datasets for company-wide profitability analysis.

This role is hybrid.

Responsibilities

• Build and enhance the profitability reporting solution using manufacturing ERP data.
• Automate manual financial reporting and cost allocation processes currently managed by Finance.
• Extract, transform, and analyze large volumes of operational and financial data to support customer and facility-level profitability.
• Maintain and integrate allocation tables provided by Finance.
• Support data integration workflows using Azure Data Factory and SQL Server Agent.

Required Skills

• 8+ years of SQL development experience with advanced SQL Server skills.
• Expertise in complex query development, stored procedures, performance tuning, and data transformation.
• Experience building reporting and analytics solutions from enterprise data sources.
• Proficiency in Python, Spark, or R for scripting, automation, and large-scale data processing.
• Strong understanding of relational databases, data modeling, and data transformation.
• Experience working with large datasets and automated data processing.
• Hands-on experience with Azure Data Factory.
• Experience with SQL Server Agent scheduling and automation.
• Ability to translate business requirements into technical solutions and communicate effectively with stakeholders.

Preferred Skills

• Experience with manufacturing ERP systems and operational reporting environments.
• Understanding of financial and operational data interactions within ERP platforms, including BOMs and routings.
• Familiarity with standard cost accounting methodologies.

Key Skills

Education

Bachelor's degree