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: C andidates 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.
• 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 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