Senior Data Engineer Offline
This is an exciting opportunity to work on a high-impact project, architecting an end-to-end data solution in a collaborative and forward-thinking environment. The ideal candidate will be at the forefront of delivering scalable, efficient, and best-in-class Data engineering solutions supporting business-critical insights and reporting capabilities.
We are seeking a Senior Data Engineer to lead the design and implementation of robust data pipelines and warehouse solutions leveraging Snowflake, AWS and Azure. This role will focus on ingesting and transforming data from marketing and sales systems, enabling advanced analytics and reporting capabilities. The candidate will play a key advisory role in defining and implementing best practices for data ingestion, transformation, and reporting.
Our client is a global real estate services company specializing in the management and development of commercial properties. Over the past several years, the organization has made significant strides in systematizing and standardizing its reporting infrastructure and capabilities. Due to the increased demand for reporting, the organization is seeking a dedicated team to expand capacity and free up existing resources.
Skills & Experience
- 5+ years of experience in data architecture, data engineering, or related roles.
- Deep knowledge of Python
- Ability to work independently, gather requirements and deliver results in a fast-paced environment.
- Proven expertise in designing and implementing data pipelines on AWS / Azure.
- Deep knowledge of data warehouse architectures, including Snowflake architecture and data governance.
- Good to know: Workato (or similar integration tools) and Power BI for dashboards and reporting.
- Experience in data validation, cleansing, and optimization techniques.
- Exceptional communication and stakeholder management skills
Responsibilities
- Design and implement scalable data pipelines on AWS / Azure to ingest and transform data from different sources
- Integrate SFDC data using tools like Workato (or propose alternative solutions).
- Provide advisory services on Snowflake architecture and implement best practices for ingestion, validation, cleansing, and transformation.
- Develop the initial set of data products (analytics, dashboards, and reporting) in Power BI.
- Ensure scalability, efficiency, and performance of the data infrastructure.
Interview process:
1. HR interview (30 min)
2. Technical interview (1 hour)
3. PM interview (30 min)
4. Interview with Head of Real Estate Solutions (30 min)
5. Client interview (30 min)
6. Offer