Data Engineer

Company :

Highmark Health

Job Description : 

JOB SUMMARY

*** Due to Department of Defense (DOD) contract requirements, the incumbent who fills this position must be a US citizen and must also pass a background check.***

Work Location: Hybrid/Remote

• If you live within 50 miles of Pittsburgh, PA, you will be required to work on-site Tuesday, Wednesday, and Thursday.
• If you live beyond 50 miles of Pittsburgh, PA, this will be a fully remote role. Remote employees should anticipate limited travel (3-4 times annually) to Pittsburgh, PA for company events

This role is an integral member of a technical team, responsible for supporting the design, development, and maintenance of the organization's data infrastructure, ensuring the efficient and reliable flow of data across various systems. This position is responsible for ensuring the reliable movement, transformation, and storage of data across various platforms. The incumbent will work closely with data professionals, analysts, and engineers to build and optimize data pipelines, ensuring data quality and integrity. The ideal candidate is adaptable, solution-oriented, and capable of collaborating across multiple teams to support a broad range of data initiatives. The incumbent and team will be involved in every aspect of the data process, from idea generation, analysis, design, build, and support, using the latest technologies and design patterns.

ESSENTIAL RESPONSIBILITIES

• Design, develop, and maintain robust data processes and solutions to ensure the efficient movement and transformation of data across multiple systems.

• 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

• Monitor work against the production schedule, provide progress updates, and report any issues or technical difficulties to lead developers regularly.

• Implement and manage data governance practices, ensuring data quality, integrity, and compliance with relevant regulations.

• Collaborate on the design and implementation of data security measures, including access controls, encryption, and data masking

• Perform data analysis and provide insights to support decision-making across various departments

• Stay current with industry trends and emerging technologies in data engineering, recommending new tools and best practices as needed

• Other duties as assigned or requested.

EXPERIENCE

Required

• 3 years of experience in design and analysis of algorithms, data structures, and design patterns in the building and deploying of scalable, highly available systems

• 3 years of experience in a data engineering, ETL development, or data management role.

• 3 years of experience in SQL and experience with database technologies (e.g., MySQL, PostgreSQL, MongoDB).

• 3 years of experience in data warehousing concepts and experience with data warehouse solutions (e.g., Snowflake, Redshift, BigQuery)

Preferred

• Proficiency in Python for data manipulation, scripting, API integrations, and developing robust data engineering solutions.
• Strong SQL skills for complex data extraction, transformation, and loading (ETL/ELT) across various database systems.
• Demonstrated experience with version control systems (Git/GitHub/GitLab) for collaborative development, code management, and deployment best practices.
• Experience implementing and following SDLC best practices for data solutions, ensuring robust development, testing, and deployment.
• Hands-on experience with Google BigQuery or comparable cloud-native data warehouse solutions (e.g., Snowflake, Amazon Redshift, Azure Synapse Analytics) for designing, developing, and optimizing data architecture.
• Knowledge of data governance, data quality, and data lineage best practices.
• Demonstrated experience with dimensional modeling (Star Schema, Snowflake Schema) and other data modeling techniques, including Slowly Changing Dimensions (SCDs).
• Experience with Infrastructure as Code (IaC) tools like Terraform for managing cloud resources.
• Experience building and managing data pipelines using workflow orchestration tools like Apache Airflow or Google Cloud Composer.
• Proficiency with Google Cloud Platform (GCP) services relevant to data engineering, such as BigQuery, Cloud Storage, Cloud Functions, Cloud Dataflow, and Pub/Sub.
• Familiarity with Data Lake/Lakehouse concepts and their application in modern data architectures.
• Solid understanding and practical application of dbt (data build tool) for data transformation, testing, documentation, and version control of data models.
• Experience with Starburst for data federation and analytics.

SKILLS

• Demonstrated ability to achieve stretch goals in a highly innovative and fast-paced environment

• Adaptability: Ability to take on diverse tasks and projects, adapting to the evolving needs of the organization

• Analytical Thinking: Analytical skills with a focus on detail and accuracy

• Interest and ability to learn other data development technologies/languages as needed

• Technical Proficiency: Comfortable with a range of data tools and technologies, with a willingness to learn new skills as needed

• Track record in designing and implementing large-scale data sources

• Sense of ownership, urgency, and drive

• Demonstrated passion for user experience and improving usability

• Team Collaboration: A team player who can work effectively in cross-functional environments

• Experience and willingness to mentor junior data engineers and help develop their skills and leadership

EDUCATION

Required

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Computer Engineering or related field or relevant experience and/or education as determined by the company in lieu of bachelor's degree.   

Preferred

• Master's degree in Computer Science, Information Systems, Data Science, Computer Engineering or related field

LICENSES or CERTIFICATIONS

Required

• None

Preferred

• None

Language (Other than English):

None

Travel Requirement:

0% - 25%

PHYSICAL, MENTAL DEMANDS and WORKING CONDITIONS

Position Type

Office- or Remote-based

Teaches / trains others

Occasionally

Travel from the office to various work sites or from site-to-site

Rarely

Works primarily out-of-the office selling products/services (sales employees)

Never

Physical work site required

No

Lifting: up to 10 pounds

Constantly

Lifting: 10 to 25 pounds

Occasionally

Lifting: 25 to 50 pounds

Rarely

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.

Pay Range Minimum:

$67,500.00

Pay Range Maximum:

$126,000.00

Base pay is determined by a variety of factors including a candidate’s qualifications, experience, and expected contributions, as well as internal peer equity, market, and business considerations.  The displayed salary range does not reflect any geographic differential Highmark may apply for certain locations based upon comparative markets.

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.

We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the email below.

For accommodation requests, please contact HR Services Online at HRServices@highmarkhealth.org

California Consumer Privacy Act Employees, Contractors, and Applicants Notice