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**

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

**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