Power BI Developer

The Opportunity:

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:

We are seeking a highly motivated and experienced Power BI Developer to service the needs of multiple EITaaS capability teams, for this Dept. of the Air Force program. You will be responsible for designing, developing, and maintaining robust and insightful Power BI dashboards and reports. You will work with your manager and colleagues to understand requirements, priorities, and objectives to ensure work supports the larger capabilities and direction of the overall solution. You will play a crucial role in transforming raw data into actionable intelligence that drives informed decision-making across the organization. This role requires a strong understanding of data modeling, ETL processes, DAX, and Power BI best practices.

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.

Qualifications:

• US Citizenship required.
• Current certification for Security+ or any of CISSP, CCNA, or CCNP
• Ability to obtain to a Department of Defense (DoD) Secret Clearance and pass all relevant background checks for a security clearance. Active DoD clearance preferred but not required.
• 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, Azure Synapse Analytics, or other cloud-based data services.
• Experience with data governance and data quality principles.
• Experience with version control systems (e.g., Git).
• Power BI certifications (e.g., Microsoft Certified: Data Analyst Associate).
• Experience with other BI tools such as Tableau or Qlik.
• Experience with enterprise security controls such as DISA STIGs or NIST 800-53.

• This would be better worded to focus on Data Model quality. The PBI developer may not have any control over the data source and completeness or accuracy of the data. But should be held responsible for building a reliable data model form these data sources.

• A requirement around sound UI and report design with experience using out of the box PBI visuals. Desired experience with customization tools such as Deneb using Vega or Vega-lite would be helpful.

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:

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.