Senior Datawarehouse Engineer - Prolacta Bioscience

Do you want to contribute to a larger purpose to save the lives of infants in the NICU? This is Prolacta Bioscience’s mission! Take a look at this opportunity with our IT team, which is seeking a passionate individual, to fill the role of our Senior Datawarehouse Engineer.

As a Senior Datawarehouse Engineer, you will research, develop and implement data analysis projects including but not limited to data reporting, data visualizations, and ad-hoc research projects.  You will work closely with IT teams on planning, design, installation, configuration, automation and maintenance of said systems.  You will be responsible for ensuring that our data systems are engineered for greater accuracy, efficiency, flexibility and reuse.  You will work with all the different business functions to ensure that their future data needs are met with our current and future designs.

Who Is Prolacta Bioscience?

We give babies a brighter future by unlocking the biological power of human milk. Established in 1999, Prolacta Bioscience is a privately held life sciences company that has touched the lives of more than 100,000 premature infants globally. Prolacta is the world’s leading hospital provider of 100% human milk– based nutritional products. Based in Southern California, we employ more than 300 people globally, many of whom have dedicated their lives to neonatal care.

For more information, please visit www.prolacta.com

How you will contribute

This role will provide you with the opportunity to contribute to the growth of our organization and develop your professional skills by…

• Working with IT leadership to define and drive the organization’s data warehousing strategy and vision
• Designing, implementing and managing data models to support Data Warehouse and Data Mart layers
• Designing, implementing and managing ETL processes at the organizational level
• Designing and implementing data and reporting systems that allow a greater degree of ‘Self Service’ report creation
• Analyzing and verifying efficiency, internal consistency, completeness and accuracy of data systems and making required adjustments

Other duties and responsibilities

• Analyze and interpret data trends
• Defines training strategy
• Provide leadership to the team for the assigned projects, applications, and services
• Designs organization wide “views” and custom reports
• Responsible for design direction
• Work on multiple projects as needed
• Works with end users to validate requirements; captures relevant data and reporting requirements
• Develops enterprise reports in conjunction with developers, contractors, and business stakeholders
• Prepares documentation including designs, technical requirements, test scripts, test results, data migration plans, implementation plans and procedures
• Prototypes designs and user requirements using various tools such as Visio
• Recommends establishment of new or modified reporting methods and procedures to improve report content and completeness of information.
• Explores, recommends and implements BI tools
• Participates in and conducts team reviews throughout the life cycle of the project
• Strongly adheres to Prolacta’s structured SDLC (software development life cycle) and validation processes
• Manages the application maintenance ticket queue; troubleshoots performance issues and designs effective solutions
• Effectively works with the IT team by improving processes, developing standards, and improving project documentation and procedures
• Effectively works with a Scrum or Kanban team as designated

What you bring to the role

• Bachelor’s Degree in Computer Science, Data Science, Math, Economics or related field
• Eight or more years of experience required developing Enterprise scale Data Warehouse and Data Marts
• Eight or more years of experience with SQL Server including stored procedures, triggers and scripts
• Experience with SQL Server 2008/2014/2016 required
• Proficient in Self Service BI
• Proficient in Data Modeling (star, snowflake schemas)
• Experience in creating and interpreting ER diagrams
• Proficient in ETL using Microsoft Sql Server Integration Services (SSIS) and stored procedures.
• Proficient in BI reporting software such as Power BI Service/Desktop, Qlik, Tableau
• Proficient in SQL Server 2008/2014/2016
• Experience with Microsoft Azure, SQL Data Warehouse, Azure Data Factory and Power BI
• Experience in MySQL, PostgreSQL, NoSQL
• Experience in project management principles
• Experience in developing machine learning models using R/Python
• Experience in Waterfall and Agile SDLC
• Experience in FDA regulated, Biologic or Health Care companies desired
• Data Vault Warehouse Design experience is desired

How Prolacta benefits you

To drive the personal growth and business impact of our employees, we’re committed to developing a supportive and enriching culture for everyone. From up to 100% healthcare coverage starting on your first day, to discretionary stock options and 401(k) match, we value our employees’ health and financial wellbeing. We offer four weeks PTO during your first year of employment and support our new parents with a generous time-off program. We encourage employees to participate in our employee affinity groups, take volunteer time off, and provide access to different educational opportunities.

What else do you need to know

Location: Duarte, CA - Hybrid available

Schedule: 8-5 M-F

Travel: Minimal

FLSA: Exempt

Pay: $130,000 - $150,000

Candidates for positions with Prolacta Bioscience must be legally authorized to work for any employer in the United States. Verification of employment eligibility will be required at the time of hire. Prolacta Bioscience does not sponsor or takeover sponsorship of employment visas.

Depending on your residential location certain laws might regulate the way Prolacta manages applicant data. California Residents, please review our Privacy Notice for California Employees and Job Applicants for further information, this can be found on Prolacta.com on www.prolacta.com . By submitting your application, you are agreeing and acknowledging that you have read and understand the above notice.

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to effectively communicate (e.g., talking/ hearing), walk, sit, use hands and fingers to handle, feel and reach things. The employee is occasionally required to taste, smell, stoop, kneel, crouch or crawl.  Specific vision abilities required by this job include close vision, color vision and ability to adjust focus.

Sedentary to light work; repetitive motions; pushing; pulling; visual acuity to prepare and analyze data and figures, transcribe, view a computer terminal.

EEO Statement

“Prolacta Bioscience, Inc. is an Equal Employment Opportunity Employer.” Prolacta Bioscience, Inc. is committed to a proactive program of affirmative action and diversity development. The Company will continue to recruit, hire, train, and promote into all job levels without regard to race, religion, gender, marital status, familial status, national origin, age, mental or physical disability, sexual orientation, gender identity, source of income, or veteran status.

#LI-Hybrid