ScatterPie Analytics

Job Summary:

We are seeking an experienced Tableau Server Administrator to manage, maintain, and optimize our multi-node, on-premise Tableau Server environment. The ideal candidate will have strong expertise in Tableau Server architecture, installation, upgrades, and troubleshooting, as well as ensuring its scalability, performance, and security. This role will also involve collaboration with business intelligence teams to support Tableau dashboards and workflows.

Key Responsibilities:

Tableau Server Installation & Configuration:

1. Manage multi-node, on-premise Tableau Server deployment and configuration.
2. Install and upgrade Tableau Server across environments (Development, QA, Production).
3. Configure and maintain Tableau Server processes, services, and configurations for optimal performance.

Performance Monitoring & Optimization:

1. Monitor server performance, disk space, and log files to ensure availability and efficiency.
2. Conduct capacity planning and fine-tune server resources (e.g., CPU, RAM, and disk utilization) to support increasing workloads.
3. Optimize Tableau extracts, data connections, and server processes for improved speed and efficiency.

User Management & Security:

1. Manage user accounts, groups, roles, and permissions in Tableau Server.
2. Implement and enforce security protocols for data, content, and access controls.
3. Collaborate with IT teams to ensure compliance with organizational security policies.

Troubleshooting & Issue Resolution:

1. Diagnose and resolve Tableau Server-related issues, including downtime, errors, and performance bottlenecks.
2. Work with Tableau Support to address critical incidents and escalations.

Automation & Scripting:

1. Automate administrative tasks using Tableau Server Command Line (tabcmd) and REST APIs.
2. Schedule and monitor Tableau extract refreshes, subscriptions, and workflows.

Collaboration with Stakeholders:

1. Work closely with BI developers, data engineers, and analysts to support Tableau content publishing and troubleshooting.
2. Assist in creating governance standards for Tableau content and server usage.

Data Connectivity & Integration:

1. Maintain and troubleshoot Tableau Server connections to various data sources, such as SQL databases, flat files, and APIs.
2. Collaborate with data teams to ensure high availability and data accuracy.

Upgrades, Patches & Backups:

1. Plan and execute Tableau Server upgrades, patches, and backups with minimal disruption to operations.
2. Implement disaster recovery plans and strategies for Tableau Server.

Documentation & Reporting:

1. Maintain detailed documentation for server configurations, upgrade logs, and processes.
2. Create usage reports, server activity logs, and audit trails for stakeholders.

Required Skills & Qualifications:

Technical Expertise:

• Strong experience with Tableau Server administration in a multi-node, on-premise environment.
• Proficiency in Tableau Desktop, Tableau Prep, and Tableau Server tools (tabcmd, TSM, REST API).
• Knowledge of Windows Server/Linux administration and networking concepts.
• Familiarity with scripting languages (Python, PowerShell, or Bash) for automation.

Database & Data Integration Skills:

• Experience with relational databases like SQL Server, PostgreSQL, Oracle, or MySQL.
• Knowledge of data extraction, ETL processes, and integrating Tableau with enterprise data sources.

Performance Tuning:

• Expertise in optimizing Tableau extracts, dashboards, and server configurations for high performance.

Problem-Solving Skills:

• Ability to troubleshoot server issues and resolve them efficiently.

Soft Skills:

• Excellent communication and collaboration skills.
• Strong organizational skills with attention to detail.

Preferred Qualifications:

• Tableau Server Certified Associate or Certified Professional certification.
• Experience managing Tableau in high-availability and disaster recovery scenarios.
• Familiarity with Tableau Cloud or hybrid Tableau environments.
• Knowledge of load balancing, SSL certificate configuration, and Active Directory integration.

Benefits:

• Competitive salary and performance-based incentives.
• Opportunities for professional development and Tableau certifications.
• Flexible working hours and hybrid working options (if applicable).
• Access to cutting-edge BI tools and resources.

• BizTalk Development:
• Design, develop, and deploy BizTalk solutions for integrating business processes.
• Build custom BizTalk maps, orchestrations, pipelines, and adapters to meet integration requirements.
• Troubleshoot and resolve issues with BizTalk applications, ensuring minimal downtime.
• Implement best practices for BizTalk development and integration.
• Create and maintain documentation related to BizTalk applications and processes.
• SQL Development & Management:
• Develop, optimize, and maintain SQL Server databases, including stored procedures, queries, and triggers.
• Write efficient SQL queries to extract, transform, and load data.
• Perform database tuning and optimization for performance improvements.
• Ensure database security, integrity, and backup.
• Conduct routine maintenance tasks such as patching and updates for SQL databases.
• Integration & Collaboration:
• Collaborate with business analysts and other developers to understand business requirements and integrate them into solutions.
• Participate in design and code reviews, ensuring quality and standards are adhered to.
• Assist in the deployment of BizTalk solutions and SQL database updates to production environments.
• Support Existing Systems:
• Provide ongoing support and maintenance for existing BizTalk applications, SQL databases, and integration processes.
• Troubleshoot, monitor, and optimize existing BizTalk integration workflows, databases, and related services.
• Ensure smooth operations by resolving issues and improving the performance of legacy systems.
• Monitoring & Support:
• Monitor the performance of BizTalk applications and SQL databases to ensure optimal performance.
• Provide ongoing support for BizTalk integrations and SQL database issues.
• Troubleshoot and resolve technical issues related to integrations and SQL queries.
• Provide 2nd/3rd line support for any issues that arise in the production environment.

Required Skills & Qualifications:

• Technical Skills:
• Strong experience with BizTalk Server (preferably BizTalk 2016 or later).
• Expertise in creating and managing BizTalk orchestrations, maps, and pipelines.
• Proficient in SQL Server (SQL Server 2012/2014/2016/2017/2019).
• Experience with T-SQL, stored procedures, triggers, views, and indexes.
• Familiarity with SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).
• Knowledge of web services (SOAP, REST) and messaging formats (XML, JSON).
• Experience with BizTalk adapters and message brokers.
• Analytical and Troubleshooting Skills:
• Strong problem-solving skills with the ability to debug and troubleshoot BizTalk and SQL issues.
• Ability to quickly understand new systems and integrations and provide efficient solutions.

Skills: ETL+ SQL

· Experience with SQL and data querying languages.

· Knowledge of data governance frameworks and best practices.

· Familiarity with programming/scripting languages (e.g., SparkSQL)

· Strong understanding of data integration techniques and ETL processes.

· Experience with data quality tools and methodologies.

· Strong communication and problem-solving skills

Detailed JD: Data Integration: Manage the seamless integration various data lake, ensuring that jobs are running as expected, validate the data ingested , track the DQ checks , rerun/reprocess the jobs in case of failures post figuring out the RCAs

Data Quality Assurance: Monitor and validate data quality during and after the migration process, implementing checks and corrective actions as needed.

Documentation: Maintain comprehensive documentation related to data issues encountered during the weekly/monthly processing and operational procedures.

Continuous Improvement: Recommend and implement improvements to data processing, tools, and technologies to enhance efficiency and effectiveness.