Middle Microsoft Power BI Developer

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.

• 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