Discover

The Opportunity

Moncton, NB
Information Technology
Experienced
Full-time

Reporting to the Manager, BI Application Support, the BI System Analyst leads the development and/or support of assigned system(s). These systems currently include the Oracle BI stack and Microsoft BI stack. This includes researching, consulting, designing, documenting and modifying system documentation and work products throughout the system development lifecycle. This role is the technical system owner and is the technical product “expert” and as such, is expected to mentor others as appropriate.

What you'll do

Responsibilities

  • Develop and maintain functional knowledge and technical expertise of in-house analytics systems and financial system integration.
  • Work with support teams to ensure analytics systems and financial system integrations are available, secure and performing satisfactorily, in compliance with defined Service Level Agreements (SLAs).
  • Lead the creation and maintenance of all system documentation which includes, but is not limited to, BI Requirements, Report Specifications, Data Warehousing Requirements, Interface Specifications, and Data Mapping Specifications.
  • Provide accurate assessments and estimates for project and release plans.
  • Lead the development of data integration, application integration, exposing data to users, reports, dashboards and data visualization that are compliant to the corporate standards of Quality, Operations, and Security.
  • Provide secondary application support to business users and provide training and knowledge transfer to the applicable primary support departments.

What you'll need

Qualifications

  • You have a university degree, community college technology diploma, professional certification or membership
  • You have a minimum 5 years’ progressive experience in BI application development, application integration, data integration, data pipelining, and ETL development.
  • Experience working in a team-oriented, collaborative environment is essential
  • Must possess strong technical data integration and data analysis skills
  • Must have 2 years’ experience with Oracle PL-SQL/ODI or Microsoft TSQL/SSIS
  • Preference will be given for the following:
    • Experience integrating with financial systems (note ALC uses oracle E-Business Suite)
    • Experience using scripting technologies such as Python or PowerShell
    • Experience using Data Lakes
  • Ability to document/maintain report specifications, develop, and test reports/dashboards
  • Must possess strong written and oral skills
  • Ability to exercise discretion and judgment
  • Analytical and problem-solving abilities

We're looking for

Core Skills

Scripting technologies Integrating with financial systems Microsoft TSQL/SSIS Oracle PL-SQL/ODI

A little bit about us

Atlantic Lottery

Our players have been having fun and "dreaming big" since 1976 when Atlantic Lottery started offering lottery games on behalf of the governments of Nova Scotia, New Brunswick, Newfoundland and Labrador and Prince Edward Island. The game options have grown and changed over the years and so has our workforce! Today's Atlantic Lottery has more than 600 employees, who are the heart and soul of our business. We offer everything from dare-to-dream draw games to online bingo; breakopen tickets to sports wagering; and games in social settings and on the internet. With games come winners - big and small wins every day - but the best thing about lottery games is that when you choose to play with us, everyone benefits. 100% of our profits go back into our communities. That feels good! #ProudToBeAL

We are proud, gritty, community-minded, and punch above our weight. Being Atlantic Canadian means that we work hard and we know how to have fun. It also means that we genuinely care for each other as co-workers, neighbours, and friends.

Your best life is waiting in Atlantic Canada. At Atlantic Lottery, we have many roles that allow you to work from any of our four Atlantic provinces. Explore living East:

Are you interested?

Work With Us

Atlantic Lottery delivers a career in a fun and high-performing environment that offers a competitive salary, relevant training, development opportunities and flexible benefits. If you are interested in applying for this position please apply before April 16, 2018.

We thank all applicants for their interest, however, only those selected for an interview will be contacted.