SQL Server Database Developer

Challenger Motor Freight; Cambridge; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading North American freight company is seeking a SQL Server Database Developer to enhance business applications and BI reporting platforms. The role involves developing and maintaining SQL solutions while focusing on process improvements. Candidates should have strong SQL skills, a degree in Computer Science, and excellent analytical abilities to thrive in a collaborative environment. This full-time position offers competitive benefits and a commitment to career growth.

Benefits

Comprehensive total rewards package

Support of professional memberships

Engaged coaching and mentoring

Qualifications

• Five years of experience developing and supporting in SQL Server environment.
• Experience with SSIS Package management.
• Proficient in Microsoft SQL permissions for security.

Responsibilities

• Develop, test, and maintain SQL Server stored procedures and functions.
• Create and maintain reports in SSRS and PowerBI.
• Lead process improvement initiatives using AI and ML techniques.

Skills

Strong interpersonal and learning skills

Critical thinking and problem solving

Analytical skills

Education

Diploma / Degree in Computer Science

Tools

Microsoft SQL 2008

SSIS

Power BI

Job description

Challenger Motor Freight Inc. is an equal opportunity employer committed to creating a diverse and inclusive workplace. We strongly encourage applications from all qualified candidates including women members of visible minorities persons with disabilities and aboriginal peoples. If you require any accommodations at any stage of the recruitment process please dont hesitate to reach out to us at emailprotected. We are dedicated to ensuring an accessible and supportive experience for every applicant.

Envision :

Working for a company dedicated to personal career growth and opportunity in moving the organization forward. Challenger Motor Freight Inc. is a Platinum Club Member in Canadas 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.

Its not by chance that Challenger is a leading North American freight transportation 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 youre 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 goals
• A continuous improvement environment where all ideas are explored
• Engaged coaches and mentors who will provide guidance but also allow autonomy
• Team atmosphere
• Competitive and comprehensive total rewards package including company paid group benefits and company sponsored retirement savings plan
• Support of professional memberships and certifications
• Standard office hours; Monday to Friday from approximately 8 : 00am to 5 : 00pm

The Opportunity :

The SQL Server Database Developer is responsible for developing solutions in our SQL environment to support our business applications and BI Reporting platforms. You will have a strong understanding of business concepts with working knowledge in key technical tools. This position works within a team that has an impact on all divisions in the company and there is room for growth.

The individual will place a high emphasis on process improvement and logical problem-solving using in-depth analysis of the problem statement and working diligently to build out robust reporting solutions. Furthermore the candidate will have excellent analytical skills an ability to summarize data in a simple manner and a desire to work closely in cross-functional teams.

The 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.

What You Will Get From the Role :

A continuous learning environment that develops your individual career goals

A continuous improvement environment where all ideas are explored

Engaged coaches and mentors who will provide guidance but also allow autonomy

Team atmosphere

Comprehensive total rewards package including company paid group benefits and individual RRSP

Support of professional memberships and certifications

Key Accountabilities :

SQL Server Database Development (90%)

Develop test and maintain SQL Server stored procedures functions tables views and triggers relating to vendor supported applications and custom applications.

Create maintain and deploy reports in SSRS PowerBI and vendor reporting solution.

Champion the automation processes to create workflows with SSIS in order to manage the data warehouse.

Automate processes and create workflows with SSIS.

Use SSAS to design Dimensions Measures and Roles.

Write complex SQL queries functions and triggers.

Implement improvement modifications to complex and verbose stored procedures.

Identify KPIs required and add them to dashboards such as PowerBI / Analyzer.

Use knowledge of SSRS and report design to create and deploy reports.

Analyze and implement solutions to optimize slow performing queries or procedures.

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.

Provide data management support development team.

Maintain documentation on system and process flow modifications.

Perform after hours support and system upgrades when necessary ensuring critical

systems / functions are operational.

Performs other duties as required.

Process Improvement and Implementation 10%

Apply process improvement methodologies to process improvement initiatives with an emphasis on AI and Machine Learning techniques

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.

Focuses on continuous skill development and learning in following areas :

SSIS

SSRS

Python Coding

R Script

Machine Learning

Data Management

Process Mining

Process Standardization

Six Sigma Practices

Low Code Development Application (Knime Alteryx others)

Change management

Project management

Performs other duties as required

What You Need To Be Successful In This Role :

Diploma / Degree in Computer Science or equivalent professional experience.

Five years of experience developing and supporting in SQL Server environment.

Experience with SSIS Package management

Experience with Microsoft Power BI

Proficiency in system analysis and design.

Experience maintaining complex 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.

Experience with Low Code Development applications such as Alteryx or Knime an asset.

Required Skills :

Strong interpersonal and learning skills

Able to be resourceful and seek out answers via learning forums and Google

Able to leverage ChatGPT and similar and intelligently and safely

Highly developed written and verbal communication skills with the potential interest to prepare and deliver presentations

Manages expectations and uses conflict resolution to ensure a mutually beneficial outcome for all stakeholders wherever possible

Ability to apply critical thinking and problem solving

Ability to translate client requirements or Use cases to actual working solutions

Strong attention to detail

Time management skills : ability to prioritize and comfortable in handling competing priorities

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 influence various decision-making groups to form a consensus on direction

Strong analytical skills and the ability to create detailed and accurate reports and metrics

High level of accountability due to the nature of financial and operational analysis which is required for this role

Resilient and able to manage change and measure performance of changes

Proactive attitude takes initiative to prevent issues and has a bias towards action

Well-organized enthusiastic professional and a positive team member

A continuous improvement-focus on work

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 SQL Server Database Developer 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 Challenger Motor Freight Inc. to share this information within its divisions in order to identify other employment opportunities that you may be suitable for.

Required Experience :

Manager

Key Skills

Employee Relations,Forecasting,Information Technology Sales,Account Opening

Employment Type : Full-Time

Experience : years

Vacancy : 1