Hybrid: Yes, 3 days onsite
Convert/Visa: Potential right to hire and unable to sponsor
Interview: onsite required
Keys to the position:
Data Architect/Modeler
- Financial Experience
- Data Architect & Modeler across platforms
- Hands-on engineering
- Databricks (cloud platforms)
- Experience Migrating from Legacy/Oracle to Cloud
- Implement/Support Master Data platforms
- Golden Source Data
- Will be supporting different projects not just one
We are seeking an experienced Data Architect with strong Data Modeling expertise and hands-on Data Engineering capabilities to support enterprise data initiatives within the Financial Services industry. The ideal candidate will have experience designing scalable cloud-based data platforms, developing enterprise data models, and supporting modern data architecture initiatives across large and complex environments.
This role requires expertise in enterprise data architecture, cloud data platforms, Master Data Management (MDM), and modern data engineering practices. The candidate should be comfortable working closely with business stakeholders, data governance teams, application teams, and analytics organizations to deliver scalable, secure, and high-performing data solutions aligned with enterprise standards and regulatory requirements.
Key Responsibilities:
• Design and implement enterprise-wide data architecture solutions for large-scale financial services environments.
• Develop conceptual, logical, and physical data models supporting operational, analytical, and reporting platforms.
• Architect and support cloud-native data platforms including modern data lake and data warehouse ecosystems.
• Perform hands-on data engineering activities including development of ETL/ELT pipelines, data ingestion frameworks, and transformation processes.
• Design scalable batch and real-time data integration solutions for structured and semi-structured data.
• Support Master Data Management (MDM) initiatives across security, account, client, and reference data domains.
• Collaborate with enterprise architecture, governance, security, compliance, and business teams to establish data standards and best practices.
• Implement data quality, metadata management, lineage, and governance frameworks.
• Optimize data platforms for scalability, reliability, performance, and cost efficiency.
• Support regulatory, audit, risk, and compliance reporting requirements within U.S. financial industry environments.
• Participate in cloud migration and modernization initiatives involving legacy and distributed data systems.
• Enable analytics, reporting, AI/ML, and business intelligence capabilities through trusted and governed enterprise data solutions.
Required Skills & Experience:
• 8–10 years of experience in Enterprise Data Architecture and Data Modeling across modern data platforms.
• Hands-on experience with Data Engineering and development of scalable, modern data pipelines.
• Proven experience with cloud-based data platforms and distributed data processing technologies.
• Strong understanding of data warehouses, data lake, and lakehouse architecture, including
• implementation on Modern data platforms.
o Cloud data platforms (e.g. Snowflake, Databricks, or similar)
o On-prem data platforms / legacy data warehouses (e.g. Oracle Exadata)
• Experience designing and implementing ETL/ELT frameworks using tools native to both platforms (e.g., Spark-based pipelines, Snowflake tasks and streams).
• Experience with data integration and ingestion patterns for large-scale structured and unstructured data across platforms.
• Experience designing modern data platforms for legacy transformation initiatives.
• Experience with Master Data Management (MDM) and enterprise data governance frameworks.
• Knowledge of metadata management, data lineage, data cataloging, and data quality processes.
• Experience working with financial services data domains and regulatory/compliance-driven data environments.
• Strong SQL expertise along with programming/scripting experience in Python, PySpark, or Snowpark.
• Experience with dbt (Data Build Tool) for:
o Data transformation and modeling
o ELT pipeline development within Snowflake/Databricks
o Modular, reusable SQL-based data workflows
o Data testing, documentation, and version control integration
• Experience with cloud platforms such as Azure, AWS, or GCP, including their integration with Snowflake and Databricks.
• Familiarity with API integration, real-time/streaming data pipelines (e.g., Kafka, Spark Streaming), and event-driven architectures.
• Understanding of security, compliance, and governance standards, including role-based access, data masking, and encryption in both Snowflake and Databricks.
• Experience working in Agile delivery models and collaborating with cross-functional teams.
Preferred Qualifications:
• Experience supporting enterprise modernization and cloud transformation initiatives.
• Exposure to real-time analytics and large-scale distributed data platforms.
• Knowledge of data governance and enterprise architecture frameworks.
• Strong communication and stakeholder management skills.
• Financial Services or Investment/ Wealth Management domain experience preferred.
Estimated Min Rate: $59.50
Estimated Max Rate: $85.00
What’s In It for You?
We welcome you to be a part of the largest and legendary global staffing companies to meet your career aspirations. Yoh’s network of client companies has been employing professionals like you for over 65 years in the U.S., UK and Canada. Join Yoh’s extensive talent community that will provide you with access to Yoh’s vast network of opportunities and gain access to this exclusive opportunity available to you. Benefit eligibility is in accordance with applicable laws and client requirements. Benefits include:
- Medical, Prescription, Dental & Vision Benefits (for employees working 20+ hours per week)
- Health Savings Account (HSA) (for employees working 20+ hours per week)
- Life & Disability Insurance (for employees working 20+ hours per week)
- MetLife Voluntary Benefits
- Employee Assistance Program (EAP)
- 401K Retirement Savings Plan
- Direct Deposit & weekly epayroll
- Referral Bonus Programs
- Certification and training opportunities
Note: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply.
Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Visit https://www.yoh.com/applicants-with-disabilities to contact us if you are an individual with a disability and require accommodation in the application process.
For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.
It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
By applying and submitting your resume, you authorize Yoh to review and reformat your resume to meet Yoh’s hiring clients’ preferences. To learn more about Yoh’s privacy practices, please see our Candidate Privacy Notice: https://www.yoh.com/privacy-notice
Stay Safe During Your Job Search
Fraudulent recruiting communications have become increasingly common. Emails from Yoh recruiters will only come from an @yoh.com email address. Yoh will never ask candidates to pay fees, purchase equipment, send gift cards, or transfer funds as part of the recruiting or hiring process. If you receive a communication that appears suspicious or requests payment, contact Yoh directly before responding or sharing personal information.
