The Guidewire Data Engineer will design schemas in Snowflake, develop ETL processes, optimize SQL queries, and integrate Guidewire with data platforms.
Company Description
Describe what makes your company great
Job DescriptionKey Responsibilities:
Snowflake Expertise:
- Design and develop schemas and data models within the Snowflake platform.
- Write and optimize complex SQL queries for data extraction and transformation.
Guidewire Claims Center:
- Apply hands-on experience with Guidewire Claims Center to support claims management workflows.
- Integrate Guidewire with data platforms to enable seamless data exchange.
ETL/ELT Processes:
- Utilize ETL/ELT tools (e.g., Apache Nifi, Talend, dbt) to design and execute efficient data transformation and loading processes.
Data Warehousing:
- Build and optimize cloud-based data warehouses for scalable storage and analytics.
SQL and Data Querying:
- Write advanced SQL queries for data aggregation, reporting, and analysis.
Cloud & Data Integration:
- Leverage cloud platforms (AWS, Azure, GCP) to enable system connectivity and data synchronization.
All your information will be kept confidential according to EEO guidelines.
Similar Jobs
Big Data • Fintech • Mobile • Payments • Financial Services
Lead Affirm’s enterprise AI security review program, threat-model AI and LLM applications, assess agentic systems and tool permissions, and design automated guardrails, controls, monitoring, and policy-as-code. Review code, prompts, configurations, vendors, and SaaS AI capabilities; develop testing and red-team scenarios; identify emerging vulnerabilities; support incident response; and lead cross-functional initiatives across Security, Engineering, Legal, Privacy, and Compliance.
Top Skills:
AnthropicAWSCasbGitGoogle WorkspaceInfrastructure As CodeJIRAKubernetesMcpMitre AtlasNotionOauth2OktaOpenaiOwasp Top 10 For Llm ApplicationsPci DssPythonRagSAMLSlackSoc 2Terraform
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Leads Pfizer’s strategic technology initiatives across eight Digital Core Platforms, aligning enterprise architecture, AI programs, reuse, governance, and delivery. Oversees Senior Technical Architects, sets portfolio priorities, resolves cross-program trade-offs, advises executive stakeholders, and develops senior technical talent. Establishes responsible AI-enabled delivery practices and ensures reliability, security, documentation, operational excellence, and measurable outcomes across a complex global technology portfolio.
Top Skills:
Artificial IntelligenceAutomationCloud PlatformsCybersecurityData IntegrationEnterprise ArchitectureModern Engineering PracticesReliability Engineering
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Leads business technology strategy across Pfizer divisions, aligning divisional programs and projects with enterprise digital platforms, architecture standards, security, and governance. Serves as the primary business-Digital liaison, chairs or co-leads architecture reviews, resolves cross-division technology trade-offs, and oversees Director-level technical specialists. The role establishes technology direction, promotes platform reuse, assures delivery and operational excellence, advises senior leaders, and develops technical talent in a global, regulated enterprise.
Top Skills:
Artificial IntelligenceCloud PlatformsCybersecurityData IntegrationDigital PlatformsEnterprise ArchitectureTechnology Governance
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
