BI Support Analyst

| Chicago

About Camelot Illinois

Camelot Illinois operates the Illinois Lottery, a modern enterprise that truly benefits the people of Illinois. We place consumers and social responsibility at our core, providing funding for schools, capital projects and special causes. We are a progressive organization that is reinforcing the lottery’s rightful position as a force for good alongside the State of Illinois.

Camelot Illinois is a subsidiary of Camelot Lottery Solutions, a leading solutions and technology provider to lotteries around the world. Camelot Lottery Solutions digital and data platforms, and services power some of the most innovative and fastest growing lotteries in the world including the Irish and UK National Lotteries, Loterie Romande (Switzerland), and the Arkansas Scholarship Lottery.

Our sister company, Camelot UK, has operated the UK National Lottery since 1994. Camelot UK has an unrivaled track record for success, helping the UK National Lottery deliver over $80 billion to winners and $46 billion to good causes to date.

About the Team:

The Technology team utilizes the latest technological trends to effectively build and manage solutions in an informal, open and collaborative environment.

Position Overview:

The BI Support Analyst is responsible for providing 1st line support for users of our Business Systems. The role will work in a collaborative team environment and be responsible for addressing clients’ BI issues and providing advice and training on BI systems.

Success in the role will see you as becoming the technical expert in the solution ensuring that business users from Camelot, the state of Illinois, and our vendors get the maximum value out of our systems. You will quickly address any minor issues and be the conduit for escalation and coordination of fixes to the systems.

Responsibilities:

  • Provide 1st line support for Big Data Platform, CRM and Analytic Applications.
  • Provide BI application support to clients, vendors, and employees supporting new projects from development all the way through to production.
  • Work with vendors and 2nd and 3rd line support teams to resolve complex issues such as:
    • Issues with data feeds coming from our suppliers
    • Reporting discrepancies within and between systems
  • Track and manage performance and production issues
  • Address business intelligence queries and issues in a timely fashion.
  • Assist in design and generation of reports in a timely and accurate manner
  • Monitor and optimize performance and make recommendations for functional and non-functional improvements.
  • Create and maintain documentation for all business intelligence processes and software

Requirements

Required:

  • Bachelor’s Degree or equivalent work experience required in a quantitative field
  • 1-3 plus years of related experience.
  • Experience working with Data Warehouse technologies and understanding of data models.
  • Experience working with and creating data visualizations
  • Writing queries in SQL/PostgreSQL
  • Proficient in Excel: manipulating and reformatting data, pivot tables, advanced formulas, and data structure in the context of spreadsheets
  • Strong analytical skills. Collect and research data; Use intuition and experience to complement data.
  • Strong problem solving skills. Identify and resolve problems in a timely manner; Gather and analyze information skillfully; Develop alternative solutions; Work well in group problem solving situations; Uses reason even when dealing with emotional topics.
  • Customer service focused. Manage difficult or emotional customer situations; Respond promptly to customer needs; Solicit customer feedback to improve service; Respond to requests for service and assistance; Meet commitments.
  • Self-motivated, action-oriented, multi-tasking individual with a great sense of urgency and follow-through
  • Independent and flexible, with solid communication skills and strong customer focus.
  • Quick to adapt new processes and technologies

Preferred:

  • Technical writing abilities—being able to convey technological concepts to less technical audiences
  • Working with BI software such as Qlik, Tableau, or Spotfire
  • Experience in ranking prioritization of multiple initiatives
  • Experience working with remote teams
  • Experience of Big Data technologies such as Hive and working with semi structured data e.g JSON.
  • Understanding of IT security concepts.
  • Passion for data and continuous quality improvement.
  • Some exposure to system management and reporting systems is an advantage e.g. SNMP/IBM Tivoli/Sitescope.
  • Understanding of access rights and permissions.
  • Ability to login to host, navigate to appropriate area of file system.

Benefits

Working For Camelot Illinois

We are a transformative lottery company with world-class people, technology, and operations that is committed to powering possibilities--for our employees, our partners, and our consumers. With grit and determination we believe in doing not just the easy thing but the right thing. The Camelot values of do good, be accountable, stay connected, keep improving, and spark enthusiasm are embedded in the design of our organization and our plans for Illinois.

  • Do Good: We care about our communities, our stakeholders, and each other. We act with integrity & honesty, as a positive force for Illinois.
  • Be Accountable: we drive results. And we continually strive to get those results more efficiently and effectively.
  • Stay Connected: Being open, honest, and collaborative is what makes us, us. This is embodied in our messaging and communications and in how we treat each other.
  • Keep Improving: We’re hungry to be better. We innovate and evolve our business, our teams, and ourselves, always with an eye on professional and personal growth.
  • Spark Enthusiasm: We incorporate energy and laughter into every aspect of our work to create positive and entertaining experiences.

Career Development

We want people who thrive in an autonomous, collaborative and results-driven environment to join our company. We believe the way to attract and retain the best talent is to offer a fulfilling experience and meaningful work in an organization committed to growing its people. Learning & Development is a top priority, and we partner with employees to grow and progress their professional skill sets.

Benefits and Employee Policies

We bring our experience of working with European lotteries to Illinois. We also bring a European influence to paid time off, family leave and so on. We have created a strong ethical culture that is translated to each of our employees and business dealings globally. We offer a package of benefits and policies that competes with any private sector employer in the state. We ensure that every employee is engaged and has the necessary support to understand and implement the responsible gaming principles at work.

Moreover, we pledge to have the highest standards of respect, diversity and inclusion at our company and support and encourage our partners to do the same.

Camelot Illinois is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics.

Read Full Job Description
Apply now

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • PythonLanguages
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • InDesignDesign
    • ConfluenceManagement
    • JIRAManagement
    • Microsoft ProjectManagement
    • OnePlaceCRM
    • iLookCRM
    • Adobe CampaignLead Gen
    • MarketoLead Gen

Location

Chicago’s official downtown. From shopping on State Street to wandering one of the country's largest art museums, the Loop has something for everyone.
A Good Game: Private Lotto Manager Camelot Illinois Gives Back to Causes, Community
Watch

An Insider's view of Camelot Illinois

What are some social events your company does?

Managing the Illinois Lottery takes a lot of hard work but we have a great People team that find things to let us unwind and encourages us to find fun too. We have weekly happy hours, on-site weekly yoga, team building events, department engagement events, sports leagues, and annual parties! We even have a knitting club now!

Will

Commercial Financial Analyst

What projects are you most excited about?

My time at Camelot has been very rewarding as I had the opportunity to be a part of our new website and app's launch this past year. I'm most excited about now working on how we can improve our digital experiences for our players. I really enjoy the collaborative nature of the Digital team as we all work together really well to achieve our goals.

Sean

Digital Content Manager

What are some things you learned at the company?

Some of the things I have learned during my time here at Camelot is how to own and take charge of my career. Since I have started, I have been provided with the best tools and resources to achieve optimal career success. I have also learned the importance of learning and collaborating with others.

Natassia

Camelot Business Associate

What's the biggest problem your team is solving?

People win the Lottery every day. From a return on the price of the ticket to $1,000 to $200 million, every dollar makes a positive impact on winners lives, and, in return, to the citizens of the state. We are working to restore faith in the Illinois Lottery and reassure Illinoisans that players do win.

Wendy Abrams

Senior Director of Corporate Affairs

What are Camelot Illinois Perks + Benefits

Camelot Illinois Benefits Overview

We offer a broad range of employee benefits including medical, dental, vision, life, and disability insurance, a retirement savings plan, access to training, Student Loan Repayment Benefit, Personal Discounts Program, Employee Assistance Program, and much more. We also offer regular team-building activities with people that love having fun, quarterly opportunities to connect with the community, social outings, & great work/life balance. We all have flexible hours, 26 days PTO, 6 weeks paid parental leave, 10 paid holidays, & 2 paid volunteer days.

Culture
Volunteer in local community
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Highly diverse management team
Unconscious bias training
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Camelot IL offers both FSA & HSA which helps employees cover out-of-pocket expenses with pre-tax contributions.
Disability Insurance
Camelot IL's disability insurance benefits is 60% of an employee's annual salary up to a $5,000 maximum monthly payout. Employees also have the option to purchase extra coverage.
Dental Benefits
Camelot's dental plan covers 100% of the costs of preventative care.
Vision Benefits
Camelot's vision insurance plan provides 100% coverage for annual eye exams after a $10 copay. $180 for frames and $150 for contacts every year.
Health Insurance Benefits
Life Insurance
Camelot IL offers employer-paid life insurance to all full-time employees with 2x an employee's annual salary.
Wellness Programs
Onsite Gym
Free onsite gym, divvy bike membership, yoga classes, meditation workshops, & in-house chair massages.
Team workouts
Camelot Illinois's team fitness initiatives include weekly In-office yoga.
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Camelot's 401(k) retirement plan matches 100% of an employee's contributions up to 4% of their annual salary, with immediate vesting for matched contributions.
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Family is of the greatest importance and we want our employees to have adequate time off to care for and bond with a newborn, newly adopted or newly placed child. Camelot IL offers 6 weeks of time off
Flexible Work Schedule
Camelot Illinois provides employees with a flexible work schedule that includes Flexible start and end times.
Family Medical Leave
Employees who have been with the company for 12 months are eligible for 12 weeks of family medical leave.
Company sponsored family events
Acme co. sponsors family oriented events Annually.
Vacation & Time Off Benefits
Generous PTO
At Camelot IL, we recognize the importance of time off from work to relax, spend time with family, enjoy leisure activities, take care of yourself when you are sick, etc. We provide generous PTO.
Paid Volunteer Time
Camelot Illinois is committed to supporting our communities and provides employees 2 paid days per calendar year to volunteer at the nonprofit organization of their choice.
Paid Holidays
Perks & Discounts
Casual Dress
We call our dress code “Dress For Your Day,” which means you choose the attire that fits your schedule, environment, location, and personal brand.
Commuter Benefits
Qualified Transportation Accounts - QTAs allow employees to set aside pre-tax funds used for eligible transit and parking expenses related to commuting to work.
Company Outings
Some Meals Provided
Happy Hours
Happy hours are hosted by the building once per week.
Recreational Clubs
Professional Development Benefits
Job Training & Conferences
Camelot IL offers a wide range of training programs to all employees, including, eLearning, onsite training courses to enhance job-related skills and access to job-related conferences and seminars.
Tuition Reimbursement
Camelot Illinois offers a Student Loan repayment option to all employees after 90 days.
Diversity Program
Lunch and learns
Acme Co. hosts lunch and learn meetings once per month.
Cross functional training encouraged
Promote from within
Continuing Education stipend
We offer every team a Learning and Development budget to continue taking classes, getting certifications, or attending conferences and seminars.
Time allotted for learning
Camelot Illinois allows employees to set aside 10% of working hours for learning.
Online course subscriptions available
Paid industry certifications

Additional Perks + Benefits

Free onsite gym + divvy bike membership, immediately vested in 401k with 4% match, Student Loan Repayment benefit, Camelot Champions & Game Changer staff awards, a rotational program for recent grads, engagement portal for pre-boarders, robust onboarding program + large L&D budget

More Jobs at Camelot Illinois5 open jobs
All Jobs
Data + Analytics
Operations
Sales
Data + Analytics
new
Chicago
Sales
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago