Business Intelligence Engineer, OTS-Service Desk

Operations Technology Solutions (OTS) data team is looking for a Business Intelligence
Engineer to join our team. The BI Engineer is expected to drive the analytics front of our
key business projects, come up with insights on key metrics, engage with stakeholders to
earn trust and merge data intelligence efforts centrally and globally.
The resource would be heavily engaged for a new data management platform wherein
he/she would be working on complete packaging and product design of data as products.
The resource would be working on metrics delivery for the business yet heavily involved in
visualizing and designing the end solution on amazon internal tools or third party platforms
to meet the LT goal of ODI marketplace. Leveraging their knowledge of product &system
design and cloud services they would help in creating and deploying end to end solution .
This resource would also be working on Total Cost of Ownership and Strategic
Transformation Projects with the business. The key responsibilities areas would include
metrics definition, logic creation, pipeline deployment, visualizations and stakeholder
management. He/she would engage closely with the business partners to solicit ideas,
identify pain points and define business KPIs that would help the leadership and executive
teams to monitor and regulate the services better.
The right candidate will be working with large datasets, data visualization, automation and
will enable bringing data forward to answer complex business questions that deepen our
understanding of our business drivers. This role requires an individual with excellent team
leadership and communication skills, analytical modeling skills, and the ability to work
across teams including Data Science, Software Dev, Product Management, Demand
Planning, Supply Planning, Marketing and Finance to drive business outcomes
Key job responsibilities
• Design, development and ongoing operations of scalable, performant data warehouse
(Redshift) tables, data pipelines, reports and dashboards.
• Development of moderately to highly complex data processing jobs using appropriate
technologies (e.g. SQL, Python, Spark, AWS Lambda, etc.)
• Development of dashboards and reports.
• Collaborating with stakeholders to understand business domains, requirements, and
expectations. Additionally, working with owners of data source systems to understand
capabilities and limitations.
• Deliver minimally to moderately complex data analysis;
• Actively manage the timeline and deliverables of projects, anticipate risks and resolve
issues.
• Adopt best practices in reporting and analysis: data integrity, test design, validation, and
documentation.
• Have understanding of AI/ML and other industry solutions in this space to know when to
apply what to solve business problems.
• Have proven track record of launching new products, solutions and managing projects end
to end.
• Excellence verbal and written communication skills.
• Comfortable wearing multiple hats and go over and above to drive results.
About the team
Basic qualifications
3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc.
experience
Experience with data visualization using Tableau, QuickSight, or similar tools
Experience with data modeling, warehousing and building ETL pipelines
Experience writing complex SQL queries
Experience in Statistical Analysis packages such as R, SAS and Matlab
Experience using SQL to pull data from a database or data warehouse and scripting
experience (Python) to process data for modeling
Preferred qualifications
Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
Experience in data mining, ETL, etc. and using databases in a business environment
with large-scale, complex datasets
Knowledge or AI/ML and Data Science applications
- 2+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience with one or more industry analytics visualization tools (e.g. Excel, Tableau, QuickSight, MicroStrategy, PowerBI) and statistical methods (e.g. t-test, Chi-squared)
- Experience with scripting language (e.g., Python, Java, or R)
- Master's degree, or Advanced technical degree
- Knowledge of data modeling and data pipeline design
- Experience with statistical analysis, co-relation analysis