Power BI Developer

$110,000 - $134,000/Yr

Skyepoint Decisions - Arlington, VA

Full-time - Mid Level

Arlington, VA

Professional, Scientific, and Technical Services

About the position

SkyePoint Decisions is seeking a Power BI Developer to support the Diplomatic Security Cyber Mission (DSCM) program. This role involves designing, developing, and managing business intelligence solutions using Power BI, transforming raw data into actionable insights to drive business decisions. The position requires collaboration with stakeholders to gather reporting requirements and implement effective data models and visualizations.

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: 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.
• Must have the 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.
• 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.
• Excellent communication and collaboration skills.

Nice-to-haves

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

Benefits

• Health savings account
• Disability insurance
• Dental insurance
• 401(k)
• Flexible spending account
• Paid time off
• Vision insurance
• 401(k) matching
• Life insurance