Data Analyst

About the role

CACI is seeking an experienced, self-directed enterprise Power BI Developer to be responsible for transforming complex data from a variety of sources into a variety of informational formats appropriate to the diverse target audiences. EITaaS Program is a Department of the Air Force (DAF) initiative, which includes the Air Force and Space Force. EITaaS will transform the Dept. of the Air Force IT services to an advanced enterprise service delivery model, providing enhanced enterprise IT capabilities, global service desk, local field services, and life cycle support for end-user devices.

Responsibilities

• Work will be performed at the customer site on Peterson, SFB in Colorado Springs, CO, in the DAF SIPR environment (classified).
• Specific responsibilities include:
• Develop and Maintain Power BI Solutions:
• Design, develop, and maintain interactive Power BI dashboards and reports that meet business requirements.
• Optimize Power BI reports for performance and scalability.
• Implement data security measures to protect sensitive information.
• Data Modeling and ETL:
• Develop and maintain data models within Power BI Desktop.
• Extract, transform, and load (ETL) data from various sources (e.g., databases, APIs, cloud storage) using Power Query (M language).
• Ensure data quality and accuracy through data validation and cleansing.
• Develop tabular, multidimensional models compatible with warehouse standards.
• DAX Programming:
• Write complex DAX formulas to create calculated columns, measures, and tables for insightful analysis.
• Optimize DAX code for performance and efficiency.
• Implement advanced DAX techniques such as time intelligence and ranking.
• Collaboration and Communication:
• Work closely with business stakeholders to understand their data needs and translate them into effective Power BI solutions.
• Collaborate with data engineers and database administrators to ensure data availability and accuracy.
• Document data models, ETL processes, and Power BI solutions.
• Experience working with data gateway, data integration, self-service data preparation.
• Provide training and support to end-users on Power BI report usage.
• Best Practices and Standards:
• Adhere to Power BI development best practices and standards.
• Stay up to date with the latest Power BI features and updates.
• Contribute to the development and maintenance of a Power BI governance framework.
• Troubleshooting and Support:
• Troubleshoot and resolve issues related to Power BI reports and data sources.
• Troubleshoot data connectivity issues and optimize dashboard performance for enterprise-scale implementation
• Provide ongoing support and maintenance for existing Power BI solutions.

Requirements

• Required:
• US Citizenship required.
• Work will be performed at the customer site on Peterson, SFB, Colorado Springs, CO.
• Current certification for Security+ or any of CISSP, CCNA, or CCNP
• Must have an active Department of Defense (DoD) Secret Clearance.
• 10+ Years of relevant experience (Bachelor's degree in applicable field may be substituted for 5 years of experience).
• 3+ years of experience developing Power BI or similar reports, dashboards, and data models
• Strong experience with data modeling concepts (e.g., star schema, snowflake schema).
• Experience with ETL processes and data warehousing principles.
• Proficiency in DAX (Data Analysis Expressions) language.
• Experience with Power Query (M language) for data transformation.
• Experience connecting to and retrieving data from various data sources (e.g., SQL Server, Azure SQL Database, cloud storage).
• Expertise in Power BI Desktop and Power BI Service.
• Strong understanding of data visualization principles.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.
• Ability to work independently and as part of a team.
• Desired:
• Experience with Azure Data Factory, Azur

Additional Information

Job Title: Data Analyst 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: Continental US Anticipated Posting End: 7/6/2026

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at CACI? Share your experience