About the role
π Porto
π’ Hybrid | 2 days/week on-site
π― 6+ years of experience
π About the Role
We are looking for an experienced Senior Data Engineer to join a team responsible for the development, evolution, and reliability of an enterprise Data Warehouse.
You will play a key role in designing and optimizing ETL/data integration processes, developing complex PL/SQL solutions, and ensuring that data remains accurate, consistent, secure, and readily available for business use.
This is a hands-on position for someone with strong expertise in Informatica PowerCenter, Oracle/PL/SQL, Data Modeling, and Data Warehousing, who is comfortable combining new development with the optimization and support of existing data pipelines.
π― Your Mission
As a Senior Data Engineer, you will:
- Design and develop robust ETL and data integration solutions.
- Build and optimize complex PL/SQL components.
- Contribute to the evolution of the enterprise Data Warehouse.
- Ensure data quality, reliability, integrity, and performance.
- Maintain and optimize existing data pipelines.
- Investigate and resolve complex data and ETL issues.
- Collaborate with business and technical teams to transform data requirements into effective solutions.
- Share technical knowledge and support less experienced team members.
πΌ Key Responsibilities
ETL & Data Integration
- Design, develop, test, and deploy ETL workflows using Informatica PowerCenter.
- Develop scalable extraction, transformation, and loading processes.
- Maintain and enhance existing data integration workflows.
- Integrate data from multiple source systems into the Data Warehouse.
- Optimize ETL execution times and resource consumption.
- Implement appropriate data validation, error handling, and recovery mechanisms.
- Troubleshoot failed workflows and data-processing issues.
Oracle & PL/SQL Development
- Design and develop complex PL/SQL components, including:
- Stored Procedures
- Functions
- Packages
- Queries
- Optimize SQL and PL/SQL performance.
- Analyze execution bottlenecks and propose improvements.
- Support large-volume data processing requirements.
- Ensure database developments remain maintainable, efficient, and aligned with engineering standards.
Data Warehouse & Data Modeling
- Contribute to the design and continuous evolution of the Data Warehouse.
- Develop and maintain relational and dimensional data models.
- Ensure consistency between source systems, transformations, and analytical structures.
- Support the implementation of facts, dimensions, relationships, and business rules.
- Translate business requirements into appropriate data structures.
- Ensure data models remain scalable and maintainable as requirements evolve.
Data Quality & Governance
- Implement controls that ensure:
- Data Completeness
- Data Accuracy
- Data Consistency
- Data Integrity
- Investigate data-quality issues and identify root causes.
- Contribute to data governance standards and practices.
- Ensure appropriate security and access requirements are respected.
- Improve traceability and documentation across data processes.
Maintenance & Production Support
- Monitor and maintain existing ETL pipelines.
- Investigate incidents affecting data processing and availability.
- Troubleshoot issues across ETL, database, and data layers.
- Perform root cause analysis and implement sustainable corrections.
- Support production stability and reliable data delivery.
- Identify technical debt and optimization opportunities.
Business & Technical Collaboration
- Work closely with business stakeholders to understand data requirements.
- Translate functional requirements into effective technical solutions.
- Collaborate with Developers, Data Engineers, Analysts, and database teams.
- Explain data-related topics clearly to different stakeholders.
- Support requirement clarification and technical decision-making.
Power BI & Reporting
- Support the availability and structure of data consumed through Power BI.
- Contribute to dashboards and reports when required.
- Ensure reporting solutions have access to reliable and appropriately modelled datasets.
- Collaborate with BI teams on data requirements and performance issues.
Power BI knowledge is valuable for this role but is not a mandatory requirement.
Technical Leadership & Knowledge Sharing
- Act as a senior technical contributor within the Data Engineering team.
- Participate in technical reviews and solution-design discussions.
- Promote ETL, SQL, and data modelling best practices.
- Share knowledge with colleagues.
- Mentor junior team members when required.
- Contribute to the continuous improvement of development and support practices.
β What We're Looking For
Mandatory Requirements
- 6+ years of professional experience as a:
- Data Engineer
- ETL Developer
- Data Integration Developer
- Similar data-focused role
- Strong hands-on expertise with an enterprise ETL tool.
- Informatica PowerCenter experience is highly valued.
- Excellent PL/SQL development skills.
- Strong experience with Oracle Database is highly recommended.
- Solid knowledge of:
- Data Warehousing
- Relational Data Modeling
- Dimensional Data Modeling
- Experience developing and optimizing complex ETL processes.
- Strong SQL and database performance skills.
- Experience troubleshooting data pipelines and production issues.
- Strong analytical and problem-solving capabilities.
- French C2, mandatory.
- Ability to work autonomously and collaboratively within a team.
π Technical Stack
ETL & Data Integration
- Informatica PowerCenter
- ETL / ELT
- Data Integration
- Data Transformation
- Data Pipelines
Alternative ETL experience can include:
- Talend
- Oracle Data Integrator (ODI)
Databases
- Oracle
- PL/SQL
- SQL
- Stored Procedures
- Functions
- Packages
- Query Optimization
Data Engineering
- Data Warehouse
- Relational Modeling
- Dimensional Modeling
- Data Quality
- Data Governance
- Data Integration
BI
- Power BI
- Reporting
- Dashboards
- Analytical Data Models
β Nice to Have
- Power BI experience.
- Experience with Talend or ODI.
- Strong Oracle performance-tuning knowledge.
- Experience mentoring junior Data Engineers or ETL Developers.
- Knowledge of modern Data Engineering practices.
- Experience improving or modernizing legacy ETL ecosystems.
- Professional proficiency in English.
π Language Requirements
- π«π· French: C2, mandatory
- π¬π§ English: Nice to have
Given the C2 requirement, candidates should be comfortable discussing complex functional and technical topics and collaborating professionally in French.
π€ Soft Skills
Analytical Thinking
- Strong ability to investigate complex data issues.
- Structured approach to root cause analysis.
- Ability to understand dependencies across data flows and systems.
Autonomy & Ownership
- Comfortable taking responsibility for complex ETL developments.
- Ability to independently investigate and resolve production issues.
- Proactive approach to technical improvements.
Rigor & Organization
- Strong attention to data accuracy and quality.
- Structured and methodical working approach.
- Ability to manage priorities and delivery commitments.
Communication & Collaboration
- Ability to communicate effectively with technical and business stakeholders.
- Collaborative and team-oriented attitude.
- Comfortable explaining technical data concepts clearly.
Continuous Improvement
- Proactive identification of performance and process improvements.
- Strong commitment to maintainable and high-quality data solutions.
- Willingness to share technical knowledge with the wider team.
π Why Join Us?
- Take a key role in the evolution of an enterprise Data Warehouse.
- Work extensively with PowerCenter, Oracle, PL/SQL, and Data Modeling.
- Solve complex ETL and data-performance challenges.
- Combine new development with optimization and production support.
- Influence data quality, governance, and development practices.
- Share your expertise and support the technical growth of the team.
- Work in a flexible hybrid model in Porto.