Business Intelligence Engineer

Description:

Scope of work:

Project Management Services Automated Fulfillment Initiative

• Create and conduct a weekly business review for visibility into program performance. Provide recommendations on program optimization.

• Identify root cause drivers of AF and FPA metric misses and produce a minimum of 1 finding report per month.

• Required Clean-up of dashboards or data tables that are negatively impacting the AF and FPA metrics.

Capacity Delivery

• Create a weekly business review for visibility into program performance. Provide recommendations on program optimization.

• Identify root cause drivers of capacity delivery metrics misses and produce a minimum of 1 finding report per month.

• Required Clean-up of dashboards or data tables that are negatively impacting the capacity delivery metrics.

Weekly Business Review(WBR)report: Generate a weekly report for Automated Fulfillment (AF) and Fulfillment Planning Accuracy(FPA) initiatives. This involves the following tasks: a) Generating reports for specific metrics. b) Reviewing dashboards/running queries to bridge actual performance vs. goal. c) Update on expected/realized improvement from ongoing and launched projects. c) Tracking action items. d) Following up with program owners/action item owners to providing status updates

Deep dives: Conducting weekly deep dives to root cause drivers of AF and FPA metric misses, and summarizing findings

Data quality issues: Responsible for identifying issues in dashboards or data tables that are negatively impacting the AF and FPA metrics and partnering with SCos-BI teams to resolve the issue.

Being able to delivery the servers so end customer can use them, scale and deliver the compute power, whether we are meeting customers needs, able to delivery capacity, promise dates, a problem of timing, deep dive on what happen

Weekly defects, misses, monthly basis VP, reports summarizes findings

At a high level there are 2 main types of support they need – 1 is simple data analysis support with tables they have they receive questions all the time and need weekly analysis around why data is trending one way or another. 2nd one is more project delivery to support their product work; they need additional dashboards/views to be built out. It’s not simply just a front end layer of a dashboard, some require ETL and data manipulation where there are a couple of broad tables transformed and joined into a diff way to view in dashboards.

Like any big initiative/ likes to be data drive – building metrics/pipelines, maintaining dashboards. Their weekly views for weekly meetings have been stale/broken and no one can look into it. They want to create a new goal but need the view – need data analysis to use specific views to try things.

Skills:

data analysis, dashboard, metrics, pipelines, ETL

Top Skills Details:

data analysis,dashboard,metrics,pipelines,ETL

Additional Skills & Qualifications:

2 roles – They typically L5 and L6; expectation would change depending on what they would hire for Since its 2 – we could do L4 and L6 too; L6 could be more of a lead and the L4 could do more of the “doing” or have 2 L5s or 2 L6s

Needs someone strong in data analysis, could e as simple as excel/SQL and grab data from data sources to do analysis for data. Also someone who could build data models, they have lots of raw data tables, seeking someone who could gather data and pivot to build new dashboards to build a new version of data/ETL.

Years of exp: 3-5+ years

SQL:

Less savvy one would know simple select queries

2nd one more advanced would need to create tables and be a lot more advanced, duplicate entries, complex joins

Excel: pivot tables/vlookups/basics

Experience Level:

Intermediate Level