Data Engineer

Advance Career Solutions; Dadri, Greater Noida, Hyderabad; Hybrid; INR 1,200,000 - 2,400,000; Full time

Job summary

Advance Career Solutions is seeking a CBRE Database Engineer to design, develop and maintain data warehouse solutions across multiple platforms. You will implement ETL using SnapLogic/Informatica and utilize DBT for data workflows, while enabling dashboards in Tableau/Power BI.

The role requires strong SQL, Python skills, and experience with Snowflake. You will collaborate with developers, staff and users to deliver reliable data services and governance.

Qualifications

• Bachelor's degree required in CS/IT or related field.
• 5–6 years of experience with data platforms.
• Strong knowledge of data warehouse concepts, metadata frameworks, reference data, and dimensional data modeling.
• Proficiency in ETL processes and tools like SnapLogic or Informatica.
• Advanced Python programming skills.
• Experience with Snowflake, SQL Server, PostgreSQL.
• Experience with BI/reporting tools such as Tableau or Power BI.
• Understanding of data governance principles and best practices.

Responsibilities

• Design, develop, and maintain robust data warehouse solutions for BI and analytics.
• Design, implement, and manage metadata frameworks for data consistency and quality.
• Develop and maintain reference and dimensional data models for business processes.
• Design and implement ETL processes using tools like SnapLogic or Informatica to integrate data.
• Utilize Python for data manipulation, automation, and integration tasks.
• Optimize performance of data systems and processes.
• Implement transformations in DBT to streamline data workflows.
• Collaborate with cross-functional teams to develop and maintain dashboards and reports.
• Apply data governance practices to ensure data integrity, security, and compliance.

Skills

Python programming

ETL processes

Data governance

Problem solving

Communication

Education

Bachelor's degree in Computer Science or IT

Tools

Snowflake

DBT

SnapLogic

Informatica

Tableau

Power BI

Job description

Mandate Skills Strong Hands on Snowflake DBT

Good to have Knowledge Python working expereince and PowerBITableu

Description External

About the Role

As a CBRE Database Engineer you will work with developers DT staff and endusers to provide advanced technical support maintenance and logistical support to production and test systems

This job is part of the Database Engineering job function They are responsible for the upkeep of databases across several company platforms and computing environments

What Youll Do

• Design develop and maintain robust data warehouse solutions to support business intelligence and analytics needs
• Design implement and manage metadata frameworks to ensure data consistency and quality
• Develop and maintain reference data and dimensional data models to support various business processes
• Design and implement ETL Extract Transform Load processes using tools like SnapLogic or Informatica to integrate data from multiple sources
• Utilize Python for data manipulation automation and integration tasks
• Optimize the performance of data systems and processes
• Implement transformations in DBT Data Build Tool to streamline data workflows
• Collaborate with crossfunctional teams to develop and maintain reporting tools and dashboards
• Implement data governance practices to ensure data integrity security and compliance
• Stay updated with the latest advancements in Generative AI and explore opportunities to integrate AI solutions into data engineering processes

What Youll Need

• Bachelors degree in Computer Science Information Technology or a related field
• 5 to 6 years of experience in working with data platforms
• Strong knowledge of data warehouse concepts metadata frameworks reference data and dimensional data modeling
• Proficiency in ETL processes and tools like SnapLogic or Informatica
• Advanced skills in Python programming
• Experience with databases such as SQL Server PostgreSQL and Snowflake
• Advanced SQL knowledge
• Experience with reporting tools such as Tableau Power BI or similar
• Understanding of data governance principles and best practices
• Knowledge of Generative AI and its applications is a plus
• Experience with DBT Data Build Tool for data transformations
• Ability to optimize the performance of data systems and processes
• Excellent problemsolving skills and attention to detail
• Strong communication and collaboration skil