Tech Lead, Data Analyst, Data Engineer

Tech Lead Job Description

• Develop and maintain Cognos Framework Manager models, including data sources, query subjects, dimensions, and measure structures.
• Build relational and dimensional (DMR) models optimized for self service reporting.
• Collaborate with data architects, ETL teams, and business analysts to understand data structures and reporting requirements.
• Design and implement star/snowflake schemas, hierarchies, and business friendly views.
• Optimize model performance with proper indexing, query tuning, and caching strategies.
• Ensure data consistency, security rules, and governance across all published reporting packages.
• Publish and manage Cognos packages for enterprise reporting and dashboards.
• Troubleshoot model issues, performance bottlenecks, and lineage discrepancies.
• Work closely with QA and reporting teams to validate report accuracy and data integrity.
• Document FM models, data mappings, and best practices for ongoing maintenance.

• 5+ years of hands on experience in IBM Cognos Framework Manager.
• Strong understanding of data modeling (OLTP — OLAP transformation).
• Proficient in star/snowflake schema design and dimensional modeling principles.
• Solid SQL skills (Oracle, SQL Server, or similar).
• Experience creating DMR models and building advanced calculations.
• Strong troubleshooting skills for complex joins, cardinality, and query execution.
• Familiarity with Cognos Analytics reporting tools is a plus.
• Ability to work in Agile environments and interact with business stakeholders.

• Experience with Property & Casualty (P&C) Insurance.
• Exposure to ETL tools (SSIS, BODS, etc.).
• Knowledge of Data Warehousing concepts and BI architecture.
• Experience with Guidewire Data Hub or other enterprise data platforms.

“Tech Mahindra is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin, or disability. All applicants will be evaluated solely based on their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations.

Reasonable accommodation also is available in the hiring process for applicants with disabilities. Candidates can request a reasonable accommodation by contacting the company ADA Coordinator at ADA_A