Job description

Python Data Engineer

Job Title: Data EngineerJob Summary:We are looking for a proficient Data Engineer with expertise in Amazon Redshift, Python, ApacheAirflow, dbt (Data Build Tool), API integration, and AWS.

This role will be responsible for developingand maintaining scalable data pipelines, integrating data from multiple sources, and ensuring thatour data architecture supports business intelligence, reporting, and analytics requirements.

You willcollaborate with cross-functional teams to build and optimize our data infrastructure and provideclean, high-quality data to the business.Key Responsibilities: Data Pipeline Development: Build and maintain robust ETL/ELT pipelines using Python, ApacheAirflow, and dbt to extract, transform, and load data from various sources into Amazon Redshift.

Amazon Redshift Management: Design, optimize, and maintain Amazon Redshift clusters,ensuring the warehouse is capable of handling large-scale data efficiently.

API Integration: Develop solutions to integrate external APIs for data ingestion, ensuring properdata extraction, transformation, and integration into our data infrastructure.

Data Modeling: Create and maintain scalable data models in Redshift that support analytics andreporting needs, including designing star and snowflake schemas for optimized querying.

AWS Infrastructure Management: Leverage AWS services such as S3, Lambda, EC2, andCloudWatch to build and maintain a scalable and cost-efficient data architecture.

dbt (Data Build Tool): Use dbt to manage and automate SQL transformations, ensuring modular,reusable, and well-documented data transformation logic.

Workflow Orchestration: Utilize Apache Airflow to orchestrate and automate data workflows,ensuring reliable data pipelines and scheduled jobs.

Data Quality & Testing: Implement and maintain data validation checks and testing frameworksto ensure data integrity, accuracy, and compliance across all data pipelines.

Collaboration: Work closely with data scientists, analysts, and product teams to understand dataneeds and provide technical solutions that meet business objectives.

Performance Optimization: Tune SQL queries and manage the performance of Redshift clustersto ensure fast, efficient data access and analysis.

Data Governance: Enforce data governance policies to ensure compliance with security, privacy,and data quality standards throughout the data lifecycle.Key Skills & Qualifications: Bachelors/Masters degree in Computer Science, Engineering, Data Science, or a related field.

3+ years of experience in data engineering with expertise in Amazon Redshift, Python, and AWS.

Strong experience with Apache Airflow for workflow scheduling and orchestration.

Hands-on experience with dbt (Data Build Tool) for managing SQL transformations and datamodels.

Proficiency in API development and integration, including the use of RESTful APIs for dataingestion.

Extensive experience with AWS services such as S3, Lambda, EC2, RDS, and CloudWatch.

Expertise in data modeling concepts and designing efficient data structures (e.g., star schemas,snowflake schemas) in a data warehouse environment.

Advanced knowledge of SQL for querying and optimizing large datasets in Redshift.

Experience building ETL/ELT pipelines and integrating data from multiple sources, includingstructured and unstructured data.

Familiarity with version control systems like Git and best practices for code management anddeployment automation.

Knowledge of data governance principles, including data security, privacy, and quality control.Preferred Qualifications: Experience with real-time data processing tools such as Kafka or Kinesis.

Familiarity with data visualization tools like Tableau, Looker, or Power BI.

Knowledge of other data warehousing solutions like Snowflake or Google BigQuery.

Experience with DevOps practices for managing infrastructure and CI/CD pipelines (Docker,Kubernetes).

Understanding of machine learning pipelines and how data engineering supports AI/ML initiatives.Soft Skills: Strong analytical and problem-solving skills.

Ability to work independently and as part of a cross-functional team.

Strong written and verbal communication skills, with the ability to explain technical concepts tonon-technical stakeholders.

Detail-oriented, proactive, and self-motivated with a focus on continuous improvement.

Strong organizational and project management skills to handle multiple tasks

Job Type

Payroll

Categories

Data Engineer (Software and Web Development)

Cloud Architects (Software and Web Development)

DevOps Engineers (Software and Web Development)

Database Administrator (Software and Web Development)

Software Engineer (Software and Web Development)

Must have Skills

• Python - 3 Years
• Amazon Redshift - 3 Years
• AWS - 3 Years
• Apache Airflow - 1 Years
• ETL(Extract, Transform, Load) - 1 Years
• Kubernetes - 1 Years

Required Skill Profession

Computer Occupations