Director, Data Modeling

Fidelity Investments•Westlake, TX

About The Position

The Director, Data Modeling oversees data lineage, metadata management, and semantic consistency across domains. The role establishes and enforces scalable, enterprise-wide modeling methodologies to ensure consistency, quality, and compliance across data domains. It drives best practices for conceptual, logical, and physical data models across transactional, analytical, and cloud-native platforms; influences data architecture decisions; and leads complex data-model design in multi-platform environments including Snowflake, Oracle, and AWS. The position partners with engineering and governance teams to ensure models meet enterprise standards for data quality, accessibility, security, and regulatory alignment. The director translates business vision and strategy into data-architecture recommendations, participates in cross-functional architecture design, and oversees technical implementation of cross-divisional or company-wide data architecture components. The role sets organizational direction, leads broad initiatives and multiple teams, advises senior management on technical strategy and risk, recommends technologies, and provides coaching and career-development guidance. Fidelity states that it is transitioning to a full-time onsite working model through a phased rollout; current onsite requirements vary by role and location and may evolve. The posting does not specify this position’s precise onsite schedule.

Requirements

Bachelor’s degree in Computer Science, Engineering, Information Technology, Information Systems, Business Administration, or a closely related field (or foreign education equivalent), and six years of experience as a Director, Data Modeling or in a closely related occupation performing data modeling and analysis on relational databases using SQL and SAP Power Designer or ERWIN; alternatively, a master’s degree in one of these fields (or foreign education equivalent) and four years of such experience.
Demonstrated expertise creating enterprise data lakes for analytics, AI, and ML capabilities on cloud and on-premises 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 table/view modeling techniques to create conceptual, logical, and physical models according to standards, taxonomy, and best practices, using Erwin and SAP Power Designer in Snowflake, Oracle, and SQL Server analytics data-warehouse environments.
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 through SQL reports; writing SQL/PL-SQL queries and views against SQL Server and Oracle databases; generating reports; and modifying SQL queries to improve performance.
Demonstrated expertise generating DDL (forward-engineering) and DML scripts to create and update physical databases, and reverse-engineering system databases to create additional external tables and columns and gather source-database requirements.
Fidelity will not provide immigration sponsorship for this position.

Responsibilities

Translate and incorporate business vision and strategy into data-architecture strategy recommendations at the functional level.
Participate in high-level, cross-functional data-architecture design teams.
Identify and consult internal and external technical resources to produce cross-company strategic designs.
Consult on development and delivery of major technology initiatives for the business unit.
Consult on deployment of major project deliverables and documentation of major technology applications.
Oversee technical implementation of cross-divisional or company data-architecture components.
Initiate and drive project or strategy discussions with users or external groups to resolve issues.
Set the vision, goals, and direction of the team or organization.
Plan and lead organization-wide initiatives.
Provide leadership, technical supervision, and expertise to multiple teams on complex, organization-wide projects in broad technical areas.
Advise senior management on technical strategy.
Research and recommend new technologies.
Work across groups to identify opportunities for organization-wide technology initiatives.
Provide guidance, training, and coaching to team members for performance and career development.
Identify and plan for future resource needs.
Determine strategic technical approaches for the business unit.
Advise on project risk assessment and risk-management strategies.
Oversee data lineage, metadata management, semantic consistency, and adoption of enterprise data-modeling methodologies and best practices.
Lead complex data-model design for multi-platform environments and partner with engineering and governance teams to validate enterprise standards.