Data Modeler & BI Architect (ETL & Data Warehouse)

CACI International; United States; Remote; USD 95,000 - 158,000; Full time

Benefits offered by this job

Healthcare

Learning resources

Flexible time off

Job summary

CACI International is seeking a Data Modeler to design and implement enterprise‑level data solutions that drive business intelligence and strategic decision making. You will lead the design and development of dimensional models, architect scalable data warehouses, and translate complex requirements into technical excellence.

You will mentor teammates, collaborate across ERP and analytics platforms, optimize ETL processes, perform SQL development and data profiling, and deliver reports and OLAP

Qualifications

• Active DoD Secret clearance is required.
• Bachelor's degree in Computer Science, Information Systems, Engineering or related field with 5–7 years of relevant experience, or equivalent.
• Expert-level dimensional data modeling, data warehousing, data marts, and data architecture principles.
• Advanced SQL development, query optimization, and data profiling capabilities.
• Ability to translate business requirements into technical data solutions and models; experience across multi-system environments.

Responsibilities

• Design & Architect: Develop dimensional data models and data frameworks to optimize analytical reporting and data discovery.
• Build & Transform: Create and optimize ETL processes between transactional and analytical systems.
• Collaborate & Lead: Lead design sessions and gather requirements across complex, multi-system environments.
• Analyze & Optimize: Perform SQL development, query optimization, and data profiling for scalable solutions.
• Communicate & Influence: Translate technical concepts for non-technical stakeholders and influence practices.
• Mentor & Guide: Coach team members and foster technical excellence.
• Deliver: Build reports, dashboards, and OLAP databases to meet BI requirements.

Skills

Dimensional data modeling

SQL development

Data warehousing

ETL design

Requirements gathering

Data profiling

Communication

Education

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

Tools

SQL

Power BI

Tableau

Alteryx

OLAP

Job description

CACI International is seeking a Data Modeler to design and implement enterprise‑level data solutions that drive business intelligence and strategic decision making. You will lead the design and development of dimensional models, architect scalable data warehouses, and translate complex requirements into technical excellence.

You will mentor teammates, collaborate across ERP and analytics platforms, optimize ETL processes, perform SQL development and data profiling, and deliver reports and OLAP