SAS DataFlux Manager - ETL/SQL (4-5 yrs)

JOB PURPOSE :

Data Analysts are responsible for a range of data-related activities including provision of data extracts and data transformation solutions for the company. Using specialist tools, the role is responsible for building and the delivery of the solution.

The Data Analyst is required to engage with stakeholders (both internal and external), so good communication skills underpin everything we do. Due to the nature of working with Data, the role is required to follow specified processes

JOB DESCRIPTION :

Key Accountabilities :

- Collaborate with colleagues to understand, clarify, and refine both functional and non-functional requirements for all assigned work

- Develop code and complete unit/integration tests to ensure delivery of high quality, fit-for-purpose solutions

- Investigate data issues as required, working with colleagues to understand causes and suggest fixes as quickly as possible, and, where necessary, participate in root cause analyses to identify practical long-term improvements

- Provide regular progress reports to Line Manager, Project Managers, and other key stakeholders

- Maintain effective documentation for all software developed and share expertise with colleagues to share knowledge across the whole team

- Provide cover for all BAU Data Solutions activities.

- Routinely review BAU processes to ensure they are required, current, and fit for purpose.

Risk Management :

- Champion a culture of strong internal control and risk management within the Data Solutions team

- Be aware of requirements for transmission of PAN and PII data in order to advise stakeholders of best practice

- Escalate any control deficiencies or risks noticed

- Comply with all company policies and procedures

- Comply with all regulatory procedures applicable to the role

- Report any information security incident, weakness, or malfunction

REQUIRED SKILLS & EXPERIENCE :

- Strong RDMS, Oracle and/or ANSI SQL skills

- Experience with an industry-standard ETL tool e.g. SSIS, Talend Open Studio, DataFlux Data Management Studio etc.

- Demonstrable analytical and problem solving skills

- Strong communication and interpersonal skills

- Good documentation / report writing skills

- Structured approach, with a high attention to detail

- Ability to work well under pressure and to tight deadlines

- Positive, confident attitude and enthusiastic self-starter with a "can do" attitude

- Team player, dynamic and adaptable to changing situations

- Proactive, shows initiative, takes ownership to deliver on commitments

- Exposure to SAS DataFlux Data Management Studio

- Experience with Power BI

- Some knowledge of data warehousing

- Informatica PowerCenter

- Apache Airflow

- Oracle Data Integrator (ODI)

- Azure Data Factory

- Exposure to Agile Software Development methodology

- Knowledge of version controlling using Stash/Bitbucket

EXPERIENCE REQUIRED :

- Recent experience of working well under pressure, to tight deadlines, and handling more than one piece of work at a time

- Current experience with Oracle and/or ANSI SQL

- Experience of working with business representatives to clarify and document requirements

- Experience working within financial services, insurance or customer assistance industries

- Experience with other SQL variants (e.g. PostgreSQL, SQL Server etc.)

- Experience in business report building

- Working knowledge of payment processing regulations (PCI-DSS) and security standards (ISO27001)

Experience :

- SAS DataFlux Data Management Studio : 4 years (Required)

- Power BI : 4 years (Required)