Data Engineering Analyst

Diverse Lynx; Minneapolis (MN); On-site; USD 75,000 - 100,000; Full time

Job summary

A leading company seeks a Data Engineering Analyst to develop and document the extraction of clinical data from McKesson STAR sources. The role requires expertise in ETL processes and collaboration with teams to ensure data accuracy through thorough checks and quality assurance.

Qualifications

• 2+ years with ETL & Data warehousing services.
• Proficiency in KB_SQL and related scripting.
• Database knowledge in McKesson STAR / Cache.

Responsibilities

• Complete file mapping based on provided layouts.
• Write business logic for data transformation.
• Run and interpret quality checks on data.

Skills

Analytical and problem-solving skills

Technical aptitude

Tools

ETL Tools

SQL

Scripting

Job description

Data Engineering Analyst – McKesson STAR Data Extraction

The Role in Brief: The Data Engineering Analyst will be responsible for development, deployment, and documentation required for extracting clinical information from McKesson STAR sources in alignment with supplied specifications. This resource will support members of the Acquisition Services implementation team by providing data and collaborating on adjustments based on validation cycles.

Specific Responsibilities:

1. Implementation:

Data Mapping and Transformation:

• File Mapping: Complete file mapping based on layouts and requirements provided by Project Managers.
• Business Logic: Write business logic (in KB_SQL or other languages as appropriate) for transforming data into product specifications.
• Data Quality Checks: Run and interpret quality checks against loaded data to ensure accuracy and completeness.
• Data Extraction / Data Transfer: Extract data from client source systems and transfer to internal Optum servers.

Troubleshooting and Support:

• Issue Resolution: Troubleshoot issues raised by project managers from root cause identification to resolution.
• Support Requests: Handle support requests and provide timely solutions to ensure client satisfaction.

Collaboration and Communication:

• Stakeholder Interaction: Work closely with clients, project managers, product managers, and other stakeholders to understand requirements and deliver solutions.
• Documentation: Contribute to technical documentation of specifications and processes.
• Communication: Effectively communicate complex concepts, both verbally and in writing, to team members and clients.

Qualifications:

Basic Qualifications:

• Experience: 2+ years working with ETL & Data warehousing services.
• Skills: Strong analytical and problem-solving skills.
• Technical Aptitude: Ability to learn new technologies.

Required Qualifications:

• Database Knowledge: McKesson STAR / Cache
• ETL Tools: STAR Vista Reporting (QREPro, KB_SQL)
• SQL and Scripting: Proficiency in KB_SQL and related procedural scripting

Preferred Qualifications:

• Database Knowledge: Oracle, SQL Server, MySQL
• SQL Skills: Ability to query large data sets and optimize queries
• ETL Tools: MSBI (SSIS/SSRS/SSAS)/Informatica
• US Healthcare Knowledge: Highly preferred
• Health Information Systems: Working knowledge preferred
• Clinical Data Analysis: Highly preferred
• Clinical Processes: Understanding of clinical processes and vocabulary
• Preferred Technology: Azure/AWS, Databricks, Python, Big Data

Soft Skills:

• Analytical and Creative: Highly analytical, curious, and creative
• Organized: Strong organization skills and attention to detail

Ownership: Takes ownership of responsibilities.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without discrimination. We promote and support a diverse workforce across all levels in the company.