Analytics Engineer | Academy Porto

About The Role

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
- driven
- 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 as 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
  - 's reporting and analysis needs.
• Monitoring and optimizing data integration processes to ensure that data is loaded efficiently and accurately.

Requirements

• Knowledge of web development using languages such as SQL, PL/SQL, and TSQL, among others.
• Knowledge of Databases such as Oracle, Teradata, and Microsoft SQL Server, among others.
• Knowledge of data warehousing concepts and technologies (e. g. , Redshift, Big Query, Snowflake).
• Familiarity with ETL (Extract, Transform, Load) processes and tools (e. g. , Talend, Oracle ODI, Informatica Power Center, and Data
  Stage).
• Understanding 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 a sense of autonomy.
• Motivation for international projects and ok if travel is included.
• Willingness to collaborate with other players.
• Strong communication skills.

What are we looking for?

• Interest in programming (also in brainstorming, creating, suggesting and building).
• Less than 1 year of effective experience in IT - This is a Celfocus Academy Opportunity.
• Eagerness to learn.
• 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.
• Curiosity.
• Did we mention eagerness to learn?

What We Offer

We are dedicated to fostering talent and nurturing the next generation of professionals. As part of our commitment to supporting junior team members, we offer a comprehensive training and mentoring program - Celfocus Academy - to help you excel in your career.

This is a personalized growth Program where you will be given a defined path and have a senior colleague dedicated to guiding you through every step of the way, being your counselor and your career advisor. Your goals will be set and discussed to promote professional and personal growth through training and collaboration. Follow-up meetings happen three times a year, to assess your progress and adjust your goals.

The program includes

• Full-Time Permanent Contract: Enjoy the stability and security of a
  - time position with Celfocus.
• Training and Mentoring Program: Benefit from our specialized training and mentoring initiatives designed specifically for junior team members. Our experienced professionals will guide you through
  - on learning experiences, ensuring you have the skills and knowledge to succeed.
• Career Growth Opportunities: We believe in promoting from within. As you develop your skills and contribute to our team,
  - 'll have the chance to advance your career within our organization.
• Collaborative Work Environment: Join a supportive and collaborative team where your ideas are valued, and your contributions make a difference.
• Work-Life Balance: We understand the importance of
  - life balance. Enjoy a hybrid regime and flexible working hours.

To discover more about Celfocus Academy, please visit academy - Celfocus.

At Celfocus, we are committed to cultivate a diverse and inclusive workplace. As an
- 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!

Celfocus is a European
- tech system integrator, providing leading edge professional services focused on creating business value through Analytics and Cognitive solutions – addressing Telecommunications, Financial Services, Retail, Energy & Utilities, Pharmaceutical, and other
- ' strategic opportunities. As a highly specialised engineering company, Celfocus helps clients undergo their innovation path, providing technological solutions to extract value from data and make it actionable. Serving clients in +25 countries, Celfocus delivers solutions that boost customer experience and enhance operational efficiency, via our Cognitive Automation, Data & Analytics and Digital offers.

Seniority level

• Internship

Employment type

• Contract

Job function

• Information Technology
• Industries IT Services and IT Consulting

Referrals increase your chances of interviewing at Celfocus by 2x

Get notified about new Data Engineer jobs in Porto, Portugal.

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.