Department
IT – Shared Services Unit
Division
Information Technology
Job Description
Job Purpose
Responsible for designing, developing and maintaining Business Intelligence (BI) solutions, crafting and executing queries upon request for data, presenting information through reports and visualization, supporting data warehouse/data lake performance by planning and delivering data integrations. He/She needs to understand business requirements, develops Extract, Transform and Load (ETL) solutions to extract insightful information for making business decision or assisting business operations, develops reports/visualization, provides support for data platform and assists the team to enhance data management solutions.
Key Responsibilities
Daily Operations
- Enhances enterprise information management team accomplishments and competence by planning delivery of solutions; answering technical and procedural questions for less experienced team members; teaching improved processes; mentoring team members.
- Studies data sources by interviewing users; defining, analyzing, and validating data objects; identifying the relationship among data objects; Translates business needs to technical specifications.
- Plans data integration process by developing common definitions of sourced data; designing common keys in physical data structure; establishing data integration specifications; examining data applications; examining data models and data warehouse/data lake schema; determining best-fit data interchange methods; assessing middleware tools for data integration, transformation, and routing; developing project scope and specifications; identifying factors that negatively impact integration; forecasting resource requirements; establishing delivery timetables.
- Delivers data integration by implementing shared databases; integrating data shared across legacy, new development, and purchased package environments; developing system modification specifications; mapping data; establishing interfaces; developing and modifying functions, programs, routines, and stored procedures to export, transform, cleanse and load data; meeting performance parameters; resolving and escalating integration issues; coordinating actions among users, operations staff, and outside vendors; recommending adjustments as objectives change; documenting operational procedures and data connections.
- Validates data integration by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
- Maintains data warehouse/data lake performance by identifying and resolving data conflicts; upgrading data definitions;
- Improves data management solution by designing and evaluating new technologies; improving physical design; rewriting data policy, standards, and procedures;
- Maintains team accomplishments by communicating essential information; coordinating actions; obtaining expert input; reviewing open issues and action items; contributing information to team meetings and reports; transferring knowledge of data integration process, techniques, and issues to application and support teams.
- Designs and develops BI solution including reports, dashboard and data visualization front end for business users.
- Composes and updates technical documents.
- Updates job knowledge by tracking ETL and BI strategies and technologies; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
- Accomplishes organization goals by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.
- Ability to work under tight timeframes.
- Ability to work effectively both independently and as part of a team.
Competencies and Requirements:
Experience: Minimum 3+ years working in an IT related position.
Education: Diploma or degree in Information Technology field
Language Ability: Multilingual English/Mandarin/Cantonese preferred.
Auto req ID
3145BR
Position Title
Supervisor – Enterprise Information Management
Property / Business Unit
Wynn Palace
Read Full Description