Principal Data Modeler

Are you ready to make an impact at DTCC?

Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve.

Pay and Benefits:

• Competitive compensation, including base pay and annual incentive
• Comprehensive health and life insurance and well-being benefits, based on location
• Pension / Retirement benefits
• Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
• DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).

The impact you will have in this role:

Being a member of the Data Architecture Team, the Associate Director will play an influential role to chart the course for our data strategy, tightly integrating it with our overarching business vision to drive innovation and growth. In addition, the Principal Data Modeler will act as a critical liaison between technical and non-technical teams, simplifying complex concepts and fostering data-driven decision-making.

Your Primary Responsibilities:

• Assist in steering a comprehensive vision for enterprise data solutions that aligns with our corporate ambitions and paves the path for transformative business outcomes
• Contribute to the development of standard methodologies for data architecture, data modeling, and analytics development
• Stay at the forefront of industry trends and continuously refining our processes to ensure the highest-quality, innovative, and efficient solutions
• Build collaborative relationships with business unit leaders and partners, examining their data needs to ensure the data strategy laser-focused organizational objectives
• Elevate and guide our data engineering and product teams on standard methodologies to foster a culture that prizes forward-thinking, agility, and continuous innovation. Lay the foundation of a robust data governance regime prioritizing data integrity, ethical use, and compliance as pillars of our data-centric approach
• Ensure data systems and platforms are designed and implemented to support next-generation data and analytics capabilities. Cultivate strategic partnerships with technology vendors, service providers, and industry thought leaders to keep abreast of emerging trends and opportunities in data engineering
• Serve as a data ambassador, effectively communicating the strategic value of data engineering and architecture initiatives to partners

NOTE: The Primary Responsibilities of this role are not limited to the details above.

Qualifications:

• Minimum 8 years of related experience
• Bachelor's degree (preferred) or equivalent experience

Talents Needed for Success:

• 7-10 years of experience with information technology programs and services, with proven expertise in enterprise data management and related technologies
• Detailed knowledge of Erwin Data Modeler (V9 or higher) or a comparable CASE tool
• Data management and data architecture related certifications (ex. AWS, TOGAF) are preferred
• Detailed knowledge of data warehousing concepts and the ability to convert a physical design into a dimensional design
• Knowledge of Agile development methodology and concepts
• Experience working as a member of distributed data architecture teams
• Understanding of information systems and data life-cycle management standard processes and methodologies, formal systems engineering life cycle (SELC), and systems development life cycle (SDLC)
• Detailed hands-on SQL experience
• Solid grasp of cloud technology and tools as it relates to data architecture
• Experience with two or more of the following DBMS technologies: Oracle, PostgreSQL, Snowflake, Microsoft SQL Server, DB2
• Hands-on experience with ETL tool(s): (Informatica, DataStage, Talend, etc.)
• Hands-on experience with Business Intelligence (BI) tools: (ex. OBIEE, MicroStrategy, Tableau, Power BI, QuickSight, Sigma, etc.)
• Experience with any commercially available industry data model (ex. IBM's Financial Services Data Model) preferred
• Good understanding of the concepts in the financial industry, especially in trade, clearing and settlement preferred
• Experience with data cataloging, data discovery, data observability, and/or data quality tools preferred

The salary range is indicative for roles at the same level within DTCC across all US locations. Actual salary is determined based on the role, location, individual experience, skills, and other considerations. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.