Job Description & Details
This is a heavy-hitting data engineering and reporting role housed within a state agency context, blending legacy .NET support with brand new enterprise systems like SACWIS. You'll spend a lot of your time wrangling data pipelines, building out Tableau dashboards, and keeping complex SSIS/SSRS workflows healthy. If you like bridging the gap between raw backend databases and clean visual analytics for stakeholders, this contract gives you a solid platform to do it.
What You'll Actually Be Doing
Expect to bounce between deep database architecture work and frontend reporting tasks. You will be writing complex T-SQL scripts, optimizing slow stored procedures, and handling ETL migrations from legacy platforms using tools like SSIS and Talend. On any given day, you might coordinate with business analysts to lock down requirements, build out dynamic Tableau views with drill-downs and cross-tabs, and troubleshoot data discrepancies to ensure the integrity of the agency's reporting infrastructure.
The Core Tech Stack
Tableau and Microsoft T-SQL are non-negotiable here; you need to live and breathe complex queries, performance tuning, and relational data modeling. You'll also rely heavily on SSIS and SSRS for data ingestion and report generation, alongside occasional integrations with Salesforce and MuleSoft. Knowing how to handle secure file transfers, deploy via Git or TFS, and parse multi-source data from SQL Server and DB2 will keep you afloat in this environment.
Interview Expectations
Expect the hiring manager to push hard on your ETL optimization strategies—they will likely ask how you handle a scenario where an SSIS package execution crawls on a massive dataset and what exact steps you take to troubleshoot the bottleneck. They are testing your pragmatic problem-solving and whether you know how to index properly and manage transaction logs. Another common angle will be querying architecture: be ready to explain how you handle complex joins, CTEs, and dynamic grouping in Tableau when dealing with messy, legacy database structures.
Application Advice
To get past the ATS, make sure your resume explicitly calls out your years of experience with Tableau, T-SQL, and SSIS, matching the 5+ year thresholds highlighted in the requirements. Don't just list tools; emphasize your hands-on background with data migration strategies, performance tuning, and cross-functional requirement gathering. Highlight specific instances where you optimized query performance or deployed reporting solutions into enterprise environments like SharePoint report servers.