Creating tools and dive deeps in cooperation with operational,and technical teams across the organization to identify opportunities, develop sound business cases and drive measurements of actions to continuously improve on the inputs and ultimately the outputs of the business.
• Working with large volumes and big data, in a highly complex business.
• Working with business intelligence tools, accessing and working with big data from multiple sources, and partnering with the business to identify strategic opportunities and deliver results
Understand the various operations across OTS
• Design and develop highly available dashboards and metrics using SQL and Excel/QuickSight
• Understand the requirements of stakeholders and map them with the data sources/data warehouse
• Own the delivery and backup of periodic metrics, dashboards to the leadership team
• Draw inferences and conclusions, and create dashboards and visualizations of processed data, identify trends, anomalies
• Execute high priority (i.e. cross functional, high impact) projects to improve operations performance with the help of program managers
• Perform business analysis and data queries using appropriate tools
• Work closely with internal stakeholders such as business teams, engineering teams, and partner teams and align them with respect to your focus area
• Execute analytical projects and understanding of analytical methods (like ANOVA, Distribution theory, regression, forecasting, Machine Learning Techniques, etc.)
Key job responsibilities
Key job responsibilities
1)To perform Data deep-dives-Working with data derived from various tools involving service operations, Finance and supply chain domains
2) To develop automation solutions, Automated reports and dashboards as part of key transformational and strategic programs
3) To drive governance metrics, controls and internal reviews
4) To drive cross functional action items through consistent and sustained engagement with various stakeholders
5) To gain and maintain relevant access and skills over BI Tools, OTS tools and operational dashboards which complement program execution.
6) To write, review and publish necessary documentation in line with amazon's standards- or writing various document formats.
- 2+ years of complex Excel VBA macros writing experience
- Experience defining requirements and using data and metrics to draw business insights
- Experience with SQL or ETL
- Should have 2+ years of experience in requirement elicitation and business requirement documentation. Should have strong stakeholder communication skills
- Experience creating complex SQL queries joining multiple datasets, ETL DW concepts
- Experience using very large datasets
- Should have hands on experience in developing QuickSight dashboards