Data Modeler & Data Engineer
Location
United States + 1 moreAll locations: United States | Canada
Posted
16 days ago
Salary
0
Seniority
Mid Level
Job Description
Data Modeler & Data Engineer
Exavalu Solutions India Pvt Ltd
Role Description We are seeking an experienced Snowflake Data Architect / Senior Data Modeler with deep expertise in Snowflake data modeling, Guidewire data structures, and Property & Casualty (P&C) Insurance domain knowledge. The ideal candidate will be responsible for designing scalable enterprise data models, optimizing Snowflake architecture, and collaborating with cross-functional teams to build modern cloud-based data platforms. This role requires strong experience in dimensional data modeling, AWS cloud services, ELT/ETL architecture, and enterprise data governance practices. Key Responsibilities - Data Architecture & Modeling - Design and develop conceptual, logical, and physical data models for enterprise data platforms. - Create and maintain dimensional data models including Star Schema and Snowflake Schema designs. - Translate business requirements into scalable and optimized Snowflake data structures. - Design data models supporting reporting, analytics, and operational use cases. - Ensure consistency, scalability, and maintainability of enterprise data assets. - Snowflake Data Engineering & Optimization - Design Snowflake-ready schemas and optimize physical data structures. - Implement clustering keys, partitioning strategies, and materialized views to improve query performance. - Optimize Snowflake compute and storage utilization while controlling operational costs. - Support performance tuning and query optimization initiatives. - Leverage strong understanding of Guidewire data models including PolicyCenter, ClaimCenter, and BillingCenter. - Analyze and model insurance data across policy, claims, billing, underwriting, and customer domains. - Collaborate with business stakeholders to align data solutions with P&C insurance processes and requirements. - Support enterprise-wide insurance data transformation initiatives. - Collaborate with Data Engineering teams to design and implement ELT/ETL pipelines. - Support Medallion Architecture (Bronze, Silver, Gold layers) within modern data lakehouse environments. - Design data ingestion frameworks leveraging AWS services. - Ensure seamless integration between Guidewire platforms and enterprise data ecosystems. - Governance & Security - Implement enterprise data governance standards and best practices. - Enforce data quality, lineage, metadata management, and compliance policies. - Design and maintain role-based access controls (RBAC) within Snowflake. - Ensure adherence to security, regulatory, and compliance requirements. Qualifications - 8+ years of experience in Data Architecture, Data Modeling, or Data Engineering. - Strong expertise in Snowflake Data Modeling: - Conceptual Data Modeling - Logical Data Modeling - Physical Data Modeling - Dimensional Modeling - Star and Snowflake Schemas - Advanced SQL development and performance tuning experience. - Strong programming experience with: - Python - PySpark - Hands-on experience with: - Snowflake - AWS S3 - AWS Glue - AWS Lambda - Experience designing and supporting ELT/ETL pipelines. - Knowledge of Medallion Architecture and modern data lakehouse concepts. - Strong Guidewire Data Model experience. - Strong Property & Casualty (P&C) Insurance domain knowledge. - Understanding of insurance business processes including policy administration, claims management, underwriting, and billing. Benefits - Flexibility in work arrangements, including part-time work and remote options. - Welcome back program to assist individuals returning after a prolonged absence due to health or family reasons. - Commitment to building a diverse and inclusive workforce. - Welcoming applications from all qualified candidates, regardless of race, colour, gender, national or ethnic origin, age, disability, religion, sexual orientation, gender identity or any other status protected by applicable law. - Nurturing a culture that embraces all individuals and promotes diverse perspectives.
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
• Lead the migration to Microsoft Fabric. • Rebuild existing pipelines, workflows, and workspaces from our Azure environment. • Expand and scale the platform to create value for users. • Design and build ingestion for new sources, create and validate transformation code, and surface data in intuitive semantic layers. • Maintain and improve data trust. • Work in a medallion architecture. • Put engineering quality first. • Connect data to consumption. • Consider storage and lifecycle.
Data Engineer
SuperStaffComprehensive BPO, RPO, and Call Center Outsourcing Solutions for Growing Businesses
Role Description The Data Engineer will be part of the Professional Services team, working directly on customer implementations for our B2B sales intelligence platform, helping wholesale distributors get the most out of their data. This is a hands-on role where you'll build data pipelines, configure customer instances, troubleshoot data issues, and collaborate with Customer Success Managers to deliver high-quality solutions. - Data Ingestion & ETL: Build Python/SQL pipelines to ingest invoices, orders, and catalogs. - Perform historical backfills via SFTP/API and manage Airflow DAGs. - Instance Configuration: Set up custom fields, product filtering logic, and sales workflows. - Manage SSO and user provisioning for new rollouts. - AI-Augmented Engineering: Leverage AI coding assistants (Copilot, Cursor) and LLMs to accelerate Python/SQL script generation, data mapping, and debugging. Build ETL pipelines and manage Airflow DAGs. - Customer Communication & Projects: Act as a technical point of contact. Translate complex data issues into clear updates for customers. Own project milestones from kickoff to "Go Live." - Integration & Automation: Build Workato recipes and connect customer ERPs via APIs/webhooks to ensure real-time data flow. - QA & Troubleshooting: Triage HubSpot support tickets, debug data discrepancies in large data sets, and deploy production fixes. - Documentation: Maintain customer data mappings and internal technical runbooks. Qualifications - Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience). - At least 3 years of experience in data engineering, ETL, or related roles. - Strong SQL skills for data analysis and validation. - Proficiency in Python scripting for data processing. - Familiarity with cloud platforms, preferably GCP (e.g., Cloud Storage, Cloud Functions). - Understanding of REST APIs, JSON/CSV data formats, and Git workflows. - Strong communication skills with the ability to explain technical concepts to non-technical stakeholders. Requirements - Experience with workflow orchestration tools (e.g., Apache Airflow). - Familiarity with integration platforms (e.g., Workato, Zapier). - Exposure to CRM tools (e.g., HubSpot, Asana). - Knowledge of eCommerce or sales data models (e.g., products, orders, opportunities). Technical Environment - Data & Analytics: Python, SQL, BigQuery, Looker. - Pipeline & Orchestration: Airflow, GCP (Cloud Storage). - Automation & Integration: Workato, webhooks, APIs. - Infrastructure: GCP, Kubernetes, GitHub Actions. - Systems & Tools: HubSpot, Salesforce, SFTP/FTP, ERP systems. - Project Management: Asana, GitHub. Benefits - Competitive Salary: COP $6,000,000. - Stability: Indefinite contract with all mandatory Colombian legal benefits. - Flexibility: 100% Work From Home (Remote only in Colombia). - Growth: Continuous training, development programs, and clear opportunities for professional advancement. - Culture: A collaborative, supportive, and diverse international team environment.
• Map, extract, cleanse, and transform data (patients, inventory, claims, orders, payers, etc.) • Lead and manage full-cycle data migrations from legacy DME or HME systems into NikoHealth’s platform • Collaborate with implementation consultants and product teams to ensure data accuracy and integrity • Troubleshoot and resolve data discrepancies during migration
Data Engineer
DataSpringDataSpring is the trusted data connector at the core of healthcare. For more than 25 years, we have powered the industry with the largest and most complete healthcare data foundation in the U.S., including more than 4.8 million provider data records sourced directly from providers and member data representing 75% of covered lives supplied by health plans. By improving how essential information flows across the system, DataSpring helps healthcare operate more efficiently, accurately, and with greater confidence.
Role Description The Data Engineer will support the design, development, and maintenance of data pipelines and data models that power DataSpring's analytics and data platforms. This role focuses on implementing scalable data solutions, ensuring data quality, and collaborating with senior engineers and stakeholders to deliver reliable data for reporting and analysis. This position provides an opportunity to build hands-on experience with Databricks, Azure SQL, and modern data engineering practices while contributing to enterprise data initiatives and discussions. The Data Engineer is a full-time, remote, exempt position and reports to the Sr. Director, Data Engineering & Architecture. Qualifications - 1–3 years of experience in a data engineering or analytics engineering role, including internships or academic projects. - Demonstrated success contributing to data modernization or migration initiatives in cloud environments. - Prior experience working with healthcare or other regulated data environments is highly desirable. - Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field. - Azure Data Engineer Associate or related certification (preferred). - Coursework or certification in AI/ML (preferred but not required). Requirements - Build and maintain ETL/ELT pipelines across Databricks, Azure SQL, and downstream gold-layer models supporting priority projects. - Support development and enhancement of enriched data models, including field-level enrichment logic, recency rules, and provider-level enrichment flags. - Assist in maintaining data logic, including reconciliation between source and target data sources and resolution of duplication and data discrepancies. - Assist in implementing medallion architecture patterns (bronze → gold), ensuring data quality, traceability, and performance at scale. - Support identification and resolution of systemic data quality issues, including null handling, soft deletes, authorization flags, and incorrect organizational mappings. - Support implementation of rules for data in collaboration with product, governance, and engineering stakeholders. - Assist in documenting (Confluence, mapping workbooks) to serve as a single source of truth for enrichment logic and data behavior. - Support collaboration with vendors and partners for vendors providing detailed queries, validation logic, and corrective guidance on upstream data issues. - Collaborate with product owners and engineering teams to ensure data models align with product defined use cases. - Support UAT and release readiness by preparing data, validating counts, and resolving last-mile data defects under tight timelines. Benefits - Competitive compensation and a comprehensive benefits package for full-time employees. - Medical, dental, and vision coverage. - 401(k) with company contributions and matching. - Paid parental leave. - Tuition assistance. - Generous paid time off. - Commitment to investing in our people and supporting professional growth over time. Company Description DataSpring is the trusted data connector at the core of healthcare. For more than 25 years, we have powered the industry with the largest and most complete healthcare data foundation in the U.S., including more than 4.8 million provider data records sourced directly from providers and member data representing 75% of covered lives supplied by health plans. By improving how essential information flows across the system, DataSpring helps healthcare operate more efficiently, accurately, and with greater confidence.


