Application Systems Analyst / Programmer

JPS Tech Solutions Pvt Ltd

Hartford, Northern (CT, KY)

Hybrid

USD 100,000 - 140,000

Full time

2 days ago

Be an early applicant

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Job summary

The Department of Administrative Services – Bureau of Information Technology Solutions (DAS-BITS) in Hartford seeks a mid to senior BI/Tableau Admin to manage Tableau Cloud sites, monitor refreshes, and support enterprise reporting across Azure SQL and MuleSoft RT. This role requires strong SQL, Salesforce data knowledge, and collaboration with cross-functional teams.

You will work with developers, analysts, and business users to resolve data issues, optimize pipelines, and support deployments

Qualifications

5+ years of BI/Analytics experience with Tableau Cloud administration.
Experience with Salesforce data structures and reporting impact.
Proven track record supporting enterprise reporting platforms.
Strong SQL skills with Azure SQL Database or similar.
Experience with user setup, roles, and permissions.
Ability to troubleshoot access, logic, and data issues.
Experience with SDLC documentation and deployments.
Collaborative work with architects and management.

Responsibilities

Administer Tableau Cloud sites, projects, users, groups, permissions, and security.
Monitor platform health, data refreshes, subscriptions, and scheduled jobs.
Troubleshoot Tableau performance and connectivity issues.
Support report developers, analysts, and business users.
Deploy and promote reports across environments.
Support Azure SQL Database reporting environments and data quality.
Investigate data issues and perform data validation.
Monitor data loads and integration pipelines (ADF, Salesforce, etc.).
Assist in root-cause analysis of integration/reporting problems.
Collaborate with development and integration teams during incidents and deployments.

Skills

Tableau Cloud administration

Salesforce objects & relationships

Enterprise reporting & analytics

Strong SQL & Azure SQL DB

User management & access control

Issue triage & problem solving

Environment management & deployments

Azure Data Factory (ADF)

MuleSoft Runtime Fabric (RTF)

Verbal & written communication

Tools

SQL Server

SSRS (SQL Server Reporting Services)

Azure Data Factory

MuleSoft Runtime Fabric

Job description

Job Description

PROJECT/SYSTEM/PROGRAM OVERVIEW:

The Department of Children and Families depends on the core, mission-critical applications, CTKIND and IV-E, Connecticut’sFederally-reimbursedCCWIS (Comprehensive Child Welfare information system) used by over 2,000 social workers and case managers, the application has been enhanced and modified continually to meet data capture and process functionality requirements driven by good child welfare case practice as well as State and Federal legislation and statute. Additionally, CTKIND is continuously updated in compliance with the agency’s ongoing goal of improving the safety,permanency and well-being of children in care and has invested significant resources to ensure that Connecticut has efficient, economic and effective tools to aid our Child Welfare Staff, Providers and the children and families of CT.

Department of Administrative Services – Bureau of Information Technology Solutions (DAS-BITS) provides technology expertise and services as well as an information systems infrastructure for the Department of Children and Families (DCF) and its roughly 3,300 employees. DAS-BITS strives toimprove continually improving technological services that are cost-effective and of the highest effectiveness and quality.

SCOPE OF WORK

The agency needs the service of a mid to Senior level BI/Tableau Admin. The candidate will be responsible for platform administration, incident management, troubleshooting, user support, monitoring, and ensuring the reliability of business-critical reporting and analytics services. Specifically, the candidate will be responsible for Administer Tableau Cloud sites, projects, users, groups, permissions, and security in Dev Test and Production environments and Support and troubleshoot Azure SQL Database and MuleSoft Runtime Fabric (RTF) environments and integrations impacting reporting platforms.

Specific Services Required:

In the role of the BI / Tableau Admin, the following services are required:

Administer Tableau Cloud sites, projects, users, groups, permissions, and security.
Monitor platform health, extract refreshes, subscriptions, and scheduled jobs.
Troubleshoot Tableau performance, connectivity, and reporting issues.
Support report developers, analysts, and business users.
Deploy and Promote Reports to different Environments
Support and troubleshoot Azure SQL Database environments used for enterprise reporting.
Investigate reporting data issues and perform data validation activities.
Monitor database connectivity, query performance, and data refresh processes.
Assist with SQL/SOQL troubleshooting and performance optimization.
Monitor and support Azure Data Factory pipelines that load Salesforce and other source-system data into Azure SQL Database.
Troubleshoot data load failures and data quality issues.
Assist in identifying root causes of integration and reporting issues.
Collaborate with development and integration teams during incident resolution and deployments.li>
Support MuleSoft Runtime Fabric (RTF) environments and integrations impacting reporting platforms.

REQUIRED SKILLS AND EXPERIENCE:

For this position, the candidate shares experience and judgment withteam to plan and accomplish goals, mentors less experienced staff, a wide degree of creativity and latitude is expected. In addition, the agency requires:

An experienced professional with 5 or more years of prior experience demonstrating the following knowledge and skills:

Experience with Tableau Cloud administration and support
Experience with Salesforce objects, fields, relationships, and the impact of different design decisions. Ability to apply best practices.
Experience with dashboards and supporting enterprise reporting and analytics platforms.
Strong SQL skills and experience working with Azure SQL Database or similar relational databases.
Experience with user management including new user setup, user deactivation, roles, profiles, permission sets, sharing rules and other routine tasks.
Critical thinking and problem solving around issues such as user access, declarative logic, business requests, Environment management, and backup solutions.
Comfortable engaging and escalating issues to Salesforce
Must be very organized, pro‑active and self-directed.
Must be self-starter and driven. Must Drive the work from requirements to implementation.
Must have very strong abstract thinking and problem‑solving skills.
Must have very good verbal and written communication skills.
Work on all phases of SDLC and create/maintain required technical documentation.
Work with the Salesforce Architect to establish best practices.
Work with management to supply input for key design and architecture decisions, as well as work estimation and resource planning.
Provide guidance and training to team members.