Dataflux Analyst
Job Title:
SAS DATAFluxmanager /Analyst
Reports Directly to
VP - IT
Job Type:
Contract for 1 yr + Extendable- JOB DIMENSIONS:
Experience:
4 Plus Years
Job Location:
Remote- 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:
Essential
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
Desirable
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:
Essential
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
Desirable
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)