Senior Data Engineer

Company Description

PG Forsta is the leading experience measurement, data analytics, and insights provider for complex industries—a status we earned over decades of deep partnership with clients to help them understand and meet the needs of their key stakeholders. Our earliest roots are in U.S. healthcare –perhaps the most complex of all industries. Today we serve clients around the globe in every industry to help them improve the Human Experiences at the heart of their business. We serve our clients through an unparalleled offering that combines technology, data, and expertise to enable them to pinpoint and prioritize opportunities, accelerate improvement efforts and build lifetime loyalty among their customers and employees.

Like all great companies, our success is a function of our people and our culture. Our employees have world-class talent, a collaborative work ethic, and a passion for the work that have earned us trusted advisor status among the world’s most recognized brands. As a member of the team, you will help us create value for our clients, you will make us better through your contribution to the work and your voice in the process. Ours is a path of learning and continuous improvement; team efforts chart the course for corporate success.

Our Mission:

We empower organizations to deliver the best experiences. With industry expertise and technology, we turn data into insights that drive innovation and action. 

Our Values:

To put Human Experience at the heart of organizations so every person can be seen and understood. 

• Energize the customer relationship: Our clients are our partners. We make their goals our own, working side by side to turn challenges into solutions. 
• Success starts with me: Personal ownership fuels collective success. We each play our part and empower our teammates to do the same. 
• Commit to learning: Every win is a springboard. Every hurdle is a lesson. We use each experience as an opportunity to grow. 
• Dare to innovate: We challenge the status quo with creativity and innovation as our true north. 
• Better together: We check our egos at the door. We work together, so we win together. 

Does analytical data flow through your veins? Are you fluent across cloud, on-premises, platforms, and technologies? Do you have deep healthcare experience? Do you love understanding strategic direction, creating design and direction, then getting fingers on the keyboard? This role is for a Senior Data Engineer with strong data architecture experience. This person will design, develop, and support solutions to transport, store, and analyze our analytical data. They will be key in evolving and maturing our enterprise data strategy and capabilities.

Duties & Responsibilities:

General

• Create data architecture, pipelines, and analytical solutions to meet software and data science requirements for various PG-MX Healthcare Products.
• Identify, evaluate, select, and prove out new technologies and toolsets.
• Create and execute Proofs of Concept and Proofs of Technology.
• Lead and direct the work of others in data dependent projects.

Data Storage Design

• Collaborate with software development, business teams, analysts, and data scientists to establish data storage, pipeline, and structure requirements.
• Design, develop, and maintain ETL/ELT pipelines using Databricks (PySpark, Delta Lake, SQL).
• Implement Data Lakehouse architecture leveraging Databrick Unity Catalog, Delta Live Tables, and Workflows.
• Build and optimize data ingestion frameworks for structured and unstructured data from diverse sources.
• Identify and plan for data storage performance requirements.
• Optimize Databricks clusters, jobs, and queries for performance and cost efficiency.

Application Interface and Data Storage Implementation

• Collaborate with software development, business teams, and data scientists to create and execute implementations.
• Identify impact of implementation on other applications and databases.
• Lead and mentor data engineers on data projects.
• Implement CI/CD for data pipelines using Git, Databricks Repos, and DevOps tools.
• Ensure Data quality, reliability, security compliances across environments.

Master Data Management and Data Governance

• Build and evolve Trusted Record systems to manage entities across the enterprise.
• Design, implement, and evolve solutions around person identity management.
• Develop and enforce data governance, lineage, and cataloging standards.

Mentors Data Engineers

• Identify areas of development and need.
• Provide targeted training and exploration for team members.
• Train and mentor data engineers on standards and best practices.

Technical Skills:

• Hands on experience of Azure data technologies (Databricks, Data Factory, Stream Analytics, Data Lake Storage, Synapse), on-premises Microsoft tools (SQL DB and SSIS), and familiar with AWS data technologies.
• Proficiency in Python, SQL and distributed data processing frameworks (Spark), and familiar with C#, PowerShell, and APIs.
• Significant experience with analytical solutions in relational databases such as MS SQL Server, Oracle, and DB2 as well as experience with NoSQL databases and solutions such as data lakes, document-oriented databases, and graph databases.
• Strong understanding of data modeling, schema design, and ETL best practices
• Experience with data lineage, cataloging, and metadata management in Databricks and Unity Catalog.
• Skill in data modeling and experience with tools like ER/Studio or Erwin.
• Familiarity with version control (Git) and DevOps/CI-CD practices.
• Familiarity with SQL performance tuning and Spark optimization techniques.
• Excellent problem-solving and communication skills.

Minimum Qualifications

• Minimum of 5 years Data Engineering experience in an enterprise environment.
• Bachelor’s degree in technology or like field required.

Don’t meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At PG Forsta we are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyways. You may be just the right candidate for this or other roles.

Additional Information for US based jobs:

Press Ganey Associates LLC is an Equal Employment Opportunity/Affirmative Action employer and well committed to a diverse workforce. We do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, veteran status, and basis of disability or any other federal, state, or local protected class. 

Pay Transparency Non-Discrimination Notice – Press Ganey will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 

The expected base salary for this position ranges from $100,000 to $120,000. It is not typical for offers to be made at or near the top of the range. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, and, where applicable, licensure or certifications obtained. Market and organizational factors are also considered. In addition to base salary and a competitive benefits package, successful candidates are eligible to receive a discretionary bonus or commission tied to achieved results.

All your information will be kept confidential according to EEO guidelines.

Our privacy policy can be found here: https://www.pressganey.com/legal-privacy/