BI / CRM Application Support Analyst

Camelot Illinois Chicago , IL 60606

Posted 2 months ago

About Camelot Illinois:

Camelot Illinois has been selected by the State of Illinois to be the private manager for the Illinois Lottery. The company is restoring transparency, integrity and responsibility to the Illinois Lottery. In partnership with the State, Camelot will operate a modern lottery that truly benefits the people of Illinois. The companys innovative approach places consumers and social responsibility at its core, providing funding for schools, capital projects and special causes. Camelot is committed to building an organization with the strength and experience to grow the lottery and reinforce its rightful position as a force for good.

Camelot Illinois is a subsidiary of Camelot Global, a leading technology and professional services provider to lotteries around the world. Camelot Globals portfolio of work includes the Irish National Lottery, Loterie Romande, the California State Lottery, the Kentucky Lottery, the Arkansas Scholarship Lottery, among others.

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.



Camelot Illinois is investing in best in class analytics across their retail and online business. The systems deployed cover a real time big data platform in AWS, Qlik Sense for analytics, Open Source Data Science and the full stack Adobe suite for online marketing.

The BI / CRM Support Analyst role 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 escalating client issues as appropriate, receiving 2nd line support, advice and development from team members.

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


  • Provide 1st line support for Big Data Platform, CRM and Analytic Applications.
  • Work with vendors and 2nd and 3rd line support teams to resolve complex issues.
  • Monitor and optimize performance, and make recommendations for functional and non-functional improvements.
  • Ensure that BI and CRM systems have the capacity and performance levels to meet demand.
  • Provide 3rd-line support to Operations, Live Support, and other internal stakeholders to maintain system integrity and system up-time targets.
  • Deliver improved levels of service to internal groups by endeavouring to meet and exceed SLA's.
  • Provide BI and CRM application support and expertise to Camelots development and test teams, supporting new projects from development all the way through to production.
  • Improve and document the technical processes around support.



  • Bachelors Degree or equivalent work experience required
  • 2 plus years of related experience.
  • Experience working with Data Warehouse technologies and understanding of data models.
  • Experience working with an ETL tool. (example of tools include: BODS, SSIS or ideally Talend, etc...)
  • Strong analytical skills. Collect and research data; Use intuition and experience to complement data; Designs workflows and procedures.
  • Strong problem solving skills. Identify and resolve problems in a timely manner; Gather and analyze information skilfully; 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.


  • Experience of Big Data technologies such as Hive and working with semi structured data e.g JSON.
  • Ability to login to host, navigate to appropriate area of file system.
  • Understanding of access rights and permissions.
  • Some exposure to system management and reporting systems is an advantage SNMP/IBM Tivoli/Sitescope.
  • Passion for data and continuous quality improvement.
  • Independent and flexible, with solid communication skills and strong customer focus.
  • Understanding of IT security concepts.


Working For Camelot Illinois

Camelot Illinois is building a transformative lottery company with world-class people, technology and operations. The Camelot values of being honest, creating together, keeping it simple and thinking long term are embedded in the design of our organization and our plans for Illinois.

  • Be Honest: We do what we say, we keep our promises and we dont rest until weve earned each others respect
  • Create Together: The most effective solutions come from strong collaboration, a culture of innovation, shared goals and respect for everyones expertise.
  • Keep It Simple: We keep things simple, direct and transparent so customers in particular always know where they stand.
  • Think Long Term: We work with customers to build successful lotteries for the next generation, not just the next day.

Career Growth

We want people who thrive in a relaxed, autonomous, results-driven environment to join our company. We believe the way to attract and retain the best talent is to offer a fulfilling career in an organization committed to growing its own future leaders. Career Development is a top priority and we will partner with employees to grow and progress their professional skill sets.

Benefits and Employee Policies

We will bring our experience of working with European lotteries to Illinois. We will also bring a European influence to paid time off, family leave and so on. We have created a strong ethical culture which is translated to each of our employees and business dealings globally. We aim to offer a package of benefits and policies which will compete 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 in their job.

Moreover, we pledge to have the highest standards of respect, diversity and inclusion at our company and will 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.

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Application Support Analyst

Societe Generale

Posted 3 days ago

VIEW JOBS 11/12/2018 12:00:00 AM 2019-02-10T00:00 Environment The Information Technology Department (ITEC) has worldwide responsibility for supplying Global Banking and Investor Solutions (GBIS) Divisions with the IT resources necessary for them to operate under competitive conditions in terms of technological standards, service quality and cost. ITEC is composed of diverse and talented professionals who translate ideas into action every day by combining the strength of its expertise in IT with a deep understanding of the investment banking business and regulations. ITEC has a threefold responsibility as follows: (1) Deliver innovative IT Solutions that enable GBIS to achieve its business objectives. (2) Maintain a highly resilient, flexible, cost effective and well controlled production service for our business applications, systems and infrastructure. (3) Facilitate entry into new markets, compliance with regulatory needs, growth in business volumes and add operational efficiency improvements in our overall front to back processing environment. ITEC achieves this while promoting a collaborative, innovative, and fun environment for its IT professionals. Mission Responsibilities: * Actively monitor production applications and promptly report and troubleshoot incidents * Provide functional and technical contribution to produce and promote maintainable and quality solutions. Includes documenting system requirements and documentation of support run book * Actively review production status with end-user * Actively participate in the on-boarding of new applications * Communicate with users regarding application outages and upcoming events like release, project * Understand regulatory environment and constraints * Respond to end users within timeframe dictated by the severity of the problem, document and track (case histories, issues, and action steps) * Respect internal IT norms, standards and processes * Timely reporting of production and project status to client and IT management * Partner with development team and GTS team on release management * Partner with the Global support teams to ensure quality support to our end users * Provide a customized training to end users * Participate 2x per year applications disaster recovery and document test results Profile Competencies and Experience Technical Skills: * Knowledge in SQL and able to write DML scripts * Knowledge on Client/Server application design and architecture * Comfortable working on Unix Solaris, Linux and Windows environments * Experience working with relational databases * Competence in using Microsoft Office applications (e.g. Excel) * Experience/knowledge in File Transfer Desired / Plus: * Understanding MQ Series * Knowledge with Business Objects or Tableau * Development Experience in SQL or PL/SQL Competencies: * Possess a good balance of technical expertise, business knowledge and soft skills. * Detail-oriented and organized * Strong analytical skills, follow-up capability and problem solving ability. * Can communicate clearly with a wide variety of people/functions (verbal/written) * Flexible and adaptable to new environments. Quickly learn new systems/products. * Proactive and results-oriented: sets goals and priorities that maximize the use of resources to deliver optimal results. * Team-oriented, client-focused and open to different ideas/viewpoints. * Capable of prioritizing tasks and multi-tasking projects. * Thrive in a high-pressure and time-sensitive environment. * Possess SDLC application design knowledge/experience Desired/Plus: * Knowledge on Capital Market and Investment Banking Activities Experience Needed: * 2+ years of experience in a technology environment Desired / Plus: * Experience working in a global/international financial IT environment * Practical experience in the financial industry (i.e., FO, MO, Risk, Compliance or Accounting) Educational Requirements: * Bachelor degree in Information Technology, Computer Science, Finance or relevant technical field Desired / Plus: * Master degree in Information Technology, Computer Science, Finance or relevant technical field Societe Generale Chicago IL

BI / CRM Application Support Analyst

Camelot Illinois