Lead- Data Operations/ Data Architect

Location

Detroit MI – Onsite

Duration

Long Term

Skills

Databricks – Must

Database : Oracle PL/SQL - Must

ETL: ODI OR any ETL tool - Must

Reporting : Webfocus/Tableau / Power BI – Must

Domain : P&C insurance – Must

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.

Location

Detroit MI – Onsite

Duration

Long Term

Skills

Databricks – Must

Database : Oracle PL/SQL - Must

ETL: ODI OR any ETL tool - Must

Reporting : Webfocus/Tableau / Power BI – Must

Domain : P&C insurance – Must

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.