Role description
Lead Data Analyst
- Location: United States, Eastern Time Zone
Mandatory Skills
- Property and Casualty (P&C) insurance domain knowledge, preferably including billing and payments.
Primary Technical Skills
- Advanced SQL for data extraction, transformation, validation, and analysis.
- Hands-on experience with Snowflake, Teradata, Oracle, or comparable database platforms.
- Strong P&C insurance knowledge, preferably covering billing and payments.
- Experience in data analysis, validation, reconciliation, quality assessment, and source-to-target mapping.
- Strong understanding of data warehousing and modeling concepts, including facts, dimensions, joins, ETL/ELT, data marts, and reporting.
- Ability to interpret business requirements and independently translate them into data and SQL solutions.
- Expertise in trend analysis and the generation of actionable business insights.
- Experience gathering requirements and performing business analysis.
- Ability to define KPIs, metrics, and reporting frameworks.
- Experience working with large-scale enterprise datasets.
- Advanced Excel skills for analytical reporting and ad hoc analysis.
- Effective use of AI tools to improve productivity and support day-to-day analytical activities.
Preferred Technical Skills
- MicroStrategy dashboard development, reporting, and data visualization.
- Python for data analysis and automation.
- ETL and data-integration concepts.
- Experience with dbt, Databricks, and Azure or AWS.
- Data modeling, metadata management, schema design, and performance optimization.
- Strong experience creating conceptual, logical, and physical data models.
- Insurance data and reporting.
- Agile and Scrum methodologies.
- Statistical analysis and forecasting techniques.
Key Responsibilities
- Partner with business stakeholders to define analytical, reporting, and dashboard requirements.
- Analyze large and complex datasets to identify trends, patterns, risks, and business opportunities.
- Design, develop, and maintain interactive MicroStrategy dashboards, reports, scorecards, and visualizations that support strategic and operational decision-making.
- Contribute to data-modeling activities by defining data structures, relationships, hierarchies, and reporting layers.
- Support high-priority initiatives, including dashboard modernization, reporting enhancements, and strategic roadmap programs.
- Translate business questions into actionable, data-driven insights and recommendations.
- Define, monitor, and enhance KPIs and business metrics aligned with organizational objectives.
- Perform root-cause analysis, data validation, and reconciliation to ensure reporting accuracy and consistency.
- Prepare ad hoc analyses and executive-level presentations for critical business decisions.
- Collaborate with business, technology, and offshore teams to deliver analytical solutions within agreed timelines.
- Participate in requirements workshops, solution-design discussions, effort estimation, and prioritization activities.
- Identify opportunities for reporting automation, process improvement, and enhanced data visualization.
- Maintain documentation for business rules, metric definitions, data lineage, data models, and reporting solutions.
Professional and Domain Competencies
- Strong written and verbal communication skills for an onsite, client-facing role.
- Knowledge of insurance concepts covering policies, claims, billing, payments, and operational reporting.
- Excellent stakeholder-management and relationship-building abilities.
- Ability to gather, clarify, and document requirements from multiple stakeholders.
- Strong analytical thinking and problem-solving skills.
- Ability to build compelling data narratives and present insights to business leaders and executives.
- Experience in effort estimation, prioritization, and delivery planning.
- Ability to coordinate with offshore teams and review deliverables for quality and completeness.
- Customer-centric mindset with the ability to recommend data-driven solutions.
- Self-motivated, proactive, and capable of working independently in a fast-paced environment.
Skills
Mandatory Skills : MS Excel, Teradata-SQL
Good to Have Skills : Microstrategy, Python
Other details
Actual compensation within the range will be dependent upon the individual's skills, experience, performance and internal equity.
Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree (“LTIM”):
Benefits and Perks:
- Comprehensive Medical Plan Covering Medical, Dental, Vision
- Short Term and Long-Term Disability Coverage
- 401(k) Plan with Company match
- Life Insurance
- Vacation Time, Sick Leave, Paid Holidays
- Paid Paternity and Maternity Leave
The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.
Disclaimer: The compensation and benefits information provided herein is accurate as of the date of this posting.
LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.
Benefits
Compensation range: $120,000.00 to $130,000.00 per year
About LTM
LTM is an AI-centric global technology services company and the Business Creativity partner to the world’s largest and most disruptive enterprises. We bring human insights and intelligent systems together to help clients create greater value at the intersection of technology and domain expertise. Our capabilities span integrated operations, transformation, and business AI — enabling new ways of working, new productivity paradigms, and new roads to value. Together with over 87,000 employees across 40 countries and our global network of partners, LTM — a Larsen & Toubro company — owns business outcomes for our clients, helping them not just outperform the market, but to Outcreate it. Please also note that neither LTM nor any of its authorized recruitment agencies/partners charge any candidate registration fee or any other fees from talent (candidates) towards appearing for an interview or securing employment/internship. Candidates shall be solely responsible for verifying the credentials of any agency/consultant that claims to be working with LTM for recruitment. Please note that anyone who relies on the representations made by fraudulent employment agencies does so at their own risk, and LTM disclaims any liability in case of loss or damage suffered as a consequence of the same. Recruitment Fraud Alert - https://www.ltm.com/careers/recruitment-fraud-alert
