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 compre

Position Description

Sundyne is seeking anIntermediate Data Engineeron-site in our Arvada CO office, Remote or Remote Hybrid. Responsibilities will be toenhance our existing SSIS Data Analytics Cubes and DataSet solutions along with developing datamart and data warehouse and establish the roadmapfor the next generation of Data/ML/AI tool sets. Support, Maintain and Enhance ourData 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 Engineeris to create and provide business value from corporate data assets byBuilding/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 andgovernanceprocesses 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 fieldswithin 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 fro 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 APlus