3Cloud is hiring a
Lead Data Engineer in Philippines

Summary

The job is for a senior consultant position in the Data and Analytics Practice at 3Cloud focusing on Azure Synapse. The role involves creating and optimizing star schema models, working with Table Distribution and Index types, and using PolicyBase and Azure Data Factory to help ingest data. Requirements include a Bachelor’s Degree in Computer Science or related field, at least 5 years of experience with database design, at least 2 years with Azure technologies, and previous Consulting experience.

Requirements

• Bachelor’s Degree desired in Computer Science, Information Technology, or related field
• Minimum of 5 years of experience with database design
• At least 2 years with Azure technologies
• Previous Consulting experience

Responsibilities

• Understand Azure Synapse Analytics architecture
• Be able to identify performance bottlenecks
• Monitor Azure Synapse Analytics using Dynamic Management Views
• Build performing data with Table Distribution and Index types
• Partition tables using partitioning strategy
• Creating and optimizing star schema models in a Dedicated SQL Pool
• Configure and manage workload classification and resource classes
• Build ingestion pipelines with PolyBase and ADF to load and export data (best practices)

Preferred Qualifications

• Advanced knowledge of SQL, including ability to write stored procedures, triggers, analytic functions, and tuning
• Knowledge of relational and dimensional database structures, theories, principles, and practice
• Predictive, Prescription, and Descriptive Analytics using Data Science tools and technologies including Azure ML Studio/Services, R programming language
• Other Azure development expertise including Azure Databricks, Python, Scala, R
• Other Azure technologies including storage (DataLake, DeltaLake, Blob Storage)

Benefits

• Full-time employment
• Remote in Philippines