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.