Analytics Engineer

Porto, Portugal

Celfocus

Celfocus is a European high-tech system integrator, providing professional services focused on creating business value through Analytics and Cognitive solutions –addressing Telecommunications, Energy & Utilities, Financial Services and other...

View all jobs at Celfocus

Apply now Apply later

Make an impact by working for sectors where technology is the enabler, everything is ground-breaking and there’s a constant need to be innovative.

Be part of the team that combines business knowledge, technological edge and a design experience. Our different backgrounds and know-how are key in developing solutions and experiences for digital clients.

Face challenges and learn other ways of thinking and seeing the world - there’s always room for your energy and creativity.


 

About the role

The Analytics Engineer is responsible for providing clean and transformed data ready for analysis using ETL/ELT. Analytics Engineers should have an analytical perspective on the big picture around the data involved in the process.

Their mission is to design and implement data pipelines and analytical tools to support data-driven decision-making within an organization.

They work closely with data analysts, data scientists, and other stakeholders to understand their requirements and deliver robust analytical solutions to drive the company to be aligned and focused on its goals.


As a part of your job, you will:

  • Designing and implementing data integration workflows using ETL tools such Informatica, Talend, or Microsoft SQL Server Integration Services (SSIS);
  • Transforming data to meet the requirements of the target system or data warehouse;
  • Loading transformed data into a data warehouse or other storage systems for reporting and analysis purposes;
  • Collaborating with Data Analysts to ensure that data integration solutions support the organization's reporting and analysis needs;
  • Monitoring and optimizing data integration processes to ensure that data is loaded efficiently and accurately.


What are we looking for?

  • Know-how in working on development using languages as SQL, PL/SQL, and TSQL, among others;
  • Knowledge of SAP DataSPhere;
  • Knowledge of Databases such as Oracle, Teradata, Microsoft SQL Server, among others;
  • Knowledge of data warehousing concepts and technologies (e.g., Redshift, BigQuery, Snowflake);
  • Familiarity with ETL (Extract, Transform, Load) processes and tools (e.g., Talend, Oracle ODI, Informatica Power Center, and DataStage);
  • Understanding of statistical analysis and data modeling techniques (e.g. Star Schema, Data Vault);
  • Knowledge of cloud platforms (e.g., AWS, Azure, GCP) and their data services.



Personal traits:

Ability to adapt to different contexts, teams and Clients

Teamwork skills but also sense of autonomy

Motivation for international projects and ok if travel is included

Willingness to collaborate with other players

Strong communication skills


At Celfocus, we are committed to cultivate a diverse and inclusive workplace. As an equal-opportunity employer, we welcome applicants of all backgrounds, gender identities, and abilities. We are dedicated to providing reasonable accommodations for candidates with specific needs. If you require any adjustments during the selection process, please inform our Talent Acquisition Team.

Come join the Team!

Apply now Apply later

* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰

Job stats:  0  0  0

Tags: AWS Azure BigQuery Data pipelines Data warehouse Data Warehousing ELT ETL GCP Informatica Oracle Pipelines Redshift Snowflake SQL SSIS Statistics Talend Teradata T-SQL

Region: Europe
Country: Portugal

More jobs like this