Data Engineer

Southern Trust Insurance Company • Macon, GA

1d • Remote

About The Position

We are seeking a skilled, hands-on Data Engineer to join our team. In this role, you will build, test, and maintain data pipelines and data warehouse components that support our broader data platform. You will help enable data-driven decision-making by ensuring business teams have access to clean, reliable, and well-modeled data. As a Data Engineer, you will transform raw data into actionable insights by developing scalable pipelines, creating robust data models, and supporting reporting and analytics tools in partnership with the broader team.

Requirements

• 2–4 years in data engineering with experience in Snowflake, SQL, ELT/ETL, dimensional data modeling, data warehousing, and pipeline development.
• Strong SQL skills with experience in query optimization and basic performance tuning.
• Solid understanding of dimensional modeling and core data architecture principles.
• Familiarity with Azure cloud services.
• Experience with BI tools (Power BI & Snowflake).
• Knowledge of Agile/Scrum practices.
• Experience building dimensional (Kimball-style) data models.
• Excellent communication (written and verbal).
• Strong problem-solving and incident management capabilities.
• High attention to detail and commitment to data accuracy.

Nice To Haves

• Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
• Proficiency in programming languages such as Python or Java.
• Experience with orchestration tools and CI/CD pipelines (e.g., ADO YAML Pipelines or GitHub Actions).
• Familiarity with cloud platforms (Azure) and modern data tools (Snowflake).
• Exposure to machine learning/AI concepts.
• Experience working with APIs and integrating external data sources.
• Background in the insurance industry (including carrier experience) is a plus.

Responsibilities

• Build and maintain data pipelines and data warehouse/lakehouse components (data warehouses, lakes, and marts) while following established data governance, security, and privacy controls.
• Develop reliable data ingestion pipelines using scheduled and event-driven patterns. Optimize performance and ensure resilience.
• Implement data quality frameworks, validation checks, and safeguards to minimize pipeline failures and data integrity issues.
• Contribute to improving legacy ingestion methods, address technical debt, and support impact assessment for proposed changes in partnership with the team.
• Build custom reports and dashboards using tools like Power BI, Snowflake, etc.
• Work closely with product owners and cross-functional teams to understand business needs, clarify requirements, and deliver solutions using agile methodologies.
• Identify inefficiencies, automate processes, and recommend improvements to optimize data flows.
• Document pipelines, datasets, and data models; follow team standards; and participate in code reviews to improve maintainability and consistency.
• Provide technical support for production incidents, ensuring system stability and continuous improvement.

Benefits

• 401(k) company match up to 6% eligible upon hire
• Medical, dental & vision, including company paid Life insurance and long-term disability
• Health care flexible spending accounts
• Paid time off
• Parental & family leave; military leave & pay
• Employee Referral Incentive
• Career Development & Continuing Education Assistance

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree
• Number of Employees: 1-10 employees