Credera
Senior Engineer, Data
Job Description
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).