Business Intelligence Engineer

Job Title: Business Intelligence Engineer II

Location: Bellevue, WA

Duration: 6 Months

Job Type: Contract W2

Work Type: Hybrid

Job Description:

• We are looking for an innovative, highly motivated and experienced Sr. BIE who can think holistically through multidimensional problems to understand how systems work together to identify and execute both tactical and strategic projects which drive improvements to DSP programs.
• You will work closely with engineering teams, product managers, program managers, business coaches, business development manager and org leaders to deliver end-to-end data solutions aimed at continuously enhancing overall business health of DSP programs.
• In this role, you will dive deep into disparate datasets to improve our understanding of various components involved in Last Mile delivery, build decision-driven analytics that systematically track the overall quality of the DSP business and program health, improve tooling to reduce cognitive load for data consumers, and extract actionable insights to drive program, product, value added service (VAS) offering changes .

Key Responsibilities:

• Build high quality data architecture and ETL data pipelines using SQL, Scripting and other ETL tools.
• Retrieve and analyse data using a broad set of client's data technologies (ex. Redshift, AWS S3, Internal Platforms/Solutions) and resources, knowing how, when, and which to use.
• Design, build, and maintain automated reporting, dashboards, and ongoing analysis to enable data driven decisions across our team and with partner teams.
• Report key insight trends using statistical rigor to simplify and inform the larger team of noteworthy trends that impact the business.
• Work closely with business stakeholders and leadership team to define the analytics roadmap and structure of our data solutions
• Manage and execute analytics solutions end-to-end including project management, data gathering and manipulation, modelling, problem solving, and communication of insights and recommendations.
• Earn the trust of your customers and stakeholders by continuing to constantly obsess over their business use cases and data needs and helping them solve their problems by leveraging technology.
• Be connected and influential within the BI and DE community. Work with data engineering and software development teams to enable the appropriate capture and storage of key data points. Mentor junior BI engineers.

Job Qualifications:

• 3+ years of analysing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• Experience with data visualization using Tableau, Quick sight, or similar tools
• Experience with data modelling, 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 modelling

Story Behind the Need Business Group & Key Projects

• DSP Analytics Team
• The goal of client's DSP organization is to exceed the expectations of our customers by ensuring that their orders, no matter how large or small, are delivered as quickly, accurately, and cost effectively as possible.
• To meet this goal, client is continually striving to innovate and provide best in class delivery experience through the introduction of pioneering new products and services in the last mile delivery space.

Typical Day in the Role

Day to day

• Write SQL and build dashboard
• Conduct data analysis and deep dives
• Document existing processes and the new solution that they will build
• Work with stakeholder to understand their data needs.

Ext/conversion

• possibly for high performer

Compelling Story & Candidate Value Proposition

• High vis, challenging but rewarding work

Candidate Requirements

LPs:

• Ownership and Deliver Results.
• Should be self driven.

Qualifications

• 3+ years of analysing and interpreting data with Redshift, Oracle, NoSQL etc.experience
• Experience with data visualization using Tableau, Quick sight, or similar tools
• Experience with data modelling, 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 modelling

Top 3 must-have hard skills

• Strong SQL
• Analyzing and Interpreting data from database , Excel etc.
• BI Tools (building dashboard on tools like Quicksight/Tableau)