Description:
Overall Purpose: Application Support Analyst will be responsible for the support and maintenance of SLF’s ETL jobs and reports including new technologies for data lake support and Cloud.
Key Tasks
AWS Cloud Data Lake Infrastructure Support
- Support for the existing deployed projects.
- Daily batch cycle monitoring and issue fixes and Alerting.
- Operational metrics reporting and support
- 1st line of Support for Data lake cloud issues
- Scheduling system support
- User Access and Security work
- Release Management Support Activities
ETL Support
- Maintain and acquire expertise in the development, implementation and support of enterprise data warehousing and business intelligence solutions.
- Develop SQL Server objects including complex stored procedures, extracts and interfaces to multiple current and legacy systems.
- Develop high quality and innovative data outputs e.g. Microsoft BI, including SSRS, SSIS, SSAS, Logi Analytics as well as Crystal Reports and interactive dashboards (Sharepoint etc).
- Collaborate with data and application architects, business and production system analysts, QA analysts and other system owners in the implementation and support of current and new data warehouses and their outputs.
- Interact closely with our business systems analysts and business end users to understand requirements and provide accurate solutions and estimates.
- Develop a comprehensive understanding of Sunlife’s business.
- Constantly produce high-quality, well documented code that is easily maintainable following Sun Life best development practices
- Perform and participate in the peer review process
- Work in a multi-site team environment
- Provide outstanding customer service and follow up.
- Be able to provide out of hours on call support if necessary
Essential Experience
Minimum: Bachelor's Degree in Computer Science, Computer Information Systems, or similar accreditation and experience
- 3rd level qualification in a Computer Science related discipline.
- 3 years+ software development or other relevant experience in an IT environment.
- Experience of working in the financial services sector (particularly insurance, ideally group benefits) is a plus.
- Strong Microsoft BI skills (SSIS, SSRS, TSQL) are essential
- Experience with Business Intelligence and reporting tools such as Business Objects, Crystal or LOGIXML is ideal but not essential.
- Strong written and verbal communications skills are required.
- AWS Cloud support training will be provided
Attributes
Customer focus, service delivery oriented
Strong analytical and problem solving skills
Strong written and verbal communication skills
Ability to work on multiple, concurrent projects
Ability to work with team members spread over multiple locations
Desire to learn and seek out challenges