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.