Business Analyst, Data
Trailer M2, Canada
Full Time Entry-level / Junior USD 80K - 118K
Langara College
Langara College, located in Vancouver, B.C., provides university, career, and continuing studies programs to over 23,000 students annually. We offer the largest university transfer program in Canada, with a proven record of student success.Interested in a career at Langara College?
Our employees exemplify Langara's values of excellence, collegiality, innovation and integrity. If you think this position fits your qualifications, we encourage you to apply!
Langara College is located in Vancouver, B.C.: applicants to postings must be located in BC or willing to move to BC to accept work with Langara College. Exceptions to this will be clearly outlined in the event Langara College requires work (or positions to be based) to be performed outside BC or Canada.
Current employee? Apply through Careers in your Workday account.
Job Title:
Employee Group:
Employee Type:
Permanent
Start Date:
End Date (if applicable):
Job Summary:
Under the general guidance of the Project Manager, ERP Process and Testing, the ERP Business Analyst, Data leads the assessment of client legacy data preparation needs in alignment to information technology solutions. This position provides expertise in preparation of legacy systems data through data cleansing, validation, testing, and audit activities. This role works in close collaboration with functional data owners and technical team; and is a champion in ensuring high data quality. The Business Analyst, Data is an integral member of the Student Projects and Improvement team, has a strategic perspective and a broad-based understanding of business operations whilst integrating with an enterprise solution.
We are seeking an ERP Business Analyst, Data passionate about Data and Analytics, Data Science, and Machine Learning, with exceptional analytical thinking, superb communication, and a positive customer service attitude to join our team. Experience in analysing large data sets to identify and resolve issues and experience in developing and implementing data cleansing plans is critical. Experience with ERP systems is preferred. Experience with Ellucian Banner Student is preferred. Experience in higher education or public sector is an asset. Knowledge of student life cycle processes in higher education environment is an asset.
Job Description:
Core Duties:
Leads the assessment of client needs utilizing a structured requirements process (gathering, analyzing, documenting, and managing changes) to identify business priorities and recommends options to prepare legacy data.
Identifies, elicits, and documents business requirements, defines business rules and communicates requirements for the implementation of business solutions with regards to preparing legacy data.
Communicates with stakeholders of varying technical ability and subject matter expertise.
Conducts workflow and gap analysis for data cleansing requirements.
Performs analysis and identification of requirements for data.
Works closely with Functional Workstream, Technical Workstream and other stakeholders in implementing data quality improvements, documenting agreements, and discussions with data. Position is privileged to highly sensitive information relating to business or technological changes.
Provides consultative services for the development of policies and procedures.
Analyzes metrics to ensure for client satisfaction.
Provides input and recommendations to feasibility studies for standard development projects and enhancements.
Provides technical guidance and leadership to less-experienced individuals.
Prepares functional, system and program specifications with regards to data.
Develops and implement data cleansing plans describing the overall approaches to resolve data integrity and quality issues in preparation for data conversion.
Documents data cleansing requirements in collaboration with the technical and functional teams for the development of data extracts.
Develops and implement data cleansing maintenance plan to keep the data clean post cleansing.
Develops validation reports and/or setup validation tool to monitor the ongoing data quality.
Conducts ongoing data quality audits to uncover trends and anomalies and develop actionable insights
Where data cleansing is not possible in the legacy system, document all data that cannot be cleansed prior to data conversion.
Supports the data conversion including quantitative and qualitative validation of converted data.
Conducts data analysis using statistical software, databases querying, spreadsheets and various reporting tools, and visualization tools.
Contributes to the development of data management procedures, processes, standards and data governance framework.
Prepares status reports to summarize findings communicate to client.
Maintains appropriate professional designations and up-to-date knowledge of current information technology techniques and tools.
Acquires and maintains working knowledge of the College's technical and business environment.
Builds and maintains good working relationships with project teams, business analyst peers, stakeholders, and vendors
Analyses the impacts of proposed changes to technology services and or processes within the College community.
Performs other related duties as required.
Education & Experience:
Undergraduate degree in a relevant discipline.
A minimum of 5 years of data analysis experience, with in-depth knowledge of applications and the business requirements supporting them.
An equivalent combination of education and experience may be considered.
Considerable knowledge of project management, quality assurance and change management disciplines.
Experience in software implementation projects in a business analyst role with focus on data is preferred.
Proven knowledge and expertise with legacy data migration including data analysis, data cleansing, data verification, data auditing, data extraction and data modelling (conceptual, logical).
Strong knowledge of business process mapping, improvement/optimization and BPMN.
Experience facilitating diverse groups to achieve an appropriate outcome.
Demonstrated ability to analyse and synthesize large sets of data and to formulate actionable insights.
Advanced knowledge and expertise with SQL and Oracle PL/SQL is a must.
Experience with the proper handling of sensitive data.
Solid understanding of key trends and players in the IT industry.
Experience on an ERP implementation project with student modules is strongly preferred.Knowledge with data warehouse concepts and foundations is an asset
Experience with Git and version control is an asset
Higher-education or public sector experience is an asset.
Experience with scripting languages such as PHP and Python is preferred,
Proven data visualization skills with Tableau, Power BI, Excel, and Open Source Python Libraries is an asset
Advanced experience with Excel and the ability to code macros with VBA is an asset
Skills & Abilities:
Excellent organizational, planning, and prioritization skills. Able to multi-task and deliver multiple assignments in a fast-paced and changing environment.
Ability to communicate in both technical and user-friendly language for non-technical audience.
Superior interpersonal skills. Proven ability to work effectively and diplomatically with a wide range of individuals at all organizational levels.
Demonstrates the willingness, ability, and enthusiasm to learn new processes, methodologies or technologies.
Strong analytical, problem solving, and troubleshooting skills.
Effective organizational and time management skills in meeting deadlines and working with frequent interruptions.
Creative problem-solving skills with excessive attention to detail.
Ability to maintain a high degree of confidentiality.
Ability to work independently and in a team environment.
Ability to perform complex work with high degree of accuracy.
Ability to learn and adapt to new technology and methods.
Ability to write technical and user support documentation and training materials.
Ability to make decisions in accordance to established policies, practices and standards.
Proven knowledge and continuous learning of business analysis discipline and best practices, and demonstrated contributions to practice improvement.
Passion for the data analysis and visualization.
Additional Info:
Competencies
Tenacity, resilience and patience – believes that own actions and efforts will overcome obstacles, make progress and attain successful results
Visioning and Strategic Thinking - energizes people around the vision and keeps the bigger picture in mind
Organizational awareness – understands and appreciates an organization’s internal culture and operating practices as well as the political and business climate in which the organization operates
Innovation – welcomes, generates, and implements new ideas and solutions that help to achieve and organization’s strategic goals
Problem solving and decision making – considers a wide range of information and perspectives to solve problems and make reasoned decisions; demonstrates a comfort with uncertainty and ambiguous conditions
Achieves results – goal-oriented individual who thrives on achieving outcomes through consultative and collaborate methods.
Integrity – acts with openness, honesty and respect to build and maintain an environment of trust
Why Join Langara?
At Langara College, we support the College’s vision of promoting wellness and fostering personal and professional growth for our employees. We are dedicated to embracing, honouring, and advancing diversity, equity, and inclusion, while offering a competitive and inclusive benefits package that reflects our commitment to overall health, financial security, and work-life balance.
** Eligibility and entitlements may vary based on the employment group, and if the position is temporary, part-time, or casual **
We offer the following benefits:
Extensive medical, dental, and vision coverage
Hybrid-work program for eligible positions
Generous vacation package plus paid time off during college winter closure (1 week in December)
Employer paid defined benefit pension plan
Potential eligibility for educational, training, and developmental programs
Access to on-site daycare subject to availability
Tuition waivers for courses at Langara College, subject to space availability
Course/program tuition reimbursements
Wellness classes and campus engagement events
Salary Range:
Pay Grade:
Compensation beyond the mid-point requires approval by the Public Sector Employers’ Council Secretariat (PSEC).
Scheduled Weekly Hours:
Hours may vary according to the needs of the department.
Closing Date:
People and Culture is committed to embracing, honoring, and promoting diversity, equity, and inclusion in our workplace. We remain dedicated to focusing our efforts on creating an inclusive employee community that fosters a sense of safety and belonging for everyone. We humbly acknowledge that we are just beginning our journey, which includes engaging in our own internal learning and creating a data-driven action plan that supports the integration of EDI practice into the work of People and Culture and the work we do with employees and leaders. Langara College welcomes applications from everyone including people from groups that are experiencing inequity including, but not limited to, Indigenous people, racialized people, people with disabilities, and members of the 2SLGBTQIA+ community. If there are any barriers that you are experiencing or an accommodation that we can provide to support you through the application process, please contact us.
Shortlisted candidates will be required to provide proof of educational and professional credentials noted on their resume. In addition, those shortlisted with international credentials must have their education credentials evaluated through WES (World Education Services) and provide Langara College, People & Culture document evaluation access for employment purposes.
We thank you for your interest in Langara College and for taking the time to complete an application. Only complete applications will be reviewed. Please be advised that only shortlisted candidates will be contacted due to the number of applications received.
Langara is committed to enhancing our diverse workforce.
Tags: Data analysis Data governance Data management Data quality Data visualization Data warehouse Excel Finance Git Machine Learning Open Source Oracle PHP Power BI Python Security SQL Statistics Tableau Testing
Perks/benefits: Career development Competitive pay Equity / stock options Health care Startup environment Team events Wellness
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.