Senior Data Engineer - Dimensional Modeling

Vaco; Memphis (TN); Remote; USD 60,000 - 80,000; Full time

Job summary

An internationally respected organization is seeking a Senior Data Engineer Consultant to support their growth. This role involves leveraging deep expertise in SQL Server, data warehousing, and ETL development to create scalable data pipelines. You'll work closely with stakeholders to enhance analytics and reporting initiatives, ensuring data quality and compliance. Join a forward-thinking company that values innovation and collaboration, where your contributions will significantly impact data-driven decisions. If you're ready to take your career to the next level and make a difference, this opportunity is for you.

Benefits

Medical Benefits

Dental Benefits

Vision Benefits

401(k) Retirement Plan

Flexible Work Hours

Qualifications

• 6+ years of experience in SQL development and data warehousing.
• Deep understanding of Kimball methodology and Type 2 SCDs.
• Mentor junior engineers and contribute to best practices.

Responsibilities

• Design and maintain SQL Server-based data warehouses.
• Develop and optimize ETL processes using SSIS.
• Communicate effectively with stakeholders for project updates.

Skills

SQL Development

Data Warehousing

ETL Development

Dimensional Modeling

Performance Tuning

Communication Skills

Tools

SQL Server

SSIS

Airflow

Dagster

Prefect

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.

Vaco by Highspring values a diverse workplace and strongly encourages women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans to apply.

EEO Notice

Vaco by Highspring is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.

Vaco by Highspring and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals. As part of this commitment, Vaco by Highspring and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact [e-mail] .

Vaco by Highspring also wants all applicants to know their rights that workplace discrimination is illegal.

By submitting to this position, you agree that you will be giving Vaco by Highspring the exclusive right to present your as a candidate for the foregoing employment opportunity. You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications. You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco by Highspring about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application. In exchange, Vaco by Highspring agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.

Privacy Notice

Vaco by Highspring and its parents, affiliates, and subsidiaries ("we," "our," or "Vaco by Highspring") respects your privacy and are committed to providing transparent notice of our policies.

• California residents may access Vaco by Highspring HR Notice at Collection for California Applicants and Employees here.
• Virginia residents may access our state specific policies here.
• Residents of all other states may access our policies here.
• Canadian residents may access our policies in English here and in French here.
• Residents of countries governed by GDPR may access our policies here.

Pay Transparency Notice

Determining compensation for this role (and others) at Vaco by Highspring depends upon a wide array of factors including but not limited to:

• the individual's skill sets, experience and training;
• licensure and certification requirements;
• office location and other geographic considerations;
• other business and organizational needs.

With that said, as required by local law, Vaco by Highspring believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure. The individual may also be eligible for discretionary bonuses.