Job description
Position Summary: The Data Analyst will be responsible for administering the data repository for Analytics and understanding the flow of data from GCC’s Data Warehouse to Analytics and Reporting. This analyst needs to be detail oriented and work toward becoming a Subject Matter Expert on GCC’s Customer File and Analytics data.
Roles & Responsibilities:
- Produce ad-hoc queries and develop reports to support business needs
- Writing relational and multidimensional database queries
- Development and maintenance of the database stored procedures, views and functions
- Design and develop data table structures, forms, reports, and queries for Analytics.
- Work with (Business Intelligence) BI and (Data Warehouse) DW to transition solutions from prototype development to Production
- Debugging, monitoring and troubleshooting Analytics/BI solutions
- Identify inefficiencies in current databases and investigate solutions
- Ensure all database systems meet business and performance requirements
- Creation and maintenance of technical documentation
- Data Validation
Experience & Job Requirements:
- Required: 3-5 years of experience with SQL
- Required: 3-5 years of experience with Tableau BI and Analytics tools
- Knowledge of relational databases (Oracle preferred)
- Job Scheduling and IT Automation Tools (ActiveBatch preferred)
- Experience with BI and Analytics tools (Tableau preferred)
- Strong use and knowledge of Excel (vlookups, pivots, calculations, etc.)
- Proven ability to report out on findings
- Excellent verbal/written communication skills
- Proven ability to work in a fast paced, multi-tasked environment
- Detailed and process oriented. The position requires an excellent grasp of often-changing details
- Bachelor’s degree required
- Preferred skill/tool: Alteryx
As a condition of employment, successful applicants will be required to be fully vaccinated for COVID-19 prior to their start date. Details relating to demonstrating compliance with this requirement will be provided to applicants selected for employment. Applicants who receive an offer of employment who can provide documentation that the vaccine is medically contraindicated or who object to vaccination due to a sincerely held religious belief may make a request for exemption. Grand Circle is an Equal Opportunity Employer.
