Data Engineer Intermediate

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