Data Engineer
pmicareers
Job Description
- Design, build and maintain scalable ETL/ELT pipelines using SQL, Python and tools such as Matillion, Airflow or dbt to ingest, transform and load data into enterprise data platforms.
- Develop and optimize data models, tables and transformation logic in Snowflake to support analytics, reporting and downstream data consumption use cases.
- Ensure efficient data ingestion and integration across multiple source systems by managing ingestion frameworks and enabling standardized data pipelines.
- Implement data quality, validation, monitoring and recovery mechanisms to ensure accuracy, consistency and reliability of data across pipelines and data products.
- Optimize query performance, data storage and processing efficiency through advanced SQL techniques, partitioning, indexing strategies and workload optimization.
- Collaborate with Data Analysts, IT and business stakeholders to understand requirements and translate them into scalable data solutions supporting BI, analytics and AI use cases.
- Define and enforce data governance policies including data security, access control, masking and lifecycle management within data platforms.
- Support development of data products and AI/ML pipelines by enabling curated, high-quality datasets and feature-ready data layers for advanced analytics and GenAI use cases.