$80K — $100K *
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 material for the products Prolacta sells.
As a Business Intelligence Engineer II you will work closely with IT teams on planning, design, installation, configuration, automation and maintenance of our Data Warehouse and Self Service BI system. You will help ensure 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
Design and implement data models to support Data Warehouse and Data Mart layer
Design, implement and manage ETL processes at Department level
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
Analyze and interpret data trends
Gather requirements, design and develop reports in conjunction with developers, contractors, and business stakeholders
Creates executive, business manager, and detail reports from day-to-day usage
Solicits input from each department for continuous improvement and consolidating with one single reporting tool
Recommends reporting enhancements
Prepares documentation including designs, technical requirements, test scripts, test results, data migration plans, implementation plans and procedures
Explores, recommends and implements BI tools
Prototypes designs using various tools such as Visio
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
Job Requirements and Qualifications
Bachelor’s Degree in Computer Science, Data Science, Math, Economics or related field
Three or more years of experience in Business Intelligence, Data warehousing
Experience with SQL Server 2008/2014 required
Other Knowledge, Skills and Abilities
Experience in Self Service BI
Experience in Data Modeling (star, snowflake schemas)
Experience in ETL
Experience in BI reporting software such as Qlik, PowerBI Service/Desktop, Table
Experience in SQL Server 2008/2014/2016
Experience in MySQL, PostgreSQL, NoSQL
Experience in Waterfall and Agile SDLC
Experience in FDA regulated, Biologic or Health Care companies desired
Work Environment (Location, travel, shift, on-call, etc.)
Primary – Highland
COI – As required
Travel – 5%
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 sit; use hands to finger, handle, or feel and talk or hear. The employee is occasionally required to walk. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, color vision and ability to adjust focus.
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 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.
“Prolacta Bioscience, Inc. is an Equal Employment Opportunity Employer.”
Valid through: 11/2/2021