Insurance Data Engineer Jobs in Prosper, TX (NOW HIRING)

Job Title: AWS/Snowflake Data Engineer Location: Richardson, OK Type: Contract Compensation: $90.32 Work Model: Hybrid – onsite and remote Hours: 40.0 Security Clearance: Not specified

Overview The Sr. Cloud Data Engineer is responsible for designing, building, and maintaining robust and scalable data solutions on the Amazon Web Services (AWS) cloud platform, with a strong emphasis on native AWS services, Apache Iceberg-based lakehouse patterns, and Snowflake for cloud data warehousing and analytics. This role will transform raw data into secure, high-quality, reusable datasets and data products that enable analytics, reporting, and operational use cases. This role involves developing end-to-end data pipelines, managing data lakes and lakehouse architectures using Apache Iceberg, and creating secure, high-performance interfaces/APIs to deliver data products to stakeholders. This is a long-term contract position offering benefits and some extra perks! This role is only seeking American citizens or green card holders at this time.

Responsibilities

• Design and develop data architecture (AWS Lakehouse + Snowflake): Create scalable, reliable, and efficient data lakehouse solutions on AWS using Amazon S3 and Apache Iceberg, and design curated/consumption architectures in Snowflake to enable performant analytics and governed data sharing.
• Build and maintain data pipelines (native AWS tooling): Design, construct, and automate ETL/ELT processes to ingest data from diverse sources into AWS, leveraging native services such as AWS Glue, Lambda, Step Functions, EventBridge, and orchestration patterns as appropriate.
• Develop and manage Iceberg tables: Build and manage Apache Iceberg datasets, including table design, schema evolution, partition strategies, and compaction/maintenance patterns to support ACID-like behavior and scalable analytics.
• Snowflake engineering: Design and implement Snowflake objects and pipelines to support analytics and data products (schemas, tables, views), and contribute to patterns for secure and governed consumption.
• Create and manage data APIs / interfaces: Design, develop, and maintain secure and scalable RESTful (and other) APIs to facilitate data access for internal teams and applications, typically leveraging AWS services (e.g., API Gateway, Lambda, IAM).
• Optimize performance and cost: Implement partitioning strategies, data layout optimization, and tuning techniques across Iceberg and Snowflake; monitor workloads and continuously improve efficiency and runtime performance.
• Ensure data quality and integrity: Implement data validation, reconciliation, and error-handling processes; build observability into pipelines so issues are detected early and addressed quickly.
• Collaborate with stakeholders: Work closely with analysts, data scientists, software engineers, and business teams to understand data needs and deliver effective, reusable solutions.
• Provide technical support: Offer troubleshooting and technical expertise for data-related issues across pipelines, datasets, and endpoints.
• Maintain documentation: Create and maintain technical documentation for data workflows, pipelines, dataset definitions, and API specifications.

Requirements

• Education: Bachelor's degree in Computer Science, Information Technology, or a related field.
• Experience: Proven experience in data engineering with significant hands-on experience building data solutions on AWS.
• Technical Skills: Proficiency in Python, Java, or Scala; Strong SQL skills for querying, transformations, and data modeling / database design (including Snowflake SQL); Practical experience with AWS services such as S3, Glue, Lambda, API Gateway, and IAM; Experience with Apache Spark and Hadoop ecosystems; Experience creating and deploying RESTful APIs; Experience with workflow orchestration tools (e.g., Airflow or AWS-native orchestration patterns); Familiarity with DevOps practices, CI/CD pipelines, and infrastructure as code (Terraform).
• Strongly Preferred Experience: Hands-on experience building and managing Apache Iceberg tables; Snowflake implementation and operation experience, including data modeling for analytics and secure consumption patterns.
• Soft Skills: Strong problem-solving and analytical skills; Excellent communication and collaboration skills; Ability to work independently and as part of an agile team.
• Certifications (Preferred): AWS data-related certifications and other relevant cloud/data engineering certifications.

System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan. System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law. #M- #LI- Ref: #208-Rowland Tulsa