Data Modeler

Job Title: Data Modeler

The Opportunity:

Join our innovative team as a Data Modeler where youll 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 youll lead the design and development of sophisticated data models architect scalable data warehousing solutions and translate complex business requirements into technical excellence. Youll 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:

• Clearance: An active DoD Secret clearance
• Education & Experience : Bachelors degree in Computer Science Information Systems Engineering or related field with 57 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 youre 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 youll be part of a high-performing group dedicated to our customers 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. Youll 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 nations 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:

CACI is anEqualOpportunity 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 otherprotectedcharacteristic.