Reporting Analyst

at  Aspen Custom Trailers

The interest in this position has been very high so we are accepting applications only from local candidates living in the immediate local area of Leduc, Edmonton and surrounding communities. Please indicate where you live or your application will not be reviewed.
Aspen thrives on taking on the biggest heavy haul design and manufacturing challenges in North America. Ready to roll where others fear to tread, the Aspen approach is built on a foundation of tenacity, perseverance, and unwavering determination – just like the people who use them. Aspen is a growing business looking for people with energy, drive and passion to contribute to our team.
The Reporting Analyst reports to the CFO with dotted line accountability to the IT Manager and will be responsible to support business data analytics and reporting. Additional responsibilities will include supporting the IT department with networks, hardware, software. We need someone to help us take our data analysis and reporting to the next level.

Main Responsibilities

• Authoring and deploying reports in SSRS
• Build and deploy Data Cubes for Power BI
• Develop, update, and maintain suites of reports and dashboards
• Supporting Leadership and Management in Data Mining and Reporting
• Analysis support for other departments
• Continuously monitor and improve data collection, cleansing and analysis processes
• Create, maintain, and update accurate project documentation
• Mine and analyze data from company databases to identify patterns and trends relevant to business objectives
• Communicate complex technical and data concepts in an understandable manner for Team Members and non-technical departments

Secondary Responsibilities

• Software and System support for IT
• Maintain VM Ware Esxi Hosts and Client machines
• Active Directory/Azure user creation and management
• Conduct tests and perform security and quality controls
• Write, modify, integrate and test software code
• Internal Application Development

Attributes and Skills

• Strong attention to detail
• Solid organizational capabilities and ability to complete tasks
• Able to work autonomously and uses good decision-making practices
• Creative problem-solving abilities
• The ability to find quick solutions to unplanned changes
• Excellent written and verbal communication skills
• Able to maintain a professional and calm demeanor in challenging situations
• Able to identify procedure and process improvements and advise the appropriate stakeholders
• The ability to multitask and work in a fast-paced environment
• The ability to understand various corporate IT systems and how they impact an organization
• Strong interpersonal, organizational and project management skills

Experience and Education

• A degree, diploma or certificate in the following disciplines is an asset: computer science, engineering, data analytics, business or a related discipline
• Minimum of 2 years of experience as a Reporting Analyst or similar role
• Proficiency with SSRS reports, SQL, Python, Microsoft Power BI, and Office 365 including Azure
• Familiarity with Active Directory, Exchange 365 and InTune or other corporate level suites
• Experience building and deploying internal tools
• 3-5 years of report generation experience, within the retail or food industries, is an asset

Working Conditions

• This is an on-premises job
• The work performed is carried out indoors in a regulated environment
• Regular fast pace or work with tight deadlines
• Occasional long hours based on workload

Shift Availability

• Monday to Friday – 8:00 am – 4:30 pm

Benefits

• Competitive Wages
• Extended Health Care & Dental Benefits
• AD&D, Life and STD Disability Benefits
• Employee and Family Assistance Program (EFAP)
• Company supplied PPE equipment
• Great work life balance
• Safety Boot Allowance
• Year-round work
• Stable career
• Family environment and company culture

Apply now to join North America’s premier supplier of heavy haul transportation equipment! Aspen Custom Trailers is a fast-paced, entrepreneurial company poised for significant ongoing growth. Thank you for your interest in Aspen Custom Trailers. Only applicants selected for an interview will be contacted. If you would like to know more about Aspen, please visit www.aspentrailer.co

Main Responsibilities

• Authoring and deploying reports in SSRS
• Build and deploy Data Cubes for Power BI
• Develop, update, and maintain suites of reports and dashboards
• Supporting Leadership and Management in Data Mining and Reporting
• Analysis support for other departments
• Continuously monitor and improve data collection, cleansing and analysis processes
• Create, maintain, and update accurate project documentation
• Mine and analyze data from company databases to identify patterns and trends relevant to business objectives
• Communicate complex technical and data concepts in an understandable manner for Team Members and non-technical department

Secondary Responsibilities

• Software and System support for IT
• Maintain VM Ware Esxi Hosts and Client machines
• Active Directory/Azure user creation and management
• Conduct tests and perform security and quality controls
• Write, modify, integrate and test software code
• Internal Application Developmen