Senior Data Engineer

Company: On Demand Group
Location: Minnetonka
Posted on: November 24, 2020

Job Description:

Senior Data Engineer 6 month contract to hire West Metro Position Overview Be a leader who strengthens data engineering to support agile growth. Re-engineer the data warehouse and ODS to manage increased demand from analytics and our member and provider portals. Enable transitions to open source, machine learning and Cloud technology based on a solid data foundation. Consult with Domain Data Architects, Business Stakeholders, Data and Application Integration and DBA. Our Data Engineers are responsible for converting Clientrsquos data architecture into physical designs, implementing and maintaining data structures and processing pipelines for the extraction, transformation, and loading (ETL) of data from a variety of data sources. They design and develop robust, scalable solutions that transform data into a useful format for analysis, enhance data flow, and enable efficient, cost effective consumption and analysis of data. They write complex SQL or programs and mentor technical and business users about our data. Engineers evaluate and recommend tools and technologies for data infrastructure and processing. The Data Engineer is involved in these areas Understand business and technical requirements. Convert logical data models to physical data models, DDL, roles and views. Create and update data architecture designs and data flows for subject areas impacted by a programproject. Create source to target documents for ETL developers and ensure an efficient design. Work with Client and Business SMEs on programprojects to understand requirements and identify non-functional requirements that will impact the data design. Actively engaged as core member of scrum teams to deliver on data programsprojects. Work with ETL and QA to ensure all requirements are met by the solution. Work with DBArsquos to tune performance Ideal candidate Hardworking and Collabroative Ability to share experiencesknowledge and lead others Passionate about the fundamentals of data management Ability to put together complex pieces of a puzzle to deliver better products or services for your business partners Able to be a translator between people and teams Understands that incremental changes must be part of the long-term roadmap Required Experience BS in Computer Science or related field. A Master's degree is a plus. 7 years of experience in software development and database applications with a majority of this experience in data strategy, sourcing, modeling, integration, and architecture. Skilled in data analysis, data profiling, data integration, and data quality. Data modeling for logical, physical, dimensional and relational 3NF models. Extensive experience in creating data warehouses, data marts, and operational system databases. Evaluate, analyze, design and implement solutions based on technical requirements. Communicate to a variety of audiences in both verbal and written form Preferred Experience Advanced knowledge of SQL, query tuning, RDBMS, and Query tools. Database performance is a plus. Prior experience in ETL, reporting and analytics, and business intelligence tools is preferred Prior experience in health care and payer domain is preferred. CDMP (certified data management professional) or CBIP (certified business intelligence professional) is nice to have

Keywords: On Demand Group, Minnetonka , Senior Data Engineer, Engineering , Minnetonka, Minnesota