Data Engineer III
79161BR
Information Services-Business Intelligence
Status
Full-Time
Standard Hours per Week
40
Job Category
Information Technology
Regular, Temporary, Per Diem
Regular
Office/Site Location
Boston
Remote Eligibility
Part Remote/Hybrid
Job Posting Description
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 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 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.
- Implementing data profiling and data quality methodologies and embedding them into processes involved in transforming vast amounts of data across systems.
- Creating strategies for optimal analytics delivery across the enterprise through techniques such as reverse engineering, prototyping, rapid development, and agile methodologies.
- Developing roadmaps for the evolution of the Data Warehouse in alignment with institutional needs.
- Taking technical ownership of data marts, supporting specific analytic objectives across the enterprise.
To qualify, you must have:
- Bachelors Degree is required in the field of Computer Science or IT or a related field.
- 6 years experience assisting in the development of data warehouse and data marts is required
- Proven expertise in developing data architectures, data standards, and Master data management strategies and their implementation in the enterprise data management arena.
- Experience developing data extraction, transformation, loading (ETL) routines using prominent ETL tools like Snowflakes’s streams and Dynamic Tables, Striim 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 databases (like Snowflakes, Oracle,SQL Server etc.), SQL programming, PL/SQL development, Performance tuning of Queries, BI/Reporting tools like Microstrategy, Business Objects, etc.
- Solid knowledge of BI/DW life-cycle and a “systems approach” to solving problems and issues.
- Thorough understanding of relational database concepts, data dictionaries, data attributes, cross-references & identifiers, data hierarchies & relationship types.
#LI-Hybrid
Boston Children’s Hospital requires all employees to be vaccinated against COVID-19 and Flu, (unless you are eligible for a medical or religious exemption).
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.
Similar jobs
