At Boston Children's Hospital, success is measured in patients treated, parents comforted and teams taught. It's in discoveries made, processes perfected, and technology advanced. In major medical breakthroughs and small acts of kindness and in colleagues who have your back and patients who have your heart. As a teaching hospital of Harvard Medical School, our reach is global and our impact is profound. Join our acclaimed Business Intelligence Department and discover how your talents can change lives. Yours included.
This Applications Development Specialist will be responsible for:
Designing and developing dimensional data models that become blue prints for data warehouse and data marts based on analysis and understanding of the business requirements and hospital data sources (Cerner, Epic, Peoplesoft & other internally developed data bases).
Assisting in developing master data management strategies and enterprise data standards to allow data warehouse to become the single-trusted source of truth; developing complex data integration strategies, source-to-target mappings, data lineage, and data transformation logic; developing data profiling and data quality methodologies and embedding them into the processes involved in transforming mountains of data across the systems.
Developing strategies for optimal delivery of analytics across the enterprise using techniques such as reverse engineering, prototyping, rapid development, and agile methodologies.
Developing roadmaps for the evolution of Date Warehouse as per the needs of the institution; and ultimately developing and taking technical ownership of data marts supporting specific analytic objectives across the enterprise.
To qualify, you must have:
A Bachelor's Degree in Computer Science or Information Technology or related field, and 3 or more years of experience assisting in the development of data warehouses and data marts, including experience developing data architectures, data standards, and Master data management strategies and their implementation in enterprise data management area.
Experience working with relational database concepts, data dictionaries, data attributes, cross-references & identifiers, data hierarchies and relational types.
Knowledge with developing data extraction, transformation, loading ETL routines using prominent ETL tools; developing data mapping, data relationships, hierarchical and dimensional data models; analyzing and resolving data quality and data profiling issues.
Experience working will Data Warehouse appliances, including Netezza, Teradata, SQL programming, PL and SQL development, Performance tuning of Queries, and BI/Reporting tools; working with BI and DW lifecycle; providing technical documentation, and working individually and as part of a team.
Boston Children's Hospital offers competitive compensation and unmatched benefits, including affordable health, vision and dental insurance, generous levels of time off, 403(b) Retirement Savings plan, Pension, Tuition Reimbursement, and discounted rates on T-passes (50% off). Discover your best.
Boston Children's Hospital is an Equal Opportunity / Affirmative Action Employer. Qualified applicants will receive consideration for employment without regard to their race, color, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.
Internal Number: 2656839
About Boston Children's Hospital
Boston Children's Hospital is a 395-bed comprehensive center for pediatric health care. As one of the largest pediatric medical centers in the United States, Children's offers a complete range of health care services for children from birth through 21 years of age.