Talent.com
This job offer is not available in your country.
Business Analyst - Data Warehousing

Business Analyst - Data Warehousing

Quantum Integrators Group, LLCPune
30+ days ago
Job description

Position : Business Analyst

Location : Pune / Nagpur, Maharashtra (Onsite)

Shift Timings : US Eastern Standard Time (EST) Shift

Experience : 8+ years

About the Role :

We are seeking a highly experienced and technically proficient Business Analyst with a strong background in Data Warehousing to join our consulting team. This role is critical in bridging the gap between business needs and technical solutions, particularly within complex data environments. The ideal candidate will possess exceptional analytical skills, a deep understanding of data architecture, and the ability to translate intricate business requirements into clear, actionable technical specifications. While not mandatory, prior experience in the Pharmaceutical industry will be a significant advantage.

Key Responsibilities :

Requirements Elicitation & Analysis :

  • Lead and facilitate workshops, interviews, and meetings with business stakeholders (including executive leadership, operational teams, and end-users) to thoroughly understand and document complex business processes and data requirements for Data Warehouse and Business Intelligence initiatives.
  • Analyze existing data sources, systems, and reports to identify gaps, inconsistencies, and opportunities for data integration and enhancement.
  • Translate high-level business objectives into detailed, unambiguous, and testable functional and non-functional requirements.

Documentation & Modeling :

  • Develop comprehensive documentation, including Business Requirements Documents (BRDs), Functional Specification Documents (FSDs), Use Cases, User Stories, Process Flows, Data Flow Diagrams (DFDs), and Data Models (conceptual, logical).
  • Create source-to-target mappings and data transformation rules, collaborating closely with data architects and ETL developers.
  • Maintain and manage requirements traceability throughout the project lifecycle.
  • Data Analysis & Solution Design :

  • Perform in-depth data analysis using SQL to explore data, validate assumptions, identify data quality issues, and support data profiling efforts.
  • Collaborate with technical teams (ETL developers, data architects, BI developers) to design optimal data warehouse solutions, ensuring scalability, performance, and data integrity.
  • Propose innovative solutions to complex data challenges, aligning with industry best practices and client strategic goals.
  • Stakeholder Communication & Management :

  • Act as the primary liaison between business users and technical development teams, ensuring clear communication and mutual understanding of requirements and technical constraints.
  • Present findings, recommendations, and solution designs to stakeholders at various levels, adapting communication style to the audience.
  • Manage stakeholder expectations and facilitate consensus on requirements and scope.
  • Quality Assurance & Support :

  • Develop and execute User Acceptance Testing (UAT) plans and test cases, coordinating UAT activities with business users.
  • Support testing efforts by clarifying requirements, analyzing defects, and assisting in defect resolution.
  • Provide post-implementation support and training as needed.
  • Project Lifecycle Contribution :

  • Contribute to project planning, scope definition, risk assessment, and change management processes.
  • Work effectively in Agile / Scrum or Waterfall methodologies as required by the project.
  • Required Technical Skills :

  • Extensive Data Warehousing Expertise : Proven experience with Data Warehousing concepts, Kimball methodologies (Dimensional Modeling, Star / Snowflake schemas), and Data Mart design.
  • SQL Proficiency : Advanced SQL skills for data querying, analysis, profiling, and validation across large datasets.
  • ETL Concepts : Strong understanding of ETL (Extract, Transform, Load) processes and tools.
  • Business Intelligence Tools : Familiarity with leading BI and reporting tools (e.g., Tableau, Power BI, QlikView, Cognos, BusinessObjects).
  • Data Governance & Quality : Understanding of data governance principles, data quality frameworks, and master data management (MDM) concepts.
  • Cloud Data Platforms (Advantageous) : Exposure to cloud-based data platforms (e.g., AWS Redshift, Azure Synapse, Google BigQuery) is a plus.
  • Preferred Domain Experience :

  • Data Warehouse Experience (Mandatory) : Minimum of 8 years of dedicated experience as a Business Analyst on Data Warehouse, Business Intelligence, or large-scale data integration projects.
  • Pharmaceutical Industry Experience (Advantageous) : Prior experience working within the Pharmaceutical sector, understanding its data complexities, regulatory requirements (e.g., GxP, FDA), and common business processes (e.g., clinical trials, R&D, manufacturing, sales & marketing data).
  • Qualifications :

  • Bachelor's degree in Computer Science, Information Technology, Business Administration, or a related field. Master's degree preferred.
  • 8+ years of progressive experience as a Business Analyst, with a significant focus on Data Warehousing projects.
  • Key Attributes & Soft Skills :

  • Exceptional Analytical and Problem-Solving Skills : Ability to dissect complex problems, identify root causes, and propose effective solutions.
  • Superior Communication Skills : Excellent verbal and written communication, presentation, and interpersonal skills, with the ability to articulate complex technical concepts to non-technical audiences and vice-versa.
  • Stakeholder Management : Proven ability to build strong relationships, influence, and negotiate with diverse stakeholders.
  • Detail-Oriented : Meticulous attention to detail in requirements gathering, documentation, and data analysis.
  • Proactive & Self-Motivated : Ability to work independently and as part of a team in a fast-paced, client-facing environment.
  • Adaptability : Comfortable working in a dynamic consulting environment with varying client needs and project scopes.
  • (ref : hirist.tech)

    Create a job alert for this search

    Data Data • Pune

    Related jobs
    • Promoted
    Business Data Analyst

    Business Data Analyst

    Regal RexnordChakan, Maharashtra, India
    Maintenance of the Backend system and modeling of the background data structure in collaboration with team members and corporate IT. Ensure stable operation of the ERP and CRM datasets.Maintenance a...Show moreLast updated: 5 days ago
    • Promoted
    Technical Business Analyst- Atlassian Products

    Technical Business Analyst- Atlassian Products

    ZendeskPune, Maharashtra, India
    Zendesk builds software for better customer relationships.It empowers organizations to improve customer engagement and better understand their customers. Zendesk products are easy to use and impleme...Show moreLast updated: 12 days ago
    • Promoted
    Business Analyst

    Business Analyst

    Tata Consultancy ServicesPune, Maharashtra, India
    Conduct workshops and interviews with Japanese speaking business users to document requirements and pain points.Analyze and document business processes and workflows for Life insurance products.Tra...Show moreLast updated: 2 days ago
    • Promoted
    Amazatic - Business / Data Analyst

    Amazatic - Business / Data Analyst

    AMAZATIC SOLUTIONS LLPPune
    Principal Accountabilities and Responsibilities : - Responsible for requirements gathering, documentation of solution design, documenting and executing test scenarios...Show moreLast updated: 10 days ago
    • Promoted
    Business Analyst

    Business Analyst

    PeoplefyPune, Maharashtra, India
    Greetings from Peoplefy!!!! We are looking for an experienced Business Analyst to join our team in Pune.Role : Business Analyst Experience : 8–12 Years Location : Pune Notice Period : Immediate Joi...Show moreLast updated: 25 days ago
    • Promoted
    Remote Business Analyst - 45430

    Remote Business Analyst - 45430

    TuringPune, Maharashtra, India
    Remote
    You’ll combine leadership, quality oversight, and subject expertise in MBA-relevant domains to ensure outputs are accurate, logically sound, and aligned with project goals.This role is ideal for so...Show moreLast updated: 1 day ago
    • Promoted
    Business Analyst

    Business Analyst

    Simplify HealthcarePune, Maharashtra, India
    Business Analyst Looking for an immediate joiner (0 to 15 days) Responsibilities • Assist the Product Solution Lead / Manager in driving the implementation • Understand and analyse client requir...Show moreLast updated: 30+ days ago
    • Promoted
    Business Analyst ServiceNow Order Management and Data

    Business Analyst ServiceNow Order Management and Data

    DecskillPune, IN
    Decskill, founded in 2014 as an IT Consulting Company, places paramount importance on its greatest asset : its people.Our main mission is to deliver value through knowledge and talent, and we achiev...Show moreLast updated: 24 days ago
    • Promoted
    APM Data Integration Analyst

    APM Data Integration Analyst

    TribolaTech IncPune, IN
    Title - APM Data Integration Analyst.This role ensures data integrity, integration, and governance across the APM ecosystem. The Data Integration Analyst will manage application metadata completenes...Show moreLast updated: 14 days ago
    • Promoted
    Business Analyst

    Business Analyst

    HCLTechPune, Maharashtra, India
    IFRS CTO organization, driving the development and deployment of GenAI-powered solutions through techno-functional expertise. This role requires a strong analytical mindset, proficiency in financial...Show moreLast updated: 30+ days ago
    • Promoted
    Business Analyst (IoT)

    Business Analyst (IoT)

    TEKsystemsPune, Maharashtra, India
    Hiring for Embedded BA (from IoT background only).Works with multiple stakeholders to assess impact of proposed solutions, facilitate deployments and support organizational change management.Acts a...Show moreLast updated: 5 days ago
    • Promoted
    Tech Business Analyst

    Tech Business Analyst

    Tata Consultancy ServicesPune, Maharashtra, India
    Greetings from TATA CONSULTANCY SERVICES!.Skill : ReactJS, Redux, HTML5, CSS3, LESS, JavaScript, jQuery, AngularJS, Angular 2+, Bootstrap. Years of Experience : 8 - 14 years.Location : Pune / Mumbai / Ch...Show moreLast updated: 11 days ago
    • Promoted
    Business Analyst

    Business Analyst

    Crescendo Global Leadership Hiring India Pvt LtdPune
    Mandate key skills : - Combination of core BSA skills such as Requirement gathering - Data...Show moreLast updated: 16 days ago
    • Promoted
    Spotnana - Business Analyst

    Spotnana - Business Analyst

    SpotnanaPune, India
    About The Role : Were looking for a dynamic Business Analyst with hands-on experience in the IT Software Services industry. The ideal candidate should be skilled in gat...Show moreLast updated: 30+ days ago
    • Promoted
    Workday Data Analyst

    Workday Data Analyst

    Insight GlobalPune, IN
    We are building a centralized Data Lake that will simplify and automate information delivery— further providing advanced insights and analysis to support decision making. To date, the team has launc...Show moreLast updated: 2 days ago
    • Promoted
    Business Analyst ( Fintech )

    Business Analyst ( Fintech )

    VettioPune, Maharashtra, India
    The Business Analyst will work closely with the Business Intelligence (BI) Manager to gather, analyze, and transform business data into actionable insights that inform decision-making and drive bus...Show moreLast updated: 5 days ago
    • Promoted
    Evolent Health - Business Analyst - Enterprise Applications

    Evolent Health - Business Analyst - Enterprise Applications

    Evolent HealthPune
    Your Future Evolves Here : Evolent Health has a bold mission to change the health of the nation by changing the way health care is delivere...Show moreLast updated: 5 days ago
    • Promoted
    Business Analyst

    Business Analyst

    Zensar TechnologiesPune, Maharashtra, India
    We are seeking a Senior Business Analyst with substantial experience in the UK banking and financial services sector.The successful candidate will play a key role in bridging business and technolog...Show moreLast updated: 30+ days ago