Job Description:
Role: Data Architecture lead/Agile Program Manager (RTE) – Global Investments
Location: Boston, MA (Remote)
Experience: 10+ Years
Skills: Investment Management Domain Expertise, Data Architecture and Modeling, Secure Data Service Architecture, Cloud Infrastructure and DevOps, Agile Methodologies and Program Management, RTE
Note: Investment Management Industry experience as this is a key component for this role.
Job description
· We are seeking a highly skilled and motivated Data Architect Lead for our Global Investments strategic program to join our project team. The ideal candidate will have a strong background in data architecture, investment management domain, technology, data, and with supporting large technology implementation projects. The position would work closely with both development teams and Mercer investments data team.
Must have:
· Investment Management Domain Expertise: Understanding key data domains in investment management such as clients, portfolios, funds, holdings, transactions, trades, securities/investments, ESG, analytics, performance, IBOR/ABOR/TBOR, and benchmarks/indices is essential. This expertise is crucial for designing and implementing data architectures that meet the specific needs of the investment management industry.
· Proficiency in Data Modeling: Expertise in conceptual, logical, and physical data model designs, along with proficiency with data modeling tools like Hackolade and Er-Win, is necessary. This skill ensures the ability to translate business requirements into robust data structures that support various business functions.
· Experience with Key Technologies: Hands-on experience with technologies such as NiFi, Python, Kafka, Databricks, and Snowflake. This includes designing integration solutions and building data architectures that leverage these technologies for data processing, storage, and analysis.
· Agile Transformation and Team Leadership: Significant experience in organizational Agile transformation and Agile program management (e.g., RTE role). The ability to lead agile teams, ensuring efficient software delivery processes, and fostering collaboration across distributed teams is crucial for driving successful project outcomes.
Role Detail:
· Focus on software development life cycle, you will collaborate with our Head of Technology Strategy, Head of Data, Solution Architects, Data Analysts, Data Team, and Portfolio Delivery function Leads to understand customer and technical needs to design and implement the Global Investment data platform, including Persistence, Integration and Services layers of the business solutions in compliance with architecture principles and standards followed by MMC technology.
· You will coordinate with business and technology team leads for the creation and maintenance of the LOB standardized interface layer as well as data model and catalog.
· You will form part of the Pod Leadership team tasked with bringing your architectural vision to fruition utilizing agile methodologies and assist the senior pod lead with the day to day oversight of the development team. You will elaborate your architecture designs and collaborate with our infrastructure and development teams to enable implementation of them with light touch oversight.
· We in Product Delivery Engineering are on a mission: to transform the way our Mercer business and IT teams work together to unlock the benefits of rapid delivery of quality, secure software to market by empowered teams. We will do this by rolling out our Agile at Scale Delivery model. You will oversee teams and will be responsible for their delivery of working software through to production.
What you need to have:
· Deep previous experience in the investment management industry and common applicable data domains (clients, portfolios, funds, holdings, transactions, trades, securities/investments, ESG, analytics, performance, IBOR/ABOR/TBOR, benchmarks/indices).
· Deep understanding of business and the ability to translate them to conceptual, Logical and Physical data model designs when required
· Deep understanding of integration design patterns and reporting solutions
· Self-motivated to excel in a remote position, collaborating effectively with remote teams across the globe.
· You are a self-starter; you can take initiative without waiting for direction.
· The ability to work in a fast-paced environment with changing priorities and deadlines
· You are used to working and communicating with both business and technical stakeholders at varying levels of seniority
· Extensive experience in designing and communicating technology solutions that can be traced back to requirements
· An inquisitive mind set with a track record of seeking out and implementing new technologies and architectural patterns
· Ability to support self-governance process by instilling discipline and establishing cadence with our business SME partners to ensure completeness in information assets generated in support of the solution
· Ability to work effectively with distributed teams across the globe. The business we are supporting is global and our development teams are also in differing regions.
· Significant organizational Agile transformation experience and be able to demonstrate proven strategies. Mercer has a complex technological landscape and a large portfolio of revenue generating applications. We also have significant security processes and legislative requirements to protect our customers and their data
· Previous experience of Agile Program management (e.g. RTE role)
· Experience of a wide range of Technology roles is desirable, ideally with some form of development engineering or Agile Program management background
Technical skills or qualifications required:
· Significant experience with the following technologies, architectures & methodologies:
· Nifi, Python, kafka, Databricks, Informatica or any other integration technologies
· Data modeling tools such as Hackolade, Er-Win
· Big Data / Data Lakehouse / traditional RDBMS/data warehouse/mart
· Industry standard Metadata management product – Collibra, Informatica EDC/AXON/CDGC
· Data Management Principles and Data Governance Lifecycle and standards and tooling
· Deep understanding of secure data service architecture. Expert in data services design, Secure by Design concepts, Microservices, Structure SQL and other query patterns
· Cloud Infrastructure architecture, Containerization / Kubernetes
· Secure DevOps; Application Performance Monitoring (APM) techniques; SDLC – Agile / Hybrid / Waterfall
· Experience with building solutions with Databricks.
· Experience with Snowflake (for data sharing) and Athena a plus.
· Experience working in AWS.
· Experience in building denormalzied data warehouses (star schemas, fact dimensional modeling) for citizen developer/BI user users.