Summary

The Senior Data Engineer role is critical to designing, building, testing, and maintaining our data warehouse and broader data platform. This position plays a key role in enabling data-driven decision-making by ensuring business teams have access to clean, performant, and well-modeled data. The Senior Data Engineer will transform raw data into actionable insights through scalable pipelines, robust data models, and intuitive reporting tools.

Key Responsibilities

Data Platform Development: Design, build, and maintain scalable data platforms including data warehouses, lakes, and marts with strong 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: Redefine legacy ingestion methods, retire technical debt, and perform impact analysis for proposed changes.
Reporting & Visualization: Build custom reports and dashboards using tools like Power BI, Metabase, and Tableau.
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.
Production Support: Provide technical support for production incidents, ensuring system stability and continuous improvement.

Required Qualifications

5+ years in data engineering with expertise in Snowflake, SQL, ELT/ETL, data warehousing, and pipeline development.
Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience) is preferred.
Strong SQL skills and experience with performance tuning.
Deep understanding of dimensional modeling and data architecture principles.
Familiarity with Azure cloud services.
Experience with BI tools (Power BI, Metabase, Tableau).
Knowledge of Agile/Scrum practices.
Excellent communication (written and verbal).
Strong problem-solving and incident management capabilities.
High attention to detail and commitment to data accuracy. Occasional travel to the Home Office in Macon, GA.

Preferred Qualifications

Proficiency in programming languages such as Python or Java.
Experience with orchestration tools and CI/CD pipelines (e.g., GitLab).
Familiarity with cloud platforms (Azure, AWS) and modern data tools (Snowflake, Databricks).
Exposure to machine learning/AI concepts.
Experience working with APIs and integrating external data sources.
Background in financial or insurance industries is a plus.

Technical Competencies

Data Engineering: Expertise in designing and building data warehouses/lakes, especially on Snowflake and Azure.
Data Integration: Skilled in developing complex 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 GitLab 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
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.

Southern Trust Insurance Company

Latest Jobs

Senior Data Engineer - Remote