Business Intelligence Engineer II

Position: Business Intelligence Engineer II  Location: Seattle, WA 98109  Duration: 7 Months       Job Type: Contract         Work Type:  Hybrid Note: Need a BI Engineer who has experience with SQL, Tableau, AWS  Job Description:     The Business Intelligence Engineer (BIE) is an innovative, results driven professional that executes continuous improvement through data-driven actions.  The individual must exercise strong judgment and autonomy in the identification and execution of strategic improvement plans built on cross-Category, Technology, and Operations partnerships.   This role will impact and inform how the client executes its SnS business across its replenishment business.   The individual should possess a track record of successful relationship management, strong business and analytical acumen, and experience working with technology and engineering teams.   Great communication skills, ability to think big and influence across the client teams and high ownership to deliver successful results will be essential.  Key job responsibilities  Holistically architecting an end-to-end BI landscape that activates reporting, analysis & insights for the SnS business that includes building and harvesting datasets, data pipelines, ETL, application of custom logic, data visualization & story-telling to drive the business forward.  Creating new reporting to inform business reviews, deep dive analyzer tools, and more emerging strategy efforts.  Improving auditing tools to understand relevant inputs and identify gaps in technology systems to support creation of new capabilities to drive business operating leverage.  Building insights-oriented visualization tools in Quicksight or Tableau to enhance existing ways of work for product managers, program managers, vendor managers, finance partners, and stakeholder partner teams.  Challenging existing process and work streams with data-driven insights that offer alternatives that are cost neutral, or favorable, but drive much more scalable execution.  Partnering across the SnS teams as well as the central CADE team to create an intelligence roadmap that addresses core areas for automation, scale, and business financial productivity.  Scaling roadmap and solutions across categories by ensuring cross-company impact is measured and supported by stakeholder businesses.  Understanding the value chain within the broader site experience to inform new insights on customer engagement.  Developing a knowledge repository for SnS data intelligence as part of an evolving center of excellence that can be referred to outside of the SnS business  Key projects:   Migrations to new unions, move data types into new system, support engineers and stakeholders, assist in creation of metadata application layer to better upkeep data landscape   Typical Day in the Role:    Day to Day:   Assist stake holders in business management   Join meetings to talk through issues and solutions   Partner with team members to architect solutions for stakeholders  Writing SQL code to pull correct data sets   Meet time lines   Team size 5 team members  Interaction level with team: high collaboration from day 1 until they get to a point where they can work independently with assistance from team and stake holders   Chance for conversion or extension: yes based on org’s needs and performance  Candidate Requirements:    Qualifications  +2-5 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  4 -6 years of Strong working knowledge of SQL, Python, Tableau (or Quicksight)  Strong working knowledge of AWS cloud, Redshift, AWS Andes, Glue  Background (academic or professional) in statistics, programming, and marketing  Graduate degree in math/statistics, computer science or related field is highly desirable.  Excellent communication skills, equally adept at working with engineers as well as business leaders  Degree:   bachelors is relative field (masters preferred)   Nice to have;  Former experience with AWS / aws REDSHIFT   Statistical analysis experience  Best:   Meets all qualifications and Nice to haves, someone with a desire to learn and drive business to completion, High initiative and curiosity,   Red Flag:   Someone who does not take responsibility, not team oriented or has ownership mindset  Performance indicators: meeting of deliverables and deadlines  Top 3 must-have hard skills:  4 -6 years  of Strong working knowledge of SQL, Python, Tableau (or Quicksight)  +2-5  years of experience working with large-scale complex datasets  Background (academic or professional) in statistics, programming, and marketing (masters preferred)