Data Platform & Production Support Engineer

Summary:

As the Data Platform & Production Support Engineer, you will oversee, optimize, and support our comprehensive enterprise data ecosystem, including Tableau Online, Snowflake, Fivetran, dbt, Altimate AI, AWS EC2, OKTA, and Wisdom AI. This hybrid role combines system administration, identity and access management (IAM), AI-enhanced workflow optimization, data pipeline oversight, and advanced tier-2/3 support across business applications to ensure the security, performance, and reliability of our data platforms.

Responsibilities:

• Manage user provisioning, site administration, and Role-Based Access Control (RBAC) across core data platforms, including Tableau Online, Snowflake, Fivetran, dbt, Altimate AI, AWS EC2, Revifi, Obsidian, and Wisdom AI.
• Administer OKTA groups, application tiles, API credentials, and execute routine OAuth token rotations across all supported tools.
• Lead quarterly User Access Reviews (UAR) to ensure security compliance across Snowflake, Tableau Online, Fivetran, dbt, Wisdom AI, and related enterprise apps.
• Implement robust security measures, including managing service accounts, IP whitelisting, and formulating cross-tool network policies.
• Monitor Tableau Online environment health and site performance, tracking dashboard load times, extract statuses, and user engagement via built-in administrative views.
• Ensure the successful execution of scheduled data extracts and Tableau-to-Snowflake flow refreshes, quickly addressing any failures to prevent business downtime.
• Facilitate the deployment and publication of optimized dashboards post-Change Advisory Board (CAB) approval.
• Conduct daily health checks on Fivetran connectors, provision new integrations, refresh expired tokens, validate data syncs, and partner with Fivetran support for advanced troubleshooting.
• Track dbt job execution and speed. Leverage Altimate AI to automate model documentation, enforce testing, track column-level lineage, and perform blast radius impact analysis before code deployments.
• Maintain and support background engineering scripts and cron jobs on EC2 instances. Handle user/role administration, rotate credentials, and troubleshoot process failures.
• Monitor virtual warehouse compute performance, storage utilization, and query runtimes in Snowflake.
• Utilize Altimate AI FinOps features alongside Snowflake's auto-suspend and scaling policies to pinpoint resource-heavy queries, right-size compute instances, and drive cost efficiencies.
• Provide ongoing administration and technical support for Wisdom AI, managing non-SCIM manual user onboarding, RBAC, JIRA ticket workflows, and OKTA tile configurations upon manager approvals.
• Partner with Revifi support to resolve issues related to platform spend, data observability, and governance.
• Actively triage and resolve support tickets within the JIRA and Salesforce data queues.
• Spearhead Proofs of Concept (POCs) for evaluating new platforms, connectors, and AI tools, collaborating across teams for seamless implementation.
• Author and maintain comprehensive Standard Operating Procedures (SOPs), system configurations, and user documentation.

Requirements:

• Proven experience administering SaaS and cloud environments, particularly Tableau Online, Snowflake, Fivetran, dbt, Altimate AI, AWS EC2, and specialized application platforms like Wisdom AI.

Required Skills:

• Deep knowledge of OKTA, RBAC methodologies, OAuth token management, non-SCIM user provisioning, IP allowlisting, and executing UAR compliance audits.
• Familiarity with Altimate AI capabilities and AI-assisted data tools for user support, documentation, and query execution.
• Advanced SQL proficiency for system troubleshooting and query optimization capable of managing automated bash/Python scripts within Linux/EC2 environments.
• Strong grasp of modern ELT/ETL pipelines, data synchronization, and data quality platforms (e.g., Revifi).
• Skilled in navigating JIRA, Salesforce ticketing, Git version control, and Change Advisory Board (CAB) deployment standards.
• Excellent written and verbal communication skills for cross-functional collaboration, technical documentation, and proactive system-alert messaging.

#AditiConsulting
# 26-05768