Data Engineer / ETL Developer

Company Description

Informa Connect organizes major branded annual events and operates specialist digital communities that are key convening places for a particular market. We run around 800 events each year in over 60 countries, create digital platforms based on engaging news and information content, and operate professional development programs for individuals and businesses in Foodservice and Hospitality, Sustainability, Marketing, Global Finance, Life Sciences, and in a number of other specialist markets.

Job Description

Informa Connect is looking for a skilled and motivated Data Engineer to support our Foodservice portfolio. Acting as a conduit between IT and Marketing centrally, you will be highly collaborative and passionate about business architecture and have an expert-level understanding of how data and marketing operations inform sound decisions.

This hybrid role requires expertise in SQL and ETL development, as well as the ability to analyze business needs to translate them into technical solutions to support the wider organization. You will partner with an innovative team to plan future data and operational needs, implementing solutions to optimize and manage our groupwide tech stack. If you are entrepreneurial, love all things data and “getting your hands dirty” in the backend of automations systems, this is the job for you.

Job Description

As the Data Engineer you will be a critical supporting role for the Data Insights team within the Foodservice Group of Informa Connect, responsible for becoming an expert advisor to our business on our data model and how to use it, as well as monitoring, triaging, and fixing data issues to improve data quality. You will also support data quality initiatives, maintain data models, develop reports and dashboards, and participate in data governance discussions. You will help establish and maintain standard data practices and governance.

Customer-focused to your core, you will help visualize the data to map out Connect’s capability and technology based on user persona, bridging the gap between strategy and execution, streamlining and rationalizing the IT enablement process, optimizing the customer experience from the inside out. The ideal candidate will be extremely organized and data-driven, comfortable writing SQL queries, analyzing and interpreting results from various databases, and manipulating data to feed into reporting tools such as PowerBi.

This position reports directly to the Director of Data Operations & Digital Insights requires extensive collaboration with sales, brand and marketing directors as well as senior management across divisions. You will play a key part in synthesizing and creating synergies for the work of others, drawing from disciplines like business analysis, process management and operations to define the database and automation strategy across Informa Connect’s Foodservice portfolio brands.

Primary responsibilities:

• Database Operations & Marketing Automation:
  • Work closely with both central development and directly with Director of Data Operations & Digital Insights, to ensure all optimal and new innovative practices are aligned and shared across the group.
  • Assist the wider team in data integration projects between disparate Salesforce CRM instances and marketing-related platforms (Marketo, Eloqua).
  • Master our data set as a subject matter expert and collaborate with stakeholders to uncover insights and amplify the value within the data.
  • Your overarching goal will be to streamline all data and marketing efforts, to optimize and improve marketing operation workflows which measure effectiveness, performance, and ROI using various Business Intelligence tools.
  • Participate in data governance activities, including maintaining the data dictionary and business glossary and documenting data lineage.
  • Work on resolving data quality issues by developing immediate solutions and long-term strategies with the IIRIS (CDP) team.

• Business Process Operations
  • Work cross-functionally to assist in weekly and monthly reporting meetings, ensuring operational excellence while you serve as a central conduit across business functions.
  • Partner with the central teams to ensure data governance and alignment across systems and processes.
  • Develop, monitor and improve the efficiency and effectiveness of our marketing automation & CRM systems (Eloqua, Marketo, Salesforce, et al) on behalf of the Foodservice portfolio in line with Connect’s wider marketing tech strategy.

Qualifications

• Bachelors degree required. 2-3 years’ experience in data analysis and / or database development
  • At least 2 years of SQL development or programming experience.
• A "can-do" attitude, with a desire to extend existing skills and be a problem solver
• A mind that analyzes & seeks out opportunities to experiment with data continuously optimizing reporting to improve the way we understand our database.
• Exemplary organizational and prioritization skills – project oriented with an attention to detail.
• Excellent collaboration and communication skills; written, verbal, presentation.
• Advanced skills in SQL or any other data querying (including writing advanced select statements, stored procedures, and functions).
• Ability to work with databases, transactional data, and data warehouses (e.g., Redshift, Snowflake).
• Able to easily understand, create, manipulate, and upload XML, JSON, CSV and MS Excel files.
• Familiarity with data governance concepts, including managing data quality, accuracy, and integrity.
• Proficient in Microsoft Office Suite, namely an expert in Excel and PowerBI, including pivot tables, data tabulation, data visualization and dashboard creation.
• Experienced with a diverse marketing tech stack, including but not limited to: Eloqua, Marketo, Adestra, Salesforce CRM, PowerBI, Google Analytics, data repository, etc.

This posting will automatically expire on Feb 14, 2025.

Additional Information

We work hard to make sure Life at Informa is rewarding, supportive and enjoyable for everyone. Here’s some of what you can expect when you join us. But don’t just take our word for it – see what our colleagues have to say at LifeAt.Informa.com

Our benefits include:

• Freedom & flexibility: colleagues rate us highly for the flexibility and trust they receive, and we support a range of working patterns
• Great community: a welcoming culture with in-person and online social events, our fantastic Walk the World charity day and active diversity and inclusion networks
• Broader impact: take up to four days per year to volunteer, with charity match funding available too
• Career opportunity: the opportunity to develop your career with bespoke training and learning, mentoring platforms and on-demand access to thousands of courses on LinkedIn Learning. When it’s time for the next step, we encourage and support internal job moves
• Time out: 15 days PTO rising to 20 after three years and 25 after six years, plus 10 national holidays, a birthday leave day and the chance to work from (almost!) anywhere for up to four weeks a year
• Competitive benefits, including a 401k match, health, vision and dental insurance, parental leave and an ESPP offering company shares at a minimum 15% discount
• Strong wellbeing support through EAP assistance, mental health first aiders, free access to a wellness app and more • Recognition for great work, with global awards and kudos programs
• As an international company, the chance to collaborate with teams around the world
• The salary for this position is $61,625-$75K/YR depending on experience.

We know that sometimes the 'perfect candidate' doesn't exist, and that people can be put off applying for a job if they don't fit all the requirements. If you're excited about working for us and have most of the skills or experience we're looking for, please go ahead and apply. You could be just what we need! We believe strongly in the value of diversity and creating supportive, inclusive environments where our colleagues can succeed.  As such, Informa is proud to be an Equal Opportunity Employer.  We do not discriminate on the basis of race, color, ancestry, national origin, religion, or religious creed, mental or physical disability, medical condition, genetic information, sex (including pregnancy, childbirth, and related medical conditions), sexual orientation, gender identity, gender expression, age, marital status, military or veteran status, citizenship, or other protected characteristics under federal, state or local law. 

See how Informa handles your personal data when you apply for a job here.