Director, Data Modeling
FMR
- Westlake, TX
- On-site
- Director+ level
- 6+ yrs experience
- Data Modeling
- No visa sponsorship
The role in 30 seconds
This Director, Data Modeling role oversees data lineage, metadata management, and semantic consistency, establishing and enforcing enterprise-wide modeling methodologies. The position influences data architecture decisions and leads the design of complex data models across multiple platforms like Snowflake, Oracle, and AWS, partnering with engineering and governance teams to ensure compliance with enterprise standards.
Is this role a fit for you?
The backgrounds this role is most likely to hire from, as RoleStack reads the posting.
Strong match
- Internal tooling / back-office systems
- B2B enterprise platform / workflow software
- B2B infrastructure / API / developer tools
- Data platform / ML pipeline
Workable stretch
- B2C consumer-facing application
- Creator / builder / self-serve tool
- Marketplace / multi-sided platform
Harder transition
- Embedded systems / hardware-adjacent
Industry: Financial Services & FinTech. See your personal match score
What they're really screening for
Must-haves
- CORE Bachelor’s degree in Computer Science, Engineering, Information Technology, Information Systems, Business Administration, or a closely related field (or foreign education equivalent) and six (6) years of experience as a Director, Data Modeling (or closely related occupation) performing data modeling and analysis on relational databases using SQL and SAP Power Designer or ERWIN.
- CORE Master’s degree in Computer Science, Engineering, Information Technology, Information Systems, Business Administration, or a closely related field (or foreign education equivalent) and four (4) years of experience as a Director, Data Modeling (or closely related occupation) performing data modeling and analysis on relational databases using SQL and SAP Power Designer or ERWIN.
- CORE Demonstrated Expertise creating enterprise data lakes used for analytics, Artificial Intelligence (AI), and Machine Learning (ML) capabilities on Cloud and On-Prem Platforms, using big data processing techniques and solutions.
- CORE Demonstrated Expertise designing complex dimensional and relational databases using Ralph Kimball (Star and Snowflake), Bill Inmon Data Vault Design, and Denormalized Analytical Based Table/View data modeling techniques to create conceptual, logical, and physical models according to standards, taxonomy, and best practices, using data modeling tools – Erwin, and SAP Power Designer in an analytics data warehouse environment in Snowflake, Oracle, and SQL Server.
- CORE Demonstrated Expertise building source-to-target mapping documents, profiling, mining, specifying, extracting, cleansing, and analyzing large data warehouses, using SQL Developer, Toad, and Python; generating insights for business and end users using SQL reports; writing SQL/PL-SQL queries and views against the database (SQL Server/Oracle) and generating reports; and modifying the existing SQL queries for improving query performance.
- CORE Demonstrated Expertise generating DDL scripts (Forward-engineer) and DML scripts to create and update physical databases; and performing reverse-engineering of system database to create additional external tables and columns to gather data requirements from the source databases.
- CORE Oversees data lineage, metadata management, and semantic consistency across domains.
- CORE Establishes and enforces scalable, enterprise-wide modeling methodologies that ensure consistency, quality, and compliance across all data domains.
- CORE Drives adoption of best practices for conceptual, logical, and physical data models across transactional, analytical, and cloud-native platforms.
- CORE Influences data architecture decisions to support scalability, interoperability, and business agility.
Résumé keywords for this role
Terms the posting stresses. Include the ones you can honestly back up.
Tools & technologies
- Snowflake
- Oracle
- AWS
- SAP Power Designer
- ERWIN
- SQL Server
- SQL
- SAP
- AI
- Artificial Intelligence
- ML
- Machine Learning
- Cloud
- On-Prem Platforms
- big data
Concepts & phrases
- Director, Data Modeling
- data lineage
- metadata management
- semantic consistency
- enterprise‑wide modeling methodologies
- conceptual, logical, and physical data models
- transactional, analytical, and cloud-native platforms
- data architecture decisions
- complex data models
- multi-platform environments
- enterprise standards
- data quality, accessibility, security, and regulatory alignment
- business vision and strategy
- data architectural strategy recommendations
- cross-functional data architecture design teams
Words that count as the same thing: "AI" ≈ Artificial Intelligence · "ML" ≈ Machine Learning · "SAP Power Designer" ≈ PowerDesigner · "Erwin" ≈ ERwin Data Modeler · "SQL Server" ≈ Microsoft SQL Server
Check my résumé against these keywordsHiring at FMR
Open senior roles RoleStack tracks right now, posted in the last 30 days.
More open roles at FMR
Full job description from FMR
From FMR's posting. View the original
Fidelity will not provide immigration sponsorship for this position.
Job Description:
Position Description:
Oversees data lineage, metadata management, and semantic consistency across domains. Establishes and enforces scalable, enterprise‑wide modeling methodologies that ensure consistency, quality, and compliance across all data domains. Drives adoption of best practices for conceptual, logical, and physical data models across transactional, analytical, and cloud-native platforms. Influences data architecture decisions to support scalability, interoperability, and business agility. Leads the design of complex data models for multi-platform environments (Snowflake, Oracle, and AWS). Partners with engineering and governance teams to validate that models meet enterprise standards for data quality, accessibility, security, and regulatory alignment.
Show full description Show less
Primary Responsibilities:
• Translates and incorporates business vision and strategy to data architectural strategy recommendations at the functional level.
• Participates in high-level, cross-functional data architecture design teams.
• Identifies and consults with internal and external technical resources to produce cross-company strategic designs.
• Consults on development and delivery of major technology initiatives for the business unit.
• Consults on deployment of major project deliverables.
• Consults on the documentation of major technology applications.
• Oversees the technical implementation of cross-divisional or company data architectural components.
• Initiates and drives project or strategy discussions with users or external groups to resolve issues.
• Sets vision, goals, and direction of team/organization.
• Plans and leads organization-wide initiatives.
• Provides leadership, technical supervision, and expertise to multiple teams in broad technical areas on complex organization-wide projects.
• Advises senior management on technical strategy.
• Researches and recommends new technologies.
• Works across groups to identify opportunities for organization-wide technology initiatives.
• Regularly provides guidance, training, and coaching to other team members for performance and career development.
• Identifies and plans for future resource needs.
• Determines technical approaches at a strategic level for the business unit.
• Advises on risk assessment and risk management strategies for projects.
Education and Experience:
Bachelor’s degree in Computer Science, Engineering, Information Technology, Information Systems, Business Administration, or a closely related field (or foreign education equivalent) and six (6) years of experience as a Director, Data Modeling (or closely related occupation) performing data modeling and analysis on relational databases using SQL and SAP Power Designer or ERWIN.
Or, alternatively, Master’s degree in Computer Science, Engineering, Information Technology, Information Systems, Business Administration, or a closely related field (or foreign education equivalent) and four (4) years of experience as a Director, Data Modeling (or closely related occupation) performing data modeling and analysis on relational databases using SQL and SAP Power Designer or ERWIN.
Skills and Knowledge:
Candidate must also possess:
• Demonstrated Expertise creating enterprise data lakes used for analytics, Artificial Intelligence (AI), and Machine Learning (ML) capabilities on Cloud and On-Prem Platforms, using big data processing techniques and solutions.
• Demonstrated Expertise designing complex dimensional and relational databases using Ralph Kimball (Star and Snowflake), Bill Inmon Data Vault Design, and Denormalized Analytical Based Table/View data modeling techniques to create conceptual, logical, and physical models according to standards, taxonomy, and best practices, using data modeling tools – Erwin, and SAP Power Designer in an analytics data warehouse environment in Snowflake, Oracle, and SQL Server.
• Demonstrated Expertise building source-to-target mapping documents, profiling, mining, specifying, extracting, cleansing, and analyzing large data warehouses, using SQL Developer, Toad, and Python; generating insights for business and end users using SQL reports; writing SQL/PL-SQL queries and views against the database (SQL Server/Oracle) and generating reports; and modifying the existing SQL queries for improving query performance.
• Demonstrated Expertise generating DDL scripts (Forward-engineer) and DML scripts to create and update physical databases; and performing reverse-engineering of system database to create additional external tables and columns to gather data requirements from the source databases.
#PE1M2
#LI-DNI
Fidelity’s Onsite Working Model
Fidelity is transitioning to a full-time onsite working model through a phased rollout across regions and roles. Currently, some roles and locations require 100% onsite presence, while others require less. Onsite expectations are likely to evolve as the rollout continues. This transition does not apply to fully remote roles.
Certifications:
Category:
Information TechnologyPlease be advised that Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.
FAQ
How much experience do you need?
The posting asks for 6+ years in director, data modeling. It is a director+-level role.
Does FMR sponsor visas for this role?
The posting says visa sponsorship is not available.
Is this role remote?
It is an on-site role.
What tools and technologies does the posting mention?
Snowflake, Oracle, AWS, SAP Power Designer, ERWIN, SQL Server, SQL, SAP, AI, Artificial Intelligence, ML, Machine Learning, Cloud, On-Prem Platforms, big data.