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) Apply tot his job Apply To this Job