Job Description & Details
This is a 12-month contract role for a Senior Software Engineer and ETL/SQL Developer based in Thornton, CO. You'll be diving deep into data warehousing, legacy codebases, and building out robust multi-tiered architectures using a mix of modern and older Microsoft technologies.
What You'll Actually Be Doing
Expect to spend a good chunk of your time untangling legacy code, optimizing database queries, and designing data marts that actually make sense for the business. You will bridge the gap between heavy-duty ETL processes and front-end reporting tools, ensuring data flows reliably while debugging issues in production applications. It is a classic data-heavy enterprise role where your ability to reverse-engineer old systems and build scalable data models will dictate your success.
The Core Tech Stack
You absolutely need strong SQL Server skills, deep knowledge of ETL toolsets, and a solid grasp of data warehousing methodologies. On the application side, fluency in C#, .NET, Visual Basic, and JavaScript is non-negotiable because you will be touching both backend database logic and enterprise UI layers. Experience with OLAP technologies, Crystal Reports, and data modeling tools like Analysis Server will be your bread and butter here.
Interview Expectations
Expect the interview panel to drill down into your SQL performance tuning strategies, likely asking you how you would diagnose and optimize a sluggish query running against a massive dataset with poorly structured legacy schemas. They want to hear about your systematic approach to breaking down old code without breaking existing functionality. You should also be prepared to whiteboard a complete ETL pipeline and explain how you handle error logging, data drift, and schema evolution.
Application Advice
To get past the automated screening, make sure your resume explicitly highlights your hands-on experience with SQL Server dialects, SSIS or other ETL toolsets, and enterprise-grade C#/.NET development. Don't just list technologies; include specific metrics or examples of legacy systems you've refactored or data warehouses you've designed from scratch to catch the hiring manager's eye.