Business Intelligence Engineer
Hybrid – London
Up to £400 a day
Inside IR35
12 Months
Key Skills:
5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
Experience with data visualization using Tableau, Quicksight, or similar tools
Experience with data modeling, warehousing and building ETL pipelines
Key job responsibilities
• Design, develop, and oversee the reporting pipelines to onboard internal and external data sources provided metrics into reporting and measurement tool, using appropriate technologies (e.g., SQL, Python, Spark, AWS Lambda, etc.)
• Design, develop and optimize data visualization for the dashboards used across functional teams within XCM
• Collaborate with stakeholders (marketing, advertising, engineering, and product management) to understand business domains, requirements, and expectations and reflect these on the onboarding of new features for current and future business intelligence roadmap of XCM
• Work closely with owners of data source systems to gain insights into their capabilities and limitations
• Deliver minimally to moderately complex data analysis to support business needs
• Adopt best practices in reporting, including ensuring data integrity, designing thorough testing, validating outputs, and maintaining comprehensive documentation
Basic qualifications
• 5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• Knowledge of paid media buying and general marketing
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• Experience writing complex SQL queries
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modelling
• Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
Preferred qualifications
• Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
• Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
• Experience with forecasting and statistical analysis
• Adjacency and understanding on media and marketing landscape
• Experience in code review and version control tools, such as git
Basic qualifications
• 5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• Knowledge of paid media buying and general marketing
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• Experience writing complex SQL queries
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modelling
• Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
Preferred qualifications
• Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
• Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
• Experience with forecasting and statistical analysis
• Adjacency and understanding on media and marketing landscape
• Experience in code review and version control tools, such as git
If you are interested please apply or send your CV to luke.sandilands@cpl.com