%20scale(0.62)'%20d='M12%201.8C12.7%207.2%2016.8%2011.3%2022.2%2012%2016.8%2012.7%2012.7%2016.8%2012%2022.2%2011.3%2016.8%207.2%2012.7%201.8%2012%207.2%2011.3%2011.3%207.2%2012%201.8Z'/%3e%3c/svg%3e)
%20scale(0.62)'%20d='M12%201.8C12.7%207.2%2016.8%2011.3%2022.2%2012%2016.8%2012.7%2012.7%2016.8%2012%2022.2%2011.3%2016.8%207.2%2012.7%201.8%2012%207.2%2011.3%2011.3%207.2%2012%201.8Z'/%3e%3c/svg%3e)
Business Intelligence (BI) Engineer
互联网、AI·人工智能
BI engineers build data warehouses, develop reports and analytical models, transforming massive data into actionable business insights to support decision-making.
Daily work
- 01Design and maintain data warehouse models to ensure consistency and accuracy.
- 02Extract, clean, and transform data using SQL to meet analytical needs.
- 03Develop visual reports and dashboards using Tableau/Power BI.
- 04Communicate with business units to understand requirements and translate into data products.
- 05Write automation scripts to optimize data processing pipelines.
- 06Participate in data quality monitoring and anomaly troubleshooting.
Ability requirements
Hard skills
- Proficient in SQL and query optimization.
- Familiar with data warehouse modeling (e.g., star, snowflake schemas).
- Master ETL processes and tools (e.g., Informatica, Airflow).
- Skilled in BI tools (Tableau, Power BI, Looker).
- Programming ability in Python or R.
- Knowledge of statistics and basic machine learning algorithms.
Soft skills
- Analytical thinking and logical reasoning.
- Strong communication and collaboration skills for requirement understanding.
- Business acumen to uncover value behind data.
- Proactive learning and problem-solving.
- Project management and multitasking coordination.
Best suited for
Ideal for those who are data-sensitive, logically clear, enjoy uncovering business value through numbers, willing to collaborate with business teams, and patient with complex data.
Less suited for
Not suitable for those who dislike repetitive data work, lack patience, avoid business communication, or prefer working independently without collaboration.
Salary (monthly)
Pre-tax estimate, tier-1 cities with social insurance · reference only
Profile
MBTI Fit
Resume examples for this role
Disclaimer: Salary figures on this page are estimated pre-tax monthly pay for positions with social-insurance contributions in China's tier-1 cities; other cities are converted using regional coefficients. Dimension scores and MBTI fit are editorial estimates, provided for reference only, and do not constitute any promise or advice.