Job Description & Details
This is a heavy-duty data engineering and visualization role where you won't just be building dashboards, but also wrangling the underlying plumbing. You'll be bridging the gap between raw data architectures and executive-level Tableau reports, meaning your SQL and ETL skills need to be just as sharp as your data viz instincts.
What You'll Actually Be Doing
Expect to spend your days knee-deep in SSIS packages, complex T-SQL scripts, and data migration strategies. You will design ETL/ELT pipelines, pull data from legacy systems like DB2 and SQL Server, and ensure data quality before it ever hits a visualization. Half the job is building robust data pipelines, and the other half is translating those data models into high-impact Tableau reports deployed to integrated servers like SharePoint.
The Core Tech Stack
You need absolute fluency in Tableau and Microsoft T-SQL—we're talking complex queries, stored procedures, and triggers. SSIS is a massive component here for data ingestion and transformation, alongside version control tools like Git and TFS. If you don't know your way around database architecture, data marts, and optimizing slow-running queries on the fly, you'll struggle to keep up with the data volume and migration demands.
Interview Expectations
They are going to test your ability to troubleshoot performance bottlenecks, likely asking you how you would diagnose a long-running SSIS package or an unoptimized SQL query that is dragging down a dashboard. The hiring manager wants to see if you can trace a data issue all the way from the legacy source system up to the Tableau front-end without breaking a sweat.
Application Advice
Your resume needs to heavily feature your end-to-end data experience—don't just list Tableau; pair it directly with the ETL work you did to feed it. Make sure keywords like T-SQL, SSIS, data modeling, performance optimization, and data migration are prominent to clear the ATS and catch the eye of a tech lead who needs someone ready to hit the ground running.