Lead Engineer - Corporate Data Warehouse

Technology London, United Kingdom



Lead Engineer - Corporate Data Warehouse

Location: London, UK


About Argus


Argus is an independent media organisation with 1,200 staff. It is headquartered in London and has 28 offices in the world’s principal commodity trading and production centres. Argus produces price assessments and analysis of international energy and other commodity markets and offers bespoke consulting services and industry-leading conferences. Companies in 140 countries around the world use Argus data to index physical trade and as benchmarks in financial derivative markets as well as for analysis and planning purposes.


Argus was founded in 1970 and is a privately held UK-registered company. It is owned by employee shareholders, global growth equity firm General Atlantic and Hg, the specialist software and technology services investor.  Argus Media is committed to ensuring career and personal growth for all its staff and provides extensive training and career development opportunities, as well as participation in employee-led initiatives, including a women’s network.


What will you be doing?

As Team lead, you will be the detailed technical authority within the engineering team. You are responsible for the design, implementation and running of applications at Argus. You will manage and mentor up to six other engineers in their team.


The Data Warehouse team is responsible for providing the business intelligence platform that other teams use to discover customer and business insight. The team is responsible for progressively rolling out new data sets, reports and dashboards ensuring that the solution is performant, highly available, and suitable for the consuming users and applications. This role works closely with other Lead Engineers, the Architecture team and data team to revise and refactor our BI data models as appropriate.

In this role you will work with and be supported by:

  • Architects, who provide higher-level implementation advice and strategy.
  • Product managers who provide a development pipeline and help run the multidisciplinary team involved in product development.
  • QA engineers, responsible for testing software in development and production.
  • DevOps engineers who provide dedicated expertise – although Lead Engineers are expected to be closely involved with DevOps too.
  • 3-4 other Team leads in the department.


Key Responsibilities


  • Working as the leader of a small team (1-3 reports) to produce production code in line with business requirements.
  • Owning the BI data pipeline and its bespoke and off the shelf systems and growing /improving these as required.
  • Recruiting, training and developing the software engineers who report to you.
  • Technical leadership, providing reference implementations and demonstrations of new technologies and frameworks, and ensuring a high standard of software development.
  • Resolve technical debates/arguments to focus the team on working solutions.
  • Contribute to the strategic technology direction of the company.


Skills and Experience




  • A strong understanding of application development, encompassing all layers, including the human ones.
  • A good practical understanding data warehousing, data visualisation and data ops.
  • Large relational database systems experience e.g. Oracle, SQL etc
  • Lead experience - ability to re-enforce and nurture professional practices in the team.
  • Experience of and skill in using modern tools for database and model development
  • Good verbal and written communication skills, the ability to contribute to meetings as required
  • Experience with visualisation and analytics in a BI platform including use of tools such as Birst, Tableau, PowerBI or AWS Quicksight.
  • Understand star, snowflake data models and have implemented BI on top of them
  • Exposure to ETL/data integration tools like Oracle Warehouse Builder, Data Integrator, Data Stage, Ab Initio
  • Curious, self-driven, analytical and excited to play with data




The following are all technical areas that Argus uses or plans to use extensively. Experience and/or interest in one or more of them will be helpful


  • Experience with Amazon Redshift and best practices handling large data volumes in column store databases
  • AWS and related cloud technologies such as Glue, DataBrew etc.
  • Agile development methodology


What’s in it for you


Our rapidly growing, award-winning business offers a dynamic environment for talented, entrepreneurial professionals to achieve results and grow their careers. Argus recognizes and rewards successful performance and as an Investor in People, we promote professional development and retain a high-performing team committed to building our success.


  • Competitive salary and company bonus scheme 
  • Group pension scheme 
  • Group healthcare and life assurance scheme 
  • Flexible working environment 
  • 25 days holiday with annual increase up to 30 days  
  • Subsidised gym membership 
  • Season ticket travel loans 
  • Cycle to work scheme 
  • Extensive internal and external training


For more details about the company and to apply please make sure you upload your CV via our website: www.argusmedia.com/en/careers/open-positions 


By submitting your job application, you automatically acknowledge and consent to the collection, use and/or disclosure of your personal data to the Company. Argus is an equal opportunity employer. We welcome and encourage diversity in the workplace regardless of race, gender, sexual orientation, gender identity, disability or veteran status.