Description- 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.
Knowledge & Experience- 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
Top Skills' Details1. SQL - Candidate should be strong with SQL, should be able to query, table design, create views and functions.
2. Analysis - Candidate should have strong analytics qualitative, quantitative data analysis skills. They should have demonstrated ability to break down complex problems into phased deliverables required.
3. QA - Candidates should have experience implementing data quality checks and validations processes to ensure data accurate, completeness and consistency.
4. Communication - Candidate should have strong ability to collaborate including written and verbal communication. They should have strong documentation skills.
5. Candidate should have a degree in analytics, data science or computer science.
6. Python
Additional Skills & QualificationsAdditional 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
Job Type & LocationThis is a Contract position based out of Rochester, NY.
Pay and BenefitsThe 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 TypeThis is a hybrid position in Rochester,NY.
Application DeadlineThis position is anticipated to close on Dec 12, 2025.
>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.
Never miss an opportunity! Create an alert based on the job you applied for.
