Data and BI Analyst > Challenger Motor Freight Inc. > Joboolo CA :
Company : Challenger Motor Freight Inc. Location : Cambridge Ontario From : Talent CA
Envision:
Working for a company dedicated to personal career growth and opportunity in moving the organization forward.
ChallengerMotorFreightInc.
is a Platinum Club Member in Canada’s 50 Best Managed Companies.
Our success is directly attributed to our dedicated and talented team of professionals who work hard together with a common purpose – to keep us on the leading edge in safety, technology, and analysis.It’s not by chance that Challenger is a leading North American freight transportation company.
In 40 years, Challenger has grown from one person with a vision and a truck to an international transportation and supply chain management company.We win as a team when we work as a team, and succeed when our employees succeed.
We want people who are resilient, team-oriented, and driven because we are laser focused on meeting commitments to our People, Customer, and Profit.
If you’re looking to work for a dynamic, fast-paced, progressive organization then apply with us.We offer the following in our search for engaged employees looking to become part of a successful team:
A continuous learning environment that develops your individual career goalsA continuous improvement environment where all ideas are exploredEngaged coaches and mentors who will provide guidance but also allow autonomyTeam atmosphereCompetitive and comprehensive total rewards package including company paid group benefits and company sponsored retirement savings planSupport of professional memberships and certificationsStandard office hours; Monday to Friday from approximately 8:
00am to 5:
00pmWe are committed to protecting the health, safety and wellbeing of our employees, and have implemented Company-wide best practices which includes daily health questionnaires for our employees, mandatory facemasks in communal locations, virtual meetings, social distancing guidelines and additional cleaning procedures.The Opportunity:
The Data and BI Analyst is responsible for providing operational data support, data analysis and visual presentation for a variety of corporate initiatives, leveraging our SQL environment and BI Reporting platforms.
This role requires a candidate with excellent analytical skills, an ability to summarize data in a simple manner and a desire to work closely in cross-functional teams.
The individual will have a strong understanding of business concepts with working knowledge in key technical toolsThe chosen candidate will be a critical thinker with the ability to work independently to complete a wide range of analysis while also being able to work in a team to collaborate and support on a wide variety of profit-related initiatives.Key Accountabilities:
Operational Analytics and Data Recommendations – 45%Support operational projects; provide analysis, data-driven recommendations and enable end-user with insightful BI reporting dashboardLiaise with Operations team members.Leverages various Development Applications (including but not limited to SQL, Alteryx, Knime, etc.) to conduct deep data analysis on network performance; reports out periodically.Understands the business problems we are seeking to create solutions for.Identify KPI’s required and add them to dashboards such as PowerBI / Tableau.Provide support for on-demand data requests from user groups.Participate in team meetings to gather requirements and develop BI solutions suited to business needs.SQL Server Database Development – 45%Champion the automation processes to create workflows with SSIS in order to manage the data warehouseDevelop, test, and maintain SQL Server stored procedures, functions, tables, views, and triggers relating to vendor supported applications and custom written .NET applications.Create, maintain, and deploy reports in SSRS, PowerBI and vendor reporting solution.Implement improvement modifications to complex and verbose stored procedures.Use knowledge of SSRS and report design to create and deploy reports.Provide data management support to .NET development team.Maintain documentation on system and process flow modifications.Process Improvement & Implementation – 5%Apply Lean Six Sigma process improvement methodologies to process improvement initiatives.Prepare process recommendation documents including presentations, process models, supporting metrics, business requirements and related impact analysis.Assist in the implementation of new processes with necessary stakeholders.
This may include but is not limited to documenting all new processes, creating measurable goals for success, training end users, acting as point of contact for troubleshooting and ongoing process management.Continuous innovation and skill development – 5%Focuses on continuous skill development and learning in following areas:
SQLSSISSSRSPython CodingR ScriptMachine Learning Data ManagementProcess MiningProcess StandardizationSix Sigma PracticesLow Code Development Application (Knime, Alteryx, others)Change managementProject managementPerforms other duties as requiredWhat You Need To Be Successful In This Role:
Diploma/Degree in Computer Science, Mathematics, Statistics, Engineering or a related field required.2 years of experience developing and supporting in SQL Server environment.Experience with SSIS Package management is considered an asset.Proficiency in system analysis and design.Experience maintaining SQL queries, stored procedures, functions, and triggers.Proficient in Microsoft SQL 2008+, with a solid understanding of SQL permissions to maintain high level of data security.Strong attention to detail.Able to collaborate with a variety of stakeholders and work effectively with multiple departments, while also working independently at times to solve problems with ambiguous solutions.Ability to apply critical thinking and problem solving.Time management skills:
ability to prioritize and comfortable handling competing priorities.Resilient and adaptable to change.Highly developed written and verbal communication skills, with the ability to prepare and deliver presentations.How To Apply:
If you are looking to join a premier transportation company, and become an integral part of results oriented team who constantly challenge themselves to Go The Distance for our customers and for each other, the role of Data and BI Analyst may be right for you.No phone calls, please.
We thank all applicants; however, only those selected for an interview will be contacted.
By submitting your resume, you consent ChallengerMotorFreightInc.
to share this information within its divisions in order to identify other employment opportunities that you may be suitable for. ChallengerMotorFreightInc. CambridgeOntario
