Data Operations Lead/ Data Architect

Cyma Systems Inc
Detroit, United States of America
14 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Detroit, United States of America

Tech stack

Amazon Web Services (AWS)
Amazon Web Services (AWS)
Business Analytics Applications
Data analysis
Cloud Computing
Computer Programming
Databases
Information Engineering
Data Governance
Data Infrastructure
Data Integration
ETL
Data Systems
Data Warehousing
Dimensional Modeling
Distributed Data Store
IT Management
Machine Learning
NoSQL
Oracle Data Service Integrator
Oracle SQL Developer
Performance Tuning
Query Optimization
Power BI
Cloud Services
SQL Stored Procedures
Data Streaming
Tableau
Snowflake
Information Technology
Data Analytics
WebFOCUS
Kafka
Data Management
Tools for Reporting
Stream Processing
Confluent
Databricks

Job description

  • Partner with customers to position data as a strategic business asset, enabling them to differentiate through modern data platforms, BI, and advanced analytics solutions.

  • Engage with business stakeholders, IT leadership, and enterprise architects to design and implement scalable, cloud-native data architectures, with a strong focus on AWS-based solutions.

  • Define and drive enterprise data strategies and technology roadmaps, including architecture design, data modeling, and stepwise execution of modern data platforms supporting diverse analytics use cases.

  • Lead Data & Analytics maturity assessments and strategy workshops, ensuring alignment with business goals around performance, scalability, flexibility, and cost optimization.

  • Provide thought leadership on modern data and analytics technologies, enabling innovation in BI, advanced analytics, and predictive modeling.

  • Design, prototype, and deliver end-to-end cloud data solutions, enabling new digital capabilities, especially in the Property & Casualty (P&C) Insurance domain.

  • Act as a trusted technology advisor, driving adoption of modern data solutions to help organizations become data-driven enterprises.

  • Evaluate customer cloud readiness and AWS adoption maturity; design and deliver structured capability-building and enablement programs.

  • Collaborate with cross-functional teams including Data Engineering, Data Governance, BI/Analytics, and Business teams in complex enterprise environments.

Requirements

  • 15+ years of IT experience, including 4+ years in architecting and delivering cloud-native data solutions.

  • Minimum 4+ years of hands-on experience in the Commercial P&C Insurance domain (mandatory).

  • Strong expertise in implementing end-to-end Modern Data Platforms on AWS, using advanced processing frameworks such as Databricks.

Technical Skills

Data Platforms & Cloud

  • Deep understanding of cloud-native data architectures, data engineering pipelines, and data management frameworks.

  • Hands-on experience with AWS services (e.g., S3, Redshift, Glue, Lambda, EMR, Athena).

  • Expertise in data warehouse design, dimensional modelling, and columnar database architectures.

  • Experience with Snowflake and other modern data warehousing platforms.

Database & Programming (Mandatory)

  • Strong hands-on expertise in Oracle PL/SQL (must-have) including performance tuning, complex query optimization, and stored procedure development.

  • Experience working with relational and distributed databases across enterprise environments.

ETL / ELT & Data Integration

  • Strong knowledge of ETL/ELT concepts and tools, including:

  • Oracle Data Integrator (ODI) - preferred

  • Experience with modern ETL frameworks and pipelines

  • Exposure to streaming and real-time data processing, including technologies like Kafka (Confluent).

BI & Reporting

  • Hands-on experience with BI and reporting tools, with preference for:

  • WebFOCUS (added advantage)

  • Other BI tools such as Tableau / Power BI

  • Ability to translate business requirements into actionable dashboards and analytics solutions.

Advanced & Emerging Capabilities (Good to have)

  • Exposure to NoSQL databases (key-value stores, document databases) and understanding of performance trade-offs.

  • Experience in building data products, Data Mesh architecture, and decentralized data ownership models.

  • Knowledge of machine learning and analytics solutions, including deployment using AWS SageMaker (preferred).

Insurance Domain Skills (Mandatory)

  • Strong understanding of P&C Insurance business processes, including:

  • Policy Administration

  • Underwriting

  • Claims Management

  • Billing & Payments

  • Experience working with insurance data models, regulatory reporting, and actuarial/analytics use cases.

  • Ability to align data solutions with insurance-specific KPIs, risk modeling, and compliance requirements.

Apply for this position