Senior Data Engineer

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 is a highly successful entrepreneurial company providing equipment financing to businesses across the United States. Our exemplary customer service, our principle-centered business philosophy and our team-based operating approach are key to our success and growth. We have also recently become a bank!We are Looking to Add a Key Member to Our Enterprise Technology Group!The Senior Data Engineer relishes working with large volumes of data, enjoys the challenge of highly complex technical contexts, and, above all else, is passionate about data and analytics. They are an expert with modern data architectures, data modeling, ETL design, business intelligence tools and passionately partners with the business to identify strategic opportunities where improvements in data infrastructure creates significant business impact. They need to possess exceptional technical expertise in large scale data warehouse and BI systems.As a Senior Data Engineer, you will:Major responsibilities of the position are listed below. To perform the job successfully, the individual must be able to execute each essential duty satisfactorilyWork with the product owner and data stakeholders to understand the business requirements and implement optimal data solutionsDevelopment and operation of data pipelines that cleanses, structures, and integrates data sets from source systems and third-party data structures into a consumable and accessible format for analyses and reporting with a mind toward accuracy, scalability and high performanceDesign and implement framework to continuously monitor and troubleshoot data quality and data integrity issuesDesign and provide guidance on building reliable, efficient, scalable, and quality data pipelines with monitoring and alert mechanisms that combine a variety of sources using ETL/ELT tools or scripting languagesUses innovative and modern tools, techniques and architectures to automate the most-common and tedious data preparation and integration tasks to minimize manual and error-prone processes and improve productivityAssists with renovating the data management infrastructure to drive automation in data integration and managementCollaborate with information technology resources regarding source system data structures and changes to those structures to ensure consistent business definitions and data qualityActively collaborate in an agile teamProvide technical guidance and thought leadershipTo be successful in this role you will need:EducationBachelor’s degree in computer science, information systems or equivalent experienceExperience7+ years hands-on experience with Data Warehousing design & implementationExperience with a cloud-based warehouse (e.g., Snowflake or Azure Synapse Analytics) is a plus7+ years hands-on experience supporting high performing ETL processes, including data quality and testing processesExperience with Informatica is a strong plus7+ years of strong experience with SQL and ability to write efficient code for high volume data processing3+ years programming experience with an advanced language (C#, Python, Java, etc.)Experience with data integration of third-party systems (e.g., Salesforce, Epicor, MuleSoft, etc.)Experience ensuring data quality across multiple datasets used for analytical purposesExperience in agile development methodologiesExposure and experience with a diverse set of modern data architectures is a plusSkills and AbilitiesExcellent communication (oral and written) and interpersonal skills with a keen sense of customer service.Enthusiastic attention to detailKnowledge of statistical concepts and their application in reporting and data mart applicationsAbility to acquire new skills quickly, and thrive in a collaborative team environmentMust be able to establish and maintain professional working relationships with all levels of GreatAmerica personnel and external contactsSharing rewards is an integral part of our culture. We believe in the value of hard work and reward our employees beyond the paycheck. Our total rewards package is based on eligibility and includes:Financial BenefitsCompetitive CompensationMonthly Bonuses for Eligible Employees401(k) and Company MatchAnnual Profit SharingPaid Time OffHealth, Wellbeing, and Family Planning BenefitsPaid VacationPaid Sick DaysPaid HolidaysGym ReimbursementHealth InsuranceDental InsuranceVision InsuranceShort-Term and Long-Term DisabilityCompany Paid Life InsuranceFlexible Spending Accounts (FSA)Health Savings Accounts (HSA)Employee Assistance ProgramParental LeaveEducation and Career Planning BenefitsTuition AssistanceNetworking OpportunitiesLeadership Development OpportunitiesPerksPaid ParkingService AwardsHybrid work arrangementsBusiness casual environmentA strong organizational culture focused on our greatest asset: you!If your experience aligns closely, please apply. We value diverse backgrounds and adding new perspectives. We encourage you to apply if you can make a strong impact in this role at www.greatamerica.com/careers.Please note, applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa.