Data Engineer

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!

We are ideally looking for people in the following geographies - not for an "in office" requirement but so we can continue to build our company culture with in person activities and events! Columbus, OH (and surrounding areas including Cincinnati), Chicago, IL, Pittsburgh, PA, Denver, CO, Nashville, TN

You are a client-facing, detail oriented individual who is personable with a “can-do” attitude and can adapt to various challenges in different settings. An ideal applicant should demonstrate the ability to deliver creative and analytical solutions in a fast paced problem-solving environment in addition to being able to configure business solutions. The ability to pay attention to detail while maintaining excellent organizational skills is highly valued. You should possess strong time management skills and be able to work at a self-directed pace to meet deadlines.

How We’ll Align

• Design, develop, and maintain scalable and efficient data pipelines for extracting,
  transforming, and loading (ETL) data from various sources into our data warehouse
  leveraging Azure, AWS, Databricks, Python and SQL technologies.

• Architect and implement data storage solutions (e.g., data lakes, warehouses) that ensure data is organized, accessible, and optimized for performance.

• Design and implement automation processes, utilizing platform best practices for DataOps, MLOps, Data Observability, Metadata Management, and Data Classification, etc.

• Collaborate with cross-functional teams to understand data requirements and implement
  solutions that meet business needs.

• Optimize and troubleshoot existing data pipelines for performance and reliability.

• Implement data quality and validation processes to ensure accuracy and consistency of data.

• Stay updated on industry trends and best practices in data engineering to continuously
  improve our data infrastructure.

• Work closely with data scientists, analysts, and other stakeholders to understand data use
  cases and provide the necessary infrastructure and support.

• Assemble large, complex sets of data that meet non-functional and functional business
  requirements.

• Identify, design and implement internal process improvements including re-design
  infrastructure for greater scalability, optimize data delivery, and automating manual processes.

• Minimum five (5) years of experience working in a heavy data environment.  

• Bachelor's degree or experience in Data Science and Management field.

• Familiarity with cloud platforms, such as AWS, Azure, or Google Cloud.

• API development experience

• Deep understanding of key engineering and architecture principles

• Experience working containerization technologies (e.g docker, Kubernetes, EKS, GKE, AKS).

• Experience with GIT and SDLC best practices.

• Proven experience as a Data Engineer or similar role.

• Experience with DBT or similar Data Engineering/Transformation tools.

• Experience with pub/sub and/or Kafka messaging

• Knowledge of data governance and security best practices.

• Experience in Snowflake and/or Databricks technologies.

• Strong proficiency in SQL and experience with relational databases.

• Proficiency in at least one programming language (e.g., Python, Java, Scala) for data processing and scripting.

• Knowledge of data modeling and database design principles.

• Bachelor’s degree in Computer Science, Engineering, Mathematics or a related field.

Soft Skills:

• Strong communication skills, both written and verbal, with the ability to explain technical concepts to non-technical stakeholders.

• Ability to work in a fast-paced environment and manage multiple tasks and projects simultaneously.

What Could Set You Apart:

• Certifications in Cloud Platforms (AWS, Azure, GCP)

• Certifications in Cloud Data Warehouse platforms (e.g. Snowflake, Data Bricks, Salesforce Data Cloud

• Certifications in visualization platforms (e.g. ThoughtSpot, Tableau, PowerBI)

Salary/Benefits:

The annual base salary range is $100,000-$200,000k / year depending on years of 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.