Data Engineer Intermediate

It's fun to work in a company where people truly BELIEVE in what they are doing!

Headquartered in Arvada, Colorado with operations and presence in Europe, the Middle East, India, Asia, Japan and China, Sundyne is a global manufacturer of precision-engineered, highly reliable, safe and efficient centrifugal pumps and compressors for use in chemical, petrochemical, hydrocarbon, hydrogen, pharmaceutical, power generation and industrial applications. Sundyne is a leader in delivering precision-engineered and highly reliable pumps & compressors to many of the world's most important markets, including energy, chemical, industrial, carbon capture, clean hydrogen, and renewable fuels. Sundyne pumps and compressors are available in API, ANSI/ASME, ISO and other industry compliant designs. To learn more about the Sundyne family of precision-engineered pumps and compressors, please visit www.sundyne.com.

Position Description

Sundyne is seeking an

Intermediate Data Engineer

on-site in our Arvada CO office, Remote or Remote Hybrid. Responsibilities will be to enhance our existing SSIS Data Analytics Cubes and DataSet solutions along with developing data mart and data warehouse and establish the roadmap for the next generation of Data/ML/AI tool sets. Support, Maintain and Enhance our Data warehouse solutions that provide our business leaders with the data and insights they need to make decisions and service our customers with excellence.

Job Duties & Responsibilities

The primary responsibility of the Data Engineer is to create and provide business value from corporate data assets by Building/supporting multi-dimensional & tabular data models using SSIS, SSRS and other Microsoft technologies to enhance our Data Warehouse

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) as well as 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.

Ability to embrace and leverage new technologies while working effectively with other information technology professionals and business users to ensure that the data solutions and platforms are stable, affective, efficient and provide value to business needs.

Assist in leading the data management and governance processes with the strategic and operational definition, design, implementation, and continuous innovation. Also ensure Data Security, Privacy, Protection, Integrity, and Sensitivity

Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.

Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts.

Develop strong data documentation about algorithms, parameters, models, data flows, and Transformation. Ensure accuracy of data thru testing and Business QA processes

Skills & Abilities

Degree in data engineering, Computer Science, Statistics, or related fields within advanced data and analytics

6 + years Data Engineer using MS SQL Server, TSQL and SSIS

Must understand Relational and Dimensional database modeling.

Must exhibit a deep understanding and 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)

Must have proven experience in ETL and experience in Tools to support Data Migration from one or more Source(s) 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, Power Point, Teams, Share Point

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

Additional Skill Sets A Plus

Microsoft Dynamics CRM System data

RDBMS skills with dimensional modelling (SSMS)

Azure Data lakes and AI/ML feature sets.

Azure Databricks, Azure Data Factory, Azure Synapse, Fabric

Python, Power Shell

If you like growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!

Compensation Details Annual Salary: $120,000.00 - $125,000.00

Additional Compensation The Salary offered will be determined based on the applicant's education, experience, skills, knowledge, abilities, and will be compared with internal equity along with market data for this position. This position may be eligible to participate in the Company's Sales Incentive Plan with a target of up to 30% of base salary, subject to the terms and conditions of the plan. Payment is based on individual performance against established sales targets. This position may also be eligible to receive a Relocation bonus, payable as a taxable lump sum, in accordance with the Sundyne Relocation Policy.

Application Deadline: 2025-04-09