Application Systems Analyst Programmer (BI Tableau Admin)
Job Location:
Job Location:
Hartford, CT - USA
Monthly Salary:
Not Disclosed
Monthly Salary:
Posted on:
Yesterday
Posted on:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
### **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.*
**Work Schedule:** Full-Time 40 hrs/week - Monday to Friday 8:00 AM - 5:00 PM
**Visa Parameters:** H1B candidates are welcome but must have an approved I-140.
**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.*
**Work Schedule:** Full-Time 40 hrs/week - Monday to Friday 8:00 AM - 5:00 PM
**Visa Parameters:** H1B candidates are welcome but must have an approved I-140.
---
### **I. Project & System Overview**
The Department of Children and Families (DCF) depends on core mission-critical applications including CTKIND and IV-E Connecticuts Federally-reimbursed CCWIS
(Comprehensive Child Welfare Information System). Used by over 2000 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 3300 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.
* 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.
* 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.
* 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.
