Consultant - Data Engineering

Alphafmcroles; United States; On-site; USD 90,000 - 140,000; Full time

Benefits offered by this job

Competitive salary

401k matching

25 days PTO

Health, dental, vision

Training & certifications support

Job summary

Alpha FMC is seeking a Data Engineering & Operations Specialist to design and maintain data pipelines and architectures for insurance-focused engagements. You will work on Snowflake-powered solutions, leveraging DBT and data integration tools to support analytics and transformation.

Ideal candidates have 1–3+ years in data engineering within financial services, with strong SQL and scripting skills, and the ability to travel up to 75% across North America.

Qualifications

• Bachelor’s or Master’s degree in a relevant field is preferred.
• 1–3+ years as a Data Engineer with hands-on Snowflake and DBT.
• Experience with data integration tools and data warehousing concepts.

Responsibilities

• Design, implement, and maintain data pipelines and data architecture.
• Ensure scalable data storage and analytics using Snowflake.
• Collaborate with cross-functional teams to deliver client solutions.

Skills

Excellent communication

Problem solving

Team collaboration

Adaptability

Education

Bachelor’s degree in CS/IS/related

Master’s degree preferred

Tools

Snowflake

DBT

Qlik Replicate

Github

DBTLabs/Astronomer

Job description

About Alpha FMC

Alpha Financial Markets Consulting (Alpha) is a leading global consultancy to the financial services industry. Founded in 2003, we have worked for over 20 years to bring together specialist, sector-focused strategy, management consulting and technology expertise to support the entire client transformation lifecycle. Having partnered with more than 1,200 clients worldwide across the asset and wealth management, alternatives and insurance industries, Alpha is truly a trusted advisor for complex change programmes. We now have over 1,180 consultants working with clients across North America, the UK, Europe, Middle East and APAC. In 2024, in recognition of our successful track record and strong growth prospects, Alpha was acquired by Bridgepoint, one of the world’s leading quoted private asset growth investors. Our people are at the heart of everything we do. We are delighted that many of our team have built long and fulfilling careers with us, many staying over a decade. We believe this is because Alpha offers a genuinely rewarding place to work: a meritocratic environment where your career can flourish, and a welcoming culture where you can be yourself, connect with others and thrive. As we look to the future, we’re excited to be looking for new Alpha colleagues - individuals who are collaborative, innovative and ambitious. We hope you will join us and help shape the next chapter of our growth journey.

Why join Alpha?

• Established yet entrepreneurial – with over 20 years of success and a proven record on the London Stock Exchange, Alpha offers the stability of an established consultancy with the energy of a fast-growth business.
• Backed by Bridgepoint – as part of one of the world’s leading growth investors, Alpha benefits from strategic investment that fuels innovation, expansion and new offerings – creating even more opportunity for our people.
• Exposure to senior leadership – whether you are in an internal or a client facing role, you will have the opportunity to work with and learn from the best of the best – high performers at the top of their game.
• Learning and growth opportunities – we run tailored training to help you be successful, provide you excellent mentorship, and offer up to 5 days paid training time per year. Perhaps the best training though is the experience on the job – as everyone at Alpha has high responsibility and autonomy, you can develop your skillsets quickly.
• Performance-driven culture with real impact – advancement at Alpha is based on impact and capability, not tenure or quotas. You’ll have autonomy and see the tangible difference your ideas and decisions make.

Position Overview

We have a fast-growing team of dedicated consultants with deep experience from working both within the industry and consulting. Successful candidates should expect a diverse range of complex and strategic engagements across the Insurance market. As we continue to expand our client base and expertise, we are looking for individuals to join our team to support our growth journey. You will be responsible for identifying and implementing solutions for a range of issues facing insurance companies. Over the course of each project, you will collect and analyze data, prepare and test hypotheses, and present recommendations to the client to solve their unique business challenge. You’ll be playing a proactive supporting role in driving our programs forward and engaging directly with client stakeholders to solve their business challenges.

Data Engineering & Operations Specialist

What You Will Be Doing:

Design, implement, and maintain data pipelines, data integration solutions, and data architecture. Additionally, expertise in Snowflake is required to ensure efficient and scalable data storage, processing, and analytics.

What We're Looking For:

• Bachelor's or Master's degree in computer science, information systems, or a related field is preferred.
• Proven experience (1-3+ years) as a Data Engineer, with recent hands‑on experience in Snowflake, and experience in DBT.
• Proficiency in Qlik Replicate, Compose, and Github, DBTLabs & Astronomer for data integration, replication, and transformation.
• Good understanding of data engineering principles, data modeling, ETL processes, and data warehousing concepts.
• Recent hands on exposure to Snowflake, including data ingestion, storage, performance optimization, and security.
• Experience with cloud platforms, such as AWS or Azure, and working with cloud-based data solutions and services.
• Familiarity with data quality, data governance, and data lifecycle management practices.
• Solid programming skills in SQL and scripting languages (e.g., Python, PowerShell) for data manipulation and automation.
• Strong problem-solving and troubleshooting abilities, with the ability to diagnose and resolve data engineering issues.
• Excellent communication and collaboration skills, with the ability to work effectively with cross‑functional teams and stakeholders.
• Ability to perform essential functions of the position, with or without a reasonable accommodation.

Requirements:

• Bachelor’s degree in Risk Management, Business Management, Business Analytics, Economics, Engineering, or related disciplines.
• At least 1-3 years years of proven consulting experience at a recognized consulting firm or through an ‘in‑house’ consulting / business analyst role at a leading financial institution.
• Experience within financial services, preferably within the insurance industry.
• Excellent consulting and problem‑solving skills, and familiarity with recognized project and consulting frameworks and business process mapping.
• Excellent written and verbal communication skills; the ability to articulate complex problems and solutions in a simple, logical, and impactful manner; executive presentation skills.
• Proven track record of building and sustaining lasting relationships with team members.
• Appetite to support clients across our practice areas Intellectual capacity and ability to think in new, innovative ways to understand complex issues and develop creative solutions.
• Ability to comfortably multi‑task and engage in multiple initiatives concurrently.
• Flexibility to travel up to 75%.

Compensation and Perks

As part of the Alpha team, you will be rewarded with the following:

• Competitive salary with annual profit‑sharing opportunity
• 401k matching
• 25 days of annual paid time off
• Supplemented medical, dental and vision coverage
• Reimbursement for commuting, mobile phone, and home internet expenses
• Choice of laptop
• North America team‑wide training and retreats
• Sponsorship towards professional certifications / training supported with 5 days of paid training time

Our Commitment to Inclusion

At Alpha, diversity, equity and inclusion are critical to our success. Our priorities show a focus on fostering an inclusive, equitable workplace where individuals are treated fairly regardless of gender or background. We welcome applications from disabled people and are committed to making our recruitment process and workplace accessible and inclusive for everyone.