Data Modeler

Posted 10 Days Ago
Be an Early Applicant
Hiring Remotely in O'Fallon, IL, USA
In-Office or Remote
75K-158K Annually
Senior level
Information Technology • Consulting • Defense
The Role
Designs enterprise data models, data warehouses, data marts, ETL processes, and OLAP databases to support business intelligence and analytics. Develops and optimizes SQL, performs data profiling, translates business requirements into scalable technical solutions, and leads design sessions across complex systems. The role also includes stakeholder communication, mentoring junior team members, reporting and dashboard development, and establishing data modeling standards.
Summary Generated by Built In
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!

-

What You Can Expect:

 A culture of integrity.

At CACI, we place character and innovation at the center of everything we do. As a valued team member, you’ll be part of a high-performing group dedicated to our customer’s missions and driven by a higher purpose – to ensure the safety of our nation.

An environment of trust.

CACI values the unique contributions that every employee brings to our company and our customers - every day. You’ll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.

A focus on continuous growth.

Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground — in your career and in our legacy.

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

CACI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.

Skills Required

  • Active DoD Secret clearance
  • Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, with 5–7 years of relevant experience, or equivalent education and experience
  • Expert-level dimensional data modeling, including fact and dimension design
  • Deep knowledge of data warehousing, data marts, and data architecture principles
  • Advanced SQL development, query optimization, and data profiling capabilities
  • Experience designing and implementing source-to-target mappings and ETL processes
  • Strong understanding of data structures, relationships, database design, primary keys, foreign keys, and schemas
  • Ability to translate business requirements into technical data solutions and models
  • Experience working across complex, multi-system environments
  • Experience leading design sessions and facilitating requirements gathering
  • Strong analytical, problem-solving, communication, and stakeholder presentation skills
  • Experience mentoring or providing technical guidance to peers
  • Ability to manage multiple priorities and adapt in a fast-paced environment
  • Hands-on experience with Power BI, Tableau, or Alteryx
  • Experience with enterprise ERP systems such as SAP or Oracle
  • Familiarity with data lake architectures and modern analytics ecosystems
  • Experience developing data modeling standards and comprehensive documentation
  • Knowledge of OLAP tools and technologies
  • Background in statistical analysis, predictive forecasting, and trend interpretation

CACI International Inc Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about CACI International Inc and has not been reviewed or approved by CACI International Inc.

  • Healthcare Strength — Pay is supported by a broad set of health-plan options across multiple national carriers, with telemedicine and tax-advantaged accounts included. Dental and vision choices are also described as multi-option, which strengthens overall coverage breadth.
  • Leave & Time Off Breadth — Flexible Time Off is available for many salaried-exempt roles, while hourly roles accrue PTO, creating multiple time-off pathways by employment class. Paid disability coverage, fixed holidays, and paid leave programs (including parental leave and other leave types) further round out time-off and leave coverage.
  • Retirement Support — Retirement support includes a 401(k) match structure described as 50% up to 8% of pay (effective 4%) and an Employee Stock Purchase Plan with a discount. Tuition reimbursement and certification support also add to the overall rewards package that complements core retirement benefits.

CACI International Inc Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Reston, VA
17,673 Employees
Year Founded: 1962

What We Do

CACI’s approximately 23,000 talented employees are vigilant in providing the unique expertise and distinctive technology that address our customers’ greatest enterprise and mission challenges. Our culture of good character, innovation, and excellence drives our success and earns us recognition as a Fortune World's Most Admired Company. As a member of the Fortune 1000 Largest Companies, the Russell 1000 Index, and the S&P MidCap 400 Index, we consistently deliver strong shareholder value. Visit us at www.caci.com.

Similar Jobs

Aptive Resources Logo Aptive Resources

Database Engineer

Healthtech • Information Technology • Consulting
Remote
US
349 Employees

Experian Logo Experian

Expert Data Modeler, Fraud Risk Detection

Big Data • Marketing Tech • Analytics
Remote
United States
16292 Employees
104K-180K Annually

Experian Logo Experian

Senior Data Modeler, Fraud Risk Detection

Big Data • Marketing Tech • Analytics
Remote
United States
16292 Employees
83K-143K Annually

Nexaminds Logo Nexaminds

Enterprise Data Modeler

Artificial Intelligence • Cloud • Information Technology • Machine Learning • Natural Language Processing • Consulting
Remote
2 Locations
80 Employees

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Outpost Space Thumbnail
Aerospace • Defense
Los Angeles, California
38 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account