Data Engineer

We are seeking an experienced Data Engineer to join a growing data and analytics team at a leading financial services organization, supporting a member value initiative focused on measuring and improving digital and service experiences for both new and existing members. In this role, you will work closely with cross-functional teams to build, maintain, and optimize data pipelines, transforming raw vendor and operational data into consumable, analytics-ready datasets within a Snowflake environment using DBT. Strong verbal and written communication skills are essential, as engineers will collaborate with experience owners, MSR stakeholders, and technical leads to deliver high-quality, reliable data products. If you believe you are the right fit for the role, we welcome you to apply!
Key Responsibilities
• Design, build, maintain, and optimize ETL/ELT data pipelines to ingest and transform operational and vendor data into Snowflake
• Develop, manage, and tune DBT models using SQL, YAML, and Jinja templating within a DBT environment (Core and/or Fusion)
• Write and optimize complex SQL queries as part of DBT development workflows
• Interact with GitHub and GitLab via Git Bash commands on a Linux terminal to pull branches, develop locally, and push code back to shared repositories
• Leverage AI-assisted development tools within the local development environment to accelerate pipeline and model delivery, ensuring code quality and accuracy before committing to the shared repository
• Collaborate with project leads and experience owners to understand business requirements and translate them into scalable, well-optimized data engineering solutions
• Support multiple concurrent projects under the member value organization, including MSR workflow data (Flowable) and complaints data initiatives

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

3–4+ years of hands-on data engineering experience, with strong ETL/ELT pipeline development and optimization skills
3–4+ years of strong SQL proficiency, including complex query writing, optimization, and data warehouse concepts.
Experience with DBT (dbt Core or dbt Fusion), including SQL, YAML, and Jinja templating.
Proficiency with Git and Git Bash commands.
Solid understanding of relational data modeling concepts:
Experience working with sensitive or regulated data and applying data quality/scrubbing best practices

Python experience is a strong plus
Prior experience mentoring or leading junior/mid-level engineers, or taking ownership of project workstreams
Datadog (SLO/SLA monitoring)
Grafana or Fortuna
Google SRE / Data Reliability Engineering principles

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.