IT-Data Engineer/27/TEC043

1. What is the Max Bill Rate? 80
2. What is the specific title of the position? Data Engineer
3. Where is the work to be performed? Please list preferred UHG facility if other please specify i.e. remote work rural etc. Hybrid preferably otherwise remote is ok too
4. Can you please provide a summary of the project/initiative which describes whats being done?

Data profiling and analysis test data governance

Conduct ETL / DW Test Repository Gold Copy optimization troubleshooting debugging Maintenance of Data Masking mapping workflows.

Develops complex data extracts applications and ad-hoc queries using DB/ ETL Tools: Informatica Power Center and/or Informatica Cloud.

Work with the project team both technical and business to establish data requirements from all upstream data sources ensures requirements are accurate and clearly understood by those participating in the project

Designs develops and implements solutions that exemplify modern data software engineering practices

Reuses and/or develops for reuse complex components or capabilities to solve complex problems and needs enhances system design/architecture to simplify and improve resiliency in system interactions and dependencies

Anticipate emerging customer needs and develops cost friendly innovative solutions to meet them - Incorporates business objectives when evaluating processes to remove redundancies and waste considers the customer experience business impact and solution objective when managing risks and development and design of solution Work on Proof of Concepts for Big Data and Data Science

Maintains current perspective on technology trends applying that to personal and team capability growth. Implement strategies directed at acquiring data and promoting the development of new insights across the business

Sorts through large amounts of data to assess for relevancy seeks out multiple sources to gather information

Identifies cause and effect relationships between known and unknown variables

Develop tools techniques and metrics and dashboards for insights and data visualization

Support practices policies and operating procedures and ensures alignment to departmental objectives and strategy

Identifies applicable security/data standards when reviewing requirements and recommends controls to ensure compliance Pro-actively monitors adherence of assigned systems to recommended security settings

Help define acceptance test objectives test cases and assist in system and integration testing

Build solid relationship with IT operational leaders to ensure connectivity to the business

Define best practices and standards for analyzing and processing data. Contribute to technical documentation of specifications and processes

Collaborate with teammates stakeholders and other teams to identify and address systems problems provide input on current and new designs and resolve issues

Implements and continuously improves agile software delivery code management and operations practices.
5. What does the ideal candidate background look like ex: healthcare specific background etc.?

Computer Science bachelors degree or equivalent.

3 years of Data Engineering experience

3 years of experience working with relational databases ORACLE DB2 Writing Complex SQL Queries

3 years of experience with data warehouses/marts relational database architecture design and development

2 years of experience Building ETL/data pipelines using Informatica

2 years of Python experience BOT Development

2 years of Unix scripting experience

Experience working in projects with agile/scrum methodologies

Research writing and communication skills

Ability to work in a team-oriented fast-paced Agile environment managing multiple priorities
6. What does the team make-up look like - how many members and what is the break-down of the teams skill sets ex: 1 PM 4 Developers etc.?
1 Sr.Manager Product Development 1 project manager/scrum master 10 developers
7. What are the top 5-10 responsibilities for this position? Please be detailed as to what the candidate is expected to do or complete on a daily basis

Data profiling and analysis - using Tableau or MicroStrategy DB Tools rnance

Conduct ETL / DW Test Repository Gold Copy optimization troubleshooting debugging Maintenance of Data Masking mapping workflows.

Develops complex data extracts applications and ad-hoc queries using DB/ ETL Tools: Informatica Power Center and/or Informatica Cloud.

Work with the project team both technical and business to establish data requirements from all upstream data sources ensures requirements are accurate and clearly understood by those participating in the project

Reuses and/or develops for reuse complex components or capabilities to solve complex problems and needs enhances system design/architecture to simplify and improve resiliency in system interactions and dependencies
8. What skills/attributes are a must have Please be detailed as to number of years of experience?

3 years of Data Engineering experience

3 years of experience working with relational databases ORACLE DB2 Writing Complex SQL Queries

3 years of experience with data warehouses/marts relational database architecture design and development

2 years of experience Building ETL/data pipelines using Informatica

2 years of Python experience BOT Development

1 years of Unix scripting experience

9. What skills/attributes are nice to have?

Healthcare Industry experience

Developing implementing scalable cloud solutions to match the businesss changing needs

Experience with Business intelligence Tools e.g. MicroStrategy Tableau for data mining data profiling

Experience in complex projects with division or company-wide scope

Experience in Java application deployments CI/CD pipeline development experience in Java and knowledge of micro service architecture

Knowledge of Apache Kafka and micro-service is a plus

Exposure some experience in the following technologies
o DevOps
o Kafka

10. What are the work hours? ex. 9am-5pm day/night shifts rotating shifts etc
9 am to 5 pm
11. What does the interview process look like?
a. How many rounds? 2 to 3 rounds
b. Video vs. phone? Initial screening could be phone then video interview
c. How technical will the interviews be? 1
12. Do you have a candidate already identified for this role? No