数据与分析工程师
Data & Analytics Engineer
职责
• 设计和构建数据管道和ETL流程，可靠地在Hickory的系统间移动和转换数据
• 开发和维护支持可靠、结构良好的报告和分析的数据模型
• 在数据管道、报告层和临时分析中编写和优化SQL
• 构建和维护Power BI仪表板和报告，为利益相关者提供清晰、准确的业务表现视图
• 应用数据结构和算法思维，设计高效、可扩展的数据流程
• 将版本控制和CI/CD实践应用于数据管道和分析代码，确保更改经过测试并安全部署
• 应用AI工具和素养，加速数据工程、分析和报告工作
• 在相关情况下，参与数据仓库设计、数据库管理或解决方案架构
• 与业务中的利益相关者紧密合作，理解报告需求，并将其转化为可靠的数据解决方案
要求
• 3至5年相关经验
• 强大的SQL技能，能够熟练编写和优化跨大型数据集的复杂查询
• 熟悉数据建模，具备结构化数据以实现可靠和可维护报告的经验
• 有构建数据管道和ETL流程的实际经验
• 有构建数据可视化和仪表板的经验，最好是在Power BI中
• 对数据结构和算法有扎实的基础
• 有版本控制（如Git）和CI/CD流水线的实际经验
• 具备基本的AI素养——能够使用AI辅助工具支持数据工程和分析
• 接触过Azure、数据仓库、数据库管理或解决方案架构是加分项，不是必需条件
• 分析能力强，充满好奇心，注重细节，是优秀的解决问题者，沟通能力好，能够独立工作
加分项
- SQL
- 数据建模
- 数据管道/ETL
- 数据可视化
- Power BI
- 数据结构和算法
- AI素养
- 版本控制和CI/CD
- Azure
- 数据仓库
- 数据库管理
- 编程/脚本
- 解决方案架构
软技能
- 分析能力强，充满好奇心
- 优秀的解决问题者
- 良好的沟通者
- 注重细节
- 自我驱动，能够独立工作
最初发布于喜马拉雅斯
查看英文原文
Responsibilities
•Design and build data pipelines and ETL processes to move and transform data reliably across Hickory's systems
•Develop and maintain data models that support reliable, well-structured reporting and analytics
•Write and optimise SQL across data pipelines, reporting layers, and ad hoc analysis
•Build and maintain Power BI dashboards and reports that give stakeholders clear, accurate visibility into business performance
•Apply data structures and algorithms thinking to design efficient, scalable data processes
•Apply version control and CI/CD practices to data pipeline and analytics code, ensuring changes are tested and deployed safely
•Apply AI tools and literacy to accelerate data engineering, analysis, and reporting work
•Contribute to data warehouse design, database administration, or solution architecture where relevant
•Work closely with stakeholders across the business to understand reporting needs and translate them into reliable data solutions
Requirements
• 3 to 5 years relevant experience
•Strong SQL skills, comfortable writing and optimising complex queries across large datasets
•Solid experience with data modelling, structuring data for reliable and maintainable reporting
•Hands-on experience building data pipelines and ETL processes
•Experience building data visualisations and dashboards, ideally in Power BI
•Good grounding in data structures and algorithms
•Practical experience with version control (e.g. Git) and CI/CD pipelines
•Working AI literacy - comfortable using AI-assisted tools to support data engineering and analysis
•Exposure to Azure, data warehousing, database administration, or solution architecture is an advantage, not a requirement
•Analytical and curious, detail-oriented, a strong problem solver who communicates well and can work independently
Good to have
- SQL
- Data modelling
- Data pipelines / ETL
- Data visualisation
- Power BI
- Data structures and algorithms
- AI literacy
- Version control and CI/CD
- Azure
- Data warehouse
- Database administration
- Programming / scripting
- Solution architecture
Soft skills
- Analytical and curious
- Strong problem solver
- Good communicator
- Detail oriented
- Self starter who can work independently
Originally posted on Himalayas