Senior Data Engineer

Senior Data Engineer6 month contract to hireWest MetroPosition 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 Client’s 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 program/project. Create source to target documents for ETL developers and ensure an efficient design.Work with Client and Business SMEs on program/projects 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 programs\projects.Work with ETL and QA to ensure all requirements are met by the solution. Work with DBA’s to tune performanceIdeal candidate:Hardworking and CollabroativeAbility to share experiences/knowledge and lead othersPassionate about the fundamentals of data managementAbility to put together complex pieces of a puzzle to deliver better products or services for your business partnersAble to be a translator between people and teamsUnderstands that incremental changes must be part of the long-term roadmapRequired 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 formPreferred 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 preferredPrior experience in health care and payer domain is preferred.CDMP (certified data management professional) or CBIP (certified business intelligence professional) is nice to have