Business Intelligence Engineer II at Intelliswift

Job-ID32795966Reference26-03549Pay rate range - $60/hr. to $63/hr. Fully Onsite - San Francisco, CA/Seattle, WA/New York, NY Must Have 1.  SQL writes from scratch 2.  ETL 3. Working on large data set TERRABYTEs 4+ years of experience working with large-scale complex datasets - Strong analytical mindset, ability to decompose business requirements into an analytical plan, and execute the plan to answer those business questions - Strong working knowledge of SQL - Background (academic or professional) in statistics, programming, and marketing Nice to Have Gen AI fluency to auto Spark Task Breakdown This role will influence the direction of the business by translating broad business problems into specific analytics projects, conducting deep quantitative analyses, and communicating results effectively. This individual will help drive robust scalable management reporting mechanisms to assist Business and Finance leadership with insights generation and decision-making. As a key analytics partner, this candidate will have significant exposure to the Advertising Finance Leadership Team, and require partnership with a broad set of teams including finance, product, sales, operations, and technology. We see a high potential for growth in the role as we transform our data into actionable insights to continue to fuel the growth of this business. The successful candidate will have a top analytical mind capable of understanding our complex ecosystem of advertisers, and be a self-starter comfortable with ambiguity, with strong attention to detail, and with an ability to work in a fast-paced, high-energy and ever-changing environment. The drive and capability to shape the direction is a must. - Evaluation of the performance of program features and marketing content along measures of customer response, use, conversion, and retention - Statistical testing of A/B and multivariate experiments - Design, build and maintain metrics and reports on program health - Respond to ad hoc requests from business leaders to investigate critical aspects of customer behavior, e.g. how many customers use a given feature or fit a given profile, deep dive into unusual patterns, and exploratory data analysis - Employ data mining, model building, segmentation, and other analytical techniques to capture important trends in the customer base - Participate in strategic and tactical planning discussions