Senior Data Business Analyst

We are looking for a highly skilled Data Business Analyst with strong expertise in SQL, Data Warehousing concepts, ETL processes, Data Modeling, and Data Mapping.

The ideal candidate will work closely with business stakeholders, data engineers, and product teams to translate business requirements into effective data solutions. Experience with cloud-based data platforms is an added advantage.

Responsibilities

• Collaborate with business stakeholders to gather, analyze, and document data requirements
• Translate business needs into functional specifications, data models, and process flows
• Perform deep-dive data analysis using advanced SQL queries
• Work with ETL and data engineering teams to ensure accurate data pipelines and transformations
• Support Data Warehousing initiatives, including data modeling (conceptual, logical, and physical)
• Develop and maintain data mapping documents and source-to-target (S2T) specifications
• Perform data validation, profiling, and quality checks to ensure data accuracy
• Assist in defining KPIs, building dashboards, and supporting reporting needs
• Communicate findings and insights to technical and non-technical stakeholders
• Work with cloud data services (AWS/Azure/GCP) for data ingestion, storage, and processing (nice to have)

Requirements

• 5+ years of experience
• Strong SQL skills with the ability to write complex queries
• Solid understanding of Data Warehousing concepts
• Hands-on experience with ETL processes and data transformation logic
• Good knowledge of Data Modeling (dimensional & relational)
• Experience in Data Mapping and documenting S2T specifications
• Strong analytical and problem-solving skills
• Excellent communication and documentation abilities

Nice to have

• Exposure to cloud data platforms like:
• AWS: Redshift, Glue, Athena, S3
• Azure: Synapse, Data Factory, Databricks
• GCP: BigQuery, Dataflow, Pub/Sub
• Experience with BI/reporting tools (Tableau, Power BI, Looker)
• Basic understanding of data governance and metadata management