Senior Data Modeler: DW & ETL Architect | Secret Clearance

Talentify; O'Fallon (IL); On-site; USD 75,000 - 158,000; Full time

Job summary

CACI is seeking a Data Modeler to design enterprise data models and scalable data warehousing solutions. You will guide ETL design, data integration, and analytical reporting across multi-system environments.

You will mentor teammates, translate business requirements into technical data models, and collaborate with stakeholders to optimize BI capabilities, reporting performance, and data discovery.

Qualifications

• Bachelor's degree or equivalent with 5–7 years of relevant experience.
• Expert-level dimensional data modeling and data warehousing knowledge.
• Advanced SQL development, query optimization, and data profiling skills.
• Experience leading design sessions and translating requirements into data solutions.
• Ability to work across ERP systems and analytics platforms.

Responsibilities

• Design and Architect dimensional data models and data frameworks.
• Build and optimize ETL processes between transactional and analytical systems.
• Lead design sessions and gather requirements across multiple systems.
• Perform SQL development, profiling, and optimization for scalable data solutions.
• Translate technical concepts for non-technical stakeholders and influence practices.
• Mentor junior team members and guide technical direction.
• Deliver reports, dashboards, and OLAP databases for BI needs.

Skills

SQL development

Dimensional data modeling

ETL

Mentoring

Requirements gathering

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, or related field

Tools

Power BI

Tableau

Alteryx

SAP

Oracle

Job description

CACI is seeking a Data Modeler to design enterprise data models and scalable data warehousing solutions. You will guide ETL design, data integration, and analytical reporting across multi-system environments.

You will mentor teammates, translate business requirements into technical data models, and collaborate with stakeholders to optimize BI capabilities, reporting performance, and data discovery.