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

We are seeking a Senior Data Business Analyst to lead our data analysis and business analysis efforts.

You will work closely with stakeholders to gather requirements and develop data models, supporting our data migration and reporting projects. Join us to leverage your expertise in SQL, Power BI, and data profiling to drive impactful business insights.

Responsibilities

- Gather and document business and technical requirements
- Perform data source profiling and assess data quality
- Develop data models and design Power BI report models
- Collaborate with technical teams to support the build and implementation of the Snowflake platform
- Participate in data migration from on-premise systems to AWS Snowflake
- Support testing and validation of data solutions
- Engage stakeholders to ensure alignment and clarity on project goals
- Analyze business processes to identify opportunities for improvement
- Coordinate with cross-functional teams to deliver data-driven solutions
- Monitor and report on data quality and integrity
- Prepare detailed documentation and reports for clients and internal teams
- Advise on best practices in data governance and quality
- Provide training and support to junior analysts as needed

Requirements

- 5+ years of experience in Data Analysis and Business Analysis
- Solid skills in requirement gathering and stakeholder engagement
- Proficiency in SQL
- Experience with data source profiling and data modeling
- Hands-on experience in Power BI report modeling
- Familiarity with Snowflake and AWS
- Excellent analytical and problem-solving skills
- Strong communication and interpersonal skills
- Ability to work independently and within a team
- Attention to detail and accuracy in data handling
- Project management experience
- Adaptability to changing priorities and environments

Nice to have

- Experience with ETL/ELT processes and data integration tools
- Knowledge of data governance and quality best practices

📌 Senior Data Business Analyst (Gurugram)
🏢 EPAM Systems
📍 Gurugram