Senior Data Engineer

Insperity Support Services, L.P.; Town of Middleton (WI); On-site; USD 110,000 - 170,000; Full time

Job summary

Insperity is seeking a Senior Data Engineer to advance enterprise data pipelines and architectures. You will collaborate with architects, analysts, data scientists, and business users to deliver reliable data assets and actionable insights.

The role emphasizes automation, scalable reporting, and data security across on-prem and cloud environments, with opportunities to mentor teammates and influence data strategy. Owner of end-to-end data solutions and governance.

Qualifications

• Bachelor's Degree in Computer Science or related field, or equivalent work experience in BI/Data Engineering preferred.
• 5–7 years of professional experience in information systems, with 3+ years in enterprise-grade software/data engineering.

Responsibilities

• Build and optimize enterprise data pipelines and architectures.
• Collaborate with architects, analysts, and data scientists to deliver data-driven insights.
• Lead efforts in data visualization strategy and self-service reporting across the organization.
• Ensure data security and governance across data platforms and environments.
• Mentor team members and stay current with emerging data technologies.

Skills

Snowflake

SQL

dbt

CI/CD

Power BI

Tableau

Databricks

Redshift

Salesforce

Education

Bachelor's Degree in Computer Science or related field

Tools

SQL

Snowflake

DBT

CI/CD

Power BI

Tableau

Databricks

Salesforce

Marketo

Eloqua

Google Analytics

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.SummaryThis 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 RequirementsSnowflake5+ years of hands-on Snowflake experienceStrong understanding of:Virtual WarehousesSnowpipeDynamic TablesStreams & TasksSecure Data SharingClustering and performance optimizationExperience designing scalable Customer 360 data modelsKnowledge of RBAC and data security controlsDBT2+ years of dbt development experienceStrong experience with:Incremental ModelsSnapshotsSeedsMacrosTestsSourcesExposuresExperience implementing Medallion Architecture:Bronze (Raw), Silver (Conformed), Gold (Business-Ready)Experience with CI/CD deployment using dbt Cloud or GitHub ActionsData IntegrationExperience ingesting data from:CRM platforms (Salesforce, Dynamics)Marketing Automation platforms (Eloqua, Marketo)Web Analytics platforms (Google Analytics)Advertising platformsProduct usage event dataPreferred ExperienceHightouchFivetranCustomer Data Platforms (CDPs)Customer 360 architecture and designAdditional QualificationsExcellent 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.