Business Intelligence Engineer III
Job Title: Business Intelligence Engineer III
Job Location: New York, NY 10001
Job Duration: 6 Months Contract
Pay Rate: $60.50/hr to $64.50/hr
Job Description:
• Our Client seeks a business intelligence engineer to be a key partner for the Client Advertising business, with a range of products offerings for advertisers.
• We’re looking for a top technical and analytical mind capable of extracting value out of our large and disparate data sets.
• You will influence the direction of the business by leveraging our data to deliver insights that drive decisions, evolution of our products and the way they fit into Client's ecosystem.
• Additionally, you’ll help streamline and simplify the metric reporting needs for our operating cadences such as daily, weekly and monthly business reviews.
• 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.
Key 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
• 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
Basic qualifications:
• 3+ 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 in Statistical Analysis packages such as R, SAS and Matlab
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
Preferred qualifications
• Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
Business Group:
• Advertising Sales supports finance teams tp build out KPIs and dashboards
• 6 dashboards in Tableau
Reason for Request:
• Backfill for FTE going on mat leave
Daily Schedule:
• ELTs, data manipulation, transformation, SQL, ingest data from internal ad sales, prepare data marks, preparing tableau dashboards to support finance teams
• LCSUS organization - 90% core stakeholder
• Biweekly/weekly business review calls
• Less involved in data deep dives, building features in dashboards, enhance dashboard, bring in new data
• Majority is heads down work
• Working in ~2 dashboards in Tableau along with team
• Collaborative team culture, team sits together in office, high level communication
Typical week:
• Team meeting for delegation/support/collaboration/prioritization every other day
• Once tasks are delegated, working independently
Role interesting:
• Ads is a well-known organization for generating revenue at Client. Working with large stakeholders and able to get high visibility amongst leaders
Years of experience:
• 2-4+ years industry experience and advanced degree (Master’s)
• Seeking 3-5+ years’ experience if Bachelor’s Degree
Required:
• Proficient in SQL
• Tableau experience
• Communicate well in data space - data mark designing, data analytics
• MS Office/ Excel - VLOOKUPs, pivot tables, conditional formatting
Preferred:
Degree or Certification:
• Bachelor’s Degree in math/statistics, computer science or related field, or marketing at minimum
• Master’s Degree preferred
KPI:
• Customer and seller engagement with advertisers, pipeline for data renovation, time to close pitches that sellers present to create campaigns
Leadership Principles:
• Deep Dive
• Ownership
• Bias for Action
Top 3 must-have hard skills
• SQL proficiency
• Analytics and visual tools - Tableau
• Proven ability to deep dive into data and present results
Job Title: Business Intelligence Engineer III
Job Location: New York, NY 10001
Job Duration: 6 Months Contract
Pay Rate: $60.50/hr to $64.50/hr
Job Description:
• Our Client seeks a business intelligence engineer to be a key partner for the Client Advertising business, with a range of products offerings for advertisers.
• We’re looking for a top technical and analytical mind capable of extracting value out of our large and disparate data sets.
• You will influence the direction of the business by leveraging our data to deliver insights that drive decisions, evolution of our products and the way they fit into Client's ecosystem.
• Additionally, you’ll help streamline and simplify the metric reporting needs for our operating cadences such as daily, weekly and monthly business reviews.
• 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.
Key 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
• 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
Basic qualifications:
• 3+ 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 in Statistical Analysis packages such as R, SAS and Matlab
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
Preferred qualifications
• Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
Business Group:
• Advertising Sales supports finance teams tp build out KPIs and dashboards
• 6 dashboards in Tableau
Reason for Request:
• Backfill for FTE going on mat leave
Daily Schedule:
• ELTs, data manipulation, transformation, SQL, ingest data from internal ad sales, prepare data marks, preparing tableau dashboards to support finance teams
• LCSUS organization - 90% core stakeholder
• Biweekly/weekly business review calls
• Less involved in data deep dives, building features in dashboards, enhance dashboard, bring in new data
• Majority is heads down work
• Working in ~2 dashboards in Tableau along with team
• Collaborative team culture, team sits together in office, high level communication
Typical week:
• Team meeting for delegation/support/collaboration/prioritization every other day
• Once tasks are delegated, working independently
Role interesting:
• Ads is a well-known organization for generating revenue at Client. Working with large stakeholders and able to get high visibility amongst leaders
Years of experience:
• 2-4+ years industry experience and advanced degree (Master’s)
• Seeking 3-5+ years’ experience if Bachelor’s Degree
Required:
• Proficient in SQL
• Tableau experience
• Communicate well in data space - data mark designing, data analytics
• MS Office/ Excel - VLOOKUPs, pivot tables, conditional formatting
Preferred:
Degree or Certification:
• Bachelor’s Degree in math/statistics, computer science or related field, or marketing at minimum
• Master’s Degree preferred
KPI:
• Customer and seller engagement with advertisers, pipeline for data renovation, time to close pitches that sellers present to create campaigns
Leadership Principles:
• Deep Dive
• Ownership
• Bias for Action
Top 3 must-have hard skills
• SQL proficiency
• Analytics and visual tools - Tableau
• Proven ability to deep dive into data and present results
