Senior Data Engineer

GreatAmerica Financial Services; Cedar Rapids (IA); Hybride; USD 110 000 - 150 000; Plein temps

Avantages offerts par ce poste

Paid Parking

Service Awards

Hybrid work arrangements

Business casual environment

Résumé du poste

GreatAmerica Financial Services Corporation in Cedar Rapids, IA is seeking a Senior Data Engineer who loves working with large data sets and modern architectures. You will build and scale data pipelines, ensure data quality, and partner with stakeholders to turn data into actionable insights.

Join an entrepreneurial company that values collaboration, agility, and innovation. This role offers a hands-on environment, competitive compensation, and a comprehensive benefits package.

Qualifications

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

Responsabilités

• Understand business requirements and implement optimal data solutions.
• Develop and operate data pipelines cleansing, structuring, and integrating data from source systems and third-party data structures.
• Design and monitor data quality and data integrity issues.
• Design and provide guidance on building reliable, scalable data pipelines with monitoring and alert mechanisms.
• Automate data preparation and integration tasks to minimize manual errors and improve productivity.
• Renovate the data management infrastructure to drive automation in data integration and management.
• Collaborate with IT on source system data structures to ensure consistent definitions and data quality.
• Collaborate in an agile team and provide technical leadership.

Connaissances

Data warehousing

ETL processes

SQL

C#/Python/Java

Data integration

Agile development

Data quality

Formation

Bachelors degree

Outils

Informatica

Snowflake

Azure Synapse

Salesforce

MuleSoft

Description du poste

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!

TheSenior Data Engineerrelishes 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 satisfactorily

• Work with the product owner and data stakeholders to understand the business requirements and implement optimal data solutions
• Development 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 foranalysesand reportingwith a mind toward accuracy, scalability and high performance
• Design and implement framework to continuously monitor and troubleshoot data quality and data integrity issues
• Design 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 languages
• Uses 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 productivity
• Assists with renovating the data management infrastructure to drive automation in data integration and management
• Collaborate with information technology resources regarding source system data structures and changes to those structures to ensure consistent business definitions and data quality
• Activelycollaboratein an agile team
• Providetechnical guidance and thought leadership

To be successful in this role you will need:

Education

• Bachelor’s degree in computer science, information systems orequivalent experience

Experience

• 7+ years hands-on experience with Data Warehousing design & implementation
• Experience with a cloud-based warehouse (e.g.,Snowflake or Azure Synapse Analytics) is a plus
• 7+ years hands-on experience supporting high performing ETL processes, including data quality and testing processes
• Experience with Informatica is astrongplus
• 7+ years of strong experience with SQL and ability to write efficient code for high volume data processing
• 3+ years programming experience with an advanced language (C#, Python, Java, etc.)
• Experience withdata integration of third-party systems (e.g.,Salesforce, Epicor, MuleSoft, etc.)
• Experience ensuring data quality across multiple datasets used for analytical purposes
• Experience in agile development methodologies
• Exposure and experience witha diverse set ofmodern data architecturesisa plus

Skills and Abilities

• Excellent communication (oral and written) and interpersonal skills with a keen sense of customer service.
• Enthusiastic attention to detail
• Knowledge of statistical concepts and their application in reporting and data mart applications
• Ability to acquire new skills quickly, and thrive in a collaborative team environment
• Must be able to establish and maintain professional working relationships with all levels of GreatAmerica personnel and external contacts

Sharing 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 Benefits

• Competitive Compensation
• Monthly Bonuses for Eligible Employees
• 401(k) and Company Match
• Annual Profit Sharing
• Paid Time Off

Health, Wellbeing, and Family Planning Benefits

• Paid Vacation
• Paid Sick Days
• Paid Holidays
• Gym Reimbursement
• Health Insurance
• Dental Insurance
• Vision Insurance
• Short-Term and Long-Term Disability
• Company Paid Life Insurance
• Flexible Spending Accounts (FSA)
• Health Savings Accounts (HSA)
• Employee Assistance Program
• Parental Leave

Education and Career Planning Benefits

• Tuition Assistance
• Networking Opportunities
• Leadership Development Opportunities

Perks

• Paid Parking
• Service Awards
• Hybrid work arrangements
• Business casual environment
• A strong organizational culture focused on our greatest asset: you!

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.