Cloud Data Engineer - Pipelines & Analytics (Hybrid)

Socket.dev; Davenport (IA); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive salary

Comprehensive benefits package

Hybrid work arrangement

401(k) Savings and Profit-Sharing Plan

Education and professional development

Job summary

Old Republic Bitco seeks a Data Engineer - Cloud to build and mature data services across the organization in Davenport, IA. You’ll design secure, scalable data pipelines and ETL processes, enabling internal teams to leverage data for insights in a cloud environment.

You will collaborate with IT, business, and executives, contributing to data science and analytics initiatives while ensuring data integrity and quality at scale. Hybrid work arrangement offered to balance in-person collaboration.

Qualifications

• 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 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.

Responsibilities

• Design, build, and maintain robust data pipelines and ETL processes to ingest, transform, and load data from multiple sources into our data warehouse.
• Collaborate with Project Managers, Business Leaders, Analysts, and other stakeholders to understand data requirements and develop solutions that meet business needs.
• Participate in strategic data and analytics projects to enable leaders and analysts to consume data for insights.
• Integrate and deliver data from multiple sources for internal customers to analyze and make decisions.
• Develop data engineering frameworks to enable agile data insights while maintaining data quality.
• Partner across operations to build scalable data-based solutions that improve key metrics/OKRs.
• Ensure reliability, availability, and scalability of data systems and monitor performance.
• 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 at scale.
• Participate in design, coding, testing, deployment, and documentation of data pipelines.

Skills

Data engineering

ETL pipelines

SQL

Python

Cloud data platform

Power BI

Data modeling

Communication

Tools

Snowflake

Azure Synapse

Microsoft Fabric

Power BI

Job description

Old Republic Bitco seeks a Data Engineer - Cloud to build and mature data services across the organization in Davenport, IA. You’ll design secure, scalable data pipelines and ETL processes, enabling internal teams to leverage data for insights in a cloud environment.

You will collaborate with IT, business, and executives, contributing to data science and analytics initiatives while ensuring data integrity and quality at scale. Hybrid work arrangement offered to balance in-person collaboration.