- Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
- Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
- Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
- Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
- Should have good SQL scripting skills(TSQL or PLSQL).
- Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
- Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
- Experience with data security and data access controls and design
- Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
- Build processes supporting data transformation, data structures, metadata, dependency and workload management
- Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
- Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
- Must have expertise in AWS or Azure Platform as a Service (PAAS).
- Certified Snowflake cloud data warehouse Architect (Desirable).
- Should be able to troubleshoot problems across infrastructure, platform and application domains.
- Must have experience of Agile development methodologies
- Strong written communication skills. Is effective and persuasive in both written and oral communication.
Data Architect
Toronto, Ontario, Canada
Job Reference 1190773
Location Toronto, Ontario, Canada
Industry Other - IT
Function IT & Telecoms
Job Type Permanent
Date Added June 26, 2023
Related Jobs
We are working with a client to source a Piping Engineer. This is a long-term contract role working on a residential basis. Please see details below.
Title: Piping Engineer
Start Date: ASAP
Duration: 12 months (potential for extension)
Location: Qatar
Working Schedule: 5 days per week / 9 hours per day
--Experience Required--
Key Job Accountabilities
• Knows the discipline scope/cost/time requirements, assists the team to meet expectations, and coordinates with other disciplines to ensure project success.
• Supports management of project change and progressing for the discipline and works with the Project Management Team to take corrective actions regarding any issues, staffing requirements, scope changes, progressing, or other events that could affect project completion and/or profitability.
• Plans discipline quality, monitors quality activities, squad checking, drives and participates in squad checking, recommends improvements, and takes action where required.
• Provide technical support within the discipline team, liaise with the project team, and consult with relevant resources as required.
• Coordinate review and approval of design and interfaces on client requirements and specifications.
• Gathers data from multiple sources and prepares engineering studies, analyses, calculations, etc.
• Determines technical issues, defines alternate solutions, establishes pros/cons for multiple solutions, and makes recommendations through official project documents such as technical queries, technical deviations, etc.
• Creates final documentation incorporating all relevant information and pursues customer approval.
• Perform discipline specific engineering services such as:
• Identify and report changes to project scope;
• Contribute to appropriate studies, analyses and recommend actions;
• Assist with the preparation of detailed designs and drawings, specifications, data, calculations and reports;
• Provide assistance during procurement, construction and commissioning activities
--Qualifications--
Knowledge and Key Skills
• Good knowledge of discipline design/engineering with sufficient experience in different discipline areas.
• Microsoft Office – Word, Excel, Power point
• 3D Review Software: Navisworks, SPR Advantageous skills:
• CAESAR II
• 2D Software: AutoCAD, Micro-Station
• 3D Software: PDS, S3D / PDMS, E3D
If you would like to be considered for the position, please apply direct to this advertisement with your CV with contact details.
Location: London, UK
Hybrid - Ideally 3x week in the office
Start date: August or September 2023
Duration: 3 months minimum
Hours of work: 9am - 5pm local time
Reports to: UK Health Manager
Purpose
To provide expert medical advice, guidance and support in specific fields of occupational and environmental health to management and staff of our company in line with our Health standards, protocols and business performance monitoring and reporting.
?
To undertake a variety of occupational health assessments including but not limited to; preemployment, offshore medicals, transfer medicals, short- and long-term business assignment medicals worldwide, consultations, fit to return to work medicals and ill health retirement and pension criteria reviews.
?
To support us with new health business initiatives where practically feasible and provide input into ways of working that helps delivers efficiencies.
Personal Characteristics
?
In an ever-changing world where priorities vary on a daily basis, this job demands a person who is reliable, flexible, can deal with many different strands/elements of work and possesses excellent tacit and soft skills.
?
Technical knowledge of the occupational health is not sufficient on its own.
?
The individual needs to demonstrate their ability to innovate and help the business through development of digitalisation, simplification and worker welfare.
Nature and Scope of Position
? To work as a member of the Shell Health Occupational Health Team based in London but working across a wider UK OH team.
? The Shell London Occupational Health Department provides occupational health support, a health screening service and clinical advice to Shell UK Employees.
? Advice and assistance is also given to offshore medics.
? The Medical Adviser will be under the supervision of the UK Health Manager, and will work in Shell Centre, London.
? The current workload requires 1 part time Medical Adviser.
? The role is working within the Oil/Gas/Energy Industry.
Experience and Qualifications
? Fully registered Medical Practitioner with the GMC and has a recognised qualification in Occupational Medicine.
? Experience working in the field of Occupational Medicine in the Oil and Gas Industry is a plus.
? Keyboard skills and familiarity with common Microsoft packages.
? An Oil & Gas UK registered doctor is a plus.
? Experience in travel medicine would be preferred.
? Candidate should have medical background (requires to be an OEUK registered doctor).
Principal Accountabilities
1. Fitness to work planning, assessment and screening as per the Health fitness to work standards and protocols and the OEUK Medical Aspects of Fitness for Offshore Work Guidance.
1. All types of health surveillance required as per the Health Medical Surveillance protocol and in compliance with UK legislation.
2. Sickness Absence Case Management including periodic review with Management and Human Resources. Return to work rehabilitation. This requires managing a database with monthly reporting of sickness absence in terms of days lost, incidence new cases and nature of illness.
3. Proactive liaison with General Practitioners and Medical Specialists in relation to employee illness and medical incapacity.
4. Provision of Medical Emergency support at London, where the need arises. It should be noted that immediate first aid will be provided by the floor stewards and security.
5. Liaison with Health Providers and major contractors in respect of Medevac and incident management.
6. Advice and medical assistance to offshore medics and other HSE personnel.
7. Assessment, diagnosis, investigation and incident reporting of Occupational Illness cases as per the Minimum Health Management Standards and protocols.
8. Maintain records of all consultations and input health data into the health records and One Health IT tool.
9. Communication and presentations to management and employees on health related topics.
10. Review and analysis of health data for benchmarking and management reports in relation to early and successful return to work. Preventable medevacs, identification of hot spots within the business in relation to sickness absence and proactive management.
11. Business partnering with us on shared vision aspects with regards continuous improvement, ongoing efficiency savings with a focus on delivering value for money and cost saving opportunities.
12. Perform a leadership role within the clinic to ensure that continued progress against plans are made.
13. Involve themselves in 1 or more of the project items from the Health (priorities on a page) POAP.
14. Attend required regional and global health meetings along with regular attendance at clinic/team meetings and any wider HSE team meetings in order to continue the understanding of the business and keep traction on areas of work and demonstrate progression of these.
15. Comply with company and health policies & procedures.
16. Assist in any training/development opportunities for staff.
17. Attend any meetings on behalf of the health manager.
18. Develop knowledge of our Performance, monitoring and reporting system and participate in any internal/external investigations e.g. Incident review panels.
19. Manage health surveillance and provide training/education around this to the clinical team.
20. Expected to participate in clinical governance, audit and regular clinic meetings.
Airswift is an international workforce solutions provider within the energy, process and infrastructure industries. Airswift serves as a strategic partner to our clients, offering a turnkey workforce solution to capture and deliver the top talent needed to complete successful projects by aligning with the unique needs of our clients. With over 800 employees and 6,000 contractors operating in over 50 countries, our geographical reach and pool of talent available is unmatched in the industry and the level of experience, exposure and expertise that the organization has is unparalleled.
Our client is seeking for CAD Administrator to work within their facilities located in Perth, Australia.
The Company
Our client is a major consultancy player in the resources sector. With a number of upgrade projects currently underway they are looking for a CAD Administrator to assist them on the ongoing projects.
The Role
Working alongside a team of engineers and designers, you will be utilising your skills and experience to support them on day-to-day basis, as well as performing automation, simplification and standardisation of their workflows.
Key Responsibilities
- Manage and administer CAD software, licenses, and tools to ensure efficient and effective operation.
- Provide technical support to design teams, troubleshoot issues, and enhance workflow efficiency.
- Collaborate with engineering and design teams to customize CAD systems to meet project requirements.
- Maintain CAD standards and guidelines to ensure consistent, high-quality designs.
- Assist in developing and implementing CAD training programs for team members.
- Stay updated with the latest CAD technology trends and recommend improvements.
- Ensure optimal CAD system performance through regular maintenance.
- Collaborate with IT teams to address hardware and network needs.
- Manage CAD files, ensuring organization, version control, and backup procedures.
- Document CAD processes and procedures for future reference.
Requirements
- Bachelor's degree in Engineering, Computer Science, or related field.
- Proven experience as a CAD Administrator or similar role (minimum 8 years).
- Proficiency in CAD software such as AutoCAD, SolidWorks, Microstation etc.
- Strong technical problem-solving skills.
- Excellent attention to detail and ability to manage multiple tasks.
- Effective communication and collaboration skills.
- Knowledge of CAD software installation, configuration, and maintenance.
- Familiarity with IT infrastructure and networking concepts related to CAD systems.
- Relevant certifications in CAD administration are a plus.
This role is based in Perth, and as such only Perth-based candidates with full working rights can be considered.
Please apply now or send your CV to muhamad.hafizi@airswift.com
For enquiries, please call Hafizi at+61 861 875 421.