Talent.com
Data Warehouse Analyst
Data Warehouse AnalystTEKsystems • Rochester, NY, United States
Data Warehouse Analyst

Data Warehouse Analyst

TEKsystems • Rochester, NY, United States
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description
  • 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' Details
  • 1. 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 & Qualifications
    • 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
    • Job Type & Location
    • 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 Dec 12, 2025.

      h4>

      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.

    serp_jobs.job_alerts.create_a_job

    Data Analyst • Rochester, NY, United States

    Job_description.internal_linking.related_jobs
    Python Data Engineer - Remote (Req. #730)

    Python Data Engineer - Remote (Req. #730)

    Mindex • Rochester, New York, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    Founded in 1994 and celebrating 30 years in business, Mindex is a software development company with a rich history of demonstrated software and product development success.We specialize in agile so...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Self-Employed Delivery Specialist (SPENCERPORT)...

    Self-Employed Delivery Specialist (SPENCERPORT)...

    United Parcel Service • SPENCERPORT, New York, US
    serp_jobs.job_card.part_time +1
    Deliver from the comfort of your own vehicle! As a seasonal support driver (SSD), youll deliver packages to communities and businesses from your personal vehicle. This is a friendly, physically acti...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted • serp_jobs.job_card.new
    Data Entry Product Support - No Experience

    Data Entry Product Support - No Experience

    GLOCPA • Greece, New York
    serp_jobs.job_card.full_time
    We’re looking for Customer Support Product Testers across the US to work from home and help top brands improve their products before they hit the market.serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Remote Database Architects (Professional, Scientific, and Technical Services) - AI Trainer ($100-$180 per hour)

    Remote Database Architects (Professional, Scientific, and Technical Services) - AI Trainer ($100-$180 per hour)

    Mercor • Rochester, New York, US
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    Mercor is recruiting • •Database Architects who work in the Professional, Scientific, and Technical Services • • as independent contractors working on a research project • •for one of the world’s top A...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Hiring Now - Work from Home - No Experience

    Hiring Now - Work from Home - No Experience

    OCPA • Groveland, New York, us
    serp_jobs.filters.remote
    serp_jobs.job_card.part_time +1
    Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies. We guarantee 15-25 hours per week with an hourly pay of bet...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Remote Database Administrators (Professional, Scientific, and Technical Services) - AI Trainer ($90-$160 per hour)

    Remote Database Administrators (Professional, Scientific, and Technical Services) - AI Trainer ($90-$160 per hour)

    Mercor • Rochester, New York, US
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    Mercor is recruiting • •Database Administrators who work in the Professional, Scientific, and Technical Services Sector • • as independent contractors working on a research project • •for one of the wo...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Part-Time Side Work - Earn on Top of Your Day Job

    Part-Time Side Work - Earn on Top of Your Day Job

    Finance Buzz • Livonia, New York, US
    serp_jobs.job_card.part_time +1
    We’re looking for people interested in a part-time remote opportunity to supplement their main income.This position is ideal for professionals, freelancers, and anyone who wants to improve their fi...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Senior Supply Chain Data Analyst

    Senior Supply Chain Data Analyst

    ShipBob • Rochester, NY, US
    serp_jobs.job_card.full_time
    Senior Supply Chain Data Analyst.As a member of the ShipBob team, you will.Grow with an Ownership Mindset.We champion continuous learning and proactive innovation. Team members are encouraged to ide...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_hours • serp_jobs.job_card.promoted • serp_jobs.job_card.new
    RN - Telemetry in Spencerport, NY - $2,028 / week

    RN - Telemetry in Spencerport, NY - $2,028 / week

    Vetted Health • Spencerport, NY, US
    serp_jobs.job_card.full_time
    Vetted is seeking a RN - Telemetry for a travel job in Rochester, New York.The job was posted about 2 months ago.The assignment starts on ASAP and is 13 weeks long with 13 hour shifts 3 days a week...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Customer Support Specialist

    Customer Support Specialist

    Staffmark Group • Geneseo, NY, United States
    serp_jobs.job_card.full_time
    Staffmark is seeking a Customer Support Specialist to join a well-established team in Geneseo, NY.Monday - Thursday : 8 : 00 AM - 5 : 00 PM. Post-Training (Flexible Schedule) : .Monday - Thursday : 8 : 00 AM ...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Remote Database Administrators - AI Trainer ($75-$100 per hour)

    Remote Database Administrators - AI Trainer ($75-$100 per hour)

    Mercor • Rochester, New York, US
    serp_jobs.filters.remote
    serp_jobs.job_card.temporary
    Role Overview • • Mercor is collaborating with a leading AI organization to identify experienced Database Administrators for a high-priority training and evaluation project.Freelancers will be tasked...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Travel Certified Surgical Technologist - $2,006 per week

    Travel Certified Surgical Technologist - $2,006 per week

    Rang Healthcare • Dansville, NY, United States
    serp_jobs.job_card.permanent
    Rang Healthcare is seeking a travel Certified Surgical Technologist for a travel job in Dansville, New York.Job Description & Requirements. Certified Surgical Technologist.We are an equal opportunit...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Sr Data Warehouse Developer - Supply Chain

    Sr Data Warehouse Developer - Supply Chain

    University of Rochester • Rochester, NY, United States
    serp_jobs.job_card.full_time
    As a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better.Embedded in that ideal are the values we share : equity, leadership, integrity, openness, respect...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Data Analysis

    Data Analysis

    Quality Talent Group • Greece, New York, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Data Analysis - AI Training Role.Our client is a leading force in advancing safer, smarter AI technology.Their work has been featured in. They have built a global community of expert contributors an...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days
    Travel Cath Lab Tech in Spencerport, NY - $14306 / month

    Travel Cath Lab Tech in Spencerport, NY - $14306 / month

    VETTED • Spencerport, NY, United States
    serp_jobs.job_card.temporary
    Job Opportunity : Cath Lab Tech.Facility : Coast Medical Service.Provides specialized healthcare services in a clinical setting. Works collaboratively with healthcare team members.Maintains profession...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Senior Analyst, Quality Analytics & Performance Improvement- Excel / SQL (Remote)

    Senior Analyst, Quality Analytics & Performance Improvement- Excel / SQL (Remote)

    Molina Healthcare • Rochester, NY, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    The Analyst, Quality Analytics and Performance Improvement role will support Molina's Quality Analytics team.Designs and develops reporting solutions to assist HEDIS audit, rate tracking, and Ident...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted