Data Engineer

Data Engineer Southern Trust Insurance Company - 3.2 Macon, GA Job Details Full-time 1 day ago Benefits Disability insurance Health insurance Dental insurance Flexible spending account Military leave Paid time off Family leave Paid military leave Parental leave Vision insurance 401(k) matching Life insurance Referral program Qualifications Data model design Performance tuning Power BI Data visualization software proficiency Data Integration (Data management) Azure Incident management Cloud data warehouses Snowflake SQL Data Architecture Design (Architecture design skills) Improving database performance Agile software development Data analytics tools Dimensional modeling Full Job Description Data Engineer Must be located in the

Eastern or Central US Time Zone Travel:

Occasional, based on project needs

Reports To:

Chief Information Officer 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.

Key Responsibilities Data Platform Development:

Build and maintain data pipelines and data warehouse/lakehouse components (data warehouses, lakes, and marts) while following established data governance, security, and privacy controls.

Pipeline Engineering:

Develop reliable data ingestion pipelines using scheduled and event-driven patterns. Optimize performance and ensure resilience.

Data Quality & Monitoring:

Implement data quality frameworks, validation checks, and safeguards to minimize pipeline failures and data integrity issues.

Architecture & Optimization:

Contribute to improving legacy ingestion methods, address technical debt, and support impact assessment for proposed changes in partnership with the team.

Reporting & Visualization:

Build custom reports and dashboards using tools like Power BI, Snowflake, etc.

Collaboration & Agile Delivery:

Work closely with product owners and cross-functional teams to understand business needs, clarify requirements, and deliver solutions using agile methodologies.

Automation & Efficiency:

Identify inefficiencies, automate processes, and recommend improvements to optimize data flows.

Documentation & Standards:

Document pipelines, datasets, and data models; follow team standards; and participate in code reviews to improve maintainability and consistency.

Production Support:

Provide technical support for production incidents, ensuring system stability and continuous improvement.

Required Qualifications Experience:

2-4 years in data engineering with experience in Snowflake, SQL, ELT/ETL, dimensional data modeling, data warehousing, and pipeline development.

Technical Skills:

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.

Soft Skills:

Excellent communication (written and verbal). Strong problem-solving and incident management capabilities. High attention to detail and commitment to data accuracy. Preferred Qualifications 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.

Technical Competencies Data Engineering:

Experience building and supporting data warehouses/lakes, especially on Snowflake and Azure.

Data Integration:

Experience developing ELT/ETL pipelines using modern tools and scripting languages.

Data Modeling:

Proficient in logical and physical data modeling using relational and dimensional approaches.

Performance Optimization:

Experience tuning pipelines and database objects for optimal performance.

Version Control & CI/CD:

Familiarity with

ADO YAML

Pipelines or GitHub Actions and automated deployment practices.

API Integration:

Experience implementing and leveraging APIs for data exchange. Compensation Commensurate with experience Performance-based incentives Benefits Package 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 Physical Conditions/Requirements The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the functions. While performing the duties of this position, the employee is regularly required to talk or hear. The employee frequently is required to use hands or finger, handle, or feel objects, tools or controls. The employee is occasionally required to stand; walk; sit; reach with hands and arms; climb or balance; and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this position include close vision, distance vision, color vision, peripheral vision, and the ability to adjust focus. The noise level in the work environment is usually moderate.