Lead Data Engineer

SymphonyAI is a global leader in AI-driven enterprise applications, transforming industries with cutting-edge artificial intelligence and machine learning solutions. We empower organizations across retail, CPG, financial services, manufacturing, media, enterprise IT and the public sector by delivering data-driven insights that drive business value. Headquartered in Palo Alto, California, SymphonyAI has a wide range of products and a strong global presence, with operations in North America, Southeast Asia, the Middle East, and India. The company is dedicated to fostering a high-performance culture and maintaining its position as one of the largest and fastest-growing AI portfolios in the industry.

About the Role

Data Warehouse Engineer

Key Responsibilities

• Data Ingestion & Orchestration

• 10-15years of experience in designing and building scalable ingestion pipelines using

  Azure Data Factory

  .
• Integrate data from multiple sources (SQL Server, relational databases, Azure SQL DB, Cosmos DB, Table Storage).
• Manage batch and real-time ingestion into

  Azure Data Lake Storage

  .

• Data Storage & Modelling

• Develop and optimize data warehouse solutions in

  Azure Synapse Analytics

  .
• Implement robust

  ETL/ELT processes

  to ensure data quality and consistency.
• Create

  data models

  for analytical and reporting needs.

• Data Analysis & Security

• Build semantic data models using

  Azure Analysis Services

  for enterprise reporting.
• Collaborate with BI teams to deliver well-structured datasets for reporting in

  Power BI

  .
• Implement

  Azure Active Directory

  for authentication, access control, and security best practices.

• Visualization & Business Support

• Support business teams in building insightful

  Power BI dashboards and reports

  .
• Translate business requirements into scalable and optimized BI solutions.
• Provide data-driven insights in a clear, business-friendly manner.

• Optimization & Governance

• Monitor system performance and optimize pipelines for efficiency and cost control.
• Establish standards for

  data governance, data quality, and metadata management

  .

Qualifications & Skills

• Bachelors or Masters degree

  in Computer Science, Data Engineering, Information Systems, or related field.
• Proven experience as a

  Data Warehouse Engineer / Data Engineer

  with strong expertise in:

• Azure Synapse Analytics

• Azure Data Factory

• Azure Data Lake Storage

• Azure Analysis Services

• Azure SQL Database / SQL Server

• Power BI (reporting & dashboarding)

• Strong proficiency in

  SQL

  and

  data modelling

  (star schema, snowflake schema, dimensional modelling).
• Knowledge of

  Azure Active Directory

  for authentication & role-based access control.
• Excellent

  problem-solving skills

  and ability to optimize large-scale data solutions.
• Strong

  communication skills

  to collaborate effectively with both technical and business stakeholders.