Overview
Skills
Job Details
Role name: | Analyst |
Role Description: | Conduct data profiling and quality assessments using SQL Developer, TOAD for Oracle, DBeaver, and Erwin.Extract, clean, and transform data from various sources to support business intelligence and reporting needs.Analyze large datasets to uncover trends, anomalies, and actionable insights.Write and optimize complex SQL queries for data analysis and reporting.Work with AWS S3 for data storage and retrieval; use AWS Athena for querying large datasets.Compare datasets using tools such as Beyond Compare or similar utilities.Create and maintain detailed data mapping documents; collaborate with ETL teams to clarify requirements.Participate in the Amigo process to communicate Data Analyst requirements to build teams.Translate business requirements into technical specifications in collaboration with business stakeholders.Collaborate with cross-functional teams to gather, understand, and deliver on data requirements.Document data definitions, relationships, and data flows to support data governance and transparency.Present analytical findings and recommendations to stakeholders in a clear, concise, and actionable manner. |
Competencies: | Data Concepts & Data Modelling, PL/SQL, Insurance - Property & Casualty Insurance |
Experience (Years): | 6-8 |
Essential Skills: | ighly skilled and detail-oriented Data Analyst to join our team. The ideal candidate will have hands-on experience in data profiling, analysis, and data modeling, with strong proficiency in SQL and familiarity with tools such as SQL Developer, TOAD for Oracle, DBeaver, and Erwin. The role requires experience in building data mapping requirements and effectively handing them off to build teams. A solid understanding of AWS services, particularly S3 and Athena, is essential. |
Desirable Skills: | Databricks, AWS, Snowflake |
Country: | United States |
Branch | City | Location: | TCS - Cincinnati, OH |