Business Intelligence Engineer

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Business Intelligence Engineer Location(s): New York, NY Job Description: Business Intelligence Engineer with strong technical, analytical, and business intelligence skill sets and experience to be a key partner for Advertising business focusing on Streaming TV across all Video Publishers. This role will be the key contributor supporting the APM Video Ad Publishers. The person will build out the business insights, analysis practice, and data infrastructure for APM Video Ad Publishers, gaining visibility across Ads, and Finance organizations. We generate insights to guide product and partner strategy, and we provide direct business strategy support to senior leaders. We are motivated to improve overall Video Ads experience for our advertisers through Ads. As a key analytics partner, the Business Intelligence Engineer will influence the direction of the business by leveraging our data to deliver insights that drive decisions and actions. This role involves translating broad business problems into specific analytics projects, conducting deep quantitative analyses, and communicating results effectively. We seek professional to transform our data into actionable insights to continue to fuel the growth of this business. The role will help the organization identify, evaluate, and evangelize new techniques and tools to continue to improve our ability to deliver value to Customers. This role requires an individual with excellent business, communication, and technical skills, enabling collaboration with various functions, including product managers, data engineers, finance managers, software engineers, data scientists, as well as senior leadership. The successful candidate will be a self-starter comfortable with ambiguity and complex datasets and business problems. The person has strong ownership and an ability to work in a fast-paced, ever-changing, and high-energy environment. Key job responsibilities Design, develop, build, and maintain scalable data solutions, including infrastructure, pipeline, reporting, to support long-term business strategies Simplify and re-invent current data solutions to support the business scope expansion Explore and deep dive into new areas across various ad programs as well as business functions to support business decision making Translate business problems into data questions, find solutions to solve those questions with resourcefulness Present analytical findings and recommendations to business leadership Work cross-functionally with other teams in various job families to gather data sources to provide a comprehensive view of the business, inclusive of supply, demand, sales, operations, shopper, etc. Recognize and adopt best practices in reporting/analysis: data integrity, test design, analysis, validation, and documentation This role promises to give exposure to a high growth business. This BIE will be actively involved in building new metrics, understanding impact of product changes, and identifying opportunities for growth through exploratory analyses including use of lightweight statistical techniques. This role provides the opportunity to use emerging technologies such as machine learning to build models and tools used by management for strategic decision making. About the team The APM Advertising Finance team supports various publishers, including Video, Devices, Audio, Stores, Business, Books, Grocery/Physical Store. Our focus is to accelerate top-line revenue and improve profitability by evaluating overall ad supply monetization and utilization, product feature or sales package adoption, campaign performance, and other various product drivers of growth. BASIC QUALIFICATIONS 3 years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience Experience with data modeling, warehousing and building ETL pipelines Experience writing complex SQL queries Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling Experience in Statistical Analysis packages such as R, SAS and Matlab Experience with data visualization using Tableau, Quicksight, or similar tools Knowledge of SQL and data warehousing concepts PREFERRED QUALIFICATIONS 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 Experience in understanding and translating ambiguous and complex business problems into data solutions and presenting findings to the leadership Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities.