Data Engineer

Data Engineer Location: Sleepy Eye, MN (Hybrid 2 days a week) Position Overview & Responsibilities Looking for a self-motivated Data Engineer to join our Decision Science team. In this position, you will play a significant role in helping grow and modernize our analytics services. As part of the company's data operations, the data engineer will ensure accuracy in decision science and reporting as well as responsibility for collecting, managing, and converting raw data into information that can be interpreted by the business. You will design and develop data collection frameworks for structured and unstructured data including Data Pipelines, ELTs and ETLs to connect large datasets from a variety of sources. You will also engineer reports, dashboards, and visualizations using enterprise business intelligence tools. This individual will need effective communication skills, communicating up, down and across the organization. This individual will also require the skill to multitask and manage simultaneous project activities that require innovative problem solving. Our ultimate goal is data accessibility to enable the organization to leverage data for performance evaluation and optimization. Major Areas of Responsibility Engineer and implement data models for dimensions and facts within the staging and warehouse layer of our enterprise data lake house. Engineer and implement new and modify existing ETLs, data pipelines, and ELTs to move data from a variety of source systems, including structured and unstructured data, to fit into dimensional data models with large data sets. Engineer schedules and orchestrations for batch and near real time data loads into the enterprise data lake house. Troubleshoots, identifies issues and remediates data performance issues that come with developing, querying, and combining large data sets from a variety of sources. Collaborate with a variety of business users to understand definitions of data, analytics use cases, and assist in building data governance and detailed data requirements. Support and establish reports, dashboards, and visualizations using Power BI. Responsible for executing simultaneous project activities that require innovative problem solving. Provides 2nd level employee support for decision science services. Research tools, disciplines and industry trends and recommend improvements for team or company consideration. Other duties assigned within the scope, responsibility, and requirements of the job. Education, Training and Experience Requirements: Minimum formal education required: Associates/Bachelor's degree in data and analytics or an IT related discipline or 4 years of equivalent work experience. 2 or more years of experience in a corporate IT Team environment. Exceptional technical skills required. Cloud based tools (examples include Power BI, Data Factory, Databricks, Snowflake, H20.ai, Excel, database management, etc.). 2-3 years Programming/scripting experience (SQL and/or Python) and working knowledge of the software development life cycle. 2 years of experience engineering within a data warehouse or related experience with dimensional data modeling. 2 years of experience designing and developing ETLs with tools like Microsoft SSIS Proven ability to gather detailed technical requirements to design and develop business intelligence report solutions from beginning to end. Clear, concise, and precise written and verbal communication skills to effectively communicate with people of various backgrounds including non-technical audiences. Ability to multi-task and to prioritize objectives, anticipate situations and take quick action. Computer skills required: Working knowledge of Microsoft Office Suite including Visio Strict adherence to company confidentiality and ethical standards. DICE mshawc4techservices.com