Mô Tả Công Việc
Sales Operations organization at Renesas Electronics is seeking an experienced technology professional for the position of Sales Ops Data Engineer to architect, develop, test, deploy, and administrator scalable sales operations data management platforms, reports and analytics using a variety of technologies.
Responsibilities:
- End-to-end development of high performance and scalable data management platforms to support various sales operations processes starting with requirements gathering from business and operations partners using Agile development methodology.
- Document the developed data management platforms’ designs, configurations, training, and troubleshooting steps.
- Stay up to date with Azure SQL DB, Power Automate, and Power BI advancements, new features, and best practices, and provide recommendations for adopting them to improve the Sales Operations team’s data management platforms performance and functionality.
- Design, develop, deploy, and maintain high performance and scalable SQL databases to support the data management platforms and analytics that address the complex business challenges.
- Write complex SQL queries, stored procedures, functions, and triggers.
- Develop data models, schemas, and indexing strategies to ensure optimal storage and retrieval of data.
- Implement and optimize data migration processes from on-premises databases to Azure SQL DB.
- Configure and fine-tune Azure SQL DB settings, including partitioning, indexing, and query optimization, to maximize performance and cost-efficiency.
- Implement data security measures and access controls to protect sensitive data stored in Azure SQL DB.
- Integrate Azure SQL DB with Excel-VBA and Power BI, ensuring seamless data flow and efficient data access.
- Perform database monitoring, troubleshooting, and performance tuning to identify and resolve performance bottlenecks and optimize query execution.
- Automate data flow between various business data sources using Power Automate technology.
- Design, develop, and deploy advanced Excel/VBA-based tools to support business requirements.
- Model, develop and deploy advanced Data Analytics, Visualizations, and Dashboards using Power BI.
- Design and develop business applications using Power Apps technology.
- Work with the sales operations partners to improves the existing processes.
- Lead data analysis to solve complex data issues, and support adhoc requests.
Yêu Cầu Công Việc
- Bachelor's degree in Computer Science (or +5 years relevant work experience).
- In-depth knowledge and hands-on experience with Azure SQL Database, including experience with Azure SQL Database administration.
- Proficiency in designing and developing scalable database solutions, including data modeling, partitioning, and indexing.
- Strong understanding of relational database concepts, SQL query optimization, and database performance tuning.
- Experience with data migration and synchronization between on-premises databases and Azure SQL DB.
- Solid understanding of database security principles and experience implementing data access controls and encryption in Azure SQL DB.
- Excellent problem-solving and analytical skills, with the ability to troubleshoot and resolve complex database-related issues as well as analytical challenges.
- Good communication and collaboration skills, with the ability to work effectively in a team-oriented environment.
- In-depth knowledge of Excel macros (VBA).
- Knowledge of Microsoft Power Platform applications: Power Automate, Power BI, and Power Apps.
- Ability to multitask in a fast-paced environment.
- Proficiency in English
Stand out from the crowd:
- Experience of working in Sales Operations organization.
- Experience of working in Semiconductor industry.
Hình thức
Quyền Lợi
Renesas Design Vietnam Company Limited aims to provide our employees with comprehensive compensation and benefit plans, and a professional working environment. Some featured benefits are: - Competitive salary/bonus based on working performance. - Excellent training program. - Opportunity for promotion. - Fair assessment. - 24/24 hour insurance package including social and medical and unemployed insurance - Dynamic people. - Team-oriented environment. - Sport activities and Annual company trip