Senior Data Engineer

About the role

The Indiana Management Performance Hub (MPH) provides analytics solutions to improve outcomes for Hoosiers. This role involves developing and leading data engineering strategies, working with various stakeholders, and ensuring data quality and stewardship.

Responsibilities

• Develop the data technology strategy, including resolving data integration issues and crafting a universal vision for data integration.
• Collaborate with solution leads, project managers, data architects, data scientists, and data analysts on solution design, architecture, and implementation.
• Extract, transform, and load data from various data sources using data engineering tools and methods.
• Document and demonstrate solutions through documentation, flowcharts, layouts, diagrams, charts, code comments, and clear code.
• Improve operations by conducting systems analysis and recommending changes in policies and procedures.
• Provide thought leadership in data warehousing schema and database performance tuning.
• Design and implement data solutions for integration and synthesis across multiple secure systems.
• Develop and enforce new data management policies and design standards for data engineering.
• Provide advice, training, and technical support for various projects.
• Lead project activities such as requirements gathering, solution reviews, and explain technical complexities to non-technical personnel.
• Oversee the throughput of work in progress assigned to the data engineering team.
• Lead data engineering projects and mentor team members on their projects.

Requirements

• Bachelor’s Degree with coursework in analytics, informatics, computer science, mathematics, and/or engineering and 4+ years of experience, or Master’s Degree with coursework in analytics, informatics, computer science, mathematics, and/or engineering and 2+ years of experience, or 7 + years of experience applying the outlined knowledge, skills, and abilities in a similar role.
• Experience utilizing data engineering/management platforms, concepts, languages, and tools.
• Experience/exposure to cloud computing platforms.
• Working knowledge of how the front-end reporting tool influences the relational database.
• Broad knowledge base using SQL and/or Python to query and process large data sets to perform profiling, data quality assessments, manipulating data, drawing insights from large data sets, as well as being familiar with software needs for automation.
• Strong understanding of relational and dimensional databases, theories, architectures, principles, and extract, transform, load (ETL) practices.
• Strong communication skills and ability to communicate complex data engineering concepts to technical and non-technical staff as well as translate business requirements into technical specifications.

Qualifications

• Bachelor’s Degree with coursework in analytics, informatics, computer science, mathematics, and/or engineering and 4+ years of experience, or Master’s Degree with coursework in analytics, informatics, computer science, mathematics, and/or engineering and 2+ years of experience, or 7 + years of experience applying the outlined knowledge, skills, and abilities in a similar role.

Skills

• Experience utilizing data engineering/management platforms, concepts, languages, and tools.
• Experience/exposure to cloud computing platforms.
• Working knowledge of how the front-end reporting tool influences the relational database.
• Broad knowledge base using SQL and/or Python to query and process large data sets to perform profiling, data quality assessments, manipulating data, drawing insights from large data sets, as well as being familiar with software needs for automation.
• Strong understanding of relational and dimensional databases, theories, architectures, principles, and extract, transform, load (ETL) practices.
• Strong communication skills and ability to communicate complex data engineering concepts to technical and non-technical staff as well as translate business requirements into technical specifications.

Pay

The salary for this position traditionally starts at $79,118 but may be commensurate with education or work experience. Use our Compensation Calculator to view the total compensation package.

Schedule

N/A

Benefits

The State of Indiana offers a comprehensive benefits package for full-time employees that includes:

• Three (3) medical plan options (including RX coverage) as well as vision and dental plans
• Wellness Rewards Program: Complete wellness activities to earn gift card rewards
• Health savings account, which includes bi-weekly state contribution
• Deferred compensation 457(b) account (similar to 401(k) plan) with employer match
• Two (2) fully-funded pension plan options
• A robust, comprehensive program of leave policies covering a variety of employee needs, including but not limited to: 150 hours of paid New Parent Leave and up to eight weeks of paid Childbirth Recovery Leave for eligible mothers
• Up to 15 hours of paid community service leave
• Cumulative 180 hours of paid vacation, personal, and sick leave time off
• 12 paid holidays, 14 in election years
• Education Reimbursement Program
• Group life insurance
• Free Parking for most positions
• Free LinkedIn Learning access

Equal Employment Opportunity

The State of Indiana is an Equal Opportunity Employer and is committed to recruiting, selecting, developing, and promoting employees based on individual ability and job performance. Reasonable accommodations may be available to enable individuals with disabilities to complete the application and interview process as well as perform the essential functions of a role.