Mid-Level Data Engineer

LGG
Advisors is a
global consulting firm with offices in Porto, Lisbon, London, and Madrid,
delivering high-value, strategic advisory services to leading companies
worldwide.

Our Digital
Transformation team focuses on data, automation, and analytical
intelligence applied to financial consulting. We help clients unlock value from
complex data environments through scalable and robust solutions.

As we
continue to grow, we are looking to hire a Senior Data Engineer to
oversee client engagements in our Porto or Lisbon office.

Description:

• Join a growing
  team focused on data, automation, and analytical intelligence applied to
  financial consulting;
• Work with end-to-end
  data and analytics projects, including data engineering, modeling,
  visualization, and reporting automation;
• Work with
  sophisticated clients and complex data environments, both nationally and
  internationally;

Responsibilities:

• Work with data architecture,
  pipeline development, and analytics infrastructure initiatives;
• Oversee large-scale data
  modeling and warehousing solutions, ensuring quality and efficiency;
• Design and maintain dashboards
  and reports using tools like Power BI or Tableau;
• Coordinate with internal and
  external stakeholders, ensuring timely and high-quality project delivery;
• Apply best practices in
  analytics software development (e.g., version control, CI/CD, automated
  testing);
• Support the Strategy &
  Finance team by providing data-driven insights and process automation.

Qualifications:

• Bachelor’s degree in
  Engineering, Business, Economics, or related fields (preferred);
• Minimum of 3 years of professional
  experience in data engineering, business intelligence, or analytics
  project delivery;
• Experience in data
  modeling and data warehousing in large-scale environments;
• Proficiency in SQL and data
  transformation tools (preferably dbt or similar);

Requirements:

• Fluency
  in English (mandatory);
• Experience with Snowflake and
  Microsoft Azure cloud technologies;
• Good knowledge with Python programming
  skills; experience with Docker, Airflow, or Luigi is a plus;
• Familiarity with REST/SOAP
  APIs;
• Hands-on experience with Power
  BI, Tableau, or similar data visualization tools;
• Strong time management,
  attention to detail, and proactive problem-solving mindset.

Diferentials:

• Passion for finance, financial
  data, or product analytics;
• Previous experience in
  consulting or regulated environments;
• Direct involvement in digital
  transformation or automation projects within the financial sector.

What We Offer:

• Fast-growing company with a
  presence in Porto, Lisbon, London, and Madrid, that works on complex and
  stimulating projects for sophisticated clients in the US and Europe;
• Competitive salary and benefits which vary
  according to individual performance;
• Opportunity to work from home
  50% of the time;
• Career Development Plan,
  Training Programs and Sponsorship.

At LGG
Advisors, we are committed to building a diverse and inclusive workplace.
All qualified applicants will be considered for employment regardless of race,
gender identity, sexual orientation, religion, nationality, age, or disability.