Jr. Business Analyst Jobs

Overview:

You are analytical and methodical about data management and a determined problem solver looking for an entry level role with a growing organization. You are comfortable working in a multi-faceted role that allows you to work closely with a variety of ARTA staff.

You will support and optimize ARTA’s existing information systems and provide input into future revisions and development of new systems.This position will be responsible for assisting the Sr. Business Analyst in the administration of multiple integrated information systems. These systems include but are not limited to the following: Microsoft SQL Server, Report Builder, BC365, CRM365, Office365, Sharepoint, Docuware, PowerBI and BusinessConnect/Ring Central.

Life at ARTA:

The Alberta Retired Teachers’ Association (ARTA) is a vibrant organization made up of 30,000 retired educators and likeminded professionals and served by an equally as engaged team of staff. Created by teachers, we are an Alberta-based non-for-profit linked by a common purpose – to ensure a healthy, active, engaged, and vibrant lifestyle for our members in their retirement.

Our culture encourages our members and our employees to live an enhanced quality of life. Our office perks include a staff wellness program, generous time off, and continuing learning opportunities. This culminates in a workplace where we can thrive together.

A rapidly growing organization, ARTA provides an environment where individual contribution is expected and teamwork is encouraged, and where our core values are of the utmost importance. If you have a strong passion for making a difference in people’s lives, are a creative team player, and enjoy building strong relationships with those around you, then we invite you to apply to join our exciting organization.

What you will do:

• Analyze the design of current systems and applicable business models.
• Optimize existing databases and recommend improvements for performance efficiency, while ensuring integrity, consistency, security, and privacy.
• Participate in design and architecture to support application development projects, working with business users to confirm and validate the results.
• Provide support and guidance to outside application developers.
• Perform the extraction, transformation, and loading of data.
• Support the business with testing and training on application resolutions and enhancements, assisting with the development of test plans and test scripts.
• Provide end-user support coverage by responding to user queries, trouble shooting systems, and solving technical problems, as required.
• Provide operational reporting as required.
• Logical and physical data modeling for enterprise data warehouse.
• Provide data analysis to inform business decisions and provide business insights.
• Provide application support by analyzing problems.
• Ensure the integrity and quality of systems data.
• Research, source and support the implementation of new systems.
• Contribute to the ARTA team by performing other duties as assigned.

What you will have:

• Experience as a Database Developer and/or Report Developer.
• Experience with Microsoft Report Builder, Power BI, or other data visualization tools.
• Experience working with or an understanding of Smart Connect.
• 1 – 5 years of experience in a related field.
• Diploma or Degree in Computer Science, Information Systems or equivalent.
• Experience with or exposure to Microsoft SQL Server (SSIS, SQL interpretation tools, T-SQL queries, stored procedures, views, triggers, indexes, scripting, database tuning, etc.).
• Experience working with Office365, BC365, Dynamics CRM and SharePoint.
• Understanding of multidimensional data stores and data modelling.
• The ability to write a query that does ALMOST anything.

Required Attributes:

• Ability to collaborate while taking accountability.
• Ability to proactively address challenges and find solutions.
• Great communication skills and the ability to manage time efficiently.
• A commitment to lifelong learning and continual self improvement.
• Willingness to be a team player and demonstrate strong interpersonal skills.
• Pride in performance and its impact on the success of the association.
• Must be a quick and independent learner.
• Ability to demonstrate critical thinking, analytical and problem solving.
• Dedicated to improvement and consistently on the lookout for new ways to benefit the association.