Data Visualization Developer

JPS Tech Solutions Pvt Ltd; Arizona; Presencial; USD 85.000 - 120.000; Jornada completa

Descripción de la vacante

JPS Tech Solutions Pvt Ltd is seeking an experienced Data Visualization Developer to design, develop, and deploy interactive dashboards, reports, and KPI scorecards for business users across Human Services programs, including Medicaid, Child Welfare, and Child Care. The role requires strong expertise in Power BI, SSRS, DAX, SQL Server, and data warehousing.

You will integrate multiple data sources, build robust data models, optimize queries, and collaborate with stakeholders to ensure reporting

Formación

• 4+ years of Power BI development and dashboarding experience.
• 5+ years with SSRS, deployment, and connection management.
• 5+ years SQL query development.
• 5+ years Excel advanced features (Pivot, lookup, charts).
• 2+ years in data warehousing.
• Experience connecting to SQL Server, Oracle, Excel, CSV, and web data sources.
• Strong knowledge of DAX and data visualization techniques.
• Experience building BI reports and data models for business intelligence.

Responsabilidades

• Design, develop, and deploy interactive Power BI dashboards, reports, and KPI scorecards.
• Collaborate with stakeholders to translate reporting needs into actionable visuals.
• Set up and manage Power BI workspaces, connections, and deployment processes.
• Develop DAX calculations, measures, and data models for reporting.
• Integrate data from SQL Server, Oracle, Excel, CSV, and web sources.
• Develop SSRS tabular reports and optimize SQL queries.
• Work with SSAS multidimensional models and enterprise warehouse schemas.
• Create Excel-based reports with advanced PivotTables, PowerPivot, and PowerView.
• Oversee report deployment, data refresh, and connectivity configurations.
• Support deployment via Azure DevOps pipelines.

Conocimientos

Power BI

Dashboard development

KPI scorecards

Data source integration

DAX

SQL queries

SSRS

Data modeling

Excel advanced

SSAS multidimensional

Herramientas

SSRS

SSAS multidimensional

Azure DevOps

Azure Data Factory

Azure Data Lake

Azure Databricks

Oracle

SQL Server

CSV data

Descripción del empleo

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