Senior Data Engineer

Posted 13 Hours Ago
2 Locations
In-Office
Senior level
HR Tech
The Role
Senior Data Engineer responsible for designing, building, and optimizing enterprise data pipelines, architectures, and scalable reporting solutions. The role integrates data from diverse business platforms, develops Snowflake and dbt solutions, implements governance and security, and enables self-service analytics. It partners with executives, product teams, analysts, developers, and data scientists while mentoring team members, evaluating emerging technologies, and delivering reliable data assets and actionable insights.
Summary Generated by Built In

Insperity provides the most comprehensive suite of scalable HR solutions available in the marketplace with an optimal blend of premium HR service and technology. With more than 90 locations throughout the U.S., Insperity is currently making a difference for thousands of businesses and communities nationwide.


Behind our success is the unshakeable belief in the value of our people. We value diversity, inclusivity and a sense of belonging. We celebrate work and life events, and we partner with our clients and communities to make great things happen.


We’ve earned recognition time and again as a top place to work—named among the best by respected organizations like Glassdoor and U.S. News & World Report. We’re also proud to be recognized for one of the country’s Top 50 Midsize Early Talent Programs through RippleMatch’s Campus Forward Awards. There’s never been a better time to be part of Insperity, and our best work is still ahead. Learn more at Insperity.com.

Why Insperity?

Flexibility: Over 80% of Insperity’s jobs have flexibility. We want your time to have balance, whether it’s spent with coworkers, clients, family or your community.

Career Growth: Insperity provides many ways to grow with the company. We offer continuous learning programs, mentorship opportunities and ongoing training.

Well-Being: Our total rewards package includes generous paid time off, top-tier medical, dental and vision benefits, health & wellness support, paid volunteer hours and much more. We take care of our people so that you can do your best work.

We are seeking a talented Senior Data Engineer to join our team.
Summary

This position is responsible for working as a senior member of the Enterprise Data Engineering team. Takes a proactive and creative approach to expanding and optimizing enterprise-wide data and data pipeline architectures, collection of data from sources across the company, and visualization and reporting strategies of the collected data. Implements data pipelines, acquires, transforms, and optimizes data sets for various use cases across the company. Ensures data sets are prepared for easy consumption by internal and external customers. This position will collaborate regularly with developers, architects, analysts, data scientists, and business facing users across various data initiatives and will ensure architectures and strategies remain consistent throughout ongoing projects. Responsible for continued improvement of our company’s data architecture and visualization strategies to support next generation products and data initiatives. Builds a relationship with all levels of stakeholders to represent the team as a trusted partner across the business through their deep knowledge of the subject and proven ability to deliver valuable solutions.

Responsibilities:

  • Creates intentional relationships with stakeholders of all levels to ensure solutions that utilize the data pipeline meet their needs and will provide actionable, data driven insights long term.

  • Identifies, designs, and implements process improvements with a heavy focus on automation, data delivery optimization, self-service, and scalability.

  • Forms deep working relationships with stakeholders including Executives, Product Management, Centers of Excellence, and others.

  • Creates and maintains data pipeline architectures to meet continuing needs of stakeholders.

  • Assemble large, complex data sets that meet business requirements.

  • Collaborates with various infrastructure and architecture teams to optimize acquisition and transformation of data from a wide variety of data sources using SQL and other ‘big data’ technologies.

  • Innovates solutions to ensure easy visualization and reporting across the enterprise.

  • Defines and implements self-service/highly scalable visualization and reporting strategies across the enterprise.

  • Ensures data security across all implementations, data centers, cloud providers, client machines, etc.

  • Encourages, challenges, and collaborates with team members to build and optimize our data assets into an innovative competitive advantage.

  • Helps lead team activities and serves as a catalyst and initiator for innovation and creation of new solutions.

  • Serves as a mentor, trainer, and inspiration to other team members and partners with teams within the technology department.

  • Leads efforts to find, evaluate, and explore emerging and upcoming technologies to keep the team abreast of new trends and on the leading edge of developing practices, tools, and state of the art.

Qualifications:

  • High School Diploma or equivalent is required. Bachelor's Degree in Computer Science or related field, or equivalent work experience in the Business Intelligence/Data Engineering field specifically, is desired.

  • Five to seven years of professional experience in information systems is required with at least three (3) years’ experience developing, architecting, managing, or maintaining enterprise grade software systems, database administration, or similar discipline.

Technical Requirements

Snowflake

5+ years of hands-on Snowflake experience

Strong understanding of:

  • Virtual Warehouses

  • Snowpipe

  • Dynamic Tables

  • Streams & Tasks

  • Secure Data Sharing

  • Clustering and performance optimization

  • Experience designing scalable Customer 360 data models

  • Knowledge of RBAC and data security controls

DBT

2+ years of dbt development experience

Strong experience with:

  • Incremental Models

  • Snapshots

  • Seeds

  • Macros

  • Tests

  • Sources

  • Exposures

Experience implementing Medallion Architecture:

  • Bronze (Raw), Silver (Conformed), Gold (Business-Ready)

  • Experience with CI/CD deployment using dbt Cloud or GitHub Actions

Data Integration

Experience ingesting data from:

  • CRM platforms (Salesforce, Dynamics)

  • Marketing Automation platforms (Eloqua, Marketo)

  • Web Analytics platforms (Google Analytics)

  • Advertising platforms

  • Product usage event data
     

Preferred Experience

  • Hightouch

  • Fivetran

  • Customer Data Platforms (CDPs)

  • Customer 360 architecture and design

Additional Qualifications

  • Excellent understanding and practical experience with MSSQL and other relational databases.

  • Proficient with unstructured NoSQL data storage tools and techniques.

  • Excellent working and functional knowledge of database architecture concepts and the fundamentals of sound enterprise technology architecture and design.

  • Understanding of modern data platforms and analytics technologies, including Hadoop, Redshift, Tableau, Power BI, Databricks, and related technologies.

  • Strong leadership, teamwork, and collaboration skills.

  • Strong consensus-building skills and the ability to find common ground or mutual agreement across complex topics involving compromise, negotiation, and collaboration.

  • Ability to communicate complex technical concepts to management, peers, and stakeholders who may not possess a strong technical or data background.

  • Strong customer service skills.

  • Exhibits a passion for learning and continuous improvement. Takes responsibility for acquiring new skills and broadening knowledge.

  • Exhibits a commitment to the utilization of defined standards, governance, and processes.

  • Strong verbal and written communication skills, with the ability to express complex technical concepts in business terms and maintain effective working relationships.

  • Proactive in identifying and recommending opportunities for improvement, efficiency, and increased reliability.

  • Ability to create technical documentation and effectively share knowledge among team members.

This job specification should not be construed to imply that these requirements are the exclusive standards of the position.  Incumbent will follow any other instructions, and perform any other related duties, as may be required by the supervisor.

At Insperity, we celebrate the diversity of our employees and our leadership. Insperity is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law.

Skills Required

  • High school diploma or equivalent
  • Bachelor's degree in Computer Science or a related field, or equivalent business intelligence/data engineering experience
  • Five to seven years of professional information systems experience
  • At least three years developing, architecting, managing, or maintaining enterprise-grade software systems, database administration, or a similar discipline
  • At least five years of hands-on Snowflake experience
  • Strong understanding of Snowflake Virtual Warehouses, Snowpipe, Dynamic Tables, Streams and Tasks, Secure Data Sharing, clustering, and performance optimization
  • Experience designing scalable Customer 360 data models
  • Knowledge of role-based access control and data security controls
  • At least two years of dbt development experience
  • Strong experience with dbt incremental models, snapshots, seeds, macros, tests, sources, and exposures
  • Experience implementing Medallion Architecture across Bronze, Silver, and Gold layers
  • Experience with CI/CD deployment using dbt Cloud or GitHub Actions
  • Experience ingesting data from CRM, marketing automation, web analytics, advertising, and product usage platforms
  • Experience with Hightouch
  • Experience with Fivetran
  • Experience with Customer Data Platforms
  • Experience with Customer 360 architecture and design
  • Strong practical experience with MSSQL and other relational databases
  • Proficiency with unstructured NoSQL data storage tools and techniques
  • Working knowledge of Hadoop, Redshift, Tableau, Power BI, Databricks, and related data platform technologies
  • Strong leadership, teamwork, collaboration, consensus-building, and communication skills
  • Ability to communicate complex technical concepts to technical and nontechnical stakeholders
  • Ability to create technical documentation and share knowledge

Insperity Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Insperity and has not been reviewed or approved by Insperity.

  • Affordable Benefits Affordable Benefits: Healthcare costs are perceived as low relative to coverage breadth and generous plan options, elevating total compensation even when base pay is viewed as only fair.
  • Leave & Time Off Breadth Leave & Time Off Breadth: Generous PTO, paid holidays, and paid volunteer time are included, which meaningfully increase the perceived value of the overall package.
  • Retirement Support Retirement Support: A 401(k) with company match and multiple retirement plan options contribute to a well-rounded total rewards offering.

Insperity Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Kingwood, TX
4,000 Employees
Year Founded: 1986

What We Do

For more than 30 years, Insperity® has provided human resources and business solutions that help America's best companies prosper. Click here to learn how.

Similar Jobs

NinjaOne Logo NinjaOne

Senior Data Engineer

Information Technology • Productivity • Software • Infrastructure as a Service (IaaS)
Remote or Hybrid
18 Locations
2000 Employees
110K-200K Annually

NinjaOne Logo NinjaOne

Senior Data Engineer

Information Technology • Productivity • Software • Infrastructure as a Service (IaaS)
Remote or Hybrid
18 Locations
2000 Employees
110K-200K Annually

NinjaOne Logo NinjaOne

Senior Data Engineer

Information Technology • Productivity • Software • Infrastructure as a Service (IaaS)
Remote or Hybrid
18 Locations
2000 Employees
110K-200K Annually

BECU Logo BECU

Senior Data Engineer

Fintech • Financial Services
Remote or Hybrid
3 Locations
3000 Employees
110K-205K Annually

Similar Companies Hiring

RethinkFirst Thumbnail
Telehealth • Software • Professional Services • Information Technology • HR Tech • Healthtech • Edtech
New York, NY
300 Employees
Empathy Thumbnail
Fintech • Healthtech • HR Tech • Information Technology • Financial Services • Telehealth
IL
200 Employees
Compa Thumbnail
Artificial Intelligence • HR Tech • Software • Business Intelligence
Irvine, California
75 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account