Data Warehouse Administrator

3 months ago


Saskatchewan, Canada eHealth Saskatchewan Full time

**Employment Type**: SGEU Term 9 months or more**Location(s)**: SK**Salary Range**: $38.878 - $47.318 Hourly**Salary Supplement**: included in hourly salary range (in-scope)**Why eHealth?**
We may be biased, but eHealth Saskatchewan is the place to be right now As the result of a province wide consolidation of IT services in the health care sector, we have seen substantial growth in our organization that is only going to increase as we aim to meet our expanded mandate and the immense need for our support. This gives our people a unique and rare opportunity to truly create, build, improve, and leave their mark on a growing organization.

A large and complex organization, eHealth is comprised of 30+ clinical and non-clinical program (service) areas that all work together to support health care providers and teams across the province in delivering the best possible care to patients, providers, citizens, and health system users. Programs range from primary care to acute care, and includes laboratories, pharmaceuticals, and diagnostics. Additional programs that also support patient care and information include Virtual Care, the MySaskHealthRecord, and the Provincial Electronic Health Record. eHealth is also responsible for the administration of various pieces of legislation to manage the registration of/changes to all vital event records (e.g. birth, marriage, death, etc.), registration of legal name changes, registration of adoptions, and for maintaining the provincial health registry for health services eligibility and distribution of health services cards.

The eHealth teams engage directly with health system partners and other stakeholders both provincially and federally to ensure all services are delivered efficiently and effectively.

**About the Role - Data Warehouse Administrator**:
**What we are looking for**:
You will possess a strong background in both Oracle and SQL Server databases; ETL (Informatica is preferred), MicroStrategy and PowerBI products; R, Python and PowerShell; as well as MS SQL business intelligence tools, including, but not limited to: SQL Reporting Services, SQL Analysis Services, and SQL Integration Services. Proven skills in communication, analysis, problem solving, documentation standards and a rigor for quality control are required.

**You will have knowledge of and experience with**:

- Technical knowledge of database concepts, theories, and data integration using various computer platforms.
- Strong computer programming skills and demonstrated proven experience with report creation and data extraction.
- Excellent knowledge of the Microsoft Office package.
- Exceptional written and verbal communication skills and one who thrives in a dynamic, technology driven environment.
- Proven experience and skills in effective communication, problem solving, data analysis, and documentation standards.
- Thorough understanding of change management protocols and quality control are also required.
- Knowledge of the health environment and of data quality improvement techniques would be an additional asset.

**You will be**:

- Flexible, organized and quick to learn in order to independently prioritize and organize your own workload to meet tight deadlines and successfully complete projects in a changing environment;
- Patient, honest, discreet and respectful/tactful while working with various types of personal health information etc.;
- Service-oriented, thorough, reliable, disciplined, organized, and have a strong attention to detail in order to complete tasks for clients and coworkers, etc.;
- Creative, logical, and have a strong motivation for continuous improvement and learning; and
- Empathetic, diplomatic, and sensitive in order to respond to issues and concerns of others who may be angry or frustrated.

**Competencies**:
**_ Problem Solving_**

**_ Technical_**
- Technical knowledge of database concepts, theories, and data integration using various computer platforms.
- Strong computer programming skills and demonstrated proven experience on report creation and data extraction.
- Excellent knowledge of the Microsoft Office package.
- Data integration, data warehousing methodology, and logical data model design.
- Demonstrated ability to gather, understand, and synthesize specialized information in a way that can be applied to identify and meet the needs of the organization using SQL, Oracle, Informatica, R, Python, PowerShell, SSIS, Power BI and MicroStrategy tools with a focus on maintaining data integrity, privacy and security.

**_ Team/Independence_**
- Build positive work relationships.
- Work independently and participate as a team member to meet the needs of customers, partners and co-workers.

**_ Organizational_**
- Independently prioritize and organize your own workload to meet tight deadlines and successfully complete projects in a changing environment.

**_ Analytical_**
- Ability to identify, explore and evaluate options on data, processes and methodologies, information


  • Executive Director

    2 weeks ago


    Regina, Saskatchewan, Saskatchewan, Canada Regina's Warehouse District Full time

    Regina’s Warehouse Business Improvement District (RWBID) encompasses 80 blocks of the City of Regina bounded by 4th Ave on the north, South to the CP Railyard and between Winnipeg Street to Albert Street. We are a non-profit organization representing a community of nearly 600 businesses, most of them locally owned and operated. Any business located in the...


  • Saskatoon, Saskatchewan, F7K, CA Nutrien Ag Solutions Limited Full time

    At Nutrien, our purpose is Feeding the Future and we do so with safety, inclusion, integrity and results as our core values. Nothing is more important than sending our people home safe, every day.Nutrien is a leading provider of agricultural products, services, and solutions. With nearly 25,000 employees worldwide, we are the largest producer of potash (by...


  • Saskatoon, Saskatchewan, F7K, CA Nutrien Full time

    At Nutrien, our purpose is Feeding the Future and we do so with safety, inclusion, integrity and results as our core values. Nothing is more important than sending our people home safe, every day. Nutrien is a leading provider of agricultural products, services, and solutions. With nearly 25,000 employees world-wide, we are the largest producer of potash (by...

  • Warehouse Technician

    3 months ago


    Fort Saskatchewan, Canada Bunge Full time

    At Bunge, people don’t just come here to work, they come here to grow - solving challenges that directly impact the world with a diverse team of thinkers and doers. Bunge offers a strong compensation and benefits package, generous paid time off program and opportunity to progress. Most importantly, in all we do we live our values: - Act as One Team by...


  • Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    **Data Entry Administrator** At Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are...


  • Saskatoon, Saskatchewan, F7K, CA Nutrien Ag Solutions Limited Full time

    Select how often (in days) to receive an alert: Create Alert At Nutrien, our purpose is Feeding the Future and we do so with safety, inclusion, integrity and results as our core values. Nothing is more important than sending our people home safe, every day. Nutrien is a leading provider of agricultural products, services, and solutions. With nearly...


  • Fort Saskatchewan, Canada Bunge Full time

    Reporting to the Maintenance Supervisor this position is responsible for performing warehouse services and other skills as required. The Shipper/Receiver must have good working knowledge of the following: proper warehouse storage techniques, receiving materials, issuing materials, data entry of materials in computer system (SAP), and operate material...


  • Regina, Saskatchewan, S4P, Regina region, Canada Affinity Full time

    Job Description:On behalf of our healthcare client, Affinity is looking for a Database Administrator to integrate and support multiple network capital-based projects. The Database Administrator's responsibilities will include managing multiple complex projects simultaneously, with many stakeholders and many complex needs.Responsibilities:Deployment of...


  • Saskatchewan, Canada Iron Systems Full time

    Iron Systems is a leading provider of custom computing infrastructure solutions. We are seeking a talented Data Architect to join our team.As a Data Architect, you will play a crucial role in designing and implementing data models for Business Intelligence (BI) applications. Your responsibilities will encompass a wide range of tasks, from developing...

  • Data Engineer

    1 month ago


    Saskatoon, Saskatchewan, F7K, CA Blue Cross Full time

    Saskatoon or Regina Saskatoon, SK S7K2C5, CAN DescriptionSaskatchewan Blue Cross, one of Saskatchewan’s Top Employers, is currently recruiting for a full-time permanent Data Engineer to join our team in the IT Data Solutions department. This position offers the flexibility to be in-office or participate in hybrid options in our Saskatoon or Regina...

  • Data Engineer

    4 weeks ago


    Saskatoon, Saskatchewan, F7K, CA Saskatchewan Blue Cross Full time

    Saskatchewan Blue Cross, one of Saskatchewan’s Top Employers, is currently recruiting for a full-time permanent Data Engineer to join our team in the IT Data Solutions department. This position offers the flexibility to be in-office or participate in hybrid options in our Saskatoon or Regina office. JOB FUNCTION Saskatchewan Blue Cross values data and its...

  • Sr Data Developer

    1 month ago


    Regina, Saskatchewan, S4P, Regina region, Canada BQ INTERNATIONAL LTD. Full time

    Our Client has an immediate need for a full-time Sr. Data DeveloperLocation: The role will be 100% remote while COVID-19 travel/social distancing restrictions are in place. Once those restrictions are lifted, onsite requirements will be reassessed at that time.Term: May 17, 2021 to May 31, 2022Key Skills/Requirements• 10+ years of experience with ETL•...


  • Saskatchewan, Canada 7shifts Full time

    About 7shifts7shifts is a leading provider of team management software solutions for the restaurant industry. Our mission is to simplify team management and improve performance for restaurants, with a long-term vision of elevating what restaurant teams can achieve together.About the RoleWe are seeking a highly skilled Salesforce Administrator to join our...


  • Saskatchewan, Canada Saskatchewan Polytechnic Full time

    Position Overview As an integral part of the administrative team, the Office Assistant will be responsible for a variety of essential tasks that ensure the smooth operation of our educational services. Key Responsibilities Develop and maintain a robust system for the collection and management of extensive student data utilizing specialized database software....


  • Saskatchewan, Canada Saskatchewan Polytechnic Full time

    Position Overview As an integral part of Saskatchewan Polytechnic, the Office Assistant will be responsible for a variety of administrative functions that support the educational environment. Key Responsibilities Develop and maintain an efficient system for managing extensive student data utilizing specialized database software. Oversee processes to...


  • Saskatchewan, Canada Saskatchewan Polytechnic Full time

    Position Overview As an integral part of Saskatchewan Polytechnic, the Office Assistant plays a crucial role in ensuring the smooth operation of administrative functions. Key Responsibilities Develop and maintain an efficient system for managing and monitoring extensive student data utilizing specialized database software. Oversee processes that guarantee...


  • Saskatchewan, Canada Saskatchewan Polytechnic Full time

    Job SummarySaskatchewan Polytechnic is seeking a highly organized and detail-oriented individual to join our team as an Office Assistant. In this role, you will provide exceptional customer service and administrative support to our clients and staff.Key ResponsibilitiesProvide administrative support to our clients and staff, including preparing and...


  • Saskatchewan, Canada Saskatchewan Polytechnic Full time

    Job SummarySaskatchewan Polytechnic is seeking a highly organized and detail-oriented individual to join our team as an Office Assistant. In this role, you will provide exceptional customer service and administrative support to our clients and staff.Key ResponsibilitiesProvide administrative support to our clients and staff, including preparing and...


  • Saskatchewan, Canada Saskatchewan Polytechnic Full time

    Job SummaryWe are seeking a highly organized and detail-oriented Administrative Assistant to provide support to the School of Computing and Digital Innovation at Saskatchewan Polytechnic.Key ResponsibilitiesProvide administrative support to program heads and instructors, including organizing course materials, managing supplies, and coordinating...


  • Saskatchewan, Canada Saskatchewan Polytechnic Full time

    Job SummaryWe are seeking a highly organized and detail-oriented Administrative Assistant to provide support to the School of Computing and Digital Innovation at Saskatchewan Polytechnic.Key ResponsibilitiesProvide administrative support to program heads and instructors, including organizing course materials, managing supplies, and coordinating...