Data Engineer III

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. 

The Data Engineer III will design, develop, and support solutions to transport, store, and analyze data for our Unified Data Platform and multiple On-Prem data marts using Azure, Azure Databricks, and On Premises SQL Server extracting data from our source systems.

Analyze, design, architect, develop and test software systems that simulate business processes and can be used to optimize and increase their efficiency, using various computer languages and Windows based platforms.

Gather customer requirements and create high-level component level architecture and confer with personnel of organizational units involved to analyze current operational procedures, identify problems, oversee specific input, and output requirements.

Format reports, write detailed description of user needs, program functions, and steps required to develop or modify computer programs.

Review computer system capabilities, workflow, and schedule limitations to determine if requested program or program change is possible within existing system.

Serve as key member in evolving and maturing our enterprise data strategy and capabilities at Press Ganey.

Technical Skills:

• 2+ years experience with Azure data technologies (Databricks, Data Factory, Stream Analytics, Data Lake Storage, Synapse), on-premises Microsoft tools (SQL DB and SSIS)
• 1+ years experience with SQL, Python, PySpark. Experience in Apache Spark
• 1+ years experience with C#, PowerShell, and APIs
• 2+ years experience with analytical solutions in relational databases such as MS SQL Server, Oracle, and DB2.  Experience with NoSQL databases and solutions such as data lakes, document-oriented databases, and graph databases a plus
• Experience in data modeling
• Experience with Azure DevOps and GitLab
• Proficient in creating CI/CD pipelines to track version changes, branch deployment
• Proficient in integrating automatic unit tests into CI/CD process
• Experience with developing automated job schedules using tools such as Tidal
• Familiarity with data visualization tools such as Power BI

Minimum Requirements:

• Bachelor’s degree in Computer Science, Management Information Systems, or related field
• Minimum of 3 years Data Engineering experience in an enterprise environment
• Excellent communication and collaboration skills
• Strong analytical and problem-solving abilities

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 $ 81,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/