Business Intelligence Consultant

Spectraforce; Hartford (CT); On-site; USD 90,000 - 130,000; Full time

Job summary

Spectraforce is seeking a mid- to senior-level BI/Tableau Admin to manage Tableau Cloud sites, Azure SQL databases, and MuleSoft RT Fabric integrations. You will monitor, troubleshoot, and support enterprise reporting and analytics platforms while collaborating with developers and business users.

The role requires 5+ years of experience, strong SQL and Salesforce data skills, and a proactive, self-directed approach. Onsite work is required, with local candidates preferred.

Qualifications

• 5+ years of relevant experience in BI/analytics environments.
• Tableau Cloud administration and support experience.
• Experience with Salesforce objects, fields, relationships, and best practices.
• Dashboards and enterprise reporting platforms experience.
• Strong SQL skills and Azure SQL Database experience.
• Experience with user management and access controls.
• SDLC processes and technical documentation experience.

Responsibilities

• 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 across environments.
• Support and troubleshoot Azure SQL Database environments for reporting.
• Investigate data issues and perform data validation.
• Monitor data loads and Azure Data Factory pipelines.
• Collaborate with development and integration teams during incidents and deployments.
• Provide guidance and training to team members.

Skills

Tableau Cloud administration

Azure SQL Database

Salesforce data modeling

SQL querying

MuleSoft RT Fabric

User management

SDLC documentation

Problem solving

Effective communication

Self-starting

Tools

Tableau Cloud

Azure Data Factory

MuleSoft Runtime Fabric

Salesforce

Job description

The candidate must be local and able to work onsite 1 day per week. The candidate must also be available to attend at least one in-person interview. During any virtual meetings, the candidate must be formally introduced by their vendor.

SCOPE OF WORK

The agency needs 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.

Specifically, the candidate will be responsible for administering Tableau Cloud sites, projects, users, groups, permissions, and security in Dev, Test, and Production environments, as well as supporting and troubleshooting Azure SQL Database and MuleSoft Runtime Fabric (RTF) environments and integrations impacting reporting platforms.

Specific Services 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.
• Support MuleSoft Runtime Fabric (RTF) environments and integrations impacting reporting platforms.

REQUIRED SKILLS AND EXPERIENCE

For this position, the candidate shares experience and judgment with the team to plan and accomplish goals, mentors less experienced staff, and 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, proactive, and self-directed.
• Must be a 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.

ADDITIONAL 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.