Enterprise Data Analyst

About Us
Amsted Canada Inc., is not only a leader in the manufacture of industrial components, we are a company where you are the driver of your own career.  At Amsted, we know that our employees are at the heart of our world-class business, and we value you and want you to excel with us. We spend time understanding where you want your career to go and help you get there by offering the support and resources that will allow you to grow with us.  At Amsted Canada Inc., we also encourage a spirit of Innovation by allowing time and space to experiment, to think differently and to challenge the status quo.  If this is the type of environment where you believe you will thrive, we encourage you to join us.

Operating under the Amsted Industries umbrella since 1962, today we are meeting the growing needs of a global market with over 80 facilities across six continents.  Amsted Canada Inc. has established a new business center in downtown Charlottetown, Prince Edward Island.  We are elevating our global technology teams in several areas including but not limited to Engineering, Security, Development, Infrastructure, Emerging Technology, and SAP.  These teams are instrumental in providing support to all Amsted Industries entities locations worldwide.

We have an exciting opportunity for a Data Analyst for Amsted Automotive, an Amsted Industries entity.  At Amsted Automotive, we are not just a company – we are a community of innovators, creators, and dedicated professionals who take pride in our work and in each other. As an employee-owned organization, every single team member has a stake in our success and shares in our achievements. This unique ownership culture fosters a collaborative, supportive environment where your ideas and contributions truly matter. Come join us and be a part of a dynamic team that is revolutionizing the automotive industry and driving the future of transportation! 

Position Details
Are you a data enthusiast with a knack for turning complex datasets into actionable insights? Join our team as a Data Analyst and play a pivotal role in shaping our Enterprise Data and Analytics strategy. We’re looking for someone with strong technical skills and a deep understanding of data management, analysis, business processes, and reporting. You’ll collaborate with a diverse IT team and user-base across manufacturing plants in the United States, Canada, Mexico, Italy, and China, driving decision-making and supporting our organization’s goals and objectives. If you’re ready to make an impact, apply now!

What we offer you:

• Autonomy to help drive the development of our growing office on Prince Edward Island in a role that will impact our growth and how we work across all functions at Amsted Canada Inc.
• Highly competitive compensation and benefits package that only begins with a strong base salary commensurate with skills and abilities, but includes annual incentive opportunities and a comprehensive benefits package
• Investment into your personal and professional development to ensure you remain at the top of your field and can reach your goals
• Being a part of team who cares about YOU – the professional and the person

What you will do:

• Data Collection & Analysis: Gather and analyze large datasets from multiple sources. Perform data extraction, transformation, and loading (ETL) to ensure data is accurate, consistent, and useful.
• Reporting & Visualization: Create and maintain automated dashboards, reports, and visualizations that provide valuable insights to key stakeholders using Power BI and other pertinent tools.
• Data Quality Assurance: Ensure data integrity and quality by performing regular checks and troubleshooting data inconsistencies. Develop and implement strategies for data cleansing and validation.
• Technical Support: Provide technical assistance and guidance in the use of data analysis tools and techniques. Work alongside IT teams to improve data systems and infrastructure.
• Database Management: Collaborate with database administrators and developers to ensure efficient database management and optimization.
• Trend Analysis & Forecasting: Identify trends, patterns, and opportunities within datasets and provide predictive analysis to help inform strategic decision-making.
• Documentation & Reporting: Document processes, methodologies, and code used for data analysis and reporting. Maintain clear records of project requirements, analysis results, and outcomes.
• Collaboration: Work closely with cross-functional teams, including systems analysts, software developers, subject matter experts, and management to align data insights with business goals.

Required Skills/Abilities:

• Strong knowledge of SQL and relational database management systems (e.g., MySQL, MS SQL Server).
• Proficiency in data visualization tools (e.g., Power BI or similar tools).
• Familiarity with ETL processes and data integration techniques.
• Strong Excel skills, including advanced functions and pivot tables.
• Excellent problem-solving and critical-thinking abilities.
• Strong attention to detail and accuracy in work.
• Good communication skills and ability to explain technical concepts to non-technical stakeholders.
• Ability to work independently and as part of a team in a fast-paced environment.

Compensation & Benefits:

• Excellent base salary and targeted annual bonus structure (Entry Salary: $58,000 plus bonus; Salary will be determined based on skills, ability, and qualifications)
• Comprehensive employee benefits package including medical, dental, life and disability insurance, salary continuation, and a health spending account
• Company Pension Program
• Tuition reimbursement
• Fitness reimbursement credit

Education and Experience:

• Bachelor’s degree in information technology, Computer Science, Data Science, Data Analytics, or a related field. 

• 2+ years of experience in a data analysis role with an IT-focus. Entry level candidates with demonstrated competencies considered.
• Experience with design, development, and implementation preferred.
• Experience with Microsoft Power PI, One Lake, and Fabric preferred.
• Experience with cloud data platforms (e.g., AWS, Azure, Google Cloud).
• Knowledge of machine learning algorithms or predictive modeling.
• Familiarity with project management tools and agile methodologies.
• Experience in scripting languages, data analysis, and statistical tools (e.g., Python, R, Bash, or similar).

This position requires travel both domestically and internationally up to 15% of the time.  This position is being filled in our Charlottetown office and is not available for remote work at this time.

Experience

Preferred

• 2 year(s): Data analysis role with an IT-focus

Education

Preferred

• Bachelors or better in Computer Science or related field
• Bachelors or better in Information Technology or related field

Skills

Preferred

• Language Skills-English

Behaviors

Preferred

• Detail Oriented: Capable of carrying out a given task with all details necessary to get the task done well
• Team Player: Works well as a member of a group
• Dedicated: Devoted to a task or purpose with loyalty or integrity

Motivations

Preferred

• Growth Opportunities: Inspired to perform well by the chance to take on more responsibility
• Work-Life Balance: Inspired to perform well by having ample time to pursue work and interests outside of work
• Self-Starter: Inspired to perform without outside help