Senior Data Engineer

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.