TEKsystems · 11 hours ago
Data Warehouse Analyst
Rochester, NY
Full-time
Hybrid
Entry, Mid Level
$40/hr - $45/hr
2+ years expTEKsystems is a leading provider of business and technology services, and they are seeking a Data Warehouse Analyst to join their Data Warehouse team. The role involves conducting business needs analysis, designing data models, ensuring data quality, and collaborating with cross-functional teams to support data-driven decision-making.
Information Technology
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
Qualification
Required
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
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
Benefits
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)
Company
TEKsystems
At TEKsystems, they understand people. Every year they deploy over 80,000 IT professionals at 6,000 client sites across North America,
10001+ employees
H1B Sponsorship
TEKsystems has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (46)
2024 (52)
2023 (33)
2022 (22)
2021 (36)
2020 (53)
Funding
Current Stage
Late StageLeadership Team
Ryan Skains
Vice President, TEKsystems Global Services
Recent News
2025-11-19
2025-10-29
Company data provided by crunchbase