Senior Consultant - Data Engineering

Alpha Financial Markets Consulting; New York (NY); On-site; USD 120,000 - 190,000; Full time

Benefits offered by this job

401k matching

25 days of annual PTO

Supplemental medical, dental andVision

Commuting, mobile phone, home internet

Laptop provided

Team training and retreats

Certifications sponsorship with 5 paid

Job summary

Alpha FMC is seeking a Senior Data Engineer to design and maintain data pipelines and architectures for insurance-focused analytics. You will work closely with clients and internal teams to collect data, build scalable solutions, and enable data-driven decisions using Snowflake and related tools.

Ideal candidates have 4+ years in data engineering or consulting, strong SQL and scripting skills (Python/PowerShell), and expertise in Snowflake, data warehousing, and ETL processes.

Qualifications

• Bachelor’s or Master’s degree in CS/IS or related field preferred.
• 4+ years of proven consulting or equivalent Senior Data Engineer experience.
• Experience with Snowflake data storage, ingestion, and optimization.
• Strong skills in SQL and scripting (Python, PowerShell).
• Experience with data integration tools and data governance concepts.

Responsibilities

• Design, implement, and maintain data pipelines and data integration solutions.
• Build and optimize data architecture for analytics and reporting.
• Collaborate with cross-functional teams and stakeholders to solve data challenges.

Skills

Data engineering

Data modeling

ETL

SQL

Python

PowerShell

Communication

Collaboration

Education

Bachelor’s or Master’s degree in CS/IS/related

Tools

Snowflake

Qlik Replicate

Qlik Compose

Github

DBTLabs

Astronomer

AWS

Azure

Job description

Preferred Location :New York, New Jersey, Connecticut

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

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 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 (4+ years) as a Senior Data Engineer, with expertise in Qlik Replicate, Compose, and DBTLabs & Astronomer, combined with hands-on experience in Snowflake typically required.
• Proficiency in Qlik Replicate, Compose, and Github, DBTLabs & Astronomer for data integration, replication, and transformation.
• Strong understanding of data engineering principles, data modeling, ETL processes, and data warehousing concepts.
• Expertise in 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 4 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 50%.

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.