Data Engineer Intermediate

$120,000 - $125,000/Yr

Sundyne - Arvada, CO

Full-time - Mid Level

Arvada, CO

Transportation Equipment Manufacturing

About the position

Sundyne is seeking an Intermediate Data Engineer to enhance existing SSIS Data Analytics Cubes and DataSet solutions, develop data marts and data warehouses, and establish a roadmap for next-generation Data/ML/AI toolsets. The role involves supporting, maintaining, and enhancing data warehouse solutions to provide business leaders with insights for decision-making and customer service excellence.

Responsibilities

• Create and provide business value from corporate data assets by building/supporting multi-dimensional & tabular data models using SSIS, SSRS, and other Microsoft technologies.
• Utilize SQL to curate and query large data sets, perform analyses, create custom views, and troubleshoot data anomaly issues back to the source systems.
• Maintain and enhance expertise across an application technology stack (Microsoft SQL) and a technology domain (BI/DW and Data Analytics).
• Design and map data models to shift raw data into meaningful insights and evaluate the effectiveness and capability of new data sources and data gathering techniques.
• Assist in leading the data management and governance processes with strategic and operational definition, design, implementation, and continuous innovation.
• Ensure data security, privacy, protection, integrity, and sensitivity.
• Perform tests and validate all data flows and prepare all ETL processes according to business requirements.
• Document all technical and system specifications for all ETL processes and perform unit tests on all processes.
• Develop strong data documentation about algorithms, parameters, models, data flows, and transformations.
• Ensure accuracy of data through testing and Business QA processes.

Requirements

• Degree in data engineering, Computer Science, Statistics, or related fields with advanced data and analytics.
• 6+ years of experience as a Data Engineer using MS SQL Server, TSQL, and SSIS.
• Deep understanding of relational and dimensional database modeling.
• Strong knowledge of the Microsoft BI Stack, including SSIS, SSRS, SSAS, SharePoint, PowerPivot, Power Query, MDX, DAX, and PowerBI.
• Advanced experience using MS SQL to extract data, understand data structures, run queries, and analyze data in a data warehouse environment.
• Strong understanding of tier one Manufacturing ERP System data (JDE, SAP, Syteline, Navision).
• Proven experience in ETL and experience in tools to support data migration from one or more sources to destination with application of transformation rules.
• Effective communication skills, both written and verbal.
• Highly proficient with Microsoft Office Suite: Excel (advanced features), Word, Outlook, PowerPoint, Teams, SharePoint.
• Strong communication skills and the ability to synthesize findings from analyses into clear, concise communications for business leadership.
• Team player attitude and strong ability to collaborate with colleagues across the globe.

Nice-to-haves

• Experience with Microsoft Dynamics CRM System data.
• RDBMS skills with dimensional modeling (SSMS).
• Familiarity with Azure Data lakes and AI/ML feature sets.
• Experience with Azure Databricks, Azure Data Factory, Azure Synapse, Fabric, Python, PowerShell.

Benefits

• Annual Salary: $120,000.00 - $125,000.00
• Potential participation in the Company's Sales Incentive Plan with a target of up to 30% of base salary, subject to terms and conditions.
• Eligibility for a Relocation bonus, payable as a taxable lump sum, in accordance with the Sundyne Relocation Policy.