Skills

Communication Problem Solving SQL Architecture Enterprise Architecture Databases power bi SQL Server Analytics

Job Specifications

Job Description:

On behalf of our Healthcare Client, Affinity Healthcare Solutions is looking for a Senior Programmer / Senior SQL Developer to augment the current Cancer App & DSP (Data Sharing Platform) technical support team. The chosen individual’s work will be comprised of a mixture of steady state and project-based efforts.

Responsibilities:

• Database conversions

• Prepare data for analytics

• Investigation into and design of data sharing platform (DSP)

• Prepare for security models for DSP

• Technical governance

• Troubleshooting and problem solving

• Advance the goals of the DSP

• After-hours support as needed

Qualifications:

Mandatory Requirements

• University degree in Computer Science or a related discipline, or an equivalent combination of education and experience

• Minimum 15 years of demonstrated IM/IT experience

• Minimum 5 years of experience supporting and maintaining health applications for Regional Health Authorities and/or Departments of Health in a Canadian Provincial jurisdiction

• Minimum 10 years of experience with SQL Server Integration Services (SSIS), including creation of SSIS packages

• Strong written and oral communication skills in English

• Availability to start work immediately on site in Fredericton, New Brunswick

Scored Requirements:

• 5+ years of recent experience as a Senior Programmer/SQL Developer on health analytics or health reporting database systems for Regional Health Authorities and/or Departments of Health in a Canadian Provincial jurisdiction

• 10+ years of experience with relational database systems, including SQL Server (version 2012 or later)

• 8+ years of experience maintaining and developing SQL Server databases, tables, views, queries, functions, stored procedures, indexes, scheduled jobs, triggers, packages, and performance tuning

• 10+ years of experience with Enterprise BI or other analytic/data warehouse technologies, with preference for Power BI administration

• 5+ years of experience designing, developing, and deploying SSRS reports and/or Power BI dashboards

• 8+ years of experience developing and managing the implementation of technical solutions in operational environments

• 8+ years of experience in enterprise architecture involving multiple systems and domains

• 3+ years of experience with Cognos/Impromptu

Affinity Earn:

Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/

About Affinity:

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number: 12734

About the Company

Welcome to Affinity Group -- your trusted partner in business and technology consulting. As a carbon-neutral company certified by ClimatePartner and recognized by the Globe and Mail as one of Canada's fastest-growing companies, we are dedicated to delivering an unrivalled experience for our employees, consultants, and clients. Professional Excellence Across Disciplines: - Cyber Security Solutions: Protecting your operations with cutting-edge security measures. - Data Analytics and Business Intelligence: Transforming data in... Know more