Data Warehouse Analyst

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.

• 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.

• 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.

Contract position based out of Rochester, NY.

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)

This is a hybrid position in Rochester, NY.

This position is anticipated to close on Dec 12, 2025.

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.