| At Boston Children's Hospital, the quality of our care - and our inclusive hospital working environment - lies in the diversity of our people. With patients from local communities and 160 countries around the world, we're committed to reflecting the spectrum of their cultures, while opening doors of opportunity for our team. Here, different talents pursue common goals. Voices are heard and ideas are shared. Join us, and discover how your unique contributions can change lives. Yours included.
The Data Warehouse Specialist III shall be responsible for:
- Collaborating as member of cross functional teams to analyze and understand the business requirements and the hospital data sources. Using that understanding to design & develop dimensional data models that become blue prints for the data warehouse / data marts.
- Assisting in developing master data management strategies, enterprise data standards and data architecture. Ensuring the data is well defined, accurate, standardized, cleaned, and structure for end user self-service reporting.
- Developing data integration strategies, source-to-target mappings, data lineage, and data transformation logic.
- Developing data profiling and data quality methodologies and embed 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 Data Warehouse as per the needs of the institution.
- Developing and taking technical ownership of data marts supporting specific analytic objectives across the enterprise.
In order to qualify you must have:
- A Bachelors in Science, in Computer Science or Information Technology or a related field, with a minimum of six years experience assisting in the development of data warehouse and data marts, preferably in a health care organization.
- Proven expertise in developing data architectures, data standards, and Master data management strategies and their implementation in the enterprise data management arena.
- A thorough understanding of relational database concepts, data dictionaries, data attributes, cross-references & identifiers, data hierarchies & relationship types.
- Experience developing data extraction, transformation, loading (ETL) routines using prominent ETL tools like Informatica, Talend, etc.
- Experience developing data mapping, data relationships, hierarchical and dimensional data models; as well as analyzing data quality and data profiling issues.
- Technology skills in Data Warehouse appliances (like Netezza, Snowflake, etc.), SQL programming, PL/SQL development, Performance tuning of Queries, etc.
- Solid knowledge of BI/DW life-cycle and a "systems approach" to solving problems and issues.
Please note: During a public health emergency, individuals in this role may be expected to take on additional duties to respond to organizational needs.
Boston Children's Hospital offers competitive compensation and unmatched benefits, including a, affordable health, vision and dental insurance, generous levels of time off, 403(b) Retirement Savings plan, Pension, Tuition Reimbursement, cell phone plan discounts and discounted rates on T-passes (50% off). Flexible schedule (if applicable). 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.
|
