ETDP Associate - Data Analytics

Highmark Health; Pittsburgh (Allegheny County); Remote; USD 60,000 - 95,000; Full time

Job summary

enGen is seeking an early-career data analytics professional to join the Enterprise Technology Development Program (ETDP). This two-year, paid rotational program focuses on data analytics, building and optimizing data pipelines, and delivering high-quality data solutions.

You will work with data professionals across multiple teams to design, develop, and maintain data infrastructure, ensuring data quality and reliable data flow throughout our systems.

Qualifications

• Completed at least one quality internship in a role related to this position
• Active in one or more club, volunteerism effort, or other activity outside of the classroom
• Experience in design and analysis of algorithms, data structures, and design patterns for scalable, highly available systems
• Experience in SQL and at least one database technology (e.g. MySQL, PostgreSQL, MongoDB)
• Experience in at least one data warehousing concept and solutions (e.g. Snowflake, Redshift, BigQuery)

Responsibilities

• Design, develop, and maintain data processes to ensure efficient movement and transformation of data across systems
• Assist and participate on project teams in various project roles
• Research best practices and emerging technologies for rotations
• Develop and maintain data models, databases, and data warehouses for BI and analytics
• Collaborate with IT, product, analytics, and business teams to gather requirements and deliver data solutions
• Perform data analysis and provide insights for decision making
• Ensure compliance for standards and approvals throughout data delivery
• Communicate with team, customers, and management and document requirements and sprint reviews
• Other duties as assigned

Skills

Project Delivery

Problem Solving

Communication

Collaboration

Ownership

SQL

Team Player

Attention to detail

Education

Bachelor’s degree in CS/CE/Data Science

Graduated within the last year

GPA 3.2 or better

Tools

MySQL

PostgreSQL

MongoDB

Snowflake

Redshift

BigQuery

Airflow

AWS

Azure Data Factory

Job description

Company :

enGen

Job Description :

Applicants must be authorized to work in the U.S. independently. At this time, we do not offer visa sponsorship for this role.

JOB SUMMARY

As part of the Enterprise Technology Development Program (ETDP), this role participates in a two-year, paid, early-career rotational development program within the Data Analytics track. Associates gain hands‑on experience across multiple teams while contributing to meaningful business and technology initiatives.

This job is an integral member of one of our technical teams responsible for supporting the design, development, and maintenance of our data infrastructure, ensuring the efficient and reliable flow of data across our systems. The incumbent will work closely with our data professionals, analysts, and engineers to build and optimize data pipelines, ensuring data quality and integrity. The incumbent will be involved in every aspect as part of the data process from idea generation, analysis, design, build, and support using the latest various technologies and design patterns. Uses minimal judgement and discretion to assist in collaboration with customers to understand data, reporting, and analytical capability needs, gather project specifications, create data sets, operational reports, and analytical deliverables, analyze data to determine business problems, trends, or opportunities for process improvements, verify delivery of customer data needs, and ensure quality delivery.

ESSENTIAL RESPONSIBILITIES

• Design, develop, and maintain robust data processes and solutions to ensure the efficient movement and transformation of data across multiple systemsAssist and actively participate on project teams in various project roles
• Assist and actively participate on project teams in various project roles
• Research best practices, leading technologies, and emerging industry trends for consideration in improvements relating to rotations
• Develop and maintain data models, databases, and data warehouses to support business intelligence and analytics needs
• Collaborate with stakeholders across IT, product, analytics, and business teams to gather requirements and provide data solutions that meet organizational needs
• Perform data analysis and provide insights to support decision making across various departments
• Assure compliance for required standards and all necessary approvals have been obtained throughout the data delivery lifecycle
• Effectively communicate with team members, customers, partners and management, including assisting with or conducting requirement walkthroughs and sprint reviews, reporting project status, enabling vendor solutions and providing accurate and concise documentation
• Other duties as assigned or requested.

EXPERIENCE

Required

• Have completed at least one quality internship in a relevant role to this position
• Active in one or more club, volunteerism effort, or other activity outside of the classroom
• Experience in design and analysis of algorithms, data structures, and design patterns in the building and deploying of scalable, highly available systems
• Experience in SQL and at least 1 database technology (e.g. MySQL, PostgreSQL, Mongo DB)
• Experience in at least one data warehousing concept and solutions (e.g. Snowflake, Redshift, BigQuery)

Preferred

• Experience with data pipeline and workflow management tools (e.g. Apache Airflow, AWS Glue, Azure Data Factory)
• Experience in at least one Cloud platform (e.g. AWS, Azure, GCP) and their respective data services
• Experience translating requirements, design mockups, prototypes or user stories into technical designs
• Experience in data governance, data quality, and data security

SKILLS

• Project Delivery
• Problem Solving & Decision Making
• Written & Spoken Communication Skills
• Collaboration
• Ability to achieve stretch goals in a highly innovative and fast paced environment
• SQL
• Team player: A team player who can work effectively in cross-functional environments
• Basic sense of ownership, urgency, and drive
• Demonstrated passion for user experience and improving usability
• Basic analytical skills with a focus on details and accuracy

EDUCATION

Required

• Bachelor’s degree in Computer Science, Computer Engineering, Data Science, Information Systems, or other related field
• Graduated from an accredited Bachelor’s (or higher) degree program within the last year
• 3.2 or better GPA from their most recently completed degree program (prior to their start date)

Substitutions

• None
  

Preferred

• None

LICENSES or CERTIFICATIONS

Required

• None

Preferred

• None

Language (Other than English):

• None

Travel Required:

• Less than 25%

PHYSICAL, MENTAL DEMANDS and WORKING CONDITIONS

Position Type

• Office-Based or Remote Position

Physical work site required

• Frequently

Disclaimer: The job description has been designed to indicate the general nature and essential duties and responsibilities of work performed by employees within this job title. It may not contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to do this job.

Compliance Requirement : This job adheres to the ethical and legal standards and behavioral expectations as set forth in the code of business conduct and company policies.

As a component of job responsibilities, employees may have access to covered information, cardholder data, or other confidential customer information that must be protected at all times. In connection with this, all employees must comply with both the Health Insurance Portability Accountability Act of 1996 (HIPAA) as described in the Notice of Privacy Practices and Privacy Policies and Procedures as well as all data security guidelines established within the Company’s Handbook of Privacy Policies and Practices and Information Security Policy.

Furthermore, it is every employee’s responsibility to comply with the company’s Code of Business Conduct. This includes but is not limited to adherence to applicable federal and state laws, rules, and regulations as well as company policies and training requirements.

Highmark Health and its affiliates prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on any category protected by applicable federal, state, or local law.

California Consumer Privacy Act Employees, Contractors, and Applicants Notice