About the job

• Core Responsibilities:Design, develop, test, deploy, and maintain robust ETL/ELT pipelines that ingest and transform structured and unstructured data from multiple internal and external sources.
• Build, enhance, and optimize data warehouses, data lakes, data marts, and analytical data models using dimensional modeling and appropriate architecture patterns.
• Develop and maintain BI dashboards, reports, semantic models, KPIs, and visualizations that support operational monitoring, management reporting, and strategic analysis.
• Write, review, and optimize complex SQL queries, stored procedures, data transformations, and database objects to achieve reliable and efficient processing.
• Implement automated data validation, reconciliation, quality checks, exception handling, logging, monitoring, and alerting across data workflows.
• Ensure data accuracy, completeness, consistency, lineage, security, performance, availability, and scalability in accordance with organizational standards.
• Monitor, troubleshoot, tune, and resolve failures or performance bottlenecks in pipelines, databases, data models, reports, and BI platforms.
• Work with business stakeholders to elicit, analyze, document, and translate reporting and analytics requirements into practical technical solutions.
• Collaborate with data architects, database administrators, analysts, application teams, information-security teams, and vendors to integrate and deliver data products.
• Apply source control, release management, CI/CD, testing, documentation, and change-management practices to data engineering and BI deliverables.
• Prepare and maintain technical documentation, including source-to-target mappings, data dictionaries, architecture diagrams, operating procedures, and support guides.
• Support data governance, metadata management, access control, privacy, retention, audit, and compliance requirements.