ETL Contract Jobs

• Creation and maintenance of a Business Object data warehouse ;
• Gathering & analysis of the business requirements;
• Design and development of complex Business Object reports;
• Design and development of complex Dashboards;
• ETL processes (BODS) review, analysis of improvements and implementation;
• Data modelling;
• Physical DB design and DB performance analysis;
• Elaboration of test programs;
• Technical migration to new tools or to new versions;
• Writing of Business and Technical documentation;
• Assistance in the implementation of Datawarehouse development methodologies to the team;
• Collaboration with the team leader in the elaboration of strategy documents related to the Datawarehouse.

• In depth knowledge of relational database systems applied to data warehouse;
• In depth knowledge of data warehouse architecture;
• In depth knowledge of SQL;
• In depth knowledge of Business Objects reporting tools;
• In depth knowledge of ETL tools (BODS will be an asset);
• Good knowledge of online analytical data processing (OLAP) and data mining tools;
• Good knowledge of Data quality concepts;
• Knowledge about development of dashboards will be an asset;
• Knowledge of [email protected], PM2 and ITIL, where applicable, are required.
• Experience with online analytical processing and data mining tools is an asset;
• Experience with development of dashboards is an asset.
• Ability to cope with fast changing technologies used in application developments;
• Ability to participate in multi-lingual meetings, ease of communication;
• Capability of integration in an international/multicultural environment, rapid self-starting capability and experience in working in team;

• Minimum 11 years of professional experience in Business Objects (BOXI or SAP BI)
• Minimum 11 years of professional experience in Oracle RDMBS Database development, Data Modelling and SQL;
• Minimum 7 years of professional experience in BODI or BODS;
• Minimum 7 years of professional experience in Data Warehouse;
• Minimum 4 years of professional experience in project management or as team leader;
• Minimum 5 years of professional experience in Business Process Modelling;
• Minimum 5 years of professional experience in JEE (Java and Weblogic)

Thurrock RQ349073 Interim SSRS Report Developer & SQL Developer - Children & Adults services [Enhanced DBS required]

Responsible for developing, documenting, and supporting standardized and/or customized business intelligence reports using advanced ETL processes

To enable the exploitation of structured and unstructured data to meet the needs of Children’s and Adults services

To ensure that all activity is reflected in management and performance measures ultimately leading to the successful delivery of Statutory returns.

Ensure that policies and procedures are adhered to and monitored so that all data recording is accurate and timely and ensures the development of quality and cost effective services within Adult Social Care.

Pay Rate: £400.00 per day PAYE

This is a temporary, but possibly long term role.

N.B. – Please quote the Job Title & Vacancy Reference No. in your application, or we will be unable to match your CV to the role being applied for.

Giving yourself the best chance of success:

• Your CV needs to be current with your latest/present role, noting that we won’t be able to submit it with any unexplained gaps in employment. It will save time and thus improve your chances of success if we can put your CV forward immediately and without having to ask you for a revised version.
• Your CV must cover the “Essential Requirements” (see below) of the role, ideally by way of bullet points that directly address the “Essential Requirements” listed. Please include any DBS details and other qualifications called for.
• Your CV should clearly state that you are available to start work either immediately, or at short notice. In general, our clients are unable to work with notice periods of more than 1 week from the point at which a role is offered, 2 weeks at the very most.
• We cannot put forward covering letters, so please ensure that your CV in isolation contains all relevant information being called for.
• We recommend that you consider sending us by email (see * below) a suitably ‘tailored’ CV for each role that you apply for, noting that job boards, sites and aggregators will generally store only one version of your CV, which can be a bit limiting...

“Essential Requirements” – Please check to ensure that your CV addresses the following items:

• Your address (including post code) and a telephone number so that we can reach you during working hours
• Your recent UK working experience going back at least 5 years, or full employment history if you have been working for fewer years than this.
• Your availability to work either immediately, or at short notice.
• Your DBS must be either through us or be accompanied by a subscription to the DBS updating service
• Advanced SSRS Reporting writing skills
• Advanced SQL skills including ETL scrips
• Experience in building Data Warehouses
• Documenting Configuration of SQL Scrips and SSRS reports
• Developing SSRS skills within a team
• Working with a Social Care software system
• Reporting from Liquidlodgic LCS
• ***Qualification details and any other experience/skills relevant to the job role to help support your application (and help us to help you!) – please give full details within your CV document.

Other preferable/desirable details to include on your CV, if applicable:

• Any local authority/public sector experience
• Any relevant qualifications held or being studied for

Client Category: Local Authority

Division(s)/Disciplines involved: Children & Adults Services/SSRS Report Developer & SQL Developer

Anticipated Length of Assignment: All of our roles are technically temporary, though opening assignments can be and often are, extended by clients on a longer term basis and can sometimes become permanent. This opening assignment is for 2-3 months.

Hours per week: 37 Monday – Friday, normal working hours

Whilst our ads will appear on partner sites such as Indeed, they are also listed - and will appear first - on our own website: Triumph Consultants Limited: www.tclrec.com

• If you would prefer to send a CV straight to us rather than by way of an on-line application, you are very welcome to do so via [email protected] but please quote both the job reference and job title exactly as they appear below:

Job Ref: Thurrock RQ349073

Interim SSRS Report Developer & SQL Developer - Children & Adults services [Enhanced DBS required]

Please do try to resist contacting us with requests for progress updates.

We really do read every CV sent to us. All applications will be acknowledged by a human, not a robot, provided the job remains live and provided your CV meets the “Essential Requirements” listed.

Please note that we do our level best to take down ads as soon as roles have been filled. We are not in the business of harvesting CVs.

Important: We will interpret your application as being permission to submit your CV to this role (with the right to represent you) unless you advise us to the contrary.