Solution Architect / Sr. Solution Architect - Snowflake Data Engineer

Posted 2 Hours Ago
Hiring Remotely in United States
Remote
110K-160K Annually
Senior level
Consulting
The Role
Design, implement, and maintain Snowflake-based data pipelines, integrations, architectures, and warehousing solutions. Use Qlik, dbt Labs, Astronomer, SQL, and scripting to support data ingestion, transformation, performance, security, governance, and quality. Diagnose engineering issues, collaborate with stakeholders, and provide consulting services. The role requires bi-weekly travel to Columbia, Missouri, for approximately one year.
Summary Generated by Built In

Solution Architect / Sr. Solution Architect – Snowflake Data Engineer

* This role requires bi-weekly travel to Columbia, MO (Sunday evening - Thurs evening) for the duration of this client engagement *

Alpha Financial Markets Consulting (Alpha FMC) group, the leading global consultancy to the Insurance and InsurTech industries. We are a boutique management consulting firm that offers the world’s best Insurance and Financial Services groups a competitive edge through our expertise and industry insight. Our global Insurance Division is of a uniquely high caliber and by focusing on Insurance alone we build deep knowledge and experience within our industry.  

To clients, we are a trusted partner for creating programs, however, we are so much more to our employees. At Alpha, we pride ourselves in being a meritocratic environment perfect for building a career, meeting great people, as well as a rewarding place to work. 
 

About Alpha Insurance Technology Services 

As technology specialists, Alpha Insurance Technology Services: 

Provide knowledgeable resources who can implement, configure and support the major platforms used by our clients. 

Form a range of partnerships with key vendors to position itself as a preferred implementation partner for major business applications. 

Assist clients with their journey to the next generation of cloud-based architectures. 

Help clients to define and implement their future state data architectures. 

Help clients with bespoke development that complements their core application architecture. 

Provide knowledgeable and client-focused support for client’s major applications, including upgrades, migrations and business-as-usual issue management. 

Job Level: Individual Contributor

Our client maintains broad salary ranges for its roles in order to account for variations in geographic location, education, training, skills, relevant work experience, business needs and market demands.  Please remember that this range is the starting base pay only and does not consider other components that make up the total rewards package for the position. 

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.

Other Info 

  • This role requires bi-weekly travel to Columbia, MO (Sunday evening - Thurs evening) for the duration of this client engagement (about a year).
  • Prior consulting experience is required
  • Applicants must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Alpha will not sponsor applicants for U.S. work visa status for this opportunity (no sponsorship is available for H-1B, L-1, TN, O-1, E-3, H-1B1, F-1, J-1, OPT, CPT or any other employment-based visa)
  • All Alpha team members must pass thorough background checks, including fraud prevention initiatives like physical location verifications.
  • Team members are expected to be available from 8:30am - 5:30pm EST, Monday - Friday.
  • Infrequent travel to client sites may be required.

Benefits / Additional Information 

  • 25 days of annual paid time off (accrued), in addition to paid holidays
  • 5 days of paid training time for continuing education/professional certifications
  • Reimbursement for commuting, mobile phone, and home internet expenses 
  • Supplemented medical, dental and vision coverage 
  • 401k matching  

Compensation

There are a wide range of factors that are considered in making compensation decisions including but not limited to - skill sets, experience and training, and licensure and certifications. The base salary range for this position is: $110,000 to $160,000 and is subject to change based on salary benchmarking. In addition to this salary, employees would be eligible for both variable and non-variable benefits. 

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. 

Data Privacy Policy 

Full details around what data we hold, why we hold it and for how long are available in our recruitment privacy statement (https://alphafmc.com/privacy-policy/). 


Skills Required

  • Bachelor’s or master’s degree in computer science, information systems, or a related field
  • 4+ years of experience as a senior data engineer
  • Expertise in Qlik Replicate, Qlik Compose, dbt Labs, Astronomer, and Snowflake
  • Proficiency with GitHub and data integration, replication, and transformation tools
  • Strong understanding of data engineering, data modeling, ETL, and data warehousing
  • Expertise in Snowflake data ingestion, storage, performance optimization, and security
  • Experience with AWS, Azure, or other cloud-based data solutions
  • Familiarity with data quality, data governance, and data lifecycle management
  • Programming skills in SQL and scripting languages such as Python or PowerShell
  • Strong problem-solving and data engineering troubleshooting abilities
  • Excellent communication and cross-functional collaboration skills
  • Prior consulting experience
  • Authorization to work in the United States without employment-based visa sponsorship
  • Ability to travel bi-weekly to Columbia, Missouri, Sunday evening through Thursday evening, for approximately one year
  • Ability to pass thorough background checks
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: London
289 Employees

What We Do

Alpha Alternatives (formerly Lionpoint Group) is the specialist alternatives consulting division of Alpha FMC, dedicated to creating value for private markets clients—including Private Equity, Private Debt and Liquid Credit, and Real Assets and Infrastructure—through advisory support, technology optimization, and process transformation. With hundreds of specialist consultants in key markets globally, we deliver solutions across the entire program lifecycle, helping over 300 clients navigate complex operational and technology challenges across all areas of their business, from front to back office, to achieve their business objectives.

Similar Jobs

SailPoint Logo SailPoint

Account Executive

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
2 Locations
2461 Employees
111K-168K Annually

Zscaler Logo Zscaler

Site Reliability Engineer

Cloud • Information Technology • Security • Software • Cybersecurity
Easy Apply
Remote or Hybrid
Santa Clara, CA, USA
8697 Employees
212K-265K Annually

Samsara Logo Samsara

Contract and Billing Specialist - USA

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
85K-128K Annually

DFIN Logo DFIN

Deal Desk Lead

Fintech • Software
Remote or Hybrid
United States
1750 Employees

Similar Companies Hiring

Charted, Inc. Thumbnail
Software • Payments • Fintech • Financial Services • Consulting • Automation • Artificial Intelligence
Boston, MA
72 Employees
Energy CX Thumbnail
Greentech • Professional Services • Business Intelligence • Consulting • Energy • Financial Services • Utilities
Chicago, IL
150 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account