Company
Prolacta is the pioneer in human milk-based nutritional products for premature infants in the neonatal intensive care unit (NICU). Prolacta believes that there is no adequate replacement for human breast milk and, as such, we believe infant nutritional products should be human milk-based. As a privately held, scientifically driven company, committed to improving premature infant nutrition, we are using human milk to change the standard of care in the NICU. Prolacta operates and/or owns milk banks that provide the starting material for the products Prolacta sells.
Job Summary
As a Business Intelligence Engineer you are responsible for defining and implementing the BI strategy and vision for Prolacta Bioscience. This will include researching, developing and implementing 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.
Primary Duties and Responsibilities
• Work with IT leadership to define and drive the organization’s data warehousing strategy and vision
• Design and implement data and reporting systems that allow a greater degree of ‘Self Service’ report creation
• Analyze and verify efficiency, internal consistency, completeness and accuracy of data systems and making required adjustments
• Design and implement continuous validation techniques using automated testing
• Work with IT partners, internal and external customers to gather and validate requirements
• Communicate concisely with business stakeholders via phone and/or in person
• Manage, acquire, clean, and manipulate data to support all analyses and reporting activities
• Designs organization wide “views” and custom reports
• Perform analysis for a wide range of requests using data in different formats and from various platforms
Job Requirements and Qualifications
Requirements
• Strong knowledge for business process and requirements
• 8+ years of data management experience
• 5+ years of Business Intelligence experience
• Advanced MS SQL experience, query optimization, modeling
• Experience with Qlik, Power BI, Excel, ETL
• A degree in Computer Science, Data Science, Math, Economics or related field
Preferred Qualifications
• Experience with Corporate Finance and Accounting
• Knowledge of MySQL, PostgresSQL, NoSQL
• Experience with Git is a plus
• Strong experience with PowerShell
Other Knowledge, Skills and Abilities
• Excellent verbal and written communication skills; Ability to work effectively with individuals at all levels in the organization
• Experience in FDA regulated and/or biologic companies desired
• May work on other duties as needed
• Perform job with little to no oversight
• Self-motivated
• Willingness to coach team members
Work Environment (Location, travel, shift, on-call, etc.)
• This position is primarily based in Duarte office
• May need to travel to City of Industry office per project or task needs
• May need to be on-call or work during off hours per project or task needs

Disclaimer
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.
“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.