Azure Data Engineering Consultant - Engineering - PH PDC
- Manila City, Metro Manila
- Permanent
- Full-time
- Providing high level design and technical solutions for Cloud Engineering team.
- Prioritize multiple tasks effectively and deliver data model design, analytics-focused data warehousing, and data integration/management leveraging cloud and other technologies to add advanced capabilities and improve application efficiency.
- Demonstrate a strong commitment to personal learning and development.
- Understand how our daily work contributes to the priorities of the team and business.
- Understand the set expectations and demonstrate accountability in keeping personal performance on track.
- Actively focus on developing effective communications and relationship-building skills with stakeholders, clients and team.
- Demonstrate an appreciation for working with others.
- Understand what is fundamental to Deloitte's success as a business.
- Demonstrate integrity and an awareness of strengths, differences, and personal impact.
- Develop their understanding of Deloitte and offer a fresh perspective.
- Bachelor's degree in Software Engineering, Information Technology, or equivalent
- At least 4 years working experience as a Data Engineer; adept experience in data engineering principles and how to apply advanced data manipulation processes to various types of data.
- Good understanding of key data warehousing fundamentals including modelling techniques like dimensional model creation. Knowledge of Data Vault model design would be advantages.
- The ability to develop complex data transformation routines using leading cloud data manipulation languages like Python or Scala.
- Knowledgeable in data engineering practices and ETL.
- Extensive knowledge on Data and Integration tools in Azure:
- Azure Data Factory (ADF)
- Azure Functions
- Skilled in SQL for query, triage, and remediation (Advanced)
- Knowledgeable in SQL Managed Instance (PaaS SQL service)
- Initial design and creation / installation
- Configure backups to meet RPO targets
- Patch servers
- Define version requirements
- Define database level maintenance plan standards (e.g., update statistics, reorganizing indices, compressing data) and performance tuning (clustered and non-clustered indexes, etc.)
- Adhere to application level specific maintenance standards
- Create and manage failover group in DR scenarios
- Design and configure access control, audit, applying security policies
- Monitor overall DB infra health (current running queries)
- Configure cross-server app data replication
- Skilled in Azure Functions to support encryption / decryption functions (Java based) (Advanced)
- Ability to support activities for planned DR events.
- Knowledgeable in CICD and change management.
- Good communication skills to be able to communicate to stakeholders clearly and effectively.
- Strong analytical and problem solving skills
- Azure Data Factory (ADF)
- Azure Functions
- SQL Server (Managed Instance)
- SQL, Python, Scala, Java, or any related programming language
- (Nice to Have) Databricks
- (Nice to Have) Infrastructure as code (Azure DevOps)
- Embrace the dynamic nature of our work environment with the opportunity to work on a hybrid set-up and a shifting schedule.
- Rewards platform - your hard work won't go unnoticed at Deloitte!
- Training and development - at Deloitte we believe in investing in our best assets, the people! You will have access to world class training and funding towards industry and other professional certifications.
- Receive support and mentoring to progress your career. You will have access to mentors and coaches who will help you pave a path for career progression.
- Benefits effective upon hiring including paid time off and holidays, health, and life insurance!