Primary Duties and Responsibilities:
- Create and maintain on-demand, ad-hoc and scheduled dashboards, reports and data extracts
- Gather and consolidate data from multiple sources and correlate into insightful information and reports for high-level analysis
- Work with end users to gather requirements, identify and understand discrepancies, perform troubleshooting, and resolve issues
- Identify opportunities to automate recurring requests for reports and data
- Optimize reports and data extracts by tuning SQL queries, ensuring data sources are properly indexed, and other optimization techniques
- Validate data and proactively identify potential data issues (inconsistencies between sources, missing/incomplete data, etc.)
- A successful candidate will perform these duties with minimum supervision and assistance
Skills:
- Minimum five years solid experience in creating reports using Microsoft SQL Server Reporting Services SSRS (Required)
- Experience writing Microsoft SQL Server Integration Services - SSIS tasks to generate and distribute reports (Required)
- Expert in Excel and highly adept in analyzing data and creating daily/weekly/monthly reports, including knowledge of vlookups, pivot tables, graphs, and linked data (Required)
- Ability to write and optimize complex queries in SQL (Required)
- Ability to visualize complex quantitative data in a simple, intuitive format and to present findings in a clear and concise manner (Required)
- Experience using Tableau or similar BI tool (Required)
- Experience using Amazon Redshift or other columnar-based storage (Desired)
Education and Experience:
- Bachelor's degree in any computer science or data analytics related field
- At least 5 years of working experience in data analysis and/or creating reports
- Detail and task-oriented with a strong work ethic and ability to work independently in a deadline driven environment
- Willing to work on the night shift schedule
- Excellent oral and written communication skills
