Overview: Job Title: Business Intelligence Engineer Location: London Shift: Standard day shift, 40 hours per week Monday-Friday Duration: 6 months contract (extensions possible) Daily Rate (depending on experience level) 43.75 to 50 pounds per hour - Inside IR35 Agency Contract with Benefits (PTO, Pensions, National Insurance contribution) Who we are: Apex Systems is a leading Data and Digital Transformation professional services organization focused on providing solutions with real business value. We provide a customer-focused approach to building authentic partnerships with our clients with objective counsel from concept to deployment for a consistent voice through the dynamic IT environment. What we look for: Join our talented team of technologists who work with our clients to solve their most challenging software and application problems. Our mission is providing Insights that Inspire. In this role, you will work among engineering teams to develop cutting-edge software solutions. Principal Duties and Responsibilities: - Build End to End dashboarding solutions to optimize EU CF Operations using AWS - Data source exploration, data warehousing expansion, horizontal datasets for downstream consumption - Work with customers to build Dashboards with the right KPIs, Metrics for decision making - Data Quality checks, ETL/ELT processes, automation Technical Requirements: - Strong proficiency in SQL and Python programming - Extensive experience with data modeling and data warehouse concepts - Advanced knowledge of AWS data services, including: S3, Redshift, AWS Glue, AWS Lambda - Experience with Infrastructure as Code using AWS CDK - Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and security best practices Preferred Qualifications: - Master's degree in Computer Science, Information Systems, or related field - AWS certifications (Solutions Architect, Data Analytics) - Experience with real-time data processing - Experience with version control systems (Git)