Power BI Developer

$86,000 - $138,000/Yr

Peraton - Arlington, VA

Full-time

Arlington, VA

Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services

About the position

The Power BI Developer will be responsible for designing, developing, and managing business intelligence solutions using Power BI within Peraton's Department of State Diplomatic Security Cyber Mission program. This role focuses on transforming raw data into actionable insights, creating visually compelling reports and dashboards, and ensuring data accuracy and security. The developer will collaborate with stakeholders to gather requirements and implement solutions that enhance business processes.

Responsibilities

• Design, develop and manage business intelligence solutions using Power BI.
• Transform raw data into meaningful insights that drive business decisions.
• Design and develop data models that support Power BI reports and dashboards.
• Use Power Query and DAX to transform, cleanse, and structure data for analysis.
• Optimize data models for efficient performance and scalability.
• Create visually compelling and interactive reports and dashboards in Power BI.
• Develop custom visualizations to meet specific business requirements.
• Implement drilldowns, filters, and slicers to enhance user activity.
• Connect Power BI to various data sources including SQL Server, Dataverse, Azure, Excel, and third-party APIs.
• Implement scheduled data refreshes to keep reports up to date.
• Collaborate with business stakeholders to gather and document reporting requirements.
• Analyze business needs and translate them into technical specifications for Power BI solutions.
• Identify bottlenecks such as slow queries or inefficient data models.
• Implement row-level security (RLS) and other security measures to control access to sensitive data within Power BI.
• Manage user roles and permissions to ensure proper access control.
• Conduct testing to validate the accuracy and functionality of the Power BI reports and dashboards.
• Debug and troubleshoot issues that arise during formal testing or in production.
• Document data models and report logic for future reference and maintenance.
• Update reports and dashboards based on changing business needs or feedback from users.
• Stay updated with the latest features and best practices in Power BI.
• Explore new ways to leverage Power BI for advanced analytics and reporting.

Requirements

• Bachelor's degree in computer science and 5 years' experience or 3 years with a Master's; 0 years with a PhD.
• Possess one of the following certifications, or be able to obtain before start date: CAP, CASP+ CE, CCISO, CCNA-Security, CISM, CISSP (or Associate), CND, CSSLP, CySA+, GICSP, GSEC, GSLC, Security+ CE, SSCP, PPDA, Agile IC, or SNOW App Dev.
• Experience in Power BI UX design and creating visually appealing and interactive reports and dashboards.
• Experience maintaining and improving existing reports with an updated UX approach and consistent design.
• Experience transforming raw data into actionable insights through interactive and user-friendly reports, ensuring data accuracy and consistency across reports.
• Experience using Report Builder or Power Pages.
• Ability to integrate data from Dataverse into Power BI using SQL queries and Dataflows.
• Experience managing data connections, data models, and transformations within the Power BI environment.
• Experience writing and optimizing SQL queries to extract and manipulate data for reporting purposes.
• Experience utilizing Power BI Dataflows to prepare and transform data for analysis.
• Demonstrated ability in planning, execution, and delivery of Power BI solutions within scope, time, and budget.
• Strong analytical and problem-solving skills.
• Experience working in an Agile development environment.
• Experience creating technical documents.
• Excellent communication and collaboration skills.

Nice-to-haves

• Microsoft Certified: Data Analyst Associate or relevant certifications are a plus.

Benefits

• Competitive salary range of $86,000 - $138,000 based on experience and other factors.