Key Responsibilities
ETL Pipeline Development
- Design, develop, and maintain scalable ETL/ELT pipelines using modern data engineering practices
- Ensure efficient data ingestion, transformation, and loading across systems
- Optimize data workflows for performance, scalability, and reliability
SQL Development & Optimization
- Write complex SQL queries using Basic and Advanced SQL concepts
- Develop and optimize stored procedures using PL/SQL and T-SQL
- Ensure efficient query performance and database optimization
Data Warehousing & Architecture
- Design and implement data warehousing solutions aligned with business needs
- Work with modern data platform fundamentals including Databricks
- Ensure structured and optimized storage of large-scale datasets
Data Modeling & Design
- Apply data modeling fundamentals to design logical and physical data models
- Ensure models support analytics, reporting, and downstream data usage
- Optimize data structures for performance and scalability
Programming & Data Processing
- Develop data processing solutions using Python
- Support automation and transformation tasks in data pipelines
- Work with structured and semi-structured data formats
Stored Procedures & Database Engineering
- Develop and maintain stored procedures for data processing and transformation
- Work with relational databases and ensure data integrity
- Support database performance tuning and optimization
Collaboration & Delivery
- Work closely with data architects, analysts, and business stakeholders
- Translate business requirements into technical data solutions
- Participate in Agile development processes and delivery cycles