Product Engineering (Senior ETL Developer)
Core
Designing and developing data integration components, feeds, and cloud-based data pipelines to support insurance agent compensation measurement, sales tracking, and business intelligence reporting.
Role type
Senior ETL Developer
Builds
Data integration processes, data warehouse feeds, and cloud-based data pipelines for agent compensation and sales reporting systems.
Domain
Insurance / Data Engineering
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
ETL Development, Data Integration, Microsoft SQL Server, SSIS, T-SQL, Windows PowerShell, Data Validation, Data Reconciliation, Performance Optimization, Stored Procedures, Windows Scripting
Preferred skills
Data Warehousing Concepts, Star Schema, Snowflake Schema, SSAS, Oracle Database PL/SQL
Technologies
Microsoft SQL Server, SSIS, SSRS, Power BI, Oracle DB, Windows Shell Scripts
Responsibilities
Own data integration capabilities within the agent compensation and sales reporting team; Create new solutions to enable accurate sales tracking and reporting; Develop new capabilities and support integration between Oracle DB and SQL Server; Develop new data pipelines and support integration SQL Server and Power BI; Develop and optimize complex SQL Queries, Stored Procedures, Functions, Packages, and Views; Develop Windows Shell Scripts for job automation, scheduling, file handling, and monitoring; Troubleshoot ETL failures and resolve production issues.
Seniority
Senior, hands-on IC
