
Senior DBT Architect and Engineer
- Remote
- Pittsburgh/Remote, Pennsylvania, United States
- Delivery
Job description
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 providiång 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!
HIKE2 has an immediate opening for a Senior DBT Architect and Engineer. You will focus on designing modular, scalable DBT projects and have a strong understanding of Data Modeling techniques. Engage with technical and non technical stakeholders and have extensive experience in version control systems.
Job requirements
5+ years of experience in data engineering or analytics engineering, with at least 2 years of hands-on experience using DBT in production.
Strong experience in modern data stack tools: DBT, Airflow, SQL, cloud data warehouses (e.g., Snowflake, BigQuery, Redshift).
Experience designing modular, scalable DBT projects (using packages, macros, exposures, sources, etc.).
Strong understanding of data modeling techniques (e.g., star schema, snowflake schema, dimensional modeling).
Comfortable engaging with technical and non-technical stakeholders to gather requirements and present solutions.
Ability to thrive in face-moving, client-facing environments and diplomatically handle challenging conversations.
Excellent written and verbal communication skills
Experience with version control systems (e.g., Git), CI/CD workflows, and development best practices.
Self-directed, organized, and capable of leading engagements with minimal supervision
Preferred Skills and Experience:
Previous experience working client facing preferably within a law firm, technology company or consulting organization
Previous experience deploying software into a large, highly regulated organization
The annual base salary range is $140,000-$165,000k /year. 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?
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.
or
All done!
Your application has been successfully submitted!