Business Intelligence / Tableau Administrator - hybrid Hartford, CT

Novalink Solutions LLC•Hartford, CT

3d•Hybrid

About The Position

The Department of Children and Families (DCF) relies on core, mission-critical applications like CTKIND and IV-E, Connecticut’s Comprehensive Child Welfare Information System (CCWIS). These applications are used by over 2,000 social workers and case managers and have been continuously enhanced to meet data capture and process functionality requirements driven by child welfare practices, as well as State and Federal legislation. CTKIND is regularly updated to align with the agency's goal of improving the safety, permanency, and well-being of children in care. DCF has invested significantly in ensuring efficient, economic, and effective tools for its Child Welfare Staff, Providers, and the children and families of Connecticut. The Department of Administrative Services - Bureau of Information Technology Solutions (DAS-BITS) provides technology expertise, services, and an information systems infrastructure for DCF and its approximately 3,300 employees, aiming for continuous improvement in cost-effective and high-quality technological services.

Requirements

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.
Microsoft SQL Server - Advanced (7-9 Years)
Transact-SQL - Proficient (4-6 Years)
SQL Server Reporting Services (SSRS) - Proficient (4-6 Years)

Nice To Haves

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.

Responsibilities

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