Application Systems Analyst / Programmer (BI / Tableau Admin)

### **Job Title: Application Systems Analyst / Programmer (BI / Tableau Admin)**

**Job ID:** 65931
**Client:** State of Connecticut - Department of Children and Families (DCF)
**Location:** 505 Hudson Street, Hartford, CT 06106
**Work Model:** Hybrid (80% Remote, 20% In-Person) - *Candidate MUST be local to the area.*

---

### **I. Project & System Overview**

The Department of Children and Families (DCF) depends on core, mission-critical applications including CTKIND and IV-E, Connecticut's Federally-reimbursed CCWIS

(Comprehensive Child Welfare Information System). Used by over 2,000 social workers and case managers, these applications are continually enhanced to meet data capture and process functionality requirements driven by child welfare case practices and State/Federal legislation.

The Department of Administrative Services - Bureau of Information Technology Solutions (DAS-BITS) provides the technology expertise and information systems infrastructure for the DCF and its roughly 3,300 employees.

---

### **II. Scope of Work**

The agency requires the services 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.

**Specific Services Required:**
* Administer Tableau Cloud sites, projects, users, groups, permissions, and security in Dev, Test, and Production environments.
* 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.
* Support MuleSoft Runtime Fabric (RTF) environments and integrations impacting reporting platforms.

---

### **III. Required Skills and Qualifications**

The ideal candidate is an experienced professional with 5 or more years of prior experience, capable of mentoring less experienced staff, establishing best practices, and exercising a wide degree of creativity and latitude.

**Required Experience (5+ Years):**
* Experience with Tableau Cloud administration and support.
* Experience with Salesforce objects, fields, relationships, and the impact of different design decisions, with the 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 Salesforce user management including new user setup, deactivation, roles, profiles, permission sets, and sharing rules.
* 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 support.
* Experience working on all phases of the SDLC and creating/maintaining required technical documentation.
* Ability to work with the Salesforce Architect to establish best practices and provide input for key design, architecture decisions, work estimation, and resource planning.
* Must be highly organized, self-directed, and capable of driving work from requirements to implementation.
* Excellent verbal and written communication skills with strong abstract thinking abilities.
* Ability to provide guidance and training to team members.

**Preferred Qualifications:**
* Experience with Azure Data Factory (ADF).
* Experience with MuleSoft Runtime Fabric (RTF) or MuleSoft integrations.
* Experience working with Salesforce data and reporting environments.
* Microsoft Azure experience.