Develops data integration strategies, source to target mappings, data lineage, and data transformation logic. Analyzes and understands business requirements and hospital data sources and, design and develop dimensional data models for data warehouse and data marts.

The Data Engineer III will be responsible for:

• Collaborating as a member of cross-functional teams to analyze and understand business requirements and hospital data sources, using that understanding to design and develop dimensional data models that serve as blueprints 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 structured for end-user self-service reporting.
• Developing data integration strategies, source-to-target mappings, data lineage, and data transformation logic.
• Creating data profiling and data quality methodologies and embedding them into the processes involved in transforming extensive data across systems.
• Developing strategies for optimal delivery of analytics across the enterprise using techniques such as reverse engineering, prototyping, rapid development, and agile methodologies.
• Creating roadmaps for the evolution of the Data Warehouse as per institutional needs.
• Taking technical ownership of data marts supporting specific analytic objectives across the enterprise.

To qualify you must have:

• Bachelor’s Degree in the field of Computer Science or IT or a related field is required
• Six years’ experience assisting in the development of data warehouse and data marts preferably in a health care organization is required
• Proven expertise in developing data architectures, data standards, and Master data management strategies and their implementation in the enterprise data management arena.
• 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, Data Stage, etc.
• Experience developing data mapping, data relationships, hierarchical and dimensional data models; as well as analyzing data quality and data profiling issues.
• Broad swath of technology skills in Data Warehouse appliances (like Netezza, Teradata, etc.), SQL programming, PL/SQL development, Performance tuning of Queries, BI/Reporting tools like Cognos, Business Objects, etc.
• Solid knowledge of BI/DW life-cycle and a “systems approach” to solving problems and issues.

Boston Children’s Hospital offers competitive compensation and unmatched benefits including flexible schedules, affordable health, vision and dental insurance, child care and student loan subsidies, generous levels of time off, 403(b) Retirement Savings plan, Pension, Tuition and certain License and Certification Reimbursement, cell phone plan discounts and discounted rates on T-passes. Experience the benefits of passion and teamwork.

#LI-Hybrid

#L
I-Hybrid