Data Engineer

PHARMACISTS INSURANCE COMPANY•Algona, IA

18h•$82,000 - $135,000•Hybrid

About The Position

Pharmacists Mutual Insurance Group has an opening for a Data Engineer. The Data Engineer supports the organization’s data needs by ensuring secure, reliable, accurate, and accessible data across all business units. This includes stewardship and maintenance of enterprise data assets, modeling and integration of data from systems of record, and support for analytical and reporting capabilities. Data team members partner directly with business units, business analysts, and data stewards to interpret requirements, ensure data accuracy and governance, and deliver high quality analytics solutions. The team is responsible for developing and maintaining the enterprise data stack using both on premises and cloud native components, with a goal of being entirely cloud native in the future. Data Engineer II • Applies SQL Server and data warehousing concepts to develop and maintain ETL/ELT workflows, ensuring data accuracy and quality. • Participates in building and maintaining ETL pipelines, data warehouse structures, data quality rules, and metadata. • Assists in the operation and enhancement of Data Quality and MDM processes. • Works with minimal assistance and contributes to improvements in data reliability and accessibility. Senior Data Engineer • Applies expert level data engineering practices to design and optimize enterprise data models and ETL architectures, perform advanced SQL performance tuning, and implement data mastering solutions to ensure scalable, high quality data. • Leads efforts to establish source of truth datasets and governance practices. • Manages projects and tasks independently and mentors Data Engineers and Analysts. • Demonstrates high quality work and serves as a technical leader in the data domain.

Requirements

Strong SQL abilities: querying, performance tuning, transformations, and modeling.
Understanding of data warehouse concepts: facts/dimensions, SCD, star schemas.
Familiarity with ETL patterns, data pipelines, and data quality concepts.
Understanding of source of truth, data mastering, and governance practices.
Experience with version control systems and CI/CD practices.
Ability to interpret business requirements and translate them into technical solutions.
Ability to analyze complex data issues and make critical decisions.
Strong communication skills for explaining technical data concepts to non technical users.
Ability to organize, prioritize, and manage multiple data initiatives simultaneously.
Ability to maintain confidentiality and handle sensitive data appropriately.
Effective customer service and collaboration with crossfunctional teams.
SQL Server queries, stored procedures, indexing, performance tuning, data warehouse modeling and optimization
ETL Development package creation, scheduling, error handling, and operational support
Data Quality/MDM data profiling, rule building, mastering, stewardship workflows
SSAS Tabular Model design, DAX measures, relationships, and performance tuning
PowerBI / SSRS Report building, dataset modeling, dashboarding, and governance
Version Control Git, Azure DevOps, or similar
Cloud native data architecture tooling and patterns
High School Diploma or equivalent and 7 years of related experience, or Associate’s Degree or equivalent and 5 years of related experience, or Bachelor’s Degree and 3 years of related experience, or Master’s Degree
High School Diploma or equivalent and 10 years of related experience, or Associate’s Degree or equivalent and 8 years of related experience, or Bachelor’s Degree and 5 years of related experience, or Master’s Degree and 2 years of related experience

Responsibilities

Work with Business Analysts, Data Stewards, and business users to understand reporting and data needs.
Design, build, enhance, and maintain data pipelines and data warehouse structures.
Ensure data from all systems of record is integrated into the data architecture and is validated and accessible for analytics.
Troubleshoot data issues, ensure data accuracy, and support end user questions.
Maintain and extend documentation for data flows, data models, and data definitions.
Participate in project planning and provide visibility into data related tasks and timelines.
Assist in data governance initiatives, including lineage, metadata management, and stewardship processes.
Collaborate across IT and data teams to maintain data environments, participate in quality and governance focused reviews, evaluate emerging data technologies, and effectively manage multiple priorities both independently and as part of a team.
Design, optimize, and maintain high performance data warehouse Kimball schemas, ensuring efficient query and modeling access.
Develop, deploy, and support ETL pipelines, applying data validation, error handling, performance tuning, and job scheduling.
Collaborate with data stewards to monitor and resolve data quality issues, implementing data validation and profiling rules as well as data quality dashboards.
Design and manage a Single Source of Truth, implementing golden record and survivorship logic within a master data management solution.
Design and optimize high performing, reliable semantic tabular models by defining accurate measures, dimensions, hierarchies, and relationships for enterprise reporting.
Support data stewards in data exploration and reporting insight generation, ensuring compliant use of governed data models and certified datasets.
Manage data engineering code and pipeline artifacts in version control, participating in code reviews to ensure quality and governance, and supporting release management of data assets.