Power BI Developer

$100,000 - $116,000/Yr

Skyepoint Decisions - Arlington, VA

Full-time - Mid Level

Arlington, VA

Professional, Scientific, and Technical Services

About the position

The Power BI Developer position at SkyePoint Decisions involves designing, developing, and managing business intelligence solutions using Power BI to support the Diplomatic Security Cyber Mission (DSCM) program. The role focuses on transforming raw data into actionable insights, optimizing data models, and collaborating with stakeholders to enhance reporting capabilities. This position is contingent upon customer approval and operates on a hybrid schedule in Rosslyn, VA.

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 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.
• 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

• Several insurance options including HMO and High Deductible plans with Health Savings Accounts (HSAs), Flex Spending Accounts (FSAs), Full Dental Plans, ST/LT Disability, Life Insurance, floating federal holiday options, and 401k matched.
• Certificate Incentive Program to promote professional development.
• Flexible Work Environment.
• PTO and floating federal holiday options.