Systems Analyst, Data Warehouse

2 weeks ago

Windsor, Canada TransForm Shared Service Organization Full time

***:
The Systems Analyst - Data Warehouse works as part of the Application, Integration and Development team to provide project development and operational support services across the entire region. Functionally, this is a hybrid role that performs Analysis-Programming-Database and Data Modelling services. The Analyst level typically works under the direct guidance of the Database Architect, for work task definition and prioritization.
- Microsoft BI Dev. Suite: SSIS, SSAS, MDS
- Reporting Tools: SSRS, PowerBI
- Development languages: C#, JavaScript, T-SQL, CCL
- Databases: MS SQL, Oracle

Senior Roles participate in the development of the overall information management strategy and play a key role in stakeholder engagement across the entire Erie St. Clair region. Senior roles are expected to provide leadership assistance to the management team in the following areas:

- Subject matter expertise to assist in definition of work assignments, system configuration, development of standards and issues investigation/escalation.
- Work stream leadership on major projects / or associate PM on small to medium complexity initiatives.
- Acting as MRP (most responsible person) for assigned functional areas / assists and supports Account Managers on new requests/investigations.
- Coaching and mentoring of supporting staff.

**WHAT YOU’LL DO**:

- Performs development services as required for major and minor projects following standard development lifecycle methodologies (ex, preparation of clearly articulated requirements documents), under the general guidance of management or senior staff.
- Create documentation that includes intermediate to complex diagrams (swim lane diagrams, flowcharts, process flow diagrams).
- Troubleshooting data gaps or anomalies with SMEs (Subject Matter Experts).
- Work with Database Architect to design, model and implement solutions. Includes creation of appropriate documentation while obtaining customer signoff and approvals.
- Participate and contribute to meetings, workshops and design sessions.
- Store and provision data securely in our Data Warehouse, following established standards and best practices.
- Participates in the investigation and technical recommendations for assigned areas of responsibility
- Shared responsibility for technology change management as an ad-hoc member of the Change Advisory Board (CAB)
- Responsible for work assignments prioritization, scheduling, and issues management for assigned technologies
- Shared responsibility for the upkeep and safeguarding of production systems in partnership with the Service team.
- Responsible for delivery of assigned project roles (ex, Work-Stream member)
- Other duties as assigned

For Senior Roles additionally:

- Leads the investigation and recommendation of development proposals within a regional context (including development of written proposals, participation in RFP’s, investigation of options/alternatives) for assigned areas of responsibility (ex, Integration, Interfacing, Database Management, Master Data Management, Business Intelligence, Report Development, Custom Solution Development).
- Leads development service activities on major projects, including where applicable managing project resources and work activities for assigned work-streams in accordance with regional project management methodologies.
- Mentors supporting staff and provides training and work activity review as necessary.
- Works as part of a regional Change Advisory Board (CAB) to review and approve all technical change requests in accordance with regional policies and procedures.
- Works as part of a regional support team to resolve production critical issues (provide 2nd & 3rd level support) in conjunction with the Regional Service Model/SLA’s - including scheduled and unscheduled activities after hours as required.

**MUST- HAVES**:

- Three (3) year University Degree or Community College diploma in Information Technology
- Minimum two to four (2-4) years of experience in supporting technology solutions in an IT development environment.
- For Senior Role, minimum four to six (4-6) years of experience in supporting technology solutions in an IT development environment.
- Knowledge of database development and tabular modelling
- Intermediate T-SQL query development (Microsoft SQL, Oracle)
- Scripting/programming languages (C#, JavaScript/JSON, Powershell)
- Experience with Microsoft SSIS, SSAS

**WE VALUE**:

- Healthcare IT related experience an asset
- Additional scripting/programming experience, an asset
- Experience in participating in technology or development projects
- Experience in technology support services
- Experience establishing & maintaining effective relationships with clients, vendors, & team

**OTHER CONDITIONS**:

- Minimal exposure to disagreeable conditions typical of an office position: exposed to stress and pressure associated with multiple priorities and deadlines
- Must be able to travel within the Southwestern Ontario a

  • Data Analyst Innovator

    3 weeks ago

    Windsor, Ontario, Canada ZipRecruiter Full time

    Job SummaryWe are seeking an experienced Data Analyst to join our team. As a key member of our data analytics group, you will be responsible for analyzing complex data sets, identifying trends and insights, and providing actionable recommendations to inform business decisions.About the RoleThis is a fantastic opportunity for a highly skilled data analyst to...

  • Business Data Analyst

    1 month ago

    Windsor, Canada BNA O&M General Partnership Full time

    **About BNA O&M General Partnership** Bridging North America (BNA) was selected to design, build, finance, operate and maintain the CAD $6.4 billion Gordie Howe International Bridge project for Windsor-Detroit Bridge Authority (WDBA) - a Public-Private-Partnership (P3). BNAOM is the OMR entity managing the Operations, Maintenance, and Rehabilitation of the...

  • Data Analyst

    6 months ago

    Windsor, Canada Rovio Full time

    Data Analyst Data & Analytics Helsinki Metropolitan Area Permanent 19.06.2024 Data & Analytics Permanent Open position Rovio is part of the SEGA family and world famous for our flagship IP Angry Birds - want to know more about Rovio as an employer? .We are looking for a Data Analyst with a focus on User Acquisition to join our Data Science and...

  • Business Solutions Systems Analyst

    4 weeks ago

    Windsor, Ontario, Canada City Of Windsor Full time

    We are seeking a highly skilled Business Solutions Systems Analyst to join the City Of Windsor team. This is a full-time position that offers an exciting opportunity to work in a dynamic and innovative environment.Job SummaryThe successful candidate will be responsible for developing and supporting business systems, applications, and processes. They will...

  • Senior Data Analyst Lead

    3 weeks ago

    Windsor, Ontario, Canada The County of Essex Full time

    About The County of EssexThe County of Essex is a leader in innovation and data-driven decision-making. We are seeking a highly skilled Senior Data Analyst Lead to join our team.Estimated Salary: £80,000 - £100,000 per annum.Job DescriptionWe are looking for a seasoned data analyst with expertise in machine learning algorithms and big data technologies. As...

  • Financial Analyst

    3 months ago

    Windsor, Canada Windsor-Detroit Bridge Authority Full time

    **Financial Analyst Position at WDBA** **Company Profile** Windsor-Detroit Bridge Authority (WDBA) offers a unique opportunity to make a lasting contribution to the largest bi-national infrastructure project in North America today - the Gordie Howe International Bridge. Join our Canadian Crown corporation in fulfilling our mandate to build and operate this...

  • Data Analyst Expert

    4 weeks ago

    Windsor, Ontario, Canada Rovio Full time

    About RovioRovio is part of the SEGA family and world-famous for our flagship IP Angry Birds.Job DescriptionWe are looking for a Data Analyst with a focus on User Acquisition to join our Data Science and Analytics craft. In this position, your main focus will be to improve product marketing analytics as part of our internal publishing team, providing support...

  • Data Analyst with Strong SQL Skills

    14 hours ago

    Windsor, Ontario, Canada ZipRecruiter Full time

    We are seeking a skilled Data Analyst to join our team at ZipRecruiter, a leading online employment marketplace.The ideal candidate will have 1-3 years of experience in data analysis and strong skills in SQL, data visualization, and cloud computing. They will be responsible for collecting, analyzing, and presenting data to inform business decisions and drive...

  • Data Scientist

    6 months ago

    Windsor, Canada YOCHANA IT SOLUTIONS INC Full time

    Work Term: Permanent - Work Language: English - Hours: 35 to 40 hours per week - Education: Bachelor's degree - Experience: 1 year to less than 2 years - or equivalent experience **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test data models and database...

  • Technical Analyst

    6 months ago

    Windsor, Canada Enwin Utilities Full time

    **Technical Analyst** **The successful applicant must have the following skills and competencies**: - University Degree in Computer Science or related discipline with a minimum of two (2) years of similar or related experience; OR a College diploma in a related field with a minimum of three (3) years' similar or related experience. - Working knowledge of...

  • Warehouse Supervisor

    6 days ago

    Windsor, Canada ZF Full time

    Become our next FutureStarter Are you ready to make an impact? ZF is looking for talented individuals to join our team. As a FutureStarter, you’ll have the opportunity to shape the future of mobility. Join us and be part of something extraordinary! Warehouse Supervisor Country/Region: CA ...

  • Technical Analyst

    6 months ago

    Windsor, Canada Enwin Utilities Full time

    **Technical Analyst** **The successful applicant must have the following skills and competencies**: - University Degree in Computer Science or related discipline with a minimum of two (2) years of similar or related experience; OR a College diploma in a related field with a minimum of three (3) years' similar or related experience. - Working knowledge of...

  • Information Systems Analyst

    6 months ago

    Windsor, Canada CB Canada Full time

    Overview Flex-N-Gate is a leading manufacturer and supplier of components for the automotive industry, recently ranked 10th of the 150 Top North American Suppliers in “Automotive News.” A growing and vital company, Flex-N-Gate provides a great opportunity for hard-working and skilled individuals. Scope of the Position The...

  • GIS Data Analyst

    5 months ago

    Windsor, Canada City Of Windsor Full time

    : Reporting to the GIS Supervisor, this position will maintain many GIS database files by updating, creating, acquiring, and manipulating geospatial data, some of which have special requirements. Will analyze geospatial data using ESRI products for the division and other departments. Offers solutions to all new GIS related applications by reviewing...

  • IT Business Solutions Analyst

    4 weeks ago

    Windsor, Ontario, Canada City Of Windsor Full time

    We are seeking an IT Business Solutions Analyst to join our team at the City Of Windsor. This is a full-time position that offers a competitive salary and a comprehensive benefits package.About the PositionThe Systems Analyst – Business Solutions will be responsible for developing and supporting business systems, applications, business processes,...

  • Inventory Control Analyst

    1 month ago

    Windsor, Canada Plasman Full time

    Plasman One Company, One Driving Force.Plasman is a leading global automotive and manufacturing company with several locations across North America and Europe. With a rich history dating back over 45 years, our collaborative approach, work ethic, and commitment have made us a global leader in automotive components. We believe the only thing that separates...

  • Warehouse Associate

    6 months ago

    Windsor, Canada Genuine Vapes Distribution Full time

    **About us** We are professional, fast-paced and demanding. Our work environment includes: - Growth opportunities - Relaxed atmosphere - Company perks - Lively atmosphere **Responsibilities**: - Package, load, and unload products in a warehouse setting - Perform picking and packing duties to fulfill customer orders - Assist with shipping and receiving...

  • Financial Analyst, Payroll

    2 months ago

    Windsor, Canada Windsor Regional Hospital Full time

    **Position Purpose**: Reporting to the Manager, Payroll, General and Patient Accounting, the Financial Analyst works co-operatively with senior management and managers to effectively and efficiently manage the financial resources of the organization. This includes providing interpretative services to assigned departments and the development and analysis of...

  • Warehouse Operations Manager

    1 week ago

    Windsor, Ontario, Canada Toni Group, LLC Full time

    Toni Group, LLC is seeking a seasoned professional to fill the role of Warehouse Operations Manager.Job Summary:The successful candidate will be responsible for leading the warehouse team and overseeing the coordination and workflow of our inventory management systems.About Us:Toni Group, LLC is a leading provider of logistics and supply chain solutions. We...

  • GIS Data Analyst

    1 month ago

    Windsor, Ontario, Canada City Of Windsor Full time

    Job Summary:This role is responsible for maintaining and updating GIS database files, analyzing geospatial data, and providing technical support to corporate users and other agencies. The ideal candidate will have a strong background in GIS, urban planning, or a related field, and experience with ESRI products and VertiGIS Studio Web-based Suite of...