Data Operations Lead/ Data Architect

Job Title: Lead- Data Operations/ Data Architect  

Location : Detroit MI – Onsite

Long Term

Key Responsibilities

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

Desired Skills & Experience, Core Domain Experience

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