Power BI & Azure Web App Developer at Arbitration Forums Inc.

United States

DEPARTMENT: Data Insights and Innovation JOB TITLE: Power BI & Azure Web App Developer JOB CODE: PBIAWD REPORTS TO: Manager, Advanced Analytics FLSA STATUS: Exempt EMPLOYMENT TYPE: Full-Time JOB PURPOSE: This role at Arbitration Forums is as unique as it is rewarding because of the AF IPAAL Values (Integrity, Passion, Accountability, Achievement, Leadership) and TRI Model (Trust, Respect, Inclusion).  The Power BI & Azure Web App Developer is responsible for leading the analysis, design, development, testing, and deployment of data analytics solutions as well as Azure Web App for a Dashboard portal. The final deliverables for data analytics solutions can take many forms, such as data feeds, reports, dashboards/visualizations, data applications, and end-user reporting. This role plays a key role in designing and developing the dashboard portal, defining the data structures and layers to ensure effective, consistent, and efficient delivery of analytics products to our members and AF employees. This role is expected to interact with AF employees and members to solicit feedback on their designs, utilization of the solutions, and to make recommendations based upon customer feedback.  DEPARTMENTAL EXPECTATION OF EMPLOYEE * Adheres to AF Policy and Procedures and the AF IPAAL Values and TRI Model  * Acts as a role model within and outside AF.  * Performs duties as workload necessitates.  * Maintains a positive and respectful attitude.  * Communicates regularly with the departmental leader about department issues.  * Demonstrates flexible and efficient time management and ability to prioritize workload.  * Consistently reports to work on time, prepared to perform duties of the position.  * Meets Department productivity standards.  ESSENTIAL DUTIES AND RESPONSIBILITIES Solution Design & Architecture * Design and implement scalable web application architecture hosted on Azure App Service (Web Apps), including environment strategy for Dev / QA / UAT / Prod. * Define API-driven rendering patterns (e.g., server-side rendering, SPA with API calls, or hybrid), and establish standards for data-fetching, caching, and error-handling. * Collaborate with data architects, product architects, and stakeholders to translate requirements into technical designs, including non-functional requirements (performance, resiliency, security, compliance). * Evaluate and recommend Azure services (e.g., API Management, Key Vault, Application Insights, Front Door, Azure Cache for Redis) to meet reliability and scale needs. Web Application Development (UI + Rendering) * Build responsive, accessible web interfaces that render content based on API responses, including robust UI states (loading, empty, partial, error). * Develop reusable UI components and page templates aligned to design standards and accessibility requirements. * Implement client-side and/or server-side rendering strategies optimized for performance. * Ensure consistent UX behavior across browsers and devices, including mobile-friendly layouts. API Integration & Data Handling * Integrate APIs to retrieve reports and dashboards from analytics tools such as Power BI and WebFOCUS * Implement resilient API consumption patterns:  * retries with backoff (where appropriate) * timeouts and cancellation * circuit-breaker patterns (as applicable) * graceful degradation and fallback UI * Transform and validate API payloads for presentation needs while maintaining data integrity. * Coordinate API contracts including versioning and backward compatibility planning. Security, Identity & Access * Implement authentication and authorization using enterprise identity solutions (e.g., Microsoft Entra ID/Azure AD, OAuth2/OIDC). * Enforce secure coding practices:  * protect against common vulnerabilities (OWASP Top 10) * input validation, output encoding, CSRF protection * secure session/token handling * Manage secrets and certificates using Azure Key Vault (no secrets in code or config files). * Support role-based access control (RBAC) and claims-based authorization patterns across UI features and API access. Azure App Service Configuration & Operations * Configure Azure Web App resources:  * deployment slots (blue/green or canary) * autoscaling rules * custom domains and TLS certificates * app settings and connection strings * Implement environment-specific configuration management (feature flags, app settings, config providers). * Ensure high availability and reliability with appropriate scaling, health checks, and recovery patterns. * Perform routine maintenance: dependency updates, runtime upgrades, certificate renewals, and platform patch planning. Data Engineering and Analysis * Identifies data needs of members and AF employees.  * Collaborates with AF teams to define and execute strategies to gather data from multiple sources, creating and maintaining the necessary pipelines while conveying business and technical data needs for the development and deployment of data-based products. Data Visualizations, Reporting and Data Feeds * Designs, builds, and manages data visualization, reporting and data feeds for internal and external users utilizing tools available.  * Defines and applies consistent design for the user experience to minimize training needs and provide a common experience across the data analytics platform.  * Advocates for advances required to deliver insights in new and innovative methods while also focusing on lifecycle maintenance of our data analytics, full breadth of solutions. Power BI embedding * Embed Power BI content (Power BI Embedded vs user-based embedding), manage embed tokens, handle workspace/report identifiers, and align with Power BI admin settings. * Row-Level Security (RLS) / effective identity handling for embedded scenarios. Report catalog / inventory management * Own the data model for the portal catalog (report metadata, owners, tags, audiences, environments, certification status, last refresh, deprecation status). * Implement CRUD/admin workflows (who can add/edit/remove listings; approval workflow if needed). Data Accuracy and Solution Quality * Documents and maintains design deliverables and validates application results against calculations and data definitions to ensure quality of products delivered. * Conducts testing, follows defect tracking processes to deliver quality solutions. Supports the quality assurance, testing, and production release processes.  * Partners with Data Governance and Data Architecture to ensure that data is declared in the enterprise taxonomy catalog and managed according to data governance policies. Security * This role is responsible for following AF Security standards and ensuring the security model and best practices are built into deliverables.  * The Data Analytics Developer utilizes the AF security standard processes to ensure member data is secured. Production Support * Proactively follows up on production support tickets or any other reported data discrepancies providing leadership on the prioritization of support activities. * Performs incident investigation and service restoration. Change and Configuration Management Duties * Responsible for version control, change management processes and impact analysis of changes. This includes maintaining the inventory of reports, summaries of changes and driving creation and prioritization of the product backlog. * Leads deployment of solutions, including collaboration across AF to ensure seamless and efficient implementation.  QUALIFICATIONS Experience, Education and Licensure * Minimum of 5 years of experience in Azure Web App and Power BI development * Bachelor’s degree in computer science, Business, Statistics, or related field (equivalent work experience may be considered * Agile development methodology, including tools such as Jira and Confluence for product documentation. * Experience designing, developing, and delivering data analytics solutions in Power BI independently * Experience leading logical data modeling in a data analytics environment. * Advanced SQL skills, including writing and tuning complex queries, Oracle database experience preferred. * Experience and discipline utilizing multiple version control software products and change management processes. * Experience utilizing data transformation and load technologies such as Talend, ADF, etc. * Knowledge of advanced data analytics and predictive analytics, including data sciences, text analytics, and machine learning. Experience interacting with Data Science, ML tools such as Dataiku, Azure ML, Databricks AI, etc. * Understanding of cloud-based data engineering processes, as well as exposure to data platforms such as Fabric.   AMERICANS WITH DISABILITY SPECIFICATIONS  PHYSICAL DEMANDS The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.  While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle, or feel objects, tools or controls; reach with hands and arms; climb stairs; balance; stoop, kneel, crouch or crawl; talk or hear; taste or smell. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus. WORK ENVIRONMENT This is a fully remote position requiring reliable high-speed internet access and a dedicated workspace.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.