CACI International

Data Modeler

CACI International • $75K — $158K *
US-AnywhereRemote in United States
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Active DoD Secret clearance required
  • Bachelor's degree in Computer Science or related field with 5–7 years experience
  • Expert in dimensional data modeling and data warehousing principles
  • Advanced skills in SQL development and ETL process design
  • Demonstrated ability to translate business requirements into technical solutions

Responsibilities

  • Design and architect dimensional data models and data frameworks
  • Create and optimize ETL processes for data handling
  • Lead design sessions and gather requirements from experts
  • Analyze SQL development and optimize queries for efficiency
  • Translate technical concepts for non-technical stakeholders
  • Mentor lower-level team members in technical practices
  • Build reports, dashboards, and OLAP databases for business intelligence

Benefits

  • Comprehensive healthcare and wellness benefits
  • Financial and retirement support options
  • Family support and continuing education programs
  • Generous time off policies to balance personal and professional life
  • Flexible work arrangements to accommodate various lifestyles
Full Job Description
Job Title: Data Modeler

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: Secret

Employee Type: Regular

Percentage of Travel Required: Up to 10%

Type of Travel: Local

* * *

The Opportunity:


Join our innovative team as a Data Modeler where you'll play a pivotal role in designing and implementing enterprise-level data solutions that drive business intelligence and strategic decision-making. This position offers the opportunity to work with cutting-edge technologies while solving complex data challenges in a dynamic, fast-paced environment.

As a recognized subject matter expert, you'll lead the design and development of sophisticated data models, architect scalable data warehousing solutions, and translate complex business requirements into technical excellence. You'll mentor team members, influence technical direction, and deliver solutions that optimize analytical reporting performance across the organization


Responsibilities:

  • Design & Architect: Develop dimensional data models (fact/dimension design) and data frameworks that optimize analytical reporting performance and support end-user data discovery
  • Build & Transform: Create and optimize ETL processes for data extraction, transformation, cleansing, and loading between transactional and analytical systems
  • Collaborate & Lead: Lead design sessions, facilitate requirements gathering with subject matter experts, and guide technical solutions across complex, multi-system environments
  • Analyze & Optimize: Perform SQL development, query optimization, and data profiling to ensure scalable and efficient data solutions
  • Communicate & Influence: Translate technical concepts for non-technical stakeholders and influence policies, practices, and procedures across teams
  • Mentor & Guide: Coach and provide technical guidance to lower-level team members, fostering a culture of technical excellence
  • Deliver: Build reports, dashboards, and OLAP databases that meet complex business intelligence and information requirements

Qualifications:

Required: 


  • Clearance: An active DoD Secret clearance
  • Education & Experience: Bachelor's degree in Computer Science, Information Systems, Engineering, or related field with 5–7 years of relevant experience, or equivalent combination of education and experience
  • Technical Expertise: Expert-level dimensional data modeling (fact/dimension design)Deep knowledge of data warehousing, data marts, and data architecture principles. Advanced SQL development, query optimization, and data profiling capabilities. Proven source-to-target mapping and ETL process design and implementation. Strong understanding of data structures, relationships, and database design principles (PK/FK, schemas)
  • Professional Skills: Demonstrated ability to translate business requirements into technical data solutions and models. Experience working across complex, multi-system environments (ERP systems, analytics platforms, etc.)Proven track record leading design sessions and facilitating requirements gathering. Strong analytical and problem-solving abilities with focus on scalable, efficient solutions. Excellent communication skills with ability to present technical concepts to diverse audiences. Experience mentoring or providing technical guidance to peers. Ability to manage multiple priorities and adapt in a fast-paced, evolving environment

Desired:


  • Hands-on experience with BI and analytics tools (e.g., Power BI, Tableau, Alteryx)
  • Experience with enterprise ERP systems (e.g., SAP, Oracle)
  • Familiarity with data lake architectures and modern analytics ecosystems
  • Experience developing data modeling standards and comprehensive documentation
  • Knowledge of online analytical processing (OLAP) tools and technologies
  • Background in statistical analyses, predictive forecasting, and trend interpretation

Ready to Apply?

If you're a data professional who thrives on designing elegant solutions to complex problems and wants to make a strategic impact through data architecture and analytics, we want to hear from you!

-


Pay Range:

There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.

Since this position can be worked in more than one location, the range shown is the national average for the position.

The proposed salary range for this position is:

$75,200-$158,100

About CACI International

CACI International Inc is a multinational professional services and information technology company. It provides services to many branches of the federal government including defense, homeland security, intelligence, and healthcare. CACI has approximately 23,000 employees worldwide. The company's mission is to provide enterprise and mission technology services and solutions that best fit the needs of its customers. CACI has been named a Fortune World's Most Admired Company, a Washington Post Top Workplace, and a Forbes Best Employer for Diversity.
Learn more about CACI International
Size
22,000 employees
Market Cap
$7.1 billion
Industry
Net Income
$374.4 million
Founded
1962
5 Year Trend
+7.3%
Revenue
$5.8 billion
NASDAQ

Similar Jobs

More Jobs at CACI International

  • CACI International
    AI/ML Engineer
    $82K — $172K *
    King Of Prussia, PA 19406 (Montgomery County)
    Information Technology
    In-Person
  • CACI International
    Software Engineer Skill Level 0
    $72K — $149K *
    Annapolis Junction, MD 20701 (Howard County)
    Aerospace & Defense
    In-Person
  • CACI International
    Software Engineer Skill Level 0
    $72K — $149K *
    Annapolis, MD 21401 (Anne Arundel County)
    Aerospace & Defense
    In-Person
  • CACI International
    AI Technologist
    $131K — $290K *
    Fort Washington, MD 20744 (Prince Georges County)
    Education, Government & Non-Profit
    In-Person
  • CACI International
    Senior Full Stack Developer
    $120K — $265K *
    Fort Washington, MD 20744 (Prince Georges County)
    Education, Government & Non-Profit
    In-Person

More Information Technology Jobs

Find similar Data Modeler jobs: