BI Engineer

Position: BI Engineer Location: Seattle, WA 98109 Duration: 3 Months Job Type: Temporary Assignment Work Type: Onsite/Hybrid Pay Rate: $ 55.62-55.62/ Hourly Overview TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. We are a community of 50 million who think—and feel—differently about investing. Together, we’re changing the way the world invests. Since our founding in 1975, helping investors achieve their goals has been our main reason for existence. At Client, we’re built differently. Our client is investor-owned, meaning that we’re owned by our funds, which are owned by our fund shareholder clients. Therefore, your success adds to ours, so you’re surrounded by people who care about the same things. With no other parties to answer to, we make decisions—including keeping investing costs as low as possible—with your needs in mind. Because of our unique structure, your goals align with our goals. Job Description • Client we are working to be the most customer-centric company on earth. To get there, we need exceptionally talented, bright, and driven people. client's Subscribe & Save (SnS) program ($20+ billion in revenue) within the Consumables organization is looking for an analytical, driven, and creative leader to drive strategically important operational & technical initiatives through business intelligence, analysis & insights. • 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 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 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 client 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 busines Story Behind the Need – Business Group & Key Projects • Business group: data analytics for subscribe and save feature for client, subscribe for reoccurring items on a specific timeline, provides the data analytics for SnS Business with client 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 • 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 Selling Points: • Client's Subscribe & Save (SnS) program ($20+ billion in revenue) • High touch from vendors and customers, huge impact on business Leadership Principals: • Customer Obsessed, Earns Trust, Job 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 client 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 employee 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 client Quicksight) • +2-5 years of experience working with large-scale complex datasets • Background (academic or professional) in statistics, programming, and marketing (masters preferred) TekWissen® Group is an equal opportunity employer supporting workforce diversity. porting workforce diversity.