Express Scripts Canada (ESC) is seeking a Database Administrator, with expertise in leveraging Microsoft SQLServer databases to support analytics reporting. We are looking for an individual who enjoys a challenge and loves an innovative work environment. We know that our clients expect the best from us and that means providing benefit management solutions that deliver better health benefits for less to our clients – employees, employers, insurance carriers, third-party administrators and government health programs.
In this role you will assist the team in building, improving, and maintaining a world class data analytics environment. You will roll up your sleeves to work with a team of technology engineers with a growing base of expertise in infrastructure-as-a-service and platform-as-a-service, in designing, developing, integrating, and testing a data analytics environment dedicated to that Express Scripts Canada. You should have extensive experience working with Microsoft database and related analytics technologies deployed in a clustered environment. You should possess excellent communication skills, and a drive to make a significant impact in the ways Canadians benefit from leading edge health benefits services. Expect to take ownership of on key architectural decisions related to the analytics database, to collaborate closely with a growing team, and to hold a high standard in production availability and performance.
Design, develop, maintain and document logical and physical database deployment patterns with automation, scalability foremost in your thought process
Demonstrate a high degree of proficiency in working with structured data, including collating disparate data sets from many sources
Standardize, normalize and/or de-normalizing data sets
Develop and/or assist in the design, development of extract transfer and load (ETL) processes
Work with business and technical stakeholders to solve abstract business problems and thriving in an environment where every day is a new challenge to ensure successful delivery of projects
Work with Database Architect and other systems architects to ensure proper database architecture is designed into business requirements for projects from the ground up
Provide maintenance and support on a rotational basis for all database systems including patching, tuning and troubleshooting
Peer-evaluate production deployment plans
Develop automation scripts both monitor and maintain the systems and to support applications
Maintain detailed design documents with all changes
Post-secondary degree in computer science, information systems or computer engineering
5+ years of data warehousing experience in a complex highly regulated environments; with emphasis on HA in an active/active network environment
Extensive knowledge of MS Office tools including MS Project and MS Excel
Experience in SQL Server 2016+ SSAS, SSIS
Experience in MS SQL Server Database Administration
Experience using one or more programming languages
Ability to work both independently, with other team members, and across teams
Able to work in a fast-paced environment where priority changes occur often
Able to work with distributed teams spread across multiple time zones
Ability to communicate technical information in a concise, understandable and accurate fashion to non-technical personnel
Demonstrated ability to prioritize work load and meet multiple project deadlines
Willingness to work a flexible schedule to accommodate project deadlines and escalations
ABOUT EXPRESS SCRIPTS CANADA
Express Scripts Canada, a registered business name of ESI Canada, an Ontario partnership indirectly controlled by Express Scripts, Inc. (Nasdaq: ESRX), is one of Canada’s leading providers of health benefits management services. From its corporate headquarters in Mississauga, Ontario, just outside Toronto, Express Scripts Canada provides a full range of integrated pharmacy benefit management (PBM) services to insurers, third-party administrators, plan sponsors and the public sector, including health-claims adjudication and processing services, Home Delivery Pharmacy Services, benefit-design consultation, drug-utilization review, formulary management, and medical and drug-data analysis services, to better facilitate the best possible health outcomes at the lowest possible cost.
It will be a condition of employment that the successful candidate receives the Enhanced Reliability Clearance from the Federal Government. The candidate will be required to provide supporting documentation in order to receive Clearance if required.
We offer a competitive salary, along with a positive work environment built on solid corporate values, integrity, mutual respect, collaboration, passion, service and alignment.
We are an equal opportunity employer that promotes a diverse, inclusive and accessible workplace. By embracing diversity, we build a more effective organization that empowers our employees to be the best that they can be.
We are committed to creating a working environment that is barrier-free and we are prepared to provide accommodation for people with disabilities. Thank you for your interest in this position, however only qualified candidates will be contacted for an interview. No telephone calls please.
For more information about Express Scripts Canada, visit its Web site at www.express-scripts.ca.