Data Modeler (Financial Services)

Dexian; Raleigh (NC); On-site; USD 80,000 - 120,000; Full time

Job summary

A leading IT staffing company is seeking a Data Modeler (Financial Services) based in Raleigh, NC. The role demands strong expertise in dimensional data modeling and advanced SQL skills. Candidates should have experience in finance or banking environments as well as familiarity with ETL processes. The position requires on-site presence at the North Hills location and effective communication to collaborate with business stakeholders. This role is crucial in ensuring the delivery of robust database structures optimized for analytics.

Qualifications

• Must be local to Raleigh, NC and willing to work onsite at the North Hills location.
• Solid background in relational database design and database analysis.
• Experience with Oracle databases is preferred.

Responsibilities

• Engage directly with business stakeholders to gather, document, and clarify data requirements.
• Design, develop, and maintain logical and physical data models using Dimensional and Data Vault methodologies.
• Collaborate with ETL and data engineering teams to enable reliable data integration across cloud platforms.

Skills

Strong experience in finance or banking environments

Proven expertise in Dimensional Data Modeling

Advanced SQL skills

Excellent communication skills

Experience working with ETL processes

Experience supporting BI tools such as Power BI and/or Tableau

Job description

Job Title: Data Modeler (Financial Services)

Employment Type: Full-Time

Key Responsibilities

• Engage directly with business stakeholders to gather, document, and clarify data requirements
• Design, develop, and maintain logical and physical data models using Dimensional and Data Vault methodologies
• Translate business requirements into scalable, well-structured database designs
• Design and implement database tables and structures optimized for analytics and downstream consumption
• Perform database analysis to ensure data accuracy, consistency, and usability
• Develop, optimize, and validate SQL queries to support reporting and data quality checks
• Collaborate with ETL and data engineering teams to enable reliable data integration across cloud platforms
• Support BAU data initiatives in a fast-paced, regulated banking environment
• Partner with BI and analytics teams to ensure data models effectively support Power BI and/or Tableau reporting
• Ensure data models align with enterprise architecture standards, financial domain best practices, and future integration initiatives (e.g., data hubs or nexus environments)

Required Qualifications (Must Have)

• Must be local to Raleigh, NC and willing to work onsite at the North Hills location
• Strong experience in finance or banking environments
• Proven expertise in Dimensional Data Modeling
• Solid background in relational database design and database analysis
• Advanced SQL skills
• Experience working with ETL processes and cloud-based data platforms
• Experience supporting BI tools such as Power BI and/or Tableau
• Excellent communication skills with the ability to work directly with business stakeholders

Preferred Qualifications (Nice to Have)

• Hands-on experience with Data Vault modeling
• Experience with Oracle databases
• Familiarity with enterprise data hubs or nexus-style architectures
• Experience with dbt (data build tool)

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.

Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit https://dexian.com/ to learn more.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status