The BI Engineer will apply his/her knowledge of the Reed Exhibitions North America (RXNA) customer data platforms to help facilitate business transformation via creation of a “Data Lake” environment. Success in this role is based upon the incumbent’s ability to work in a fast-paced, team-oriented environment, and become an expert in the integration/creation of multitudes of RXNA data sources.
WHAT’S EXCITING ABOUT THIS ROLE:
RXNA has successfully transitioned our CRM to a global Oracle/SalesForce solution and are looking to build an agile environment to manipulate and visualize data. The BI Engineer is a newly created and exciting opportunity within our growing D&A team which will help support change for US business. If you enjoy being at the forefront of change and having a hand in strategy then look no further, this is the role for you!
Integrates a linking of RXUS historical data structures to the new Oracle/SalesForce solution to create a fluid environment where Data Science related projects & custom reporting comes to life.
Identifies gaps, challenges, and limitations of current reporting structure through deep understanding of the business and data warehouse architecture.
Expert at assessing proposed reports and identifying advantages, disadvantages, gaps, and possible workarounds (or alternatives) for key business needs.
Works closely with the Database Analysts, Analytics, and Data Solutions verticals within D&A to understand data analytics & reporting requirements based on assessment of need from show teams or RXUS internal departments.
Helps to integrate and visualize external/3rd party data sources to ensure the RXUS business is able to enrich marketing data and effectively segment and target anticipated audiences.
Able to take insights and learnings from statistical analytics projects and integrate the information back into the Data Lake environment for use by the RXUS community via automated reports in PowerBI.
Produces and maintains process documentation and workflows of the data lake architecture.
At times, will be asked to present findings/visualizations to stakeholders of all levels throughout the organization.
Degree in Computer Science or Data related field
Experience with OBIEE, Oracle EBS, and SQL with either MS SQL Server or ODBM.
Demonstrated strong analytical and problem solving skills
Experience with Multi-Dimensional and Star Schema Database design, multi-tier architecture and deployment, OLAP and Client/Server architectures
Demonstrated ability to work independently, showing a high degree of self-motivation and initiative
Previous experience with data visualization or reporting software (Tableau, Qlik, PowerBI, etc.)
Strong working knowledge of Python, PySpark, and AWS platform is required.
The job you are applying for is subject to a COVID-19 vaccination requirement. The successful candidate will be required to submit proof of vaccination showing their last dose of a COVID-19 2-dose vaccine or one dose of a single dose vaccine approved or authorized by the FDA or WHO and maintain up to date vaccination as recommended by the CDC. If you are unable to be vaccinated due to a medical condition or a sincerely held religious belief, practice, or observance you should speak to a recruiter about requesting an exemption/accommodation.