Senior Data Engineer - Cloud Data Warehouse & ETL

GreatAmerica Financial Services Corporation; Cedar Rapids (IA); Hybrid; USD 110,000 - 165,000; Full time

Benefits offered by this job

Hybrid work arrangements

Gym Reimbursement

Tuition Assistance

401(k) plan with company match

Bonuses

Job summary

GreatAmerica Financial Services Corporation is seeking a Senior Data Engineer to design and run large-scale data warehousing and BI solutions. You will build and optimize data pipelines, ensure data quality, and collaborate with product owners and IT to support strategic analytics across the organization.

The role requires 7+ years in data warehousing, proficiency in SQL and ETL, and experience with cloud data platforms such as Snowflake or Azure Synapse.

Qualifications

• Bachelor’s degree in computer science, information systems or equivalent experience.
• 7+ years hands-on data warehousing design & implementation.
• 7+ years experience supporting high performing ETL processes, including data quality & testing.
• Experience with a cloud-based warehouse (Snowflake or Azure Synapse) is a plus.
• 7+ years of strong SQL experience and ability to write efficient code for high volume data processing.
• 3+ years programming experience with an advanced language (C#, Python, Java, etc.).
• Experience with data integration of third-party systems (Salesforce, Epicor, MuleSoft, etc.).
• Experience ensuring data quality across multiple datasets used for analytical purposes.
• Experience in agile development methodologies.

Responsibilities

• Work with product owner and data stakeholders to understand requirements and implement data solutions.
• Develop and operate data pipelines for cleansed, structured, integrated data for analyses and reporting.
• Design and implement monitoring for data quality and data integrity issues.
• Provide guidance on building reliable, scalable data pipelines with monitoring and alerts.
• Automate common data preparation and integration tasks to improve productivity.
• Renovate data management infrastructure to drive automation in data integration and management.
• Collaborate with IT on source system data structures to ensure data quality and consistent definitions.
• Actively participate in an agile team and provide technical leadership.

Skills

SQL proficiency

ETL design

Data modeling

Data warehousing

Python

C#

Java

Agile teamwork

Education

Bachelor’s degree in computer science or information systems

Tools

Snowflake

Azure Synapse Analytics

Informatica

SQL

Python

C#

Java

Job description

GreatAmerica Financial Services Corporation is seeking a Senior Data Engineer to design and run large-scale data warehousing and BI solutions. You will build and optimize data pipelines, ensure data quality, and collaborate with product owners and IT to support strategic analytics across the organization.

The role requires 7+ years in data warehousing, proficiency in SQL and ETL, and experience with cloud data platforms such as Snowflake or Azure Synapse.