What are the responsibilities and job description for the Data Warehouse Analyst position at Jobs via Dice?
Description
Overview
The Data Warehouse team operates at the intersection of data analytics, data engineering, and business intelligence. We build robust, efficient, and scalable data structures to support high-quality, nuanced, and timely data analytics to empower strategic decisions and policies by leadership and stakeholders. The Data Warehouse Analyst plays a critical role in ensuring data-driven decision making by working closely in collaboration with team leads, development teams and stakeholders as designated to support design, development and rollout of data warehouse projects. This individual serves as a bridge between the data warehouse development team and users through the development lifecycle. They develop data warehouse and integration specifications and design documentation based on user input. They create testing strategies with input from other team members and users.
Responsibilities
Additional Skills (Preferred)
This is a Contract position based out of Rochester, NY.
Pay And Benefits
The pay range for this position is $40.00 - $45.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a hybrid position in Rochester,NY.
Application Deadline
This position is anticipated to close on Jan 28, 2026.
>About TEKsystems:
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.
About TEKsystems And TEKsystems Global Services
We're 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. We're 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. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're 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.
Overview
The Data Warehouse team operates at the intersection of data analytics, data engineering, and business intelligence. We build robust, efficient, and scalable data structures to support high-quality, nuanced, and timely data analytics to empower strategic decisions and policies by leadership and stakeholders. The Data Warehouse Analyst plays a critical role in ensuring data-driven decision making by working closely in collaboration with team leads, development teams and stakeholders as designated to support design, development and rollout of data warehouse projects. This individual serves as a bridge between the data warehouse development team and users through the development lifecycle. They develop data warehouse and integration specifications and design documentation based on user input. They create testing strategies with input from other team members and users.
Responsibilities
- Business Needs Analysis: Conduct in-depth analysis of business requirements to identify data and integration requirements specifications
- Data Modeling: Design and implement robust data models, including dimensional and snowflake models, to ensure optimal data organization and accessibility.
- Data Quality Assurance: Implement data quality checks and validation processes to ensure data accuracy, completeness, and consistency.
- Testing and Validation: Coordinate test plans, develop test cases, and execute system testing to ensure that the data warehouse meets project requirements and delivers accurate results.
- Documentation: Create and maintain comprehensive documentation, including data dictionaries, technical specifications, and training materials.
- Collaboration: Work closely with cross-functional teams, including data scientists, technical data analysts, and users, to understand their data requirements and provide effective solutions.
- Continuous Improvement: Stay updated on industry trends and best practices to identify opportunities for process improvement and technological advancements.
- Education: A Bachelor's or Master's degree in computer science, data science, or a related field is required.
- 2 years of relevant experience required or equivalent combination of education and experience
- Proficiency in SQL required
- Strong analytic, qualitative and quantitative data analysis skills, with demonstrated ability to break down complex problems into phased deliverables required
- Strong communication and interpersonal skills required
- Ability to work independently and as part of a team required
Additional Skills (Preferred)
- Strong understanding of data warehousing concepts, including dimensional modeling, ETL processes, and data quality preferred
- Knowledge of data visualization tools (e.g., Tableau, Power BI) preferred
- Experience with data mining and machine learning techniques preferred
- Experience with data warehousing ETL tools (e.g., Informatica, Talend) a plus
This is a Contract position based out of Rochester, NY.
Pay And Benefits
The pay range for this position is $40.00 - $45.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a hybrid position in Rochester,NY.
Application Deadline
This position is anticipated to close on Jan 28, 2026.
>About TEKsystems:
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.
About TEKsystems And TEKsystems Global Services
We're 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. We're 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. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're 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.
Salary : $40 - $45