19 Aug
|
CCL Products
|
Hyderabad
19 Aug
CCL Products
Hyderabad
- Extract from Source Systems Pull data daily from PostgreSQL databases hosted on AWS (RDS/Aurora) and Oracle NetSuite ERP/CRM, ensuring complete and reliable ingestion.
- Load into Azure Data Lake Land extracted datasets into Azure Data Lake Storage (ADLS Gen2), organizing data by source, frequency, and business domain using a structured folder hierarchy.
- Transform & Prepare Data — Cleanse, normalize, and model raw data within the lake to create analysis-ready datasets suitable for reporting and ad-hoc exploration.
- Build & Maintain Dashboards — Design, develop, and optimize interactive Power BI reports and dashboards that surface insights from the consolidated data lake to stakeholders at all levels.
- Manage Daily Pipelines — Monitor and maintain daily extraction schedules, troubleshoot failures, and ensure data freshness SLAs are consistently met.
- Ensure Data Quality — Implement validation checks across the extraction and transformation layers to maintain trust and accuracy in reporting outputs.
- Collaborate Cross-Functionally — Partner with engineering, finance, operations, and leadership teams to translate business questions into analytical frameworks.
- Document & Standardize — Maintain transparent documentation of extraction logic, data models, DAX measures, report definitions, and data lineage across all source systems.
- Experience with Python or R for statistical analysis or automation.
- Familiarity with Azure Synapse Analytics or Databricks for advanced transformation.
- Exposure to version control (Git) for analytics workflows.
- Knowledge of data governance frameworks and cataloging tools.
- Experience with NetSuite SuiteQL or SuiteScript for advanced data extraction.
📌 Data Analyst (Hyderabad)
🏢 CCL Products
📍 Hyderabad