21 Aug
|
EXL Talent Acquisition Team
|
Gurugram
21 Aug
EXL Talent Acquisition Team
Gurugram
- Seeking a skilled Data Engineer / Analytics Developer with expertise in DBT, Snowflake, Python, and SAS to design, develop, and maintain scalable data solutions.
- Candidate should have robust experience in data warehousing, ETL/ELT development, data transformation, analytics, and performance optimization.
- This role involves working closely with business stakeholders, data analysts, and engineering teams to deliver high-quality data products that support reporting, analytics, and decision-making.
- The person will work with different stakeholders as SME for analytics development
- Design, develop, and maintain robust data pipelines using DBT, Python, and Snowflake.
- Build and optimize data models, transformations, and data marts within Snowflake.
- Develop, test, and deploy DBT models, macros, snapshots, and documentation.
- Migrate and modernize legacy SAS-based data processes into cloud-native solutions where applicable.
- Create and maintain ETL/ELT workflows to ingest, cleanse, transform, and validate data from multiple sources.
- Write efficient SQL queries and optimize Snowflake performance, storage, and compute utilization.
- Develop Python scripts and frameworks for automation, data processing, and orchestration.
- Perform data quality checks, reconciliation, and troubleshooting to ensure data accuracy and integrity.
- Collaborate with business users, analysts, and architects to gather requirements and translate them into technical solutions.
- Support reporting, analytics, and data science initiatives by providing reliable datasets.
- Participate in code reviews, testing, deployment, and documentation activities.
- Monitor and troubleshoot production data pipelines and resolve issues proactively.
- Follow data governance, security, and compliance standards.
- Bachelor's degree in Computer Science, Information Systems, Engineering, Statistics, or a related field.
- 4+ years of experience in data engineering, analytics engineering, or related roles.
- Strong hands-on experience with DBT.
- Proficiency in Snowflake data warehouse architecture, performance tuning, and administration concepts.
- Strong programming skills in Python for data processing and automation.
- Experience developing and maintaining solutions using SAS (Base SAS, SAS SQL, SAS Macros).
- Advanced SQL skills and experience with complex data transformations.
- Experience with ETL/ELT design and implementation.
- Knowledge of data warehousing concepts, dimensional modeling, and star/snowflake schemas.
- Familiarity with version control systems such as Git.
- Strong analytical, problem-solving, and debugging skills.
- Excellent communication and stakeholder management abilities.
- Outstanding written and verbal communication skills
- Able to work in fast pace continuously evolving environment and ready to take up uphill challenges
📌 DBT Developer (Gurugram)
🏢 EXL Talent Acquisition Team
📍 Gurugram