Your current job search

Snowflake Data Architect - £110,000 - £125,000 - Remote UK



Company Overview:

My client is a modern data consultancy that empowers data-driven organisations to realise the full value of the Snowflake Data Cloud. They provide consulting and managed services in data architecture, data engineering, analytics, and data science. Renowned for their deep expertise, ease of collaboration, and exceptional culture, they are looking for curious and creative individuals to join their dynamic environment. This is a fully remote role allowing an ideal work-life balance.

Role Overview:

As a Data Architect, you will design and implement data architecture solutions for clients, leveraging expertise in data modelling, data integration, and analytics. You will lead architectural discussions and design exercises to build and automate large-scale data migrations with cross-functional teams in the US, Portugal, and Costa Rica. You will also work closely with Sales teams to provide pre-sales architecture expertise. Ideal candidates will have strong communication skills and the ability to guide clients and project team members.

Requirements:

* 6+ years of experience in data warehousing/BI/analytics.
* 3+ years as an Architect.
* Experience with Cloud platforms.
* Strong knowledge of data integration techniques (ETL/ELT, data pipelines).
* Proficiency in SQL and scripting languages (e.g., Python).
* Excellent problem-solving and analytical skills.
* Strong communication and presentation skills.

Nice to Have:

* Experience with Snowflake.
* Understanding of Snowflake design patterns and migration architectures.
* Cloud experience on AWS (Azure, GCP are nice to have as well).
* Python scripting.



Interviews ongoing don't miss your chance to secure a role working with cutting edge technology while maintaining exceptional work-life balance.



Contact me @ j.shaw-bollands@nigelfrank.com or on 0191 338 6641.



Snowflake, Data Architect, Architecture, Architect, Consultancy, Cloud, WFH, Remote

Our TOP CLIENT has retained us for a Data Quality Analyst role. They are known and highly recognized for their stability and commitment to a collaborative teamwork environment. The Data Quality Analyst will be responsible acquiring data from primary or secondary sources. This position involves obtaining legacy data from the former billing system, and mapping it to fit the billing system data model.



Location: Remote

Salary: $80K to $90K



Must Have skills:

Strong SQL skills

Python scripting

Database tools like pgAdmin, Toad, or DataGrip

Relational Databases experience (any)



Data collection: Acquiring data from primary or secondary sources.This position involves obtaining legacy data from the former billing system, and mapping it to fit our billing system data model. We sometimes do this ETL work internally, and/or work with ETL partners. Analytical skills are important tool, and just being comfortable working with data files.



* Data interpretation: Using statistical techniques to analyze data and draw logical conclusions.
* Data visualization: Using tools to identify patterns and present findings to stakeholders.
* Report and presentation development: Creating reports and presentations to explain data to stakeholders, IT representatives, and other data analysts.
* Data quality control: Validating and linking data, and providing quality assurance for imported data.
* Data protection: Understanding data protection issues and processing confidential data according to guidelines.
* Confirms project requirements by studying client requirements: collaborating with others on development and project teams.
* Works closely with project managers to understand and maintain focus on their analytics needs, including critical metrics and KPIs, and deliver actionable insights to relevant decision-makers
* Proactively analyze data to answer key questions for stakeholders or yourself, with an eye on what drives business performance, and investigate and communicate which areas need improvement in efficiency and productivity
* Create and maintain rich interactive visualizations through data interpretation and analysis, with reporting components from multiple data sources
* Gather, interpret, and present data to help others understand and solve problems.
* Turn project requirements into custom-formatted reports, and ability to analyze business procedures and recommend specific types of data that can be used to improve upon them.
* Develop, implement, and maintain leading-edge analytics systems, taking complicated problems and building simple frameworks.

Role: Scala/Java Developer

Location: Anywhere in Norway (remote)

Working in-house, you'll play a vital role in designing and building web and desktop applications for both current and future customers.

Beyond coding, you'll also have the chance to participate in technical meetings and contribute to key decision-making processes.

You'll join a close-knit development team in Bergen while being part of a larger network of 400 colleagues across Europe and the US.

What we're looking for:

* Experience in full-stack development.
* Knowledge of Scala, or a willingness to learn it if you have a background in another programming language.
* Familiarity with agile development practices.
* A passion for innovation and exploring new technologies.

What we offer:

* A comprehensive pension and health insurance plan.
* Financial support for gym memberships or exercise classes.
* Time allocated for learning new technologies.
* Flexibility with remote or home working.
* Flexitime options for working hours.
* A relaxed, flat-structured work environment.

For any questions and to get involved in the process, contact Dylan Johnston on:

* d.johnston1@jeffersonfrank.com
* LinkedIn: https://www.linkedin.com/in/dylan-johnston-666707130/

A global software technology consultancy are looking to recruit a Senior Python Developer to work for a client in the financial services sector. As a Python Developer you will have an eye for details across all aspects of the development lifecycle while maintaining organisation and good clean code. You will be able to effectively communicate with both internal teams and external clients.

Responsibilities
* Design, develop, enhance, and maintain applications and components
* Collaborate with internal and external clients to understand their application development needs, adapting and customising our platform to suit them
* Work with internal and external clients to gather and analyse requirements and product enhancements
* Participate in code reviews and provide technical feedback to the team
* Comfortable with fast-paced and strongly collaborative environments


You will have a strong background in software development and significant experience working with Python. As well as experience designing and building customer facing applications you will have a focus on design, testing and adhering to best practices.

Role: Scala/Java Developer

Location: Bergen

Working in-house, you'll play a vital role in designing and building web and desktop applications for both current and future customers.

Beyond coding, you'll also have the chance to participate in technical meetings and contribute to key decision-making processes.

You'll join a close-knit development team in Bergen while being part of a larger network of 400 colleagues across Europe and the US.

What we're looking for:

* Experience in full-stack development.
* Knowledge of Scala, or a willingness to learn it if you have a background in another programming language.
* Familiarity with agile development practices.
* A passion for innovation and exploring new technologies.

What we offer:

* A comprehensive pension and health insurance plan.
* Financial support for gym memberships or exercise classes.
* Time allocated for learning new technologies.
* Flexibility with remote or home working.
* Flexitime options for working hours.
* A relaxed, flat-structured work environment.

For any questions and to get involved in the process, contact Dylan Johnston on:

* d.johnston1@jeffersonfrank.com
* LinkedIn: https://www.linkedin.com/in/dylan-johnston-666707130/

Our TOP CLIENT has retained us for a Sr Data Engineer role. They are known and highly recognized for their stability and commitment to a collaborative teamwork environment. Our client is building a best-in-class data science platform as being on the forefront of data management and analytics is core to our investment platform. Overall, this position will play an integral role as the team implements new data management platforms, creates new data ingestion pipelines, and sources new data sets. The role will assist with all aspects of data from data architecture design to on-going data management and will have significant exposure to our Risk and commercial investing teams globally.



REQUIRED:

Must be onsite 3 days a week in the Houston, TX area

Extensive work experience with ETL/ELT frameworks to write pipelines.

Advanced skills in writing highly optimized SQL code.

Experience with Snowflake.



TOP RESPONSIBILITIES:

Execute data architecture and data management projects for both new and existing data sources.

Help transition existing data sets, databases, and code to a new technology stack.

Over time, lead analysis of data sets using a variety of techniques including machine learning.

Manage end to end data ingestion process and publishing to investing teams.

Own the process of mapping, standardizing, and normalizing data.

Ad hoc research on project topics such as vendor trends, usage best practices, big data trends, artificial intelligence, vendors, etc.

Help transition existing data sets, databases, and code to a new technology stack.

Assess data loads for tactical errors and build out appropriate workflows, as well as create data quality analysis that identifies larger issues in data.

Actively manage vendors and capture changes in data input proactively.

Properly prioritize and resolve data issues based on business usage.

Assist with managing strategic initiatives around big data projects for the commercial (trading) business.

Partner with commercial teams to gain understanding of current data flow, data architecture, investment process as well as gather functional requirements.

Assess gaps in current datasets and remediate.



PREFERRED SKILLS:

Experience in SQL programming, data architecture, and dimension modeling.

Interest and passion for data architecture, analytics, management, and programming.

Experience in energy commodities or financial services required.

Experience in mapping, standardizing, and normalizing data.

Experience with data integration platforms is preferred, and SnapLogic experience is highly preferred.

Extensive work experience with ETL/ELT frameworks to write pipelines to load millions of records.

Advanced skills in writing highly optimized SQL code.

Experience with relational databases Snowflake or Oracle is preferred.

Python work experience with Pandas, Numpy and Scikit

Ability to communicate and interact with a wide range of data users - from very technical to non-technical.

Team player who is execution focused, with the able to handle a rapidly changing set of projects. and priorities, while maintaining strong professional presence.

Strong analytics skills with demonstrated attention to details.

Familiarity with Business intelligence tools Power BI and Tableau.

Interest or experience in machine learning/Artificial Intelligence is a plus.



BENEFITS:

Competitive comprehensive medical, dental, retirement and life insurance benefits

Employee assistance & wellness programs

Parental and family leave policies

CCI in the Community: Each office has a Charity Committee and as a part of this program employees are allocated 2 days annually to volunteer at the selected charities.

Charitable contribution match program

Tuition assistance & reimbursement

Quarterly Innovation & Collaboration Awards

Employee discount program, including access to fitness facilities

Competitive paid time off

Continued learning opportunities



Reach out to me directly if interested:

E: s.murray@jeffersonfrank.com

About the company:

We are working with a major Norwegian IT Consultancy's Oslo/Drammen offices. The successful candidate will join a small, vibrant team and engage in projects across the energy sector and beyond.

Benefit from the agility and independence of a small team, with the reliability and financial support of a large-scale organization. It's consultancy without the red tape!

With a focus on consultant-first principles and an impressive roster of clients and projects, this consultancy presents an enticing career opportunity for developers in search of fresh challenges.

The Role:

* Design, code, test and debug software applications in Java and Python
* Define, design and implement new features among cross-functional teams through the organization
* Live and breathe the project life-cycle - from early concept stage all the way to deployment
* Troubleshoot and resolve problems
* Keep up with emerging technologies and how to deploy them

The Person:

* 3+ years experience with Java and Python
* Proficiency with SQL Server
* A desire to work on high-impact, primary sector projects in a small team
* Front end experience with React would be beneficial
* Not essential but helpful: knowledge of Digital Transformation processes
* Strong interpersonal skills
* A love of learning

The Reward:

* Competitive salary
* Guaranteed profit sharing and bonus opportunities
* Enhanced insurances and benefits
* Flexible working hours and remote work options
* Opportunities for professional development and growth, with certifications paid for
* Exciting and challenging projects with leading clients in various industries



For more information, apply below or contact Rob Jones at r.jones@jeffersonfrank.com!

*
*

Overview:

We are seeking a highly skilled and experienced Senior Data Engineer to join our team. The ideal candidate will possess a strong background in data architecture, management, and integration, particularly within the energy commodities or financial services sectors. This role will involve designing robust data solutions, ensuring data quality, and implementing ETL processes to support our business objectives.



Key Responsibilities:

* Data Architecture Development: Design, implement, and maintain scalable and reliable data architecture frameworks that support the organization's strategic goals and objectives.
* ETL/ELT Design and Implementation: Architect and develop ETL and ELT processes utilizing SnapLogic and other integration tools to extract, transform, and load data from various sources into centralized data stores.
* Data Modeling: Collaborate with business stakeholders to create comprehensive data models, optimizing logical and physical data design and ensuring alignment with business requirements.
* Data Management and Governance: Establish and enforce data management best practices, including data governance frameworks to ensure data accuracy, consistency, and availability across the organization.
* Quality Assurance: Conduct comprehensive data quality assessments and audits, identifying and resolving data issues to maintain high standards of data integrity.
* Data Integration: Facilitate seamless data integration across various systems and platforms by developing and maintaining data ingestion pipelines that support real-time and batch processing.
* Collaboration with Teams: Work closely with data scientists, business analysts, and software engineers to understand data needs and provide suitable data solutions and architecture for analytics and reporting.
* Cloud Database Management: Manage relational and non-relational databases using Snowflake and Oracle, including performance tuning, optimization, and effective indexing strategies.
* Data Analysis and Visualization: Utilize Python and business intelligence tools (Power BI, Tableau) to analyze complex datasets and create meaningful visualizations and reports that facilitate data-driven decision-making.
* Machine Learning Implementation: Collaborate with machine learning practitioners to implement machine learning solutions, ensuring the proper infrastructure and data pipelines are in place to support model development and deployment.
* Training and Knowledge Transfer: Mentor and train junior staff, providing knowledge transfer on data architecture and engineering best practices, tools, and technologies.
* Vendor Management: Evaluate, select, and manage relationships with vendors and technology partners to integrate new data tools and solutions, staying abreast of vendor trends that impact data strategies.
* Research and Innovation: Stay current with emerging trends, technologies, and best practices in data architecture, big data analytics, and AI/ML, recommending innovative solutions that enhance the organization's data capabilities.



Relevant Skills and Qualifications:

* Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field; Master's degree preferred.
* Proven experience in data architecture, data engineering, or a related field.
* Proficiency in SQL, T-SQL, and data modeling techniques.
* Experience with ETL/ELT tools, specifically SnapLogic.
* Familiarity with cloud data warehousing solutions, particularly Snowflake or Oracle.
* Strong programming skills in Python, with experience in data libraries such as Pandas and NumPy.
* Familiarity with modern data integration and data pipeline architectures.
* Knowledge of machine learning and artificial intelligence concepts and tools.
* Experience using BI tools (Power BI, Tableau) for data visualization and reporting.
* Excellent analytical skills with a focus on data quality and management.
* Strong communication and interpersonal skills, with experience in vendor management.

Job Title: Data Analyst/ Developer

Location: Remote (light travel)

Salary: Competitive

Role Overview:

The SQL Developer will be the primary data expert on the team, taking over database responsibilities from leadership and developers. This role involves working collaboratively across different teams to provide database expertise, build reports for data visualization, and manage data imports from various external sources.

Role Requirements:

* 3-5 years of experience with PostgreSQL databases (admin and development)
* Experience with Amazon RDS
* Proficiency in PostgreSQL
* Advanced SQL coding skills

Responsibilities:

* Own and manage the company's databases, taking over from other team members
* Assist various business teams in accessing and using data effectively
* Build reports for visualization using tools like QuickSight
* Handle data imports from healthcare partners using formats like CSV, SQL to SQL, and EDI calls
* Pull and manage data to fulfill user requests, primarily in the healthcare space
* Design, configure, and manage database systems
* Work as the sole data professional within the team, collaborating with leadership and developers

Day-to-Day Tasks:

* Managing and maintaining databases, ensuring high performance and accessibility
* Supporting business operations by developing data visualizations and analytical reports
* Collaborating with cross-functional teams to streamline data access and reporting
* Overseeing data import processes and ensuring smooth integration with existing systems
* Responding to and managing data-related requests and issues
* Designing and implementing robust database structures and best practices

An independently owned, B Corp accredited service provider are recruiting for a Lead Developer to join their team. Working closely with the Engineering Manager to set technical direction, the Lead Developer will be focused on coaching and mentoring a team of 7.



Responsibilities will include:



* Ensuring the successful planning, execution and on-time delivery of engineering projects.
* Managing day-to-day project activities, monitoring progress, identifying and mitigating any potential risks.
* Providing technical guidance and support to team members, helping to solve complex technical challenges and getting hands-on to assist successful deliveries.
* Identifying opportunities for process improvements and implementing changes to increase value, efficiency and productivity.



The successful applicant will have experience leading a team of developers and a background in C#, .Net and AWS.