Microsoft Power BI Developer

ECS; Virginia; Remote; USD 85,000 - 120,000; Full time

Job summary

ECS is seeking a Microsoft Power BI Developer to work remotely for the U.S. Postal Service Inspector General's Office (OIG). This role focuses on data mining, analytics and dashboard building to support business decisions and resource allocation.

The candidate will deliver quality BI solutions using Power BI and related technologies, collaborating with OCIO and project teams. The position requires strong data analytics skills, experience with data warehouses, and the ability to communicate

Qualifications

• Degree in Computer Science, Information Technology, Business or related field OR PL-300 certification or equivalent.
• 4+ years of progressive experience in business intelligence and/or information management.
• 2+ years of experience with data visualization and client-facing technical roles.
• Expert knowledge of ETL, data warehousing, data marts, cubes.
• Data governance, metadata management, and BI analytics concepts.

Responsibilities

• Develop, publish and schedule reports, dashboards and scorecards for business users.
• Create data models, establish relationship cardinality and cross-filter direction, and build complex measures.
• Visualize data models by generating reports and dashboards with Power BI tools.
• Collaborate with OIG customers and OCIO team on requirements and architecture.
• Coach team members in Power BI usage and best practices.
• Optimize performance of data models and ensure reliable analytics.

Skills

Power BI

Data modeling

SQL

Data visualization

ETL

DAX

M Queries

Communication skills

Problem solving

Education

Bachelor's degree in CS/IT/Business

PL-300: Microsoft Power BI Data Analyst Certification

Tools

Power BI Tool Suite

SQL Server

Oracle

SQL Data Warehouse

Job description

Job Description

ECS is seeking a

Please Note: This position is contingent upon additional funding.

• 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
• Implement solutions using Microsoft Power BI tool suite and related technologies
• 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
• 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
• Implement solutions using Microsoft Power BI tool suite and related technologies

Job Description

ECS is seeking a Microsoft Power BI Developer to work remotely. This role performs a variety of data mining, analytics and dashboard building to support the U.S. Postal Service's Inspector General's Office (OIG). This is a critical role that will provide much needed expertise to the OIG's office to make business and resource allocation decisions.

Please Note: This position is contingent upon additional funding.

Responsibilities Include

• 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
• Implement solutions using Microsoft Power BI tool suite and related technologies
• 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
• 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
• Implement solutions using Microsoft Power BI tool suite and related technologies

Note: Candidates must be able to pass a USPIS Moderate Background Investigation (MBI) and obtain a USPS Public Trust (elevated) clearance. This requires US Citizenship and the ability to pass an in-depth background check.

Required Skills

Data quality and profiling

• 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 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 data analytics codes and languages (SQL, SAS, R, Python)
• Eager to contribute to a team-oriented environment
• Able to work creatively and analytically in a problem-solving environment
• Excellent communication and interpersonal skills
• 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
• Experience creating dataflows or datamarts
• Experience with designing composite models
• Experience with applying roles and Row Level Security (RLS) to Reports, Apps and workspaces
• Experience with report builder and developing paginated reports
• 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

Desired Skills