Lead Data Modeler

Synechron; Charlotte (NC); On-site; USD 105,000 - 115,000; Full time

Benefits offered by this job

Competitive compensation and benefits

Opportunity to work abroad across Syne

10 days paid annual leave

Maternity & paternity leave plans

Comprehensive insurance plan

Retirement savings plans

Udemy for Business access

Job summary

Synechron is seeking a senior Data Modeler to support a Home Lending data modernization and regulatory reporting project. The role emphasizes data modeling across mortgage origination, servicing, and regulatory reporting with a cloud-native GCP BigQuery stack.

You will work with governance, risk, and analytics teams to translate regulatory requirements into scalable data structures, ensuring data quality and lineage across enterprise data assets.

Qualifications

• Bachelor's degree required with 12+ years hands-on data modeling in enterprise environments.
• 5+ years in Banking, Financial Services, Risk, or Regulatory Reporting domains.
• Experience in large-scale Data Warehouse Modernization or Cloud Transformation initiatives.
• Strong expertise in Home Lending, Mortgage Origination, and Mortgage Servicing data domains.
• Proven experience supporting FR Y-14M or similar regulatory reporting programs.
• Knowledge of Data Governance, metadata management, and data cataloging.

Responsibilities

• Design conceptual, logical, and physical data models for Home Lending and Regulatory Reporting.
• Develop scalable enterprise data models for Google BigQuery environments.
• Model data across Raw, Curated, Business, and Reporting layers.
• Define business rules, relationships, and metadata standards.
• Collaborate with data engineers and stakeholders to modernize legacy warehouses.
• Support data lineage, audits, and regulatory examinations.

Skills

Data Modeling

Home Lending

Mortgage Origination

Mortgage Servicing

FR Y-14M Regulatory Reporting

Banking Data Architecture

Data Governance

Cloud Data Platforms

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, Finance, or a related discipline

Tools

ERwin Data Modeler

ER/Studio

SAP PowerDesigner

SQL Developer Data Modeler

Google BigQuery

Dataflow

Pub/Sub

Oracle

SQL Server

Hive

Job description

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 16,700+, and has 57 offices in 22 countries within key global markets.

We are seeking a highly experienced Data Modeler to support a strategic Home Lending Data Modernization and Regulatory Reporting Transformation initiative. This program aims to modernize and simplify the Home Lending data ecosystem by migrating legacy reporting platforms and data warehouses to a scalable cloud-native architecture on Google Cloud Platform (GCP) leveraging BigQuery.

The ideal candidate will possess deep expertise in Data Modeling, Home Lending, Mortgage Origination, Mortgage Servicing, FR Y-14M Regulatory Reporting, Banking Data Architecture, Data Governance, and Cloud Data Platforms. This role will be instrumental in designing enterprise-scale data models supporting regulatory reporting, risk management, analytics, data governance, and self-service reporting capabilities.

Additional Information

The base salary for this position will vary based on geography and other factors. In accordance with applicable laws, the expected base salary range for this role if filled within Charlotte, NC is $105K - $115K/year & benefits (see below).

The Role

Responsibilities

• Design and maintain conceptual, logical, and physical data models for Home Lending and Regulatory Reporting domains.
• Develop scalable and optimized enterprise data models for Google BigQuery environments.
• Mortgage Origination
• Customer Information
• Loan Performance
• Delinquency Management
• Regulatory Reporting
• Define business rules, data relationships, cardinality, and metadata standards across enterprise datasets.
• Develop canonical and harmonized data models integrating multiple source systems.
• Analyze, model, and document data requirements for FR Y-14M Regulatory Reporting, including:
  • Home Equity
  • Loan-Level Performance
  • Borrower Information
  • Property Information
  • Delinquency & Default Data
• Translate complex regulatory requirements into scalable reporting structures and data attributes.
• Ensure compliance with Federal Reserve reporting standards and enterprise governance policies.
• Support data lineage documentation, regulatory audits, examinations, and compliance reviews.
• Partner with business and technical teams to modernize legacy warehouse and reporting environments.
• Design and optimize data models across:
  • Raw Layer
  • Curated Layer
  • Business Layer
  • Reporting Layer
• Define reusable data assets, enterprise data standards, and reporting datasets.
• Establish enterprise naming conventions, metadata standards, and modeling best practices.
• Collaborate with governance teams on:
  • Data Quality Rules
  • Data Controls
  • Reference Data Management
  • Data Cataloging
• Conduct data discovery workshops and data model review sessions with business stakeholders.
• Present data architecture and modeling solutions to both technical and non-technical audiences.
• Partner with Data Engineers, Data Architects, Product Owners, Risk Teams, and Regulatory Reporting teams to deliver scalable cloud-based solutions.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Engineering, Finance, or a related discipline.
• 12+ years of hands‑on Data Modeling experience in enterprise environments.
• 5+ years of experience within Banking, Financial Services, Risk, or Regulatory Reporting domains.
• Extensive experience supporting large‑scale Data Warehouse Modernization or Cloud Transformation initiatives.
• Strong experience in Home Lending, Mortgage Origination, and Mortgage Servicing data domains.
• Proven experience supporting FR Y-14M reporting or similar regulatory reporting programs.
• Conceptual Data Modeling
• Logical Data Modeling
• Physical Data Modeling
• Dimensional Modeling
• Data Vault Modeling
• Snowflake Schema Design
• Hands‑on experience with Google Cloud Platform (GCP), including:
  • BigQuery
  • Dataflow
  • Pub/Sub
• Strong experience with enterprise databases and warehouse platforms including:
  • Oracle
  • SQL Server
  • Hive
  • BigQuery
• Metadata Management
• Data Governance
• Data Quality Frameworks
• Master Data Management (MDM)
• Data Cataloging
• Strong understanding of enterprise regulatory reporting, risk reporting, and financial data governance frameworks.
• Excellent stakeholder management, communication, and problem‑solving skills.
• Experience working in Agile delivery environments.

Preferred, but not required

• Experience working with large U.S. banking institutions.
• Knowledge of risk management and finance data domains.
• Experience supporting regulatory reporting modernization initiatives.
• Familiarity with AI‑assisted data discovery and metadata management tools.
• Experience with Mortgage Origination Systems (LOS) and Mortgage Servicing Platforms.
• Exposure to enterprise data reconciliation and data control frameworks.
• Professional certifications in Data Management, Cloud Technologies, or Data Architecture.

Tools & Technologies

• ERwin Data Modeler
• ER/Studio
• SAP PowerDesigner
• SQL Developer Data Modeler
• Google BigQuery
• Dataflow
• Oracle
• SQL Server
• Hive
• GCP Ecosystem

We offer

• A highly competitive compensation and benefits package.
• A multinational organization with 60 offices in 20 countries and the possibility to work abroad.
• 10 days of paid annual leave (plus sick leave and national holidays).
• Maternity & paternity leave plans.
• A comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region).
• Retirement savings plans.
• A higher education certification policy.
• Commuter benefits (varies by region).
• Extensive training opportunities, focused on skills, substantive knowledge, and personal development.
• On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.
• Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellence (CoE) groups.
• Cutting edge projects at the world’s leading tier‑one banks, financial institutions and insurance firms.
• A flat and approachable organization.
• A truly diverse, fun-loving, and global work culture.

SYNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.