Job Description
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.
• 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.
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.
Skills:
• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) are required.
• Have solid background in data warehouse design and/or data lake design.
• In-depth understanding of database management systems and ETL (Extract, transform, load) framework.
• Familiarity with BI technologies (e.g. Tableau or SAS Visual Analytics).
• Familiarity with R or Python programming is an advantage.
• Proven abilities to take initiative and be innovative.
• Willing to learn new technology.
• Basic understanding of Hotel and Gaming processes.
• Analytical mind with a problem-solving aptitude.
• Familiar with IT processes and procedures.
• Excellent verbal and written communication.