Amsted Canada

Enterprise Data Analyst

LocationCharlottetown, PE
Job TypeFull-time

About This Job

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


Education


Preferred


Bachelors or better


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

Trending Jobs

company-logo

Assistant General Manager, Navy Yard Electric Utility

Job TypeFull-time
Salary
$108000 - $108000
Philadelphia, Pennsylvania
17 days ago
company-logo

Electrical Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, Pennsylvania
3 months ago
company-logo

Accounts Payable Clerk

Job TypeFull-time
Salary
$65000 - $65000
Dallas, Texas
19 days ago
DM

Apprentice Lineman

Delta Montrose Electric Association
Job TypeFull-time
 
Montrose, CO
22 days ago
company-logo

Division Order Analyst

Job TypeFull-time
 
Dallas, Texas
8 days ago
company-logo

contract landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Lafayette, Louisiana
3 months ago
company-logo

Oil and Gas Land and Title Analyst - SAM Associate II

Bank of America
Job TypeFull-time
 
Dallas, Texas
about 1 month ago
company-logo

Attorney

Toeppich & Associates
Job TypeFull-time
 
Houston, Texas
about 1 year ago
company-logo

Apprentice Lineman I

San Patricio Electric Cooperative, Inc.
Job TypeFull-time
 
Sinton, TX
about 1 month ago
HM

Lineworker Apprentice I

Henderson Municipal Power & Light
Job TypeFull-time
 
Henderson, KY
26 days ago
company-logo

Associate Attorney

Buffalo Biodiesel Inc.
Job TypeFull-time
 
Buffalo, NY
29 days ago
company-logo

Senior Landman

Greenlake Energy
Job TypeFull-time
 
Austin, Texas
about 1 month ago
company-logo

Foundry Professionals

Penticton Foundry
Job TypeFull-time
 
British Columbia, Canada
10 days ago
company-logo

Apprentice Lineman

Southern Pine Electric
Job TypeFull-time
 
Brandon, MS
23 days ago
company-logo

Electrical Designer

Dudley Staffing
Job TypeFull-time
Salary
$45 - $60
Canonsburg, Pennsylvania
3 months ago
company-logo

Contracts Administrator

Third Coast
Job TypeFull-time
Salary
$70000 - $85000
Houston, Texas
22 days ago
company-logo

Deckhand

Ballard Marine Construction
Job TypeFull-time
 
Bradenton, FL
12 days ago
company-logo

Residential Helper

Waste Pro
 
Columbus, MS
26 days ago
PS

Screen Printing Operator

Providence screen printing
Job TypePart-time
Salary
$39520 - $41600
East Providence, RI
17 days ago
company-logo

Groundman (Local 659) - Medford, Oregon - #113370

PacifiCorp
Job TypeFull-time
Salary
$73560 - $73560
Medford, OR
25 days ago