What will you do:
- Monitor & support various data loads for our Enterprise Data Warehouse.
- Support business users who are accessing POWER BI dashboards & Datawarehouse tables. Handle incidents, service requests within defined SLA’s.
- Work with team on managing Azure resources including but not limited to Databricks, Azure Data Factory pipelines, ADLS etc.
- Build new ETL/ELT pipelines using Azure Data Products like Azure Data Factory, Databricks etc.
- Help build best practices & processes.
- Coordinate with upstream/downstream teams to resolve data issues.
- Work with the QA team and Dev team to ensure appropriate automated regressions are added to detect such issues in future.
- Work with the Dev team to improve automated error handling so manual interventions can be reduced.
- Analyze process and pattern so other similar unreported issues can be resolved in one go.
What you will need:
Strong IT professional with 3-4 years of experience in Data Engineering. The candidate should have strong analytical and problem-solving skills.
Must have:
- 3-4 years of experience in Data warehouse design & development and ETL using Azure Data Factory (ADF)
- Experience in writing complex TSQL procedures on MPP platforms - Synapse, Snowflake etc.
- Experience in analyzing complex code to troubleshoot failure and where applicable recommend best practices around error handling, performance tuning etc.
- Ability to work independently, as well as part of a team and experience working with fast-paced operations/dev teams.
- Good understanding of business process and analyzing underlying data Understanding of dimensional and relational modelling
- Detailed oriented, with the ability to plan, prioritize, and meet deadlines in a fast-paced environment. Can be added to SDE
- Knowledge of Azure cloud technologies
- Exceptional problem-solving skills
Nice to have:
- Experience crafting, building, and deploying applications in a DevOps environment utilizing CI/CD tools
- Understanding of dimensional and relational modeling
- Relevant certifications
- Basic knowledge of Power BI.
Who are you:
- Bachelor’s degree or foreign equivalent degree in Computer Science or a related field required
- Excellent communication skills.
- Able to work independently or within a team proactively in a fast-paced AGILE-SCRUM environment.
- Owns success – Takes responsibility for the successful delivery of the solutions.
- Strong desire to improve upon their skills in tools and technologies