Senior Data Engineer

Looking for an experienced Senior Data Engineer to join the Prosigliere team.

Description

We are seeking a highly skilled and motivated Data Engineer to join our growing team. The ideal candidate will be instrumental in designing, building, and maintaining robust and scalable data pipelines and infrastructure. This role requires a deep understanding of data warehousing principles, ETL processes, and database management, with a strong focus on ensuring data quality, accessibility, and performance to support our analytical and reporting needs. You will play a critical role in transforming raw data into actionable insights, empowering our data-driven decision-making across the organization.

Responsibilities

• Design, develop, and maintain scalable and efficient ETL / ELT pipelines using various data integration techniques to ingest, transform, and load data from diverse sources into our data warehouse.
• Manage and optimize data models and structures within Snowflake, ensuring strategic organization for performance, cost-efficiency, and ease of consumption by analytics and reporting tools.
• Administer and optimize PostgreSQL databases, including schema design, query optimization, and performance tuning.
• Develop, monitor, and troubleshoot data workflows and orchestrations using Apache Airflow to ensure timely and reliable data delivery.
• Collaborate closely with data analysts, data scientists, and business stakeholders to understand data requirements and translate them into technical solutions.
• Ensure data quality, accuracy, and consistency by implementing robust data validation, cleansing, and monitoring processes.
• Troubleshoot, debug, and optimize existing Tableau reports, and develop new, insightful dashboards and visualizations to meet business needs.
• Implement and maintain data governance best practices, including data security, privacy, and compliance.
• Participate in code reviews, contribute to architectural discussions, and promote best practices in data engineering.
• Continuously evaluate and recommend new technologies and methodologies to improve our data platform and processes.

Technology Requirements

Profile Requirements