
Power BI Developer
CACI International Inc
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $75,200 - $158,100 per year
Job Level
SeniorLead
Tech Stack
AzureCloudETLSQLTableau
About the role
- 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
- 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.
Benefits
- healthcare
- wellness
- financial
- retirement
- family support
- continuing education
- time off benefits
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Power BIDAXETLData ModelingPower QueryData VisualizationData GovernanceData QualityAzure Data FactoryAzure Synapse Analytics
Soft skills
Problem-solvingAnalytical skillsCommunicationCollaborationIndependenceTeamwork
Certifications
Security+CISSPCCNACCNPMicrosoft Certified: Data Analyst Associate