W2 Role - Power BI Developer (100% Remote)

W2 Role - Power BI Developer (100% Remote)

Interview mode: Virtual

Job Description:

Overview

• Project goal: recreate an existing Salesforce-connected Power BI report to pull directly from ServiceNow so operational teams can self-serve ticket status without ITIL licenses.
• Primary data sources: Sonder -> ServiceNow (current), original report pulled from Salesforce ; no Sonder API in use today.
• Key requirements: ServiceNow + Power BI expertise; preserve existing form functionality (search by client, service line, case number) and logic (e.g., "Was the request completed successfully?" maps to closed completed vs closed rejected ).
• Constraints and timeline: original builders left and documentation is limited; resumes will appear in Beeline within ~24 hours and Speaker A will manage the process.

• Accessible Way to search information without providing access to the actual tools
• Salesforce who ticket is assigned to, volumes, the user, searching specific case numbers the whole idea o the report with salesforce is to mitigate emails on status updates for tickets. They want operational teams to be able to access those reports and find details they are needing on their tickets
• ServiceNow instance is who it is requested for with their people leaders. Unless you have an ITIL license. Operational teams do not have the ITIL license to they do need a dashboard where they can search within PowerBI.
• They need to have a lot of experience within PowerBI and ServiceNow
• They want to pull the data from ServiceNow to produce a PowerBI Dashboard
• Current PowerBI dashboards are pulling from Salesforce but want to use the ServiceNow Data.

• "How much of this project is net-new dashboard development versus reverse-engineering and recreating the existing Salesforce reporting logic in a ServiceNow environment?" There is an existing dashboard to pull from and will be utilized, but they will be doing some net new dashboard development for operational leaders to be used. They will be recreating the existing Salesforce reporting logic in their ServiceNow environment.

Data sources & architecture

• Incoming requests originate in Sonder and translate into ServiceNow ; current visualization was wired to Salesforce instead of ServiceNow.
• The desired implementation is to pull data directly from ServiceNow (tables/APIs) into Power BI and keep the form UI equivalent to the existing one.
• There are ~3 years of ServiceNow data and the instance is broadly leveraged, but data is spread across multiple endpoints and modules.
• Some dashboards previously built by Mark may be partially reusable, but the complex original dashboard (the "monster") was set aside and likely requires reverse engineering .
• Next: validate ServiceNow table endpoints, API limits, and exact mappings for fields currently supplied by Salesforce/Sonder.

Technical requirements & constraints

• Required skills: ServiceNow data modeling/APIs , Power BI dashboard development, and ability to handle complex historical datasets and advanced visualizations.
• Developer will need to investigate data structures and mappings because original authors are gone and documentation is limited.
• There is limited handholding: Manager will be available for technical questions, but developer should expect some independent discovery work.
• Next: produce a data-mapping plan and estimate effort for reverse engineering vs full rebuild.

Reason for Need

These individuals (we need 2) will be responsible for building a Power BI reporting solution using ServiceNow 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.

Interview Process (1 panel interview)

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

Top technical requirements include: (these things must be on their resume for consideration)

• 3+ years of strong, hands-on Power BI development (ideally 5+ years)

1. Deep working knowledge of ServiceNow data, including fields, attributes and underlying data structures

1. Experience extracting, interpreting and transforming ServiceNow data for use in Power BI reporting and dashboards

1. Ability to create/migrate reporting functionality currently supported through a Salesforce-connected Power BI solutions into a ServiceNow-based solution

1. Experience building reporting that allows business users to search/filter request and ticket information, including status, aging, completion and user/access-related details

1. Ability to independently troubleshoot technical barriers and drive a defined reporting deliverable through completion

Top soft skill requirements include:

• Excellent communication skills with the ability to translate highly technical concepts for non-technical stakeholders

1. Tenacity and strong problem-solving skills; this project has already presented technical challenges and will require someone comfortable working through ambiguity and roadblocks

1. Proactive communication, particularly when encountering barriers, dependencies or risks

1. Collaborative, team-oriented approach and willingness to partner closely with both technical and business stakeholders

1. Strong ownership and follow-through within a short, project-based engagement

Additional Role Details:

• Fully remote; candidates must reside within PST, MST, CST, or EST time zones (with a preference for PST/MST)

Healthcare experience is not required, but would be a differentiator (industry agnostic is okay

Best Regards,

Shivam Kumar

Lead Technical Recruiter

Stellent IT Phone : 201-503-2666

Email: shivam @stellentit.com


Gtalk: shivam om