Business Intelligence Engineer

Job Description:

We are seeking a business intelligence engineer to be a key partner for the Advertising business to support revenue deep dives and finance system integration. We’re looking for a top technical and analytical mind capable of extracting value out of our large and disparate data sets, have background in finance processes, coupled with expertise in system integration. Lead the integration of finance systems to ensure the smooth flow of financial data across various platforms. Collaborate with DEs and finance teams to identify integration points and implement effective solutions. Additionally, you’ll help streamline and simplify the metric reporting needs for our operating cadences such as daily, weekly and monthly business reviews, support month end close processes and deep dives. Our ideal candidate is a self-starter, comfortable working through ambiguity, conceptualizing and leading complex initiatives from end to end, and has an entrepreneurial spirit. In addition to working with many stakeholders internally and externally, this role requires working through ambiguity, demonstrating good judgment under pressure and the ability to thrive in a fast-paced, dynamic environment

Qualifications:

• 10+ 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
• Experience writing complex SQL queries
• Experience with financial system integrations
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
• 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

Responsibilities

• Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions
• Make recommendations for new metrics, techniques, and strategies to improve team performance and measurement in the future
• Develop and implement data mapping strategies to ensure consistency and accuracy.
• Design and execute data transformation processes to meet financial reporting requirements.
• Define the data elements and data structure that our team should leverage to enable analytical and reporting capabilities for our business development team
• Design and influence operational best practices for reporting and analytics to enable the team to scale
• Prepare and deliver business reviews to the senior management team regarding progress and roadblocks
• Work with engineering and the data warehouse to enable the appropriate capture and storage of key data points
• Enable effective decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format
• Participate in strategic & tactical planning discussions

Preferred qualifications

• Experience in Statistical Analysis packages such as R, SAS and Matlab
• Experience with forecasting and statistical analysis