Alpha Alternatives (alternatives.alphafmc.com) Logo

Alpha Alternatives (alternatives.alphafmc.com)

Solution Architect / Sr. Solution Architect - Snowflake Data Engineer

Posted 10 Hours Ago
Remote
Hiring Remotely in United States
110K-160K Annually
Senior level
Remote
Hiring Remotely in United States
110K-160K Annually
Senior level
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.
The summary above was generated by AI

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/). 


Similar Jobs

An Hour Ago
Remote or Hybrid
Junior
Junior
Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Coordinate installation projects from initial customer and provider contact through scheduling, product delivery, compliance documentation, issue resolution, and post-project follow-up. Communicate with customers, service providers, stores, vendors, and internal teams through inbound and outbound calls. Track project progress, document interactions in company systems, resolve work order issues, meet service-level timelines, and deliver consistent customer support in a fast-paced environment with possible night and weekend hours.
Top Skills: Installation Management SystemMyredvestSalesforce
An Hour Ago
Remote or Hybrid
136K-245K Annually
Senior level
136K-245K Annually
Senior level
Fintech • Payments • Software • Financial Services
Owns U.S. engagement and growth strategy for Afterpay, Cash App commerce, and lending products. Leads lifecycle marketing, cross-sell initiatives, incentives, experimentation, product launches, opportunity sizing, and multi-quarter roadmaps. Partners with Product, Analytics, Martech, Creative, Brand, and business leadership to drive active customers and gross profit. The role also advances AI-enabled marketing automation and requires hands-on analytical and CRM expertise.
Top Skills: BrazeClaude CodeGooseHightouchIterableSalesforce Marketing CloudSQL
An Hour Ago
Remote or Hybrid
185K-327K Annually
Senior level
185K-327K Annually
Senior level
Fintech • Payments • Software • Financial Services
Own the full-cycle sales process for mid-market commerce merchants across North America, from prospecting and qualification through negotiation, contracting, launch, and handoff. Build pipeline, develop account plans, lead consultative discovery, create business cases, negotiate commercial terms, coordinate cross-functional deal teams, maintain Salesforce forecasts, and meet revenue targets. The role also contributes market insights, sales enablement, process improvements, and represents Cash App and Afterpay at merchant meetings and industry events.
Top Skills: AfterpayCash App PaySalesforce

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account