Power BI Developer

Location:

100% Remote
Duration: 3 Months

These individuals (we need
2) will be responsible for building a Power BI reporting solution using Service Now data that mirrors the functionality of an existing Salesforce-connected report. The goal is to provide operations and business leaders visibility into request/ticket information, status, aging, completion and user access details without requiring direct access to the underlying ticketing platform.

• Video panel interview with the Hiring Manager and another technical team member (technical/behavioral)

• 3+ years of strong, hands-on Power BI development experience; 5+ years strongly preferred
• Deep hands-on experience working with Service Now data, including tables, fields, attributes, relationships, endpoints, and underlying data structures
• Experience extracting, interpreting, transforming, and modeling Service Now data for use within Power BI reports and dashboards
• Demonstrated ability to navigate complex Service Now environments where required data may exist across multiple tables/endpoints
• Experience recreating or reverse-engineering existing reporting functionality and business logic using a different source system
• Strong understanding of data modeling, transformation, relationship mapping, historical reporting, and complex visualization requirements
• Ability to independently investigate technical/data challenges and determine appropriate solutions with limited hand-holding

• Excellent written and verbal communication skills with the ability to translate highly technical concepts for non-technical business stakeholders
• Strong problem-solving skills and tenacity when working through ambiguous or technically complex issues
• Proactive communication when encountering access issues, dependencies, risks, or project roadblocks
• Strong ownership and ability to independently drive a defined deliverable through completion
• Collaborative approach and ability to partner effectively with technical, security, identity/access, and operational stakeholders
• Comfortable working within a short-duration, highly focused project engagement

R1 is seeking two temporary Power BI Developers to support a focused reporting initiative within the Client Identity & Access team. The primary objective of this engagement is to build a new Power BI reporting solution using Service Now data, modeled after the functionality of an existing Power BI report that currently uses Salesforce as its underlying data source. The existing Salesforce solution will remain unchanged and will serve as a functional reference for the new Service Now-based reporting experience.

The new solution will provide operational and business teams with visibility into request and ticket information without requiring those users to maintain direct Service Now ITIL licenses. Users should be able to locate and understand information such as request/ticket details, current status, aging, completion information, assigned resources, user/access requests, and other relevant operational data. This is not simply a dashboard-design engagement.

Successful candidates must be capable of understanding the underlying Service Now data architecture and business logic, identifying where required information resides, translating that information into an appropriate Power BI data model, and independently troubleshooting issues encountered throughout development.

The developers will recreate key functionality from an existing Salesforce-connected Power BI reporting solution using Service Now as the source of record for the new reporting solution. Requests relevant to this project originate through Sonder, R1's identity and access management platform, and subsequently flow into Service Now, where the Client Identity & Access team performs its work. The Power BI solution itself will retrieve the applicable reporting information from Service Now rather than directly from Sonder.

The Service Now environment is mature and heavily utilized; however, relevant information may be distributed across multiple tables, fields, attributes, and endpoints. The developers will need to understand these relationships and determine how to accurately reproduce the desired reporting functionality. The work may also require interpreting R1-specific business logic. For example, responses captured during request processing can…