Senior Microsoft Power BI Developer

Position Description

The position involves business intelligence and reporting technologies/methodologies. Key responsibilities include identifying data, cleaning, transforming, and loading into data models; creating data models, establishing relationship cardinality and cross-filter direction, and building complex measures; visualizing data models by creating reports and dashboards; assisting in the delivery of quality solutions using Microsoft Business Intelligence tools (Power BI) and related technologies; partnering with OIG customers and OCIO technical team members to assist with requirements definitions, solution designs, technical architecture, and delivery; and working 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 Data Analytics Expressions (DAX) and M (Power) Queries
• Experience with developing interactive dashboards -e.g., parameters, actions, navigation -for ease-of-use
• 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
• Leverage database systems including data warehouses, data marts, and models needed for business, financial, and operational analysis and/or reporting
• 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
• 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
• 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
• 8+ years of progressive experience in business intelligence and/or information management
• 4+ years of experience with data visualization and implementing high-value solutions; experience performing administrative activities across multi-environment infrastructures
• 5+ 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