职位&公司对比

职位详情

• 上海
• 5-10年
• 本科

• 要求数据开发经验
• 数据仓库开发经验
• Spark
• Oracle
• MySQL/SQL Server
• Python
• SQL
• BI报表开发经验
• ETL开发经验
• 实时数仓开发经验
• 计算机相关专业
• 非外包类

Main Responsibilities 1. Analyze and Recommend: Evaluate existing data warehouse systems and suggest upgrades and improvements. 2. Development and Installation: Oversee the development and installation of data warehouse systems. 3. Testing and Troubleshooting: Perform tests, troubleshoot issues, and ensure quality assurance. 4. Safety and Data Recovery: Implement safety procedures and data recovery plans. 5. Documentation: Develop user manuals, policies, procedures, and safety protocols. 6. Collaboration: Work with other departments and professionals in data warehouse system development. 7. Maintenance and Upgrades: Ensure installations, maintenance, and upgrades are on schedule and meet client specifications. 8. Performance Monitoring: Monitor data warehouse system performance, identify and solve problems, and ensure optimal operation. 9. System Interfaces: Manage data warehouse system interfaces for stability and security. 10. Change Control: Handle data warehouse system change control processes, including assessing change requests, developing plans, testing, and releasing changes. 11. Data Analysis & Modeling: Develop predictive models (e.g., attendance forecasting, ride wait times, seasonal demand). Analyze guest behavior data (ticketing, app usage, spending patterns) to drive personalized marketing Optimize staffing, inventory, and ride maintenance schedules using statistical metbosshods. 12. Reporting & Visualization: -Create dynamic dashboards (Tableau/Power BI) for real-time KPIs: crowd density, revenue, customer satisfaction. Automate reports for stakeholders to monitor operational efficiency. 13. Database Management: Query and manage large datasets (SQL, Python/R) froBOSS直聘m POS systems, loT sensors, and CDP/CRM platforms. Ensure data integrity across platforms 14.Collaboration: Partner with IT vendors to integrate analytics tools into park apps and loT devices. Support A/B testing for digital campaigns and in-park promotions. Requirements 1. Education: Degree in computer science or IT; business administration courses or degree is advantageous. 2. Certification: Relevant certifications may be required. 3. Experience: -At least 3 years of progressive experience in hospitality or theme park industry. - At least 1 years of experience in Ticketing, PMS, Retail, F&B, and Supply Chain system maintenance/operation.4.Strong written and verbal communication skills.5. Excellent interpersonal and leadership skills. 6. Detail-oriented, able to maintain accurate system documentation, manage time productively, and keep records of activities. 7. Data Warehouse Skills: Familiar with data warehouse architecture and design principles. Proficient in来自BOSS直聘 SQL and database management systems (e.g., Oracle, SQL Server, MySQL). Knowledge of ETL (Extract, Transform, Load) processes and tools (e.g., Informatica, Talend). Capable of data modeling and data analysis. Knowledge of big data technologies (e.g., Hadoop, Sparkand loud data warhouse solutions(eg,Amazon Redshift,Google BigQuery). PostgreSQL: Proficient in managing and optimizing PostgreSQL datab直聘ases. Power Bl: Skilled in using Power BI for data visualization and reporting. Data Governance: Knowledge of data governance frameworks and best practices to ensure data quality and consistency. Data Security: Knowledge of data security and privacy protection, able to implement and maintain data security measures. Performabossnce Optimization: Capable of optimizing data warehouse performance, including index optimization, query optimization, and storage Automation: Skilled in using scripts and automation tools (e.g., Python, Shell scripts) for data warehouse management and maintenance.