Data Mesh / Enterprise Architect

About Client:
The client is a global consulting, technology, and digital firm specializing in the financial services industry. Established in 2001, the company provides innovative solutions to help clients navigate digital transformation, enhance operational efficiency, and achieve strategic objectives. With a focus on banking, capital markets, and insurance, it leverages cutting-edge technologies such as blockchain, artificial intelligence, and data science to deliver customized IT solutions and business consulting services.
The company's commitment to innovation, combined with its industry expertise, positions it as a leader in driving technological advancements and helping financial institutions stay competitive in a rapidly evolving market.



Rate Range: $680-$720/Day



Job Description:

• We are seeking an experienced Data Mesh / Enterprise Architect to define the target-state architecture for a complex financial-services data estate.
• You will translate detailed stored procedures and data-landscape analysis into an actionable enterprise architecture. This includes defining domain and medallion-layer boundaries, creating reusable architecture patterns, designing source-aligned and consumer-aligned data products, and establishing the governance and platform capabilities required to support a federated data mesh.
• The role requires genuine delivery experience in data-product architecture not simply familiarity with data mesh concepts. You will need to make practical architectural decisions across legacy SQL estates, lakehouse platforms, reference and master data, data contracts, lineage and enterprise architecture governance.

Key Responsibilities:

• Interpret the stored-procedure landscape analysis architecturally: where a single procedure conflates responsibilities belonging to different domains or different medallion layers, define how it is split.
• Define one reusable target pattern per MCDB feature class: operational UI / applications (app), raw ingestion from systems of record (stage), third-party market and reference data (refdata), consumer extracts (extract), enterprise model, and the cross-cutting MDM, sub-ledger and risk assets.
• Map every inventory item to a pattern and produce the pattern-assignment matrix.
• Compose the target-state conceptual architecture on DEAL: source-aligned data products, aggregate and consumer-aligned data products, the federated governance plane, the self-serve platform and the catalogue of catalogues with the platform provisioning capability but never owning domain data.
• Define the medallion mapping for each pattern
• Specify output-port design so that contract-governed subscriptions replace point-to-point extracts, and define the change-feedback loop from consumer to producer.
• Produce the complexity, risk and dependency assessment and sequence the roadmap against it.

Deliverables owned:

• Architecture pattern catalogue, one per feature class (Word; TOGAF pattern cards)
• Pattern-assignment matrix covering every inventory item (Excel)
• Target-state conceptual architecture (C4 and/or ArchiMate diagram + narrative)
• Complexity, risk and dependency assessment with sequenced roadmap (Word + diagram)

Essential experience:

• 10+ years in data architecture, 5+ at enterprise or principal level in financial services.
• Genuine data mesh / data-product architecture delivery, not familiarity with the literature. Candidates must be able to describe a specific domain decomposition they authored, the contested boundaries within it, and how the platform-versus-domain responsibility split was enforced.
• Deep lakehouse and medallion architecture: Databricks with Unity Catalog, Delta, Snowflake, Kafka, Airflow, Azure Data Lake Storage Gen2. Must be able to reason about equivalents on AWS (Lake Formation, Glue Data Catalog, Amazon DataZone) when comparing options for Mizuho.
• Reference and master data architecture: vendor onboarding, identifier crosswalks across FIGI, LEI/GLEIF, CUSIP/ISIN, SEDOL and MIC, mastering and distribution to consuming domains.
• SQL Server and T-SQL depth sufficient to reason about stored-procedure decomposition the ownership boundaries in MCDB are inside the procedures, not the schema names.
• TOGAF 9 or 10 certified, with demonstrable use of TOGAF to define and govern patterns; ArchiMate or C4 modelling in production use.

Preferred / differentiating:

• FIBO applied to a taxonomy or ontology exercise; ODCS or comparable data-contract specification.
• Lineage and catalogue tooling in anger: Solidatus, Unity Catalog, Microsoft Purview, Collibra, Alation, Securiti.ai , Anomalo.
• Experience with automated code-intelligence accelerators for SQL/SAS estate analysis.

About ApTask:
ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-owned company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.

Candidate Data Collection Disclaimer:
At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.

If you have any concerns or queries about your personal information, please feel free to contact our compliance team at compliance@aptask.com.

Applicant Consent:
By submitting your application, you agree to ApTask's (www.aptask.com) Terms of Use and Privacy Policy, and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at 732-355-8000 or help@aptask.com. Message frequency may vary. Msg & data rates may apply.