ETDP Associate - Data Analytics

Highmark Health; Pittsburgh (Allegheny County); Hybrid; USD 70,000 - 90,000; Full time

Job summary

Highmark Health is offering an Enterprise Technology Development Program (ETDP) position in Pittsburgh. This two-year, paid, early-career rotation focuses on the Data Analytics track, providing hands-on experience across teams to design, build, and maintain data pipelines, models, and warehouses.

You will collaborate with data professionals to deliver reliable analytics capabilities while learning modern data technologies.

Qualifications

• Completed at least one quality internship relevant to this position.
• Active involvement in clubs, volunteerism, or other activities outside the classroom.
• Experience designing and analyzing algorithms, data structures, and patterns for scalable systems.
• Experience with SQL and at least one database technology (MySQL, PostgreSQL, MongoDB).
• Experience with data warehousing concepts and solutions (Snowflake, Redshift, BigQuery).

Responsibilities

• Design, develop, and maintain data processes ensuring efficient data movement.
• Participate on project teams in various roles throughout rotations.
• Research best practices and emerging technologies for improvements.
• Maintain data models, databases, and data warehouses for BI/analytics.
• Collaborate with IT, product, analytics, and business teams to gather requirements.
• Perform data analysis to support decision making across departments.
• Ensure compliance and proper approvals throughout data delivery lifecycle.
• Communicate project status and document technical designs.

Skills

Algorithm design

SQL proficiency

Data analysis

Communication

Team collaboration

Problem solving

Education

Bachelor's degree in CS/CE/DS

GPA 3.2+

Tools

Apache Airflow

AWS Glue

Azure Data Factory

Snowflake

Redshift

BigQuery

Job description

Company :enGenJob 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 SUMMARYAs 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 RESPONSIBILITIESDesign, develop, and maintain robust data processes and solutions to ensure the efficient movement and transformation of data across multiple systems Assist and actively participate on project teams in various project rolesAssist and actively participate on project teams in various project rolesResearch best practices, leading technologies, and emerging industry trends for consideration in improvements relating to rotationsDevelop and maintain data models, databases, and data warehouses to support business intelligence and analytics needsCollaborate with stakeholders across IT, product, analytics, and business teams to gather requirements and provide data solutions that meet organizational needsPerform data analysis and provide insights to support decision making across various departmentsAssure compliance for required standards and all necessary approvals have been obtained throughout the data delivery lifecycleEffectively 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 documentationOther duties as assigned or requested.EXPERIENCERequiredHave completed at least one quality internship in a relevant role to this positionActive in one or more club, volunteerism effort, or other activity outside of the classroomExperience in design and analysis of algorithms, data structures, and design patterns in the building and deploying of scalable, highly available systemsExperience 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)PreferredExperience 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 servicesExperience translating requirements, design mockups, prototypes or user stories into technical designsExperience in data governance, data quality, and data securitySKILLSProject DeliveryProblem Solving & Decision MakingWritten & Spoken Communication SkillsCollaborationAbility to achieve stretch goals in a highly innovative and fast paced environmentSQLTeam player: A team player who can work effectively in cross-functional environmentsBasic sense of ownership, urgency, and driveDemonstrated passion for user experience and improving usabilityBasic analytical skills with a focus on details and accuracyEDUCATIONRequiredBachelor’s degree in Computer Science, Computer Engineering, Data Science, Information Systems, or other related fieldGraduated from an accredited Bachelor's (or higher) degree program within the last year3.2 or better GPA from their most recently completed degree program (prior to their start date)SubstitutionsNonePreferredNoneLICENSES or CERTIFICATIONSRequiredNonePreferredNoneLanguage (Other than English):NoneTravel Required:Less than 25%PHYSICAL, MENTAL DEMANDS and WORKING CONDITIONSPosition TypeOffice-Based or Remote PositionPhysical work site requiredFrequentlyDisclaimer: 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