Data Warehouse Analyst

TeckLeap
Uncasville, CtHybrid2-10 YEARPosted: Jun 23, 2026
About Company

Providing innovative, comprehensive, and end-to-end information technology and workforce management solutions that empower businesses to achieve digital transformation, enhance operational efficiency, and drive sustainable growth

Job Description

The Data Warehouse Analyst is responsible for partnering with business users to gather requirements and design, develop, and implement decision support solutions that drive data-informed decision-making. This role supports the data warehouse infrastructure by building and maintaining ETL processes, data models, and reporting assets to ensure reliable, accurate, and accessible data across the organization.

Key Responsibilities

  • Collaborate with business stakeholders to understand reporting and analytics requirements and translate them into technical solutions.
  • Design, develop, and maintain data warehouse components, including ETL processes, database structures, and data views.
  • Validate and monitor data warehouse feeds using automated and manual processes to ensure data quality, accuracy, and integrity.
  • Create and maintain comprehensive technical documentation such as data dictionaries, data catalogs, and system architecture diagrams.
  • Develop and support business intelligence (BI) tools and reporting solutions to meet end-user needs.
  • Provide Level III support for BI and decision support systems, including troubleshooting complex issues and optimizing performance.
  • Design, build, and document reports, dashboards, and data visualizations.
  • Work with cross-functional teams to enhance existing reporting solutions or develop new analytics capabilities.
  • Execute approved work requests and prioritize tasks based on business needs and project timelines.
  • Promote organizational values and maintain a strong customer-service-oriented mindset.
  • Support mission-critical applications operating in a 24x7x365 enterprise environment.
  • Maintain accurate activity tracking and time reporting in accordance with IT policies.
  • Participate in on-call rotation and provide after-hours support as required.
  • Ensure compliance with data privacy, security, and regulatory requirements, including HIPAA (where applicable).
  • Contribute to continuous improvement initiatives within the data and analytics ecosystem.
  • Perform additional duties and responsibilities as assigned.

Basic Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, Engineering, Business, or a related field.
  • Demonstrated experience with one or more business intelligence and data platforms such as Snowflake, Informatica, Power BI, Tableau, or Cognos.
  • Strong understanding of data warehousing concepts, data modeling, ETL/ELT processes, and relational databases.
  • Experience with SQL and data analysis techniques.
  • Ability to communicate effectively with both technical and non-technical stakeholders.
  • Strong analytical, problem-solving, and organizational skills.
  • Ability to obtain and maintain required licenses or certifications (e.g., gaming licenses, if applicable).

Preferred Qualifications:

  • Experience with cloud-based data platforms and modern data architecture.
  • Familiarity with scripting languages (e.g., Python, Shell).
  • Experience working in highly regulated environments (e.g., healthcare, gaming, finance).
  • Knowledge of data governance and data quality frameworks.
;