Data Operations Engineer, 340b Team

Berkeley Research Group

BRG’s 340B group is one of the Healthcare Analytics practice’s largest and fastest growing groups and we are looking to expand our talented and dynamic team. The 340B team supports and advises pharmaceutical manufacturers on how to navigate the challenges and complexities of the 340B program, a government drug purchasing program. Our group is the established market leader in data and technology solutions related to the most pressing 340B-related issues for an impressive client base which includes the largest pharmaceutical manufacturers in the US. Beyond our syndicated solutions, we also integrate and synthesize data to deliver unparalleled analytics and insights into various aspects of the 340B program. The 340B program is an exciting and dynamic space to be in right now so come join us!

The Data Operations Engineer will coordinate with internal leads regarding business data, processes, and technology to ensure holistic management of our data warehouse. They will work to ensure data processes run smoothly, quality control checks are executed and reported to the teams analyzing the data, data management procedures are documented and data subscriptions/vendors are managed. This individual will continue to build out our data warehouse by researching new datasets the practice could leverage to enhance existing products and services. Additionally, the Data Operations Engineer will work with our Business, IT Security and Software Development teams to ensure our data processes and procedures are aligned with compliance standards and that we are adhering to applicable Data Use Agreements (DUAs).

Responsibilities:

• Own the process of cleaning and loading client data (or other data) into data warehouse and be responsible for data quality and timeliness
• Create and manage data quality checks that are performed after cleaning and loading is complete. Provide data reporting of these quality control checks to team members when data is “production” ready and can be used in analyses
• Routinely monitor stored procedures or automated processes for collecting and loading data to ensure no gaps or errors in the data warehouse
• Develop documentation for data management practices, procedures and quality controls as well as track the various data received and used across the practice’s products and services
• Document and manage data updates in data dictionaries
• Subject matter expert for internal and external communications related to data management, ingestions and complex or ad hoc data requests
• Collaborate with team members to provide solutions to specific data requests including dataset merges, data processing, data formatting, and other data challenges
• Work with team members to define end-state outcomes and understand how data and processes need to change to deliver outcomes
• Identify and research opportunities for process improvements as well as new datasets that could be used to by the practice to enhance or create new products and services
• Manage data subscriptions, data vendors and data-use agreements across the practice
• Ensure all datasets used in analyses are complete, up-to-date and accurate
• Additional duties may be assigned as needed

Basic Qualifications:

• Bachelor’s Degree
• 4+ years of data analytics or data management experience, preferably in consulting or healthcare industries
• Excellent SQL Server skills; experience working in PostgreSQL and/or MS Azure is a plus
• Familiarity with other scripting languages, such as SAS, R and/or Python
• Strong written and verbal communication; ability to synthesize and clearly communicate complex problems or processes to team members and clients
• Experience managing, performing quality control, and analyzing structured and unstructured data
• Experience with PowerBI, Tableau, Looker and MS Excel
• Experience with cloud-hosted data stores, such as Azure SQL or Redshift
• Experience with data warehousing principles and practices

Salary Range: $100 – $170K per year

Candidate must be able to submit verification of his/her legal right to work in the U.S., without company sponsorship.

#LI-JQ1
PM22
BRG is an Equal Employment Opportunity/Affirmative Action Employer. All qualified candidates will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, disability, or protected veteran status.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities