Work with the brightest minds at one of the largest financial institutions in the world. This is long-term contract opportunity that includes a competitive benefit package!
Our client has been around for over 150 years and is continuously innovating in today's digital age. If you want to work for a company that is not only a household name, but also truly cares about satisfying customers' financial needs and helping people succeed financially, apply today.
Position: Lead Data Modeler
Location: Charlotte NC, Dallas TX, Philadelphia PA, Palo Alto CA
Term: 6 months
Day-to-Day Responsibilities:
- Provide data modeling leadership for a team of data engineers and other data modelers
- Lead the design and development of Data Models aligning with the Domani Aligned Data Product architecture (following data mesh principles)
- Understand the data sources and consumption needs of the various domains as they evolve, and maintain a high-level context-map of domain data products
- Work with the domain data SMEs and key stakeholders to understand the BI reporting and analytics, data science teams to gather requirements for the data models
- Collaborate with the data engineers to design, build and validate the data models for BI, analytics, ML features, data warehouse and reporting
- Adjust access to the data and the reports as needed
- Identify proper data classification of sensitive/confidential data elements
- Understand any data refactoring opportunities as we migrate or refactor technical debt in place
- Work with the data engineers to implement the refactoring and migration
- Help determine and manage data cleaning and business DQ requirements
- Help determine data security needs and implement data-centric security solutions
- Participates in collaborative working environment using the agile methodology
- Provide technical leadership and guidance to business partners, peers and vendor partners
Is this a good fit? (Requirements):
- 10+ years of information architecture and data modeling experience
- 10+ years of BI/DW and data modeling experience
- Knowledge of Data Warehousing, ETL and BI architectures, concepts and frameworks
- Deep knowledge of Kimball, Inmon, Data Vault approaches for data warehouse modeling and the core differences
- Experience in data warehouse/data mart/NoSQL modeling principles/methods including conceptual, logical & physical Data Models
- Deep experience with time-series, dimensional, column-oriented, event sourced, and semantic data modeling patterns
- Optimizing physical models based on use case needs and data access patterns, considering performance, volumes, and complexity of queries
- Capable of facilitating data discovery sessions involving business subject matter experts
- Experience in translating/mapping relational data models into Data Schemas
- Experience with modeling tools (such as ERWin and ER/Studio)
- Ability to create and maintain conceptual/business, logical and physical data models
- Ability to translate a logical model into a physical model, adding appropriate physical objects needed to create the database e.g. indexes
- Experience maintaining a model repository, along with enforcing logical model versioning, tied to physical schema evolution
- Ability to synchronize models to ensure that database structures match models
- Familiar with metadata ingestion and translation
- Excellent presentation, communication, and organizational skills
- Strong interpersonal skills and ability to work as part of a team
- Familiar with Data Governance Process Management
Desired Qualifications:
- Domain Driven Design based Data Product and Data Mesh Architecture concepts to develop highly interoperable data products
- Cyber Security domain knowledge
- Data modeling in the GCP/Azure cloud environments are a bonus