Data Engineer (snowflake)

Data Engineer (Snowflake)

CBRE Business Services Organisation (CBRE BSO) is a part of CBRE Group, Inc., a Fortune 500 and S&P 500 company headquartered in Dallas, is the world's largest commercial real estate services and investment firm. The company has more than 130,000 employees serving clients in more than 100 countries. CBRE serves a diverse range of clients with an integrated suite of services.

About the role:

The Real Estate market is undergoing a significant and exciting change – driven by data and technology. The skillful use of data and insights play a vital role in CBRE's mission to create unmatched value for our clients. Our Enterprise Data Platform brings Master Data Management and Data Governance concepts, built on a modern tech platform, to transform CBRE into a fully data-enabled organization. Along the way, we are liberating data from silos across the region and building core platform functionality to provide disruptive innovation.

What You'll Do:

• Interpret and analyse data from various source systems to support data integration and data reporting needs within CBRE.
• Work with team leads to prioritize business and information needs
• Prepare detailed ETL/ELT mapping specifications
• Develop ETL/ELT pipelines
• Develop complex code data scripts (SQL and Python) for ETL
• Troubleshoot & determine best resolution for data issues and anomalies
• Assist in development of software technical documentation
• Design, specify, implement, and maintain systems using Kanban/Scrum methodologies.

What You'll Need:

• 3+ years experience in Data Platform / Warehouse / Lake engineering: source integration, pipeline development and analytics professional work experience in analytical/data roles
• Significant recent experience with Python especially in scripting and data processing using packages such as pandas
• Excellent SQL skills, ideally Postgres and SQL Server (T-SQL)
• Familiarity with common AWS services (S3, EC2, Glue)
• Experience with iPaaS applications such as SnapLogic (ideal), Jitterbit, Mulesoft, Informatica etc
• Basic knowledge of BASH scripting and Azure DevOps platform (Boards, Pipelines, Repos)
• Hands-on experience with Snowflake, especially stages, integrations, formats, procedures, role-based management
• Good Understanding of Concepts like Scaling, Cloning, Search Optimization, Clustering
• Knowledge of Indexing strategies and query tuning for performance (e.g. Explain Plans).
• Strong analytical skills with the ability to collect, organize, analyse, and disseminate significant amounts of information with attention to detail and accuracy
• Ability to clearly communicate capabilities, opportunities, and recommendations to both technical and nontechnical audiences
• Deep understanding of data architecture & data modelling best practices and guidelines for different data and analytic platforms

Why CBRE

When you join CBRE, you become part of the global leader in commercial real estate services and investment that helps businesses and people thrive. We are dynamic problem solvers and forward-thinking professionals who create significant impact. Our collaborative culture is built on our shared values — respect, integrity, service and excellence — and we value the diverse perspectives, backgrounds and skillsets of our people. At CBRE, you have the opportunity to chart your own course and realize your potential. We welcome all applicants.