Data Warehouse Engineer
Position Summary
The Data Warehouse Engineer is responsible for designing, developing, and maintaining enterprise data warehouse infrastructure and ETL solutions that support strategic decision-making and operational efficiency. This role requires expertise in data integration, database management, and modern data engineering.
Primary Duties And Responsibilities
ETL Development and Data Integration: Design, develop, and maintain complex ETL workflows using enterprise-class tools such as Informatica. Implement automated validation procedures to ensure data accuracy and integrity.
Data Warehouse Design and Optimization: Design and maintain efficient data warehouse structures, schemas, tables, views, and materialized views. Perform performance planning, tuning, and optimization including warehouse sizing, query optimization, clustering keys, and data partitioning strategies.
Technical Documentation and Data Governance: Create and maintain comprehensive technical documentation including data catalogs, structural diagrams, ETL process flows, and data lineage documentation.
Business Intelligence Support and Collaboration: Provide Level III technical support for business intelligence and decision support tools. Collaborate with business stakeholders to translate analytical requirements into technical specifications. Develop reports and data visualizations using enterprise reporting tools.
Data Pipeline Development and API Integration: Design and implement modern data pipelines that integrate with various systems through APIs and web services. Develop Python-based solutions for data extraction, transformation, and automation tasks.
Project Execution and Continuous Improvement: Execute approved work requests based on business priorities. Stay current with emerging technologies and methodologies in data warehousing and data engineering.
Minimum Education And Qualifications
- Bachelor’s degree in computer science, Computer Applications, Engineering, Business, or a related field
- Five years of proven experience in data warehousing, ETL development, and database management for a large organization
- Demonstrated expertise with ETL tools (e.g., Informatica) and business intelligence platforms such as Snowflake, Power BI, and Cognos
- Proficiency in SQL and cloud-based data warehouse technologies
- Hands-on experience with the Snowflake data platform, including architecture design, administration, and performance optimization
- Experience using Python for data integration, automation, or related data engineering tasks
- Knowledge of API development and system integration
- Strong written and verbal communication skills
- Demonstrated analytical and critical thinking abilities
- Proven ability to work collaboratively, with strong self-awareness and interpersonal skills
- Obtains and maintains at least one or more applicable gaming licenses in multiple jurisdictions
Competencies
- Advanced proficiency in SQL and relational database management systems
- Advanced expertise in Snowflake data platforms, including SnowSQL, Snowpipe, Streams, Tasks, and data sharing
- Strong competency in API development, system integration, and web services
- Working knowledge of governance and service management frameworks, including COBIT and ITIL
- Strong understanding of the software development lifecycle (SDLC) and data engineering best practices
- Proficiency in data modeling concepts and data architecture methodologies
Training Requirements
- Mohegan corporate and department policies and procedures
- Appropriate regulations that pertain to Mohegan information systems
- Purchase request review and approval with enterprise supply-chain management application
- Review and analysis of department timesheet information
- Mohegan budget planning and analysis process and procedures