Brown Brothers Harriman is looking for a talented and self-motivated developer to be a member of the Human Resources Business Technology (HRBT) team. This role will be responsible for analysis, design, development, testing, implementation and troubleshooting of the Inbound and Outbound data feeds to the HR Data Warehouse as well as providing technical leadership for the team. Additional responsibilities outside of the HR Data Warehouse include supporting Workday integrations between BBH and our 3rd party vendors, which may include some vendor product maintenance. ETL experience is required, and Oracle Data integrator (ODI) experience is preferred. As we are evolving an ecosystem of vendor-products and internally developed applications, the ability to think creatively and learn and apply different technologies to different problems (Python, Java, etc.) is an exciting opportunity this position offers. Non-technical skillset should include a high degree of organization, effective communication, the ability to collaborate with internal and external teams that include system/business analysts, developers, managers and testers.

Responsibilities:

• Model Data Warehouse data or support integration enhancements to support data modeling to develop custom Oracle HR Data Warehouse;

• Pursue reporting optimization efforts in terms of optimized reporting tables, optimized data warehouse tables and/or optimized data marts;

• Learn different point-solution technologies (RPA, ODI, Python, etc.) and bring back to and act as lead developer and training SME for the team;

• Assist in technical design within HRBT team. Identify and design solutions to be built and/or modified;

• Understand business requirements, design technical specification & develop new components for the ETL framework, identifying structures and processes to ensure that relevant data is captured;

• Conduct walk-throughs to review ETL Components, Mapping, Packages and Procedures, and all technical supporting documentation;

• Maintain integrity, metadata and data lineage for ETL inbound/outbound processes including onboarding new sources/targets via data profiling to identify data quality checks;

• Actively participate in data integration, data profiling, data validation and data quality processes and resolve data mapping and data quality issues in partnership with QA and development teams;

• Analyze and classify change requests, identifying and documenting scope of change and impact on other integrations;

• Develop and validate use case scenarios for new data intake, as well as, continuous regression validation of existing data relationships and lineage to ensure program/application performance regarding business requirements;

• Review ETL environment for Inbound/Outbound processes and help with overall data governance model;

• Engage and interact closely with business and IT stakeholders to understand Business requirements and current constraints;

• Manage and support downstream integrations from Workday to other vendors (i.e. benefits, payroll, internal systems) etc.;

• Support clients on HR related applications to resolve issues;

• Infrastructure related maintenance support on HR related applications which can include occasional after-hours support or weekend work.

Skills Required:

• 3 years of ETL experience required (ODI v12c preferred);

• Excellent technical aptitude and ability to nimbly learn and apply new technologies;

• Strong experience with Oracle Relational databases and / or Oracle Exadata;

• Hands on experience with flat files, XML, JSON and other complex files as source and target;

• Good understanding about topology, user access, logical and physical contexts etc.;

• Understanding of performance tuning;

• Provide production support to resolve any issues within the defined SLA's;

• Should have good communication skills, analytical ability and problem-solving skills;

• Should be able to articulate the issues and propose viable solutions;

• 4+ years relevant experience in HR or adjacent systems and solutions such as PeopleSoft HRMS, SAP HCM or Workday HCM preferred;

• Ability to work independently, inform appropriately, and self-manage among assigned priority items;

• Strong work ethic, follow-through and communication skills for all assigned areas of responsibility;

• Team player.

Nice to Have:

• Exposure to shell scripting, JSON, XML, PLSQL, Web Services, Relational Database Management System;

• Experience with Workday Studio highly preferred but alternate integration methodology experience is valuable;

• Experience with integration technologies including Web Services, XML, XSLT, SOAP and Java.

What We Offer:

• A collaborative environment that enables you to step outside your role to add value wherever you can

• Direct access to clients, information and experts across all business areas around the world

• Opportunities to grow your expertise, take on new challenges, and reinvent yourself — without leaving the firm

• A culture of inclusion that values each employee’s unique perspective

• High-quality benefits program emphasizing good health, financial security, and peace of mind

• Rewarding work with the flexibility to enjoy personal and family experiences at every career stage

• Volunteer opportunities to give back to your community and help transform the lives of others