Demo

Consultant - Data Integration Engineer (Snowflake)

HIKE2
Chicago, IL Full Time
POSTED ON 1/23/2025
AVAILABLE BEFORE 4/22/2025

Consultant - Data Integration Engineer (Snowflake)

Who We Are

HIKE2 is a leading provider of technology advisory and implementation services that specializes in empowering a distinct set of industries to define their future and accelerate their path forward. With expertise for law firms, financial services, insurance, business service providers, and high-tech SaaS companies, our team addresses complex and evolving challenges by providing advisory services and tailoring cutting-edge cloud solutions, AI initiatives, and data & analytics programs.

We are a collaborative, diverse, and action-oriented group of consultants who work iteratively to capture client mindsets and solve the most complex business problems. For our teams, there's no such thing as "cookie-cutter" advice or solutions. We thrive in change and love going from blank slate to truly innovative ideas and creative breakthroughs, developing solutions from our deep, cross-discipline expertise shaped by senior advisors and practical experience.

We care deeply about our clients, building strong and positive relationships with their partners and fellow guides, and the impact of their work.

At HIKE2 :

  • We work in teams
  • We are committed to our customer success and each other's success
  • We set the bar high and challenge one another
  • We are passionate about emerging technologies and love the thrill of venturing to the edge of technology
  • We get out from behind our desks and go to the drawing board
  • We gather information and get to know our clients face to face

Are you ready to make a change? Join our growing team and excel in your career!

How We'll Align

We are looking for a Data Integration Consultant who will report directly to the Data Practice Manager and play a critical role in building and optimizing the client's data integration pipelines. The ideal candidate will have deep hands-on expertise in designing, building, and managing complex data integration workflows, with a strong focus on Snowflake and other modern data integration platforms. The role requires expertise in API integration, Change Data Capture (CDC), batch processing, delta processing, and experience working within enterprise bus architectures to ensure seamless data flow across systems.

Key Responsibilities :

  • Developing and maintaining the Snowflake platform, working with stakeholders to ensure the platform meets their needs. Strong Snowflake Development will also help to evangelize and promote Snowflake Platform for various clients. Work with other developers to create and improve the snowflake platform and its applications.
  • Familiarity with latest web development frameworks and a good understanding of how Snowflake works
  • Responsible for creating, maintaining, and improving the Snowflake Open Source software platform. This includes developing and maintaining Snowflake's core platform, as well as providing support to the snowflake community.
  • Required Skills & Experience :

  • 3 years of hands-on experience in data integration / Snowflake development
  • Deep experience with data integration platforms, particularly Snowflake
  • Strong understanding of API integration and building real-time data synchronization between systems.
  • Proven expertise in Change Data Capture (CDC), batch processing, delta processing, and incremental data loading strategies.
  • Experience with enterprise bus architecture for managing real-time data flow and event-driven integrations.
  • Hands-on experience with SQL databases and cloud-based data warehousing platforms (e.g., Snowflake).
  • Proficiency in building data pipelines for systems like Salesforce, Workday, Aderant, and other cloud-based or enterprise applications.
  • Strong problem-solving skills and the ability to troubleshoot complex data integration challenges.
  • Excellent written and verbal communication skills to work effectively with both technical and non-technical stakeholders.
  • Preferred Qualifications :

  • Familiarity with cloud platforms (AWS, Azure, or Google Cloud).
  • Understanding of data governance and data security practices
  • Knowledge of data visualization tools (e.g., Tableau, Power BI) and how integrated data supports business reporting and analytics.
  • Experience working within a regulated industry or compliance-heavy environment.
  • Salary / Benefits :

    The annual salary range is $75,000-$140,000 / year (depending on experience). This range represents the anticipated low and high end of the salary for this position. This role is also eligible to receive short term incentives that align with individual and company performance. Salary will be determined by the education, experience, knowledge, skills, and abilities of the applicant, internal equity, and alignment with market data. Salary is one component of the HIKE2 total compensation package, which includes the below :

  • Six national health medical plans to choose from, including a HSA option
  • Dental & Vision options
  • Retirement Savings with a Safe Harbor 401K plan with immediate vesting and company match
  • Long and short term disability coverage options
  • Life Insurance and travel insurance
  • Flexible PTO policy and 11 paid holidays
  • Reimbursement for certifications related to your role
  • Opportunity for career development, advancement and learning
  • Don't meet every requirement?

    Studies have shown that women and people of color are less likely to apply to jobs if they don't meet every single qualification. As an innovation consultancy, we recognize that talent is not always related to job history and skills come from valuable experiences that aren't always shown on a resume. If you are excited to make a positive impact, but your experience doesn't align perfectly, we encourage you to apply. You may be the right candidate for our organization, whether it be this role or another.

    EOE / Minorities / Females / Veteran Disabled

    We are an equal opportunity employer that values diversity and commitment at all levels. All individuals, regardless of personal characteristics, are encouraged to apply. Employment policies and decisions on employment and promotion are based on merit, qualifications, performance, and business needs. The decisions and criteria governing the employment relationship with all employees are made in a nondiscriminatory manner, without regard to race, religion, color, national origin, sex, age, marital status, physical or mental disability, medical condition, veteran status, or any other factor determined to be unlawful by federal, state, or local statutes.

    U. S. Citizenship Applicants for employment in the U.S. must possess work authorization which does not require now or in the future sponsorship by the employer for a visa.

    Salary : $75,000 - $140,000

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Consultant - Data Integration Engineer (Snowflake)?

    Sign up to receive alerts about other jobs on the Consultant - Data Integration Engineer (Snowflake) career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $104,659 - $145,110
    Income Estimation: 
    $143,609 - $190,347
    Income Estimation: 
    $128,655 - $181,504
    Income Estimation: 
    $86,356 - $101,827
    Income Estimation: 
    $108,740 - $126,996
    Income Estimation: 
    $108,740 - $126,996
    Income Estimation: 
    $134,729 - $158,988
    Income Estimation: 
    $134,729 - $158,988
    Income Estimation: 
    $173,009 - $212,122
    Income Estimation: 
    $70,112 - $81,027
    Income Estimation: 
    $86,356 - $101,827
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at HIKE2

    HIKE2
    Hired Organization Address Chicago, IL Full Time
    Job Description Software Engineer Who We Are HIKE2 is a leading provider of technology advisory and implementation servi...
    HIKE2
    Hired Organization Address Chicago, IL Full Time
    Job Description Who We Are HIKE2 is a leading provider of technology advisory and implementation services that specializ...
    HIKE2
    Hired Organization Address Pittsburgh, PA Full Time
    Job Description Who We Are HIKE2 is a leading provider of technology advisory and implementation services that specializ...
    HIKE2
    Hired Organization Address CO Full Time
    Who We Are HIKE2 is a leading provider of technology advisory and implementation services that specializes in empowering...

    Not the job you're looking for? Here are some other Consultant - Data Integration Engineer (Snowflake) jobs in the Chicago, IL area that may be a better fit.

    Data Engineer – Data Integration & Analytics

    Talent Management Plus, Inc., Chicago, IL

    AI Assistant is available now!

    Feel free to start your new journey!