Senior Data Engineer

65 Insperity Support Services, L.P.; Town of Texas (WI); On-site; USD 120,000 - 180,000; Full time

Job summary

Insperity is seeking a Senior Data Engineer to join the Enterprise Data Engineering team. You will expand and optimize enterprise-wide data pipelines, acquire and transform data from multiple sources, and enable visualization and reporting strategies for internal and external users.

You will collaborate with developers, architects, analysts, and business users to maintain consistent data architectures and drive innovative solutions.

Qualifications

• Five to seven years of professional experience in information systems.
• Bachelor's Degree in Computer Science or related field, or equivalent work experience.
• Experience developing, architecting, managing, or maintaining enterprise-grade software systems.

Responsibilities

• Creates and maintains data pipeline architectures meeting stakeholder needs.
• Automates data delivery, enhances self-service, and focuses on scalability.
• Collaborates with executives, product management, and data teams.
• Assembles large, complex data sets to meet business requirements.
• Integrates data from CRM, marketing, web analytics, and advertising sources.
• Designs and implements scalable visualization and reporting strategies.

Skills

Leadership

Communication

Stakeholder engagement

Mentorship

Education

Bachelor's degree in Computer Science or related field

High School Diploma or equivalent

Tools

Snowflake

DBT

SQL

Power BI/Tableau

Job description

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

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.

Our Growth is Creating Great Opportunities! Our team is expanding, and we want to hire the most talented people we can. Continued success depends on it!