Senior Data Engineer Dimensional Modeling Position Available In Shelby, Tennessee
Tallo's Job Summary: The Senior Data Engineer Dimensional Modeling position at Vaco entails developing scalable data pipelines, collaborating with stakeholders, and maintaining SQL Server-based data warehouses. The role requires 6+ years of experience in SQL development, data warehousing, ETL pipelines, and familiarity with Kimball methodology. The compensation for this role is $55 - $60 per hour, and it is a W2 contract position with no sponsorship available.
Job Description
Vaco is actively seeking a Senior Data Engineer Consultant to support our client’s continued growth and evolution. This is a unique opportunity to join an internationally respected organization that is the leader in their field. (
Please Note :
No form of employment accommodations or sponsorship are being considered)
Key Responsibilities :
The Senior Data Engineer will utilize deep expertise in SQL Server, data warehousing, and ETL development coupled with a strong grasp of dimensional modeling (Kimball, Star Schema), Type 2 Slowly Changing Dimensions, and performance tuning. The position will lead development of scalable, high-performance data pipelines and work closely with stakeholders to support analytics and reporting initiatives.
Responsibilities :
Effectively communicate with peers, partners, and stakeholders to understand objectives, present solutions, and provide regular project updates. Design, build, and maintain SQL Server-based data warehouses (on-prem). Implement dimensional models using Kimball methodology, including Type 2 SCDs. Develop and optimize ETL processes using SSIS or equivalent tools. Write high-performance SQL queries and stored procedures. Orchestrate data workflows using DAG-based tools (Airflow, Dagster, or Prefect). Integrate new data sources and automate recurring data operations. Ensure data quality, governance, and compliance standards are upheld. Mentor junior engineers and contribute to engineering best practices.
Experience :
6+ years of experience in SQL development, data warehousing, and ETL pipelines. Deep understanding of Kimball methodology, Star Schema, and Type 2 SCDs. Expertise in SQL Server environments, including performance tuning. Experience with SSIS or similar ETL frameworks. Python or scripting languages for data workflow automation a plus. Experience with DAG-based orchestration tools (Airflow, Dagster, Prefect) a plus. Familiarity with cloud or columnar data platforms (Snowflake, Redshift, Athena, Spark/Databricks) a plus. Data modeling expertise (Dimensional, Datavault—bonus points for Datavault) a plus.
Additional Details :
Employment Type :
w2
Contract Start Date :
Immediate Location :
Remote Compensation :
$55 – $60 p/h based on skills and experience
Engagement Status :
No form of sponsorship or employment arrangements are being considered at this time. Interested Candidates are Encouraged to Apply for Immediate Consideration! Determining compensation for this role (and others) at Vaco/Highspring depends upon a wide array of factors including but not limited to the individual’s skill sets, experience and training, licensure and certifications, office location and other geographic considerations, as well as other business and organizational needs. With that said, as required by local law in geographies that require salary range disclosure, Vaco/Highspring notes the salary range for the role is noted in this job posting. The individual may also be eligible for discretionary bonuses, and can participate in medical, dental, and vision benefits as well as the company’s 401(k) retirement plan.
