The Opportunity

Join our dynamic team as a Senior Data Pipeline Consultant, where you'll tackle complex data challenges and drive impactful solutions for industry-leading clients. This role involves designing and developing sophisticated data pipelines, leveraging Azure Data Factory and dbt to implement ELT methodologies into a Snowflake enterprise data warehouse. You'll collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to deliver data-driven solutions that support multiple teams, systems, and products. Your work will directly influence the efficiency and performance of our clients' data operations, ensuring data availability and reliability.

What You'll Bring

1. Deep experience in SQL programming, database design, and data architecture concepts.
2. Extensive experience with complex modern data transformations using DBT or a similar tool.
3. Deep experience with dimensional modeling and star schema design.
4. Experience with the Kimball methodology and flexibility when situations call for alternative methodolgies.
5. Deep technical experience with data models and data warehousing.
6. Strong proficiency in Snowflake or a similar cloud data warehouse.
7. Expertise with Microsoft Azure components, including DevOps and Azure Data Factory.

What Sets You Apart

1. Experience with Legacy On-Prem environmnts SSIS.
2. Working knowledge of insurance brokerage or sales workflows and systems.
3. Previous consulting experience, enhancing your ability to deliver tailored solutions to clients.

Why You'll Love Working With Us

Experience the excitement of collaborating with top-tier U.S. clients in a fully remote, flexible work environment. You'll have the opportunity to engage in a variety of projects, each offering unique challenges and avenues for professional growth. Embrace the chance to make a significant impact while enjoying the freedom and balance of a remote-first workplace.