Job description

Senior Microsoft Power BI Developer We are seeking a Senior Microsoft Power BI Developer to join our team of qualified, diverse individuals supporting a Federal Government customer in Rosslyn, VA. Candidates must be able to obtain a Position of Public Trust Clearance – MUST be a US Citizen and must not have traveled outside the US for a combined total of 6 months or more in last 5 years. Must have resided in the US for the last 5 years This position will allow for remote work throughout the US, however it is preferred that the selected individual lives within driving distance of Arlington VA so that they are able to come into the office if needed. Preference given to candidates who have demonstrated experience with medallion architecture, Databricks, and/or experience with sensitive law enforcement and case management data. Position Description • Primary focus on business intelligence and reporting technologies/methodologies • Identify data to clean, transform, and load into data models • Create data models, establish relationship cardinality and cross-filter direction, and build complex measures • Visualize data models by creating reports and dashboards • Assist in the delivery of quality solutions using Microsoft Business Intelligence tools (Power BI) and related technologies • Partner with OIG customers and OCIO technical team members to assist with requirements definitions, solution designs, technical architecture, and delivery • Work collaboratively with team members including project managers, solution architects, and business analysts Position Requirements • Implement solutions using Microsoft Power BI tool suite and related technologies • Proficient in developing complex of Data Analytics Expressions (DAX) and M (Power) Queries • Experience with developing interactive dashboards –e.g., parameters, actions, navigation –for ease-of-use. • Proficient in creating dataflows or datamarts • Experience with designing composite models • Experience with report builder and developing paginated reports • Experience with applying roles and Row Level Security (RLS) to Reports, Apps and workspaces • Experience integrating customized automated solutions using PowerApps, Power Automate, SharePoint and Dataverse with Power BI • Understand the administrative functions for Power BI, Managing data gateway, usage report etc. • Leverage database systems including data warehouses, data marts, and models needed for business, financial, and operational analysis and/or reporting • Develop high performing, reliable, and scalable solutions • Optimize performance on new and existing data models Clearly communicate technical details to business and management staff • Perform data analysis which supports and enhances OIG information management systems and services • Experience with one or more data technologies (e.g., Oracle, SQL Data Warehouse, SQL Server, etc.) and a willingness to learn how to leverage these technologies to improve business intelligence • Author and oversee design documents for approved projects • Develop, publish and, schedule reports, dashboards & scorecards, data exploration, and visual analytics using existing and emerging technologies and tools • Provide meaningful feedback and coaching of other team members in the use of Microsoft Power BI and related technologies • Provide insight and recommendations on new and emerging technologies and concepts to OCIO team members • Eager to contribute to a team-oriented environment • Able to work creatively and analytically in a problem-solving environment • Excellent communication and interpersonal skills Primary Requirements • MUST have a Degree in Computer Science, Information Technology, Business or related field OR possess a PL-300: Microsoft Power BI Data Analyst Certification or equivalent • 4+ years of progressive experience in business intelligence and/or information management • 2+ years of experience with data visualization and implementing high-value solutions; experience performing administrative activities across multi-environment infrastructures • 2+ years of experience working in a client-facing technical role • Expert knowledge of data management, business intelligence and analytics concepts including: • Extract, transform, load (ETL) • Data warehousing, data marts, data stores, and cubes • Data quality and profiling • Data governance, data management, and metadata management • Data visualization, dashboard design / implementation, reporting, self-service BI, data KPIs, and scorecards • Predictive, prescriptive, and descriptive analytics • Proficiency in one or more languages like: • SQL • SAS • R • Python Desired Experience • Experience with Government software development policies and procedures • Experience integrating customized automated solutions using PowerApps, Power Automate, SharePoint and Dataverse with Power BI • Must be able to obtain a Position of Public Trust Clearance – MUST be a US Citizen and must not have traveled outside the US for a combined total of 6 months or more in last 5 years. Must have resided in the US for the last 5 years

Requirements

Must-haves

Senior Microsoft Power BI Developer
Preference given to candidates who have demonstrated experience with medallion architecture, Databricks, and/or experience with sensitive law enforcement and case management data.
Position Description
• Primary focus on business intelligence and reporting technologies/methodologies
• Identify data to clean, transform, and load into data models
• Create data models, establish relationship cardinality and cross-filter direction, and build complex measures
• Visualize data models by creating reports and dashboards
• Assist in the delivery of quality solutions using Microsoft Business Intelligence tools (Power BI) and related technologies
• Partner with OIG customers and OCIO technical team members to assist with requirements definitions, solution designs, technical architecture, and delivery
• Work collaboratively with team members including project managers, solution architects, and business analysts
Position Requirements
• Implement solutions using Microsoft Power BI tool suite and related technologies
• Proficient in developing complex of Data Analytics Expressions (DAX) and M (Power) Queries
• Experience with developing interactive dashboards –e.g., parameters, actions, navigation –for ease-of-use.
• Proficient in creating dataflows or datamarts
• Experience with designing composite models
• Experience with report builder and developing paginated reports
• Experience with applying roles and Row Level Security (RLS) to Reports, Apps and workspaces
• Experience integrating customized automated solutions using PowerApps, Power Automate, SharePoint and Dataverse with Power BI
• Understand the administrative functions for Power BI, Managing data gateway, usage report etc.
• Leverage database systems including data warehouses, data marts, and models needed for business, financial, and operational analysis and/or reporting

Nice-to-haves

This position will allow for remote work throughout the US, however it is preferred that the selected individual lives within driving distance of Arlington VA so that they are able to come into the office if needed.
• Experience with Government software development policies and procedures
• Experience integrating customized automated solutions using PowerApps, Power Automate, SharePoint and Dataverse with Power BI

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpython

Platform: jobdiva
Effort: medium