Data Analyst

About the role

The Reporting Analyst will provide rapid solutions to the ASCO organization giving them data insights through a process of continuous discovery and will work with a wide range of solutions and technologies applicable to the current environment using data visualizers, data transformational tools, native reporting tools within applications, Machine Learning etc. The analyst will develop, maintain, and improve data delivery through the North America Data Warehouse platforms. The right person in this role will support overall improvements in data architecture, metric definition and agile processes to support business data and analytical initiative and continuously monitor developments within the broad area of Analytics and look for opportunities to apply them to the company and department goals.

Key responsibilities

• Collaborate with team members with a flexible approach to conceptualize, design, and deliver enterprise and departmental data solutions to support business intelligence, data warehousing, reporting requirements
• Translate business requirements into data pipelines and data stores to support business needs
• Create visualizations using Business Intelligence tools like Tableau, in application reporting services and ETL Tools like Alteryx, SSIS
• Work with Data and Solution Architects to define and implement migration strategies from legacy systems to cloud architecture and technologies
• Automation, standardization, optimization and delivery of solutions with focus on data integrity and governance
• Manage various databases and ETL tools to extract and manipulate data from disparate sources e.g.: SQL Server, MySQL, Oracle, Redshift, Alteryx, and SSIS
• Perform detailed data analysis to determine the structure, content, and quality of the data through examination of source systems and data samples
• Operate with Data Warehouse team to develop data models and other structures to enable fast and easy business user access to data
• Gather and analyze requirements while working with business to develop executive, management, and team data analytics
• Work collaboratively with Business Systems Analysts, Business Data Stewards and key business users to ensure data quality, business requirements and dashboard KPIs are documented accurately and completely

About you

• Bachelor's/Master's degree, preferably with a concentration in Information Systems, Data Analytics, Computer Science, Engineering
• 5+ years relevant experience in Reporting and Analytics
• Command of advanced SQL queries and programming
• Strong Tableau data visualization skills (2-year experience preferred) with advanced-level skills with action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions, and table calculations
• Ability to work independently yet collaborates cross-functionally in a team environment
• Ability to adapt to rapidly changing priorities in a positive manner
• Strong customer service skills, and ability to remain calm and positive in a fast-paced environment
• Confident with learning new tools, technologies, and methodologies
• Excellent communication and follow up skills
• Strong analytical, quantitative, problem solving, and organizational skills with attention to detail