Data Engineer II

Data Engineer II

Helping careers take flight. Reshaping an industry. Enable your career to be Made on Duck Creek.

Duck Creek is an insurance industry leader, driving transformation and delivering modern SaaS solutions that help insurers set a new standard and revolutionize how consumers interact with insurance companies.

As a leading technology provider to the insurance industry, we don't just build great software to help insurers conduct business. We deliver software with a fully managed service model that empowers insurance companies to transform their business. With Duck Creek OnDemand, insurers are introducing groundbreaking new products faster than ever before, making smarter data-driven decisions, enhancing the customer experience to meet evolving expectations, and adapting to shifting market conditions and regulatory requirements.

Duck Creek is proud to be a Remote-First employer, empowering our employees with the choice to work from an office, from home or on a hybrid schedule. Our remote-first environment fosters inclusion, collaboration, and ensures consistent employee experience regardless of location. We support our employees in making a decision that allows them to be the most productive, they can be both at work and at home.

If working in a fast paced, rapidly evolving company that is transforming one of the world's oldest and largest industries into a standard for innovation and open exchange sounds exciting, let us know. We are excited for your career to be Made on Duck Creek.

Key Responsibilities:

• Designs, codes, and/or configures solutions for moderate complexity Agile stories, with little guidance from senior software engineers.
• Debugs and resolves moderate complexity software bugs or issues, working independently, and finds the real root cause and provide a fix without collateral damage.
• Creates a conceptual design/architecture for small scale software solutions with guidance from an architect or more senior software engineer.
• Provides guidance and mentoring to more junior software engineers.
• Follows development standards and effectively demonstrates technical solutions to other software engineers in code reviews.
• Design, implement, and manage scalable data pipelines and ETL/ELT processes using Snowflake and related technologies.
• Develop and optimize complex SQL queries and data models to support business intelligence and analytics requirements.
• Work closely with data architects, analysts, and other stakeholders to understand business requirements and deliver effective data solutions.
• Ensure data quality, integrity, and security across all data platforms and pipelines.
• Perform data migration, integration, and transformation tasks from various sources into Snowflake.
• Troubleshoot and resolve issues related to data loads, performance, and data availability.
• Document data processes, technical specifications, and best practices.
• Stay updated on cloud native SaaS architecture and industry trends, recommending improvements and new technologies as appropriate.

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

Education and Work Experience:

Bachelor's degree, or higher education level, or its foreign equivalent, in Computer Science, Computer Information Sciences, and/or related field

Total Work Experience: 10+ years (software development), 6 years minimum

Product Experience: 4 years minimum, 6+ years preferred

Domain Experience: 4 years minimum, 6+ years preferred

Specialized Knowledge, Skills, and/or Abilities:

• Experience with cloud networking architectures and understanding of devops industry best practices (e.g. Azure Infrastructure, Private Connectivity, Azure DevOps Services, CI/CD pipeline, Terraform on Azure).
• Experience with other cloud data technologies (e.g., Snowflake, SQL Azure Data Factory, Azure Storage) is a plus.
• Knowledge of data governance, security, and compliance best practices.
• Familiarity with DevOps practices and CI/CD pipelines for data engineering.
• Experience with version control systems (e.g., Git).
• Knowledge in Duck Creek Policy or Billing or Claims or Party or Clarity is a plus.
• Understands how the Duck Creek Suite operates with an understanding of all the applications.
• Excels in managing deadlines, communicating in a team, and operating independently with guidance.
• Expert in how to estimate, analyze, and the Software Product Development Lifecycle with Agile methodology.
• Excels in Insurance domain knowledge.

Other Requirements:

Travel: 0-10%

Work Authorization: Legally authorized to work in the country of the job location.

Physical: Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

What We Stand For:

Our global company celebrates & leverages the differences each employee brings to the table. Our success is a direct result of an inclusive culture where opportunities to learn from one another occur regardless of title, seniority, or background. This collaborative and team-oriented approach is at the core of how we operate and continuously improve our products, services, and systems. As such, Duck Creek is committed to providing equal opportunity to all employees and applicants to recruit, hire, train, and reward employees for their individual abilities, achievements, and experience without regard to race, color, gender, religion, sexual orientation, age, national origin, disability, marital, military, or any other protected status.

We strive to be an example to the world of inclusion, diversity, and equity in all things where employees are free to be their authentic selves in the workplace and in the communities in which we live. We believe in leading by example and are proud of the diversity of our team and our shared commitment to our Core Values: We Prioritize Respect; We Listen; We Care; We Add Value; and We Lead.

---