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
Actively collaborate in an agile team
Provide technical guidance and thought leadership
To be successful in this role you will need
Education
Bachelor’s degree in computer science, information systems or equivalent 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 a strong plus
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 with data 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 with a diverse set of modern data architectures is a 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!
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.