Data Operations Manager/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.