Data Analyst

• PDF & Document Data Extraction: Lead the extraction and post-processing of structured financial data from PDF, HTML, and scanned documents, applying OCR tooling and validation logic to ensure accuracy and consistency at scale.
• Data Extraction and Standardization: Lead initiatives to extract and standardise financial data from various formats, including XBRL and iXBRL, ensuring data accuracy and consistency.
• Mentorship and Development: Provide guidance and support to junior analysts, fostering their growth in data analysis, programming, and statistical methodologies.
• Exploratory Data Analysis: Conduct exploratory data analysis to identify trends, raise important questions, and derive actionable insights.
• Data Model Development: Design, implement and optimise conceptual, logical and physical data models for enterprise-scale data products. Develop and maintain data models using ERD diagrams and manage the data dictionaries for transactional, star and flat schemas.
• Data Model Democratization: Partner with data engineering teams to democratise the data model for designing efficient data pipelines.
• Data Modelling Standards: Define and enforce data modelling standards and best practices. Conduct data analysis to validate modelling standard compliance, model accuracy, identify anomalies, and ensure data quality.
• Data Classification and Taxonomies: Design custom taxonomies and reference data classification methods/structures.
• Programming and Automation: Utilise Python (primary), SQL, Regex, and Shell Scripts for data manipulation, analysis, and automation of processes, including meta-programming and dynamic code generation.
• Database Management: Manage and optimise databases (SQL Server, Neo4j, Snowflake, Postgres), understanding join types, aggregate functions, and data storage formats (Parquet, AVRO, Delta).
• Collaboration: Collaborate with product managers, data engineers, and analysts to translate business requirements into robust data structures. Work closely with cross-functional teams to address data quality issues and implement effective solutions.

• XBRL / iXBRL: Familiarity with XBRL and iXBRL financial reporting standards and tooling for parsing and validating tagged financial data is preferred.
• Advanced Data Modelling Techniques: Experience with advanced modelling approaches.
• Business Analysis Expertise: Ability to bridge the gap between technical and business requirements.
• Project Management: Skills in managing projects, timelines, and deliverables.
• Data Visualization Tools: Proficiency with tools such as Tableau, Power BI, or similar.
• OCR / document extraction tooling: Experience with PDF text extraction libraries (pdfplumber, PyMuPDF, Tesseract OCR) is a strong advantage., * Bachelor’s degree in Computer Science, Information Technology, or equivalent.
• 5+ years of experience in data management., * Highly skilled in data modelling: Experience developing data models from scratch for green field projects in multiple domains. Deep understanding of data warehousing concepts, dimensional modelling, and normalisation/denormalisation techniques. Expertise in tools such as Erwin Data Modeler, PowerDesigner, or similar.
• Python programming (required): Proficient in Python for data manipulation, automation, and scripting. Comfortable with core OOP concepts (classes, inheritance, encapsulation) at a working level. Experience with pandas, regex, and API-based data extraction.
• Knowledge of data products: Strong understanding of data product design principles and lifecycle.
• Strong SQL skills and experience with relational (e.g., Oracle, SQL Server, PostgreSQL) and cloud databases (e.g., Snowflake, BigQuery, Redshift).
• Good understanding of Azure cloud data services (Data Lake, Azure SQL).
• Problem-Solving: Adept at tackling complex issues and finding effective solutions.
• Curiosity and Self-Starter: Always eager to learn and take initiative without needing constant guidance.
• Comfortable with Ambiguity: Capable of working efficiently even when the answers are not immediately clear.
• Effective Communication: Excellent at conveying complex ideas and collaborating with stakeholders.
• Experience with Databases and Data Formats: Familiar with various databases, operating systems, file types, and data formats.

Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.

Hexaware provides access to a vast array of tools that enhance, revolutionize, and advance professional profile. We complete the circle with excellent growth opportunities, chances to collaborate with highly visible customers, chances to work alongside bright brains, and the perfect work-life balance.

With an ever-expanding portfolio of capabilities, we delve deep into and identify the source of our motivation. Although technology is at the core of our solutions, it is still the people and their passion that fuel Hexaware’s commitment towards creating smiles.

“At Hexaware we encourage to challenge oneself to achieve full potential and propel growth. We trust and empower to disrupt the status quo and innovate for a better future. We encourage an open and inspiring culture that fosters learning and brings talented, passionate, and caring people together.”

We are always interested in, and want to support, the professional and personal you. We offer a wide array of programs to help expand skills and supercharge careers. We help discover passion-the driving force that makes one smile and innovate, create, and make a difference every day.