Data Engineer- Cloud

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 is seeking a Data Engineer - Cloud to join our Home Office located in Davenport, IA. As a respected specialty insurer with 11 branch offices across 10 states, OR Bitco delivers tailored insurance solutions to complex industries such as construction, forest products, and oil and gas.

This position is open to hybrid work arrangement, blending flexibility with meaningful in-person collaboration.

At OR Bitco, our work is guided by core values. We care deeply about our people, partners, and customers. We are committed to excellence and accountability. We deliver on our promises with integrity and precision, and we strive to make a meaningful impact in everything we do. These values drive our mission to protect the people and industries that keep America running.

Join the OR Bitco team and be part of a workplace built on collaboration, open communication, and a positive culture that supports growth and success. If you are passionate about operational excellence and ready to make a measurable impact within a growing, industry-leading organization, OR Bitco offers the platform and challenge you have been seeking.

Position Summary

In this position you’ll have a key role in building and maturing the Company's Data Services across all aspects of the organization. This includes recommending and implementing tools for enabling internal business units to leverage data securely, effectively, and efficiently.

You’ll develop secure, high-performing data integration and ETL (Extract, Transform, Load) processes, participating in all stages of development from analysis, administration to production releases in a cloud environment. This is a highly collaborate role, spanning across IT, Business, and Executive teams from a customer perspective, and from legacy to modernization cloud-based systems.

You will be involved in all aspects of data science, engineering, and analytics as the Company instills and matures these capabilities and data discipline throughout the organization.

Primary Responsibilities

• Design, build, and maintain robust data pipelines and ETL processes to ingest, transform, and load data from multiple sources (legacy and modern) into our data warehouse, ensuring scalability and efficiency


• Collaborate with Project Managers, Business Leaders, Analysts, and other stakeholders to understand data requirements and develop solutions that meet business needs while accommodating scalable volumes of data


• Participate in strategic data and analytics projects to enable our business leaders and analysts to consume data in a curated self-service model that lead to impactful insights for key business areas


• Integrate and deliver data from multiple sources for internal customers to analyze and make decisions relevant to their functional area or across product, program, customer, and risk axis


• Develop data engineering focused frameworks to enable agile and quick data insights, while maintaining the quality of the insight, and inform strategy


• Partner across all operational and support functions to build scalable data-based solutions that provide insights into improving key metrics/OKRs


• Ensure the reliability, availability, and scalability of our data systems, monitoring performance and optimizing as needed to handle increasing data volumes


• Experience in cloud-based data infrastructure and administration consuming structured and unstructured data for business insights


• Implement automated data quality checks and validation processes to ensure data integrity and accuracy at scale


• Participate in all aspects of software/data development activities, including design, coding, code review, unit and integration testing, bug fixing, deploy and code/API documentation


• Ensure data integrity, accuracy, and reliability across multiple environments (development, staging, production)


• Knowledge of Power BI semantic models optimized to provide actionable insights to stakeholders


• Troubleshoot data-related issues, identify root causes, and implement solutions in a timely manner to minimize business impact


• Create and maintain design documents and documentation for data pipelines, systems, and processes


• Stay current with emerging technologies and trends in data engineering, recommending and implementing improvements as necessary to support scalability and growth


• Work closely with various business units and leaders to identify and interpret their data needs, suggesting innovative ways to consume and analyze data


• Architect and design robust data structures that effectively support identified business requirements


• Create reusable templates, such as Power BI semantic models, to empower other data services and IT personnel in their reporting efforts


• All other functions and duties as assigned

Qualifications

• Legally authorized to work in the United States


• 3+ years of proven experience as a Data Engineer or similar technical role, with a strong background in data lineage, development, ETL processes, and software development


• Proven experience working with a focus on data integration and data pipeline development


• Solid understanding of data modeling, data warehousing concepts, and ETL processes


• Proficiency in SQL, scripting languages such as Python or Spark, and experience working with relational databases


• Familiarity with data warehousing concepts and tools, such as Snowflake or Azure Synapse, and experience optimizing performance for large-scale data processing


• Experience with Microsoft Fabric is preferred


• Experience with data modeling, schema design, and optimization techniques for scalability


• Strong analytical and problem-solving skills, with the ability to troubleshoot complex data issues and optimize data processing pipelines for scale


• Excellent communication and collaboration skills, with the ability to work effectively in a team environment


• Self-motivated and proactive, with a passion for continuous learning and professional development

Benefits

• Competitive salary paired with a comprehensive benefits package


• Generous paid time off, plus 12 paid holidays annually


• Comprehensive health coverage, including medical, dental, and vision plans


• Additional protection through accident, critical illness, and hospital indemnity insurance


• Company-paid life insurance equal to 2× annual salary


• Company-paid short-term and long-term disability coverage


• 401(k) Savings and Profit-Sharing Plan through Old Republic


• Ongoing education, training, and professional development opportunities


• Support for industry certifications and insurance designations, including financial assistance


• Opportunities to give back through corporate philanthropy and community service initiatives


• Optional benefits including travel, commuter, and pet insurance


• Employee wellness support through a dedicated fitness program