Data Engineer with SQL and Snowflake
Hybrid
Edinburgh, United Kingdom
Freelance
21-02-2025
Job Specifications
Role :Data Engineer with SQL and Snowflake
Duration: 6 months
Location: Edinburgh(Hybrid)
Required Skills and Qualifications:
Proven experience working with SQL Server (e.g., T-SQL, Stored Procedures, Indexing, Query Optimization, System Catalog Views).
Strong experience in Snowflake architecture, including data loading, transformation, and performance tuning.
Proficient in ETL processes using tools such as Informatica PowerCenter and BDM, AutoSys, Airflow, and SQL Server Agent.
Experience with cloud platforms preferably AWS.
Strong knowledge of AWS cloud services, including EMR, RDS Postgres, Redshift Athena, S3, and IAM.
Solid understanding of data warehousing principles and best practices.
Strong proficiency in SQL for data manipulation, reporting, and optimization.
Knowledge of data modeling and schema design.
Experience working with large, complex datasets and implementing scalable data pipelines.
Familiarity with version control tools such as GitLab.
Experience with data integration, data governance, and security best practices.
About the Company
N Consulting is a global professional services company with leading capabilities in data analytics, digital, cloud and security. We come with experience and specialized skills across industries segments, we offer Consulting , IT Services, Technology and Operations services across the globe. Our quality of people is key to our success who deliver on time, serving clients across America, Europe and Asia. We embrace the power of change to create value and sustainable communities. Visit us at www.n-cons.co.uk. Know more
Related Jobs
- Company Name
- Methods Analytics
- Job Title
- (SC cleared) Senior Data Engineer - outside IR35
- Job Description
- On-site: near Worcester/Great Malvern/Gloucester Daily rate: up to £700 outside IR35 Duration: 6months with possible extension Clearance: Must be SC cleared; DV preferred We are seeking a seasoned Senior Data Engineer (Infrastructure) to join our team. This role is essential for designing, building, and maintaining sophisticated data infrastructure systems that operate across both on-premises and Azure cloud environments. The position involves deploying and managing scalable data operations that support advanced analytics and data-driven decision-making, crucial for our organisational growth and innovation. Requirements Develop and Manage Data Pipelines: You will design, construct, and maintain efficient and reliable data pipelines using Python, capable of supporting both streaming and batch data processing across structured, semi-structured, and unstructured data in on-premises and Azure environments. Hybrid Cloud and Data Storage Solutions: Implement and manage data storage solutions leveraging both on-premises infrastructure and Azure, ensuring seamless data integration and accessibility across platforms. Containerisation and Orchestration: Utilise Docker for containerisation and Kubernetes for orchestration, ensuring scalable and efficient deployment of applications across both cloud-based and on-premises environments. Workflow Automation: Employ tools such as Apache NiFi and Apache Airflow to automate data flows and manage complex workflows within hybrid environments. Event Streaming Experience: Utilise event-driven technologies such as Kafka, Apache NiFi, and Apache Flink to handle real-time data streams effectively. Security and Compliance: Manage security setups and access controls, incorporating tools like Keycloak to protect data integrity and comply with legal standards across all data platforms. Data Search and Analytics: Oversee and enhance Elasticsearch setups for robust data searching and analytics capabilities in mixed infrastructure settings. Database Management: Administer and optimise PostgreSQL databases, ensuring high performance and availability across diverse deployment scenarios. Essential Skills and Experience Strong Python Skills: Expertise in Python for scripting and automating data processes across varied environments. Experience with ETL/ELT: Demonstrable experience in developing and optimising ETL or ELT workflows, particularly in hybrid (on-premises and Azure) environments. Expertise in Hybrid Cloud Data Architecture: Profound knowledge of integrating on-premises infrastructure with Azure cloud services. Containerisation and Orchestration Expertise: Solid experience with Docker and Kubernetes in managing applications across both on-premises and cloud platforms. Proficiency in Workflow Automation Tools: Practical experience with Apache NiFi and Apache Airflow in hybrid data environments. Experience in Event Streaming: Proven ability in managing and deploying event streaming platforms like Kafka, Apache NiFi, and Apache Flink. Data Security Knowledge: Experience with implementing security practices and tools, including Keycloak, across multiple platforms. Search and Database Management Skills: Strong background in managing Elasticsearch and PostgreSQL in environments that span on-premises and cloud infrastructures. Your Impact In this role, you will empower business leaders to make informed decisions by delivering timely, accurate, and actionable data insights from a robust, hybrid infrastructure. Your expertise will drive the seamless integration of on-premises and cloud-based data solutions, enhancing both the flexibility and scalability of our data operations. You will champion the adoption of modern data architectures and tooling, and play a pivotal role in cultivating a data-driven culture within the organisation, mentoring team members, and advancing our engineering practices. Desirable Skills and Experience Certifications in Azure and Other Relevant Technologies: Certifications in cloud and on-premises technologies are highly beneficial and will strengthen your application. Experience in Data Engineering: A minimum of 5 years of experience in data engineering, with significant exposure to managing infrastructure in both on-premises and cloud settings. This role will require you to have or be willing to go through Security Clearance. As part of the onboarding process candidates will be asked to complete a Baseline Personnel Security Standard; details of the evidence required to apply may be found on the government website Gov.UK. If you are unable to meet this and any associated criteria, then your employment may be delayed, or rejected . Details of this will be discussed with you at interview.
- Company Name
- Found Talent
- Job Title
- BI Developer
- Job Description
- Are you a contract BI Specialist with experience of Microsoft Fabric and Microsoft Synapse Analytics? If so Found Talent are looking for BI Developer to join a Manchester based organisation on a 6 initial contract, outside IR35. Experience: Proven experience as a BI Developer or similar role Strong knowledge of Microsoft Fabric & Microsoft Synapse Analytics Hands-on experience with Data Warehousing, ETL processes, and data modelling Proficiency in Power BI, SQL, and Azure-based data solutions Ability to optimize large datasets Strong problem-solving skills and a data-driven mindset Nice to Have: Experience with Azure Data Factory, Databricks, or other cloud-based data services Familiarity with DAX We require a UK based candidate for this assignment
- Company Name
- N Consulting Global
- Job Title
- Data Engineer with Oracle
- Job Description
- Role: Data Engineer with oracle Location: Edinburgh(Hybrid) Duration: Contract Oracle as primary skill and Snowflake/Other Data Engineering as secondary • Strong hands-on Oracle PL/SQL development and Performance tuning skills. This person should ideally have some solution design experience or be able to design based on the requirements/discussions with cross-functional teams (if/wherever needed). • The candidate is expected to have some experience working in a Software Development/Web application-based Agile project. • UK experience is a must and preferably able to come to RBS Edinburgh office. • Banking and lending experience prefer
- Company Name
- Explore Group
- Job Title
- Data Scientist
- Job Description
- Data Scientist - Hybrid - Outside IR35 We are seeking a Data Scientist to join one of our key clients and contribute to a high-impact data platform project. The ideal candidate will have a strong ability to self-manage, design solutions, and scale data platforms. Key Responsibilities: Lead the design, scaling, and implementation of a data platform. Work closely with stakeholders to understand business needs and translate them into technical solutions. Manage and optimize data pipelines to support analytics and machine learning use cases. Collaborate with Product, Programme Engineers, and Data Scientists within the AND Team. Develop and present Proof of Concepts (PoCs) for data solutions. Ensure smooth integration of Azure & Power BI into the data ecosystem. Maintain a strong relationship with clients and key stakeholders, ensuring alignment with business goals. Key Requirements: Proven experience as a Data Scientist with a strong technical background in data platform scaling. Strong understanding of Azure & Power BI. Ability to design and implement data-driven solutions with a focus on scalability and performance. Hands-on experience with data solution architecture and proof-of-concept development. Ability to self-manage and drive projects forward with minimal supervision. Excellent stakeholder management skills, including liaising with the Head of Data & Client teams Contract Type: 6-Month Contract (Outside IR35) Rate: £350 - £400 per day Location: Hybrid – Guildford (once a week) Start Date: ASAP If this role is of interest, please apply and we can arrange a time to speak Data Scientist - Hybrid - Outside IR35