BI Analyst BI數據分析

Job updated 약 1개월 ago

Job Description

Responsibilities

● Set up and execute extract, transformation and load (ETL) functions to build a data pipeline.
● Extraction and analysis of large data sets from MySQL
● Performance tuning for current and newly added queries to the databases, ensuring the database resources are fully utilized- Delivering clear analysis and reporting of core business metrics to shareholders
● Creation and management of reports and dashboards- Data management
● Enhance and optimize existing reporting processes
● Ad hoc analysis and reporting to clients and shareholders
● Aid in reconfiguring existing architecture and database structure to address our shareholder’s evolving needs
● Daily maintenance and monitoring of all BI related databases and dashboards, including proficient handling of emergencies
● Providing actionable insight to drive growth of core products


Our Stack 
● MySQL
● Python
● AirFlow
● AWS
● Metabase
● Redshift
● Linux

Requirements

Requirements 
● 2+ years experience in a similar data-driven role
● Excellent working knowledge of SQL
● Familiarity with Python and a range of BI and data visualization tools ie PowerBI
● Familiarity with ETL data pipeline
● Understanding of principles of relational databases and data warehouse
● Strong understanding of sports and gaming will be beneficial
● Proactive and self-driven with excellent analytical skills
● Ability to thrive in a fast paced and dynamic environment
● Great communication skills

Interview process

1. Online test: 90 mins
2. Online interview: 130 mins
3. Interview result within 24 hr

2
2 years of experience required
910,000 ~ 1,800,000 TWD / year
Optional Remote Work
Personal Invitation Link
This is your personal referral link for job invitation. You'll receive an email notification when someone applied for the position via your job link.
Share this job
People who applied for this job also applied for
Logo of the organization.
Full-time
Mid-Senior level
2
800K ~ 1.5M TWD / year
Logo of the organization.
Full-time
Mid-Senior level
1
Regular earnings reach NT$40,000
Logo of the organization.
Full-time
Entry level
1
40K ~ 55K TWD / month
Logo of the organization.
Full-time
Entry level
1
40K ~ 65K TWD / month
Logo of OpenNet 開網有限公司.

About us

OpenNet is one of the best companies to work for in Taiwan; we offer a dynamic and rewarding environment for high-achievers looking to work and learn alongside like-minded individuals. We are currently in a period of rapid growth as we expand to make our technology available in over 20 countries.

We believe our employees are the company’s most valuable asset and are invested in seeing our employees grow in their careers and strike a work-life balance. We do our best to attract top talent and create a great workplace where people feel engaged, inspired, challenged, and respected.

If you are forward-thinking, passionate about technology, enjoy a fast-paced work environment and are looking for a rewarding career, then we want you on the team.

What you can expect from working at OpenNet?
1. Interesting and engaging work
2. Incredibly talented co-workers
3. Collaborative and flexible workplace
4. World-class benefits package



Jobs

Full-time
Mid-Senior level
1
860K ~ 1.8M TWD / year
Save

Full-time
Mid-Senior level
3
900K ~ 2.2M TWD / year
Save

Full-time
Mid-Senior level
2
899K ~ 1.8M TWD / year
Save