Data Visualization Developer

JPS Tech Solutions; Arizona; On-site; USD 90,000 - 140,000; Full time

Job summary

JPS Tech Solutions Pvt Ltd is seeking an experienced Data Visualization Developer to design, develop, and deploy interactive dashboards, reports, and KPI scorecards for Human Services programs. The role requires strong expertise in Power BI, SSRS, DAX, SQL Server, and data warehousing, with the ability to integrate multiple data sources and deliver meaningful business insights.

The candidate will design and deploy Power BI dashboards, build DAX calculations, manage connections, and optimize SQL

Qualifications

• Minimum 4 years of Power BI dashboard and KPI development experience.
• Strong experience with SSRS report deployment and data source management.
• 5+ years SQL Server querying and data modeling.
• Proven skills in Excel pivot tables, lookups, charts, and PowerPivot/PowerMap.
• Experience with data warehouses and SSAS multidimensional models.
• Ability to integrate data from SQL Server, Oracle, Excel, CSV, and web pages.

Responsibilities

• Design, develop, and deploy interactive Power BI dashboards, reports, and KPI scorecards.
• Collaborate with stakeholders to translate requirements into visualizations for Human Services programs.
• Set up and manage Power BI workspaces, connections, and deployment processes.
• Develop DAX calculations, measures, and data models to support reporting needs.
• Build and optimize SQL Server queries to support reporting and analysis.
• Develop and maintain SSRS reports and SSAS multidimensional models.
• Ensure data connectivity and accuracy across sources and data warehouses.
• Coordinate with DevOps for release management and deployment pipelines.

Skills

Power BI

DAX

SQL Server

Data warehousing

SSRS

SSAS multidimensional

Excel

Azure DevOps

Azure Data Factory

Azure Data Lake

Azure Databricks

SQL queries

Tools

Power BI

SSRS

SSAS

SQL Server

Azure DevOps

Azure Data Factory

Azure Data Lake

Databricks

Job description

Job Summary

We are seeking an experienced Data Visualization Developer to design, develop, and deploy interactive dashboards, reports, and KPI scorecards for business users across various Human Services programs, including Medicaid, Child Welfare, Child Care, Assistance Programs, and Child Support. The role requires strong expertise in Microsoft Power BI, SSRS, DAX, SQL Server, and data warehousing, along with the ability to integrate multiple data sources and deliver meaningful business insights.

Key Responsibilities

• Design, develop, and deploy interactive Power BI dashboards, reports, and KPI scorecards.
• Work with business stakeholders to understand reporting requirements and develop visualizations for different Human Services programs.
• Set up and manage Power BI workspaces, connections, and deployment processes.
• Develop DAX calculations, measures, and data models to support business reporting requirements.
• Connect and integrate data from multiple sources, including SQL Server, Oracle, Excel, CSV files, and web pages.
• Develop and maintain tabular reports using SQL Server Reporting Services (SSRS).
• Build and optimize SQL Server queries to support reporting and data analysis.
• Work with SSAS multidimensional models and enterprise data warehouse models.
• Develop Excel-based reports using pivot tables, lookups, charts, graphs, PowerPivot, PowerView, and PowerMap.
• Manage report deployment, data connections, and refresh configurations.
• Use Azure DevOps pipelines and release management processes to support deployment activities.
• Collaborate with technical teams and business users to ensure reporting accuracy and data consistency.
• Troubleshoot reporting and data connectivity issues and recommend improvements.

Required Qualifications

• Minimum 4 years of experience with Power BI, workspace administration, dashboard and report development, KPI scorecards, and data source integration.
• Minimum 5 years of experience with SQL Server Reporting Services (SSRS), report deployment, and connection management.
• Minimum 5 years of experience developing SQL Server queries.
• Minimum 5 years of experience with Microsoft Excel, including pivot tables, lookups, charts, graphs, dashboards, PowerPivot, PowerView, and PowerMap.
• Minimum 2 years of experience working with data warehouses.
• Experience connecting and integrating data from SQL Server, Oracle databases, Excel, CSV files, SSAS multidimensional models, data warehouse models, and web pages.
• Strong knowledge of DAX and data visualization techniques.
• Experience developing reports and managing data models for business intelligence solutions.
• Strong analytical, problem-solving, and communication skills.

Preferred Qualifications

• Minimum 2 years of experience with Azure DevOps pipelines and release management.
• Experience with Azure Data Factory, Azure Data Lake, Azure Databricks, Azure SQL Data Warehouse, and Stream Analytics.
• Experience supporting enterprise business intelligence and data warehousing environments.
• Ability to collaborate with business and technical teams to translate reporting requirements into effective visualizations.

Core Technical Skills

• Microsoft Power BI and Workspace Administration
• Dashboard, Report, and KPI Scorecard Development
• DAX and Data Modeling
• SQL Server and SQL Query Development
• SQL Server Reporting Services (SSRS)
• SSAS Multidimensional Models
• Microsoft Excel, Pivot Tables, and Lookups
• PowerPivot, PowerView, and PowerMap
• Oracle and CSV Data Integration
• Data Warehousing
• Azure DevOps Pipelines and Releases
• Azure Data Factory, Data Lake, and Databricks
• Azure SQL Data Warehouse and Stream Analytics