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

Peraton is currently seeking to hire an experienced Power BI Developer to become part of Peraton's Department of State (DoS) Diplomatic Security Cyber Mission (DSCM) program. This role is crucial in providing leading cyber and technology security experience to enable innovative, effective, and secure business processes. The position is located in Rosslyn, VA, and is a hybrid role, requiring the candidate to come into the office as needed. As a Power BI Developer, you will be responsible for designing, developing, and managing business intelligence solutions using Power BI. This includes transforming raw data into meaningful insights that drive business decisions, as well as designing and developing data models that support Power BI reports and dashboards. In this role, you will utilize Power Query and DAX (Data Analysis Expressions) to transform, cleanse, and structure data for analysis. You will also optimize data models to ensure efficient performance and scalability, create visually compelling and interactive reports and dashboards, and develop custom visualizations to meet specific business requirements. Additionally, you will implement drilldowns, filters, and slicers to enhance user activity and connect Power BI to various data sources, including SQL Server, Dataverse, Azure, Excel, and third-party APIs. You will be responsible for implementing scheduled data refreshes to keep reports up to date and collaborating with business stakeholders to gather and document reporting requirements. Your analytical skills will be put to the test as you analyze business needs and translate them into technical specifications for Power BI solutions. You will identify bottlenecks such as slow queries or inefficient data models and implement row-level security (RLS) and other security measures to control access to sensitive data within Power BI. Managing user roles and permissions to ensure proper access control will also be part of your responsibilities. You will 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, and document data models and report logic for future reference and maintenance. Staying updated with the latest features and best practices in Power BI and exploring new ways to leverage Power BI for advanced analytics and reporting will be essential to your success in this role.

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 to ensure 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 Masters; 0 Years with 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 to support business intelligence needs.
• 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 to provide comprehensive insights.
• Experience managing data connections, data models, and transformations within the Power BI environment.
• Ability to troubleshoot and resolve any issues related to data or reporting functionality.
• 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.
• Experience maintaining and troubleshooting dataflows to ensure continuous data refresh and availability.
• 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, capable of working with stakeholders across different levels of the organization to gather requirements, provide updates, and drive adoption of developed solutions.
• Commitment to staying up to date with the latest Power BI features, industry standards, and best practices in application development and data security.
• U.S. citizenship with an active Secret security clearance and ability to obtain a Top-Secret clearance.

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.