Senior Engineer, Data

Description

We're looking for someone with hands-on, business-oriented strategic and technical consulting to our clients for cloud infrastructure, automation solutions, and solution architecture.

In this role, you will:

• Evaluate business needs, and objectives and build algorithms and prototypes.
• Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports and reporting environments.
• Conduct complex data analysis and report on results, analyze and organize raw data.
• Identify opportunities for data acquisition by developing analytical tools and programs.
• Collaborate with data scientists and architects on several projects.
• Consolidate and optimize available data warehouse infrastructure.
• Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports and reporting environments.
• Assembles performance statistics, analyzes them, and makes recommendations for improvements.
• Establishes system documentation and ensures it is continually sustained.
• Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients.
• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
• Carry out monitoring, tuning, and database performance analysis.
• Design, automate, build, and launch scalable, efficient and reliable data pipelines into production.
• Perform root cause analysis and resolve production and data issues.

Requirements

Technical Skills you bring in:

• Experience and expertise with data models, data mining, and segmentation techniques
• Experience with SQL database design
• Experience with programming languages (e.g. Python)
• Experience in combining raw data from different sources and conducting complex data analysis
• Experience in building algorithms and prototypes and perform complex data analysis
• Experience in design and implement ETL procedures for intake of data from both internal and external sources, as well as ensure data is verified and quality is checked
• Experience in design and implement ETL processes and data architecture to ensure proper functioning of analytics, as well as client’s or third-party’s reporting environments and dashboard
• Carry out monitoring, tuning, and database performance analysis
• Minimum 1+ years of experience performing data warehouse architecture development and management
• Minimum 4 years experience with technologies such as SQL Server, SQL and stored procedures
• Minimum 1+ years experience developing code, testing for quality assurance, administering RDBMS, and monitoring databases
• High proficiency in dimensional modeling techniques and their applications
• Minimum 1 + years experience in custom ETL design, implementation and maintenance (ADF/Databricks/Synapse)
• Advanced SQL skills is a must

Requirements / Qualifications:

• Desirable: Bachelor or master's degree in Computer Science or related technical field
• Data engineering certification (preferable)
• Ideally Intermediate English Proficiency (B2 reading, writing, and conversation).