Data Warehouse Engineer
TEKsystems
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
TEKsystems in Cleveland, OH is seeking a Data Warehouse Engineer to own data movement from source systems into Snowflake and to design, build, and operate a scalable analytics platform. The role emphasizes high-quality data pipelines, a trusted Snowflake warehouse, and well-modeled datasets for analytics.
The candidate will be hands-on, with experience building a data warehouse from scratch, tuning SQL Server, restoring databases, and performing disaster recovery tests.
Qualifications
- Bachelor's degree or equivalent practical experience.
- 5+ years of experience in data engineering or data warehousing, including at least one warehouse built from scratch: raw, staging, data marts, and data cubes.
- Strong SQL skills, including complex joins, window functions, CTEs, stored procedures, and performance tuning.
- Hands-on experience building data pipelines from source databases into a cloud data warehouse, preferably Snowflake.
- Working knowledge of dimensional modeling (Kimball) and slowly changing dimensions.
- 3+ years administering SQL Server in production: performance tuning, backup/restore, disaster recovery planning and testing.
- Experience with ETL/ELT tooling and scheduling/orchestration of data jobs.
- Ability to troubleshoot across systems and document work thoroughly.
Responsibilities
- Design, build, and maintain ingestion pipelines from source databases into Snowflake, using batch and CDC patterns.
- Integrate data from CRM, analytics, and finance systems.
- Monitor runs, resolve failures, and implement data-quality checks.
- Document source-to-target mappings, refresh schedules, and dependencies.
- Build and maintain a layered warehouse: raw, staging, and presentation layers.
- Write and optimize transformation logic in SQL, including SCDs and surrogate keys.
- Design dimensional data marts and cubes for finance, operations, and other groups.
- Partner with analysts to turn requirements into well-defined data products.
- Manage Snowflake warehouses, databases, schemas, and roles with least privilege.
- Plan, document, and test disaster recovery including Always On and backup strategies.
- Collaborate with report developers and stakeholders to deliver reliable datasets.
Skills
Education
Tools
Job description
The Data Warehouse Engineer owns the movement of data from our source systems into Snowflake to keep our on-premises SQL Server environment healthy. This position will help design, build, and operate a scalable analytics data platform that supports key business domains. This role focuses on developing high quality data pipelines, a trusted Snowflake data warehouse, and well modeled datasets that power analytics and decision making across the organization.
The Data Warehouse Engineer is a hands-on role for someone who has built a data warehouse from the ground up and is just as comfortable tuning a SQL Server instance, restoring a database, or running a disaster recovery test.
- Design, build, and maintain ingestion pipelines from source databases (SQL Server and other relational systems) into Snowflake, using batch and incremental or change-data-capture patterns.
- Integrate data from third party SaaS platforms such as CRM, product analytics, and finance systems.
- Monitor pipeline runs, resolve failures, and set up alerting, logging, and data-quality checks.
- Document source-to-target mappings, refresh schedules, and dependencies.
- Build and maintain a layered warehouse: raw (landing) tables, cleansed and transformed staging layers, and curated presentation layers.
- Write and optimize transformation logic in SQL, including slowly changing dimensions, surrogate keys, and late-arriving data.
- Design and deliver dimensional data marts and data cubes (star schemas, aggregates, semantic or OLAP models) for finance, operations, and other business groups.
- Partner with report developers and analysts to turn business requirements into well‑defined, tested data products.
- Manage warehouses, databases, schemas, and roles in line with least‑privilege access and our naming conventions.
- Tune performance and control cost: warehouse sizing, clustering, query profiling, and resource monitors.
- Support masking policies and other data‑protection controls and promote changes from development to production through a controlled release process.
- Manage a small environment of SQL Server instances: installation, patching, configuration, capacity planning, and security.
- Tune performance: indexing, statistics, query plans, wait‑stat analysis, and blocking or deadlock resolution.
- Own backup and recovery: design backup schedules, verify backups, and perform point‑in‑time restores.
- Plan, document, and test disaster recovery, including high availability options such as Always On availability groups, log shipping, or failover clustering.
- Maintain SQL Agent jobs, maintenance plans, and monitoring.
- Keep runbooks, data dictionaries, and architecture diagrams current.
- Produce clear technical documentation, including pipeline designs and data flow diagrams.
- Follow change management and secure development practices and take part in on‑call or after‑hours support for critical loads and outages.
- Partner with analytics and business stakeholders to translate requirements into well modeled, reliable datasets.
- Bachelor's degree in computer science, information systems, or a related field, or equivalent practical experience.
- 5+ years of experience in data engineering or data warehousing, including at least one warehouse built from scratch: raw tables, transformation layers, data marts, and data cubes.
- Strong SQL skills, including complex joins, window functions, CTEs, stored procedures, and performance tuning.
- Hands-on experience building and supporting data pipelines from source databases into a cloud data warehouse, preferably Snowflake.
- Working knowledge of dimensional modeling (Kimball), including fact and dimension design and slowly changing dimensions.
- 3+ years administering SQL Server in production: performance tuning, backup and restore, and disaster recovery planning and testing.
- Experience with ETL or ELT tooling and with scheduling or orchestration of data jobs.
- Ability to troubleshoot across systems, communicate clearly with technical and non-technical users, and document work thoroughly.
- Snowflake SnowPro Core or Advanced certification, or a Microsoft SQL Server or Azure data certification.
- Experience with legal or professional services data, such as practice management and billing systems like Aderant Expert.
- Experience with SSRS, Power BI, or similar reporting tools, and with building semantic layers for them.
- Experience with dbt, Python, or PowerShell for transformation, automation, and testing.
- Familiarity with Snowflake features such as Streams, Tasks, Snowpipe, dynamic tables, role‑based access control, and Cortex.
- Knowledge of secure coding practices (such as OWASP) and of data governance, masking, and audit requirements for confidential client data.
- Experience with source control and CI/CD for database and pipeline code.
Growth mindset to enhance emotional intelligence, empathy and an understanding of inclusion and belonging practices that support managing and collaborating across differences.
Cloud data warehouse: Snowflake (warehouses, roles, stages, Snowpipe, Streams, Tasks, resource monitors)
Databases: Microsoft SQL Server (T‑SQL, SQL Agent, Always On, log shipping, backup and restore)
Pipelines: ETL/ELT tools, SSIS or equivalent, orchestration and scheduling, change‑data‑capture patterns
Modeling : Kimball dimensional modeling, star schemas, aggregates, cubes and semantic models
Reporting: SSRS, Power BI, or similar
Automation: SQL, Python, PowerShell, Git, CI/CD
Operations: Monitoring, alerting, runbooks, change management, disaster recovery testing
Data warehouse, snowflake, snowflake data warehouse, sql, sql database, data warehouse architecture, etl, data modeling, etl development
- - Knowledge of highly regulated environment - legal, financial, healthcare, etc.
- - Experience working as a Snowflake professional and as a DBA in past years.
Intermediate Level
This is a Contract to Hire position based out of Cleveland, OH.
The pay range for this position is $53.00 - $66.00/hr.
Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job‑related factors.
Eligibility requirements apply to some benefits and may depend on your jobclassification and length of employment. Benefits are subject to change and may besubject to specific elections, plan, or program terms. If eligible, the benefitsavailable for this temporary role may include the following:Medical, dental & visionCritical Illness, Accident, and Hospital401(k) Retirement Plan Pre-tax and Roth post‑tax contributions availableLife Insurance (Voluntary Life & AD&D for the employee and dependents)Short and long‑term disabilityHealth Spending Account (HSA)Transportation benefitsEmployee Assistance ProgramTime Off/Leave (PTO, Vacation or Sick Leave)
This is a Contract to Hire position based out of Cleveland, OH.
This position is anticipated to close on Nov 6, 2026.
This is a hybrid position in Cleveland,OH.
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Were a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. Were a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. Were strategic thinkers, hands‑on collaborators, helping customers capitalize on change and master the momentum of technology. Were building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.
Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
