Business Intelligence Engineer, RBS Brand Experience

DESCRIPTION

Are you passionate about transforming complex data into actionable business insights at a global scale? RBS Brand Experience (formerly APIE) is seeking an experienced Business Intelligence Engineer who thrives on ambiguity and can decipher evolving business needs to shape data-driven solutions.
As a Business Intelligence Engineer, you'll be at the intersection of data and business strategy, translating complex requirements into actionable analytics solutions. You'll partner with stakeholders to unlock insights that elevate our global work authorization experiences and drive program scalability. Key job responsibilities A successful candidate will demonstrate: Advanced SQL skills for writing complex queries and stored procedures to extract, transform, and analyze large datasets Proficiency in Python, particularly with libraries like pandas and PySpark, for data manipulation and ETL processes Strong analytical and problem-solving capabilities, with the ability to translate business requirements into efficient data solutions Experience in designing and implementing scalable ETL pipelines that can handle large volumes of data Expertise in data modeling and database optimization techniques to improve query performance Ability to work with various data sources and formats, integrating them into cohesive data structures Skill in developing and maintaining data warehouses and data lakes Proficiency in using BI tools to create insightful visualizations and dashboards Ability to thrive in ambiguous situations, identifying data needs and proactively proposing solutions Excellence in communicating technical concepts and data insights to both technical and non-technical audiences Customer-centric mindset with a focus on delivering data solutions that drive business value" A day in the life You'll work closely with Product Managers, Software Developers, and business stakeholders to: Build and maintain dashboards that drive business decisions Perform deep-dive analyses to uncover actionable insights Develop and automate data processes to improve efficiency Present findings and recommendations to leadership Partner with global teams to implement data-driven solutions

BASIC QUALIFICATIONS

• 2+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with scripting language (e.g., Python, Java, or R)
• Experience building and maintaining basic data artifacts (e.g., ETL, data models, queries)
• Experience applying basic statistical methods (e.g. regression) to difficult business problems
• Experience gathering business requirements, using industry standard business intelligence tool(s) to extract data, formulate metrics and build reports

PREFERRED QUALIFICATIONS

• Bachelor's degree, or Advanced technical degree
• Knowledge of data modeling and data pipeline design
• Experience with statistical analysis, co-relation analysis
• Experience in designing and implementing custom reporting systems using automation tools