Cloud Data Engineer - ETL & Analytics

BITCO Insurance Companies; Davenport (IA); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Competitive salary

12 paid holidays

Health coverage

Life insurance

Disability coverage

401(k) + profit sharing

Education & development

Certifications support

Community involvement

Travel insurance

Wellness program

Job summary

Old Republic Bitco seeks a Data Engineer - Cloud to join our Davenport, IA team in a hybrid role. You will design, build, and optimize cloud-based data pipelines and ETL processes to support data-driven decision making across the organization.

You'll collaborate with IT, analytics, and business units, implement data quality checks, and leverage Snowflake, Azure Synapse, and Power BI to deliver scalable insights.

Qualifications

• Legally authorized to work in the United States.
• 3+ years of proven experience as a Data Engineer or similar technical role with data lineage, development, ETL processes, and software development.
• Proven experience with data integration and data pipeline development.
• Solid understanding of data modeling, data warehousing concepts, and ETL processes.
• Proficiency in SQL and scripting languages such as Python or Spark; experience with relational databases.
• Familiarity with data warehousing concepts and tools, such as Snowflake or Azure Synapse; experience optimizing large-scale data processing.
• Experience with Microsoft Fabric is preferred.
• Strong analytical and problem-solving skills; ability to troubleshoot data issues at scale.
• Excellent communication and collaboration skills; able to work effectively in a team environment.
• Self-motivated with a passion for continuous learning and professional development.

Responsibilities

• Design, build, and maintain robust data pipelines and ETL processes to ingest, transform, and load data from multiple sources into our data warehouse, ensuring scalability and efficiency.
• Collaborate with Project Managers, Business Leaders, Analysts, and stakeholders to understand data requirements and develop solutions that meet business needs at scale.
• Participate in strategic data and analytics projects to enable leaders to consume data in a curated self-service model for insights.
• Integrate and deliver data from multiple sources for internal customers to analyze and make informed decisions.
• Develop data engineering frameworks to enable agile data insights while ensuring data quality.
• Partner across operational and support functions to build scalable data-based solutions improving key metrics/OKRs.
• Ensure reliability, availability, and scalability of data systems; monitor performance and optimize for increasing data volumes.
• Experience in cloud-based data infrastructure and administration handling structured and unstructured data for insights.
• Implement automated data quality checks and validation processes to ensure data integrity at scale.
• Participate in all software/data development activities including design, coding, testing, deployment, and documentation.
• Maintain data integrity across development, staging, and production environments.
• Knowledge of Power BI semantic models to provide actionable insights to stakeholders.
• Troubleshoot data-related issues, identify root causes, and implement timely solutions to minimize business impact.
• Create and maintain design documents for data pipelines, systems, and processes.
• Stay current with emerging data engineering technologies and trends to support scalability.
• Work with business units to interpret data needs and propose innovative ways to analyze data.
• Architect robust data structures that meet identified business requirements.
• Create reusable templates, such as Power BI semantic models, to empower teams in reporting.
• All other functions and duties as assigned.

Skills

SQL

Python

Spark

Data integration

Data modeling

Data warehousing

Tools

Snowflake

Azure Synapse

Microsoft Fabric

Job description

Old Republic Bitco seeks a Data Engineer - Cloud to join our Davenport, IA team in a hybrid role. You will design, build, and optimize cloud-based data pipelines and ETL processes to support data-driven decision making across the organization.

You'll collaborate with IT, analytics, and business units, implement data quality checks, and leverage Snowflake, Azure Synapse, and Power BI to deliver scalable insights.