Back to Job Search

Lead No/SQL Data Modeler

  • Location: Charlotte, 28288
  • Salary: $80.00 - $85.64 / hour
  • Job Type:Contract

Posted 2 months ago

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

Candidates will be responsible for following the client's COVID-19 protocols. Please refer to your MATRIX representative for specifics.

About Us

At MATRIX, we expertly match talented professionals with job opportunities to elevate careers. Since 1983, we have placed thousands of professionals at innovative clients across every industry ranging from small startups to Fortune 50 companies. It’s why we’re consistently in the top 25 of all U.S. IT staffing firms and why our consultants rate us well above the industry average, earning us ClearlyRated's Best of Staffing awards year after year. People come to us for a job, and stay with us because of our top-notch consultant care.

MATRIX is and Equal Employment Opportunity employer including disability and veteran and provides reasonable accommodations for all qualified individuals.  Supporting medical or religious documentation will be required where applicable. If you are a qualified individual you may request a reasonable accommodation under the American Disability Act (ADA). If you are a person with a disability needing assistance applying, or at any point in the hiring process, please email us at MATRIX_HR@MatrixRes.com. To ensure a quick response to your request, please use the words “Accommodation request” as the subject line of your email.

For hourly W2 contract roles MATRIX offers a highly competitive benefit package including Medical, Dental, Vision, Life, Disability, HSA, and 401(k) with pre and post-tax options.  Please see MatrixRes.com/Benefits for more information.

For direct hire placement with our clients, benefits would be offered in accordance with that particular client’s offerings. This may include PTO, Medical, Dental, Vision, 401K and other pre and post-tax options.