Int. Data Architect with MS BI Stack (SSRS, SSAS, SSIS, SSMS) expertise to develop and deliver [...]

S.i. Systems; Regina; Remote; CAD 90,000 - 110,000; Full time

Job summary

A leading technology consulting firm in Canada is looking for an experienced Data Architect with strong expertise in the MS BI Stack (SSRS, SSAS, SSIS, SSMS). This remote role involves developing and delivering crucial MIS reports for a healthcare client, focusing on data architecture, transformation, and analytics. The ideal candidate will have relevant experience, particularly in managing data warehouse projects, and possess excellent analytical skills. The position is for a duration of 4 months with likely extensions.

Qualifications

• 5+ years of experience with MS BI Stack (SSRS, SSAS, SSIS, SSMS).
• 5+ years of DBA experience.
• Strong understanding of data architecture and transformation strategies.
• Excellent knowledge of SQL and data warehouse management.

Responsibilities

• Develop and optimize database models for healthcare data.
• Implement project data-related needs and maintain data integrity.
• Collaborate on programming and automate reporting solutions.
• Migrate data and design comprehensive data models.

Skills

Experience with MS BI Stack (SSRS, SSAS, SSIS, SSMS)

DBA experience

Data warehouse management

Data backup and recovery

ETL and Data design

Data security

SQL proficiency

Analytical skills

Education

Bachelor's degree or Community College diploma in computer technology

Tools

SQL Server

Oracle

Python

R

Job description

Int. Data Architect with MS BI Stack (SSRS, SSAS, SSIS, SSMS) expertise to develop and deliver MIS reports and case costing data extracts for our regional healthcare client - SW

Duration : 4 months (extensions likely)

Location : Remote (EST Hours)

We are searching for a seasoned technical Data Scientist – Data Architect to join our team. As a valued member of the Enterprise Intelligence Team, the Data Scientist – Data Architect will play a crucial role leading a strategic project that is a key priority for the hospital – development and delivery of MIS reports and case costing data extracts. As a valued member of the team, the Data Architect for Business Intelligence & Data Analytics, HIS will play a crucial hands‑on role in designing and implementing all project data‑related needs. We are looking for a strong hands‑on candidate who possesses a holistic view of IT in a healthcare setting including experience and strong knowledge of data architecture, data transformation strategies, data warehousing, BI, and analytics. Reporting to the Director, Enterprise Intelligence, the successful candidate will apply rigorous project management knowledge, technical expertise and interpersonal skills to successfully plan and execute on the project to completion using standard project management methodologies, best practices, and tools.

Responsibilities

• Responsible for developing and optimizing database models to store and retrieve electronic medical record and administrative data.
• Modeling / transformation, design and documentation
• Proficiency in developing reports with SQL, SSRS / SSIS / SSAS tools;
• Data warehouse - Development and analysis development and maintenance of architectures and data structures to support reports and analyzes which includes among other things the regular updating / updating of the ETL, the design of the data mapping, the integration and aggregation of data from various sources, SQL Server database;
• Programming and testing - In close collaboration with the programmer analyst, make sure to have an action plan for programming and automating the reports of the decision support service using programming languages such as SQL, SAS, SSAS, SSRS, SSIS or Business Objects or other reporting tools in the HIS;
• Execute thorough analysis / profile of all system data elements (tables and fields), migrate data, and design data models with strong expertise in SQL, Oracle, Python, R and / or similar data storage software query languages
• Developing database solutions to store and retrieve company information
• Analyzing structural requirements for the new Oracle Health software and may associated applications. Design conceptual and logical data models and flowcharts
• Optimize new and current database systems and improve system performance by conducting tests, troubleshooting and integrating new elements
• Perform tests and evaluations regularly to ensure data security, privacy, and integrity
• Participate in the development of archival and migration strategies of legacy applications data and / or databases
• Assist in the implementation and execution of the data migration and data archival strategies
• Reviewing gaps and proposing a solution for data migration and archival during the solution design phase
• Define, document, communicate, and stabilization of all relevant data integration and transfer processes
• Support the design and help implement visualization and reporting of archived data to satisfy business needs and data retention policies of the organization

Must Haves

• 5+ years of experience with MS BI Stack (SSRS, SSAS, SSIS, SSMS)
• 5+ years of DBA experience
• Demonstrable experience in managing data warehouse and BI domain
• Excellent knowledge of data backup, recovery, security, integrity, and SQL
• Familiarity with database design, documentation, and coding
• Strong understanding of ETL / Data design / Data model / Data consolidation / Data cubes
• Strong understanding of Data Security
• Good functional knowledge and ability to work with both MS SQL, and Oracle and NoSQL database environment
• Strong analytical skills with the ability to translate business needs into technical solutions
• Project management experience would be an asset
• Ability to exercise independent judgment and take action
• Highly self‑motivated and self‑directed with keen attention to detail
• Consistent and regular attendance required

Education & Training

• Bachelor's degree or Community College diploma relating to computer technology
• In-depth understanding of database structure principles
• Experience gathering and analyzing system requirements
• Knowledge of data mining and segmentation techniques
• Expertise in SQL and Oracle
• Experience with producing conceptual and logical architecture diagrams