
Senior Data Engineer | SQL Server & AWS
At Possumus, we are looking for a Senior Data Engineer to join an international insurance company undergoing the evolution of its data platform.
In this role, you will work closely with the Data Architect, maintaining and enhancing the current analytical environment based on SQL Server while actively contributing to the migration towards a modern cloud-based data architecture.
This is an excellent opportunity for someone who enjoys building scalable data solutions, improving existing platforms and participating in the modernization of enterprise data ecosystems.
What you will be doing
-Build and maintain data pipelines using SQL Server, SSIS, Python and Airflow.
-Develop and optimize ETL processes supporting analytical and reporting needs.
Migrate and refactor legacy SSIS packages into modern cloud-based solutions.
-Design and maintain dimensional data models (Facts, Dimensions and One Big Tables).
-Collaborate with the Data Science team on feature engineering for predictive models.
-Optimize SQL queries, data models and pipeline performance.
-Ensure data quality, testing, documentation and reliability across the platform.
-Work alongside the Data Architect to support the company's cloud migration strategy.
-Participate in the evolution of the data platform towards modern lakehouse technologies.
Soft skills we value
-Ownership and accountability.
-Curiosity and continuous learning mindset.
-Strong analytical and problem-solving skills.
-Attention to detail and data quality.
-Excellent communication and collaboration skills.
-Ability to adapt to evolving technologies and changing business priorities.
Minimum requirements
- 4+ years of experience as a Data Engineer.
- Strong experience with SQL Server and SSIS.
- Advanced SQL knowledge (CTEs, Window Functions, query optimization).
- Experience building and maintaining ETL pipelines.
- Solid Python skills (Pandas, scripting, APIs).
- Experience with Airflow or similar orchestration tools.
- Strong understanding of dimensional modeling and Data Warehousing concepts.
- Experience working with analytical data models and enterprise data platforms.
- English reading skills for technical documentation.
Nice to have
- AWS services (S3, Glue, Athena, Redshift).
- Databricks.
- Delta Lake, Apache Iceberg or similar lakehouse technologies.
- Spark / PySpark.
- DBT.
- Great Expectations or other data testing frameworks.
- Git and CI/CD practices.
- Experience supporting Machine Learning or churn prediction pipelines.
Location & Work Model
- 📍 Hybrid position
- Buenos Aires – Parque Patricios
- On-site attendance twice a week
Our Hiring Process:
-TA Interview
-Technical interview and English validation
-Psycho-occupational interview
-Job Offer
If you want to learn more about us, please click the following links:
-https://possumus.tech/
-https://possumus.tech/es-es/culture