Company Overview
FrontWell Solutions is a leading consulting firm and system integrator specialising in manufacturing digitalisation for regulated industries. Founded in 2017, we offer a range of services including advisory, consulting, software selection, business process analysis, system integration, validation, and support operations. Our expertise primarily serves the life sciences, pharmaceutical, biotech, medical devices, and discrete manufacturing sectors, providing digital solutions to enhance production efficiency and compliance.
Position Overview
As a Data Engineer at FrontWell Solutions, you will play a crucial role in designing, implementing, and maintaining robust data solutions in alignment with the technical requirements defined by our System Analysts that drive operational excellence and support our clients' digital transformation initiatives. This position focuses on leveraging cutting-edge Azure tools and data engineering practices to ensure efficient data extraction, transformation, loading, and analysis. A key component of our approach will be the Data Mesh concept, which will guide our development efforts. You will act as a key technical resource, collaborating with internal teams and clients to deliver innovative data solutions that meet business needs and enhance decision-making processes.
Key Responsibilities
- Design, implement, and maintain robust ETL pipelines using Azure Data Factory, ensuring efficient incremental data loading and detailed logging.
- Write, optimise, and manage complex SQL queries for data extraction, transformation, and analysis.
- Leverage Databricks and Python for data integration, transformation, and analytics workflows.
- Build and manage API integrations, transforming JSON responses into structured tables while ensuring strong authentication and security protocols are in place.
- Develop and maintain data models using DBT (Database Tool) to support analytics and reporting needs.
- Utilise Azure Data Catalog, Azure Databricks, and related tools for comprehensive data engineering solutions.
- Collaborate with teams accessing SAP BW middleware for seamless integration with SAP data sources.
- Monitor and optimise data pipeline performance, identifying and implementing improvements to enhance efficiency and reliability.
- Ensure all data engineering activities comply with company policies, industry regulations, and data security standards.
What You Have to Offer
- Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.
- Minimum of 5 years of experience in data engineering roles with a proven track record of designing and implementing data solutions using Azure technologies.
- An understanding of the Data Mesh concept, which will play a crucial role in our development efforts.
- Proficiency in SQL and Python for data management and processing.
- Hands-on experience with Azure Data Factory, Azure Databricks, and related Azure data services.
- Strong knowledge of data modelling, API integration, and ETL processes.
- Excellent problem-solving and analytical skills and a quality mindset.
- Excellent communication skills in English (fluency in written and spoken English).
- Willingness to travel as needed for client engagements or other professional duties.
Working Conditions
This is a remote position based in Portugal. Standard office hours apply; however, flexibility may be required to meet client expectations or service delivery commitments. Let me know if you'd like further adjustments!
