Sr. Business Data Analyst & Modeler

Hiring: Data Modeler

Experience: 6+ years

Location: Bangalore/Gurugram/Pune

Required Skills

• Hands-on experience in conceptual, logical, and physical data modeling.
• Strong knowledge of ER modeling, dimensional modeling, star/snowflake schemas, fact/dimension tables, and SCDs.
• Strong SQL skills for data profiling, validation, and quality checks.
• Experience with source-to-target mapping, data dictionaries, metadata, and data lineage.
• Proficiency in Erwin, ER/Studio, or similar modeling tools.
• Exposure to Snowflake, Databricks, Redshift, SQL Server, or other data platforms.
• Understanding of data governance, UAT, reconciliation, and Agile methodologies.
• Strong analytical, documentation, and stakeholder management skills.

Preferred Qualifications

• Experience in enterprise data warehousing or lakehouse modeling.
• Knowledge of data products, data contracts, quality SLAs, and reusable datasets.
• Exposure to dbt, data cataloging, metadata management, and governance tools.
• Ability to work independently in a fast-paced environment.

If interested please share your cv at : snigdhaattheratebeanhr.com

Job Title: Senior Data Engineer

Position Summary

We are seeking a highly skilled Data Engineer with strong expertise in reporting infrastructure, data modeling, and analytics platforms. This role will focus on building scalable reporting solutions, optimizing data pipelines, and enabling data-driven decision-making across the organization. The ideal candidate will have deep experience with databases, data warehousing, and complex query development. While Ruby on Rails experience is beneficial, the primary emphasis is on data engineering and reporting systems.

Key Responsibilities

• Design, develop, and maintain reporting infrastructure and data platforms.
• Build and optimize complex SQL queries, data models, and reporting datasets.
• Develop scalable ETL/ELT pipelines and data integration processes.
• Design and maintain database schemas to support analytics and reporting requirements.
• Collaborate with business stakeholders to understand reporting needs and translate them into technical solutions.
• Implement data quality, governance, and performance best practices.
• Support and enhance enterprise reporting solutions and dashboards.
• Work with large-scale datasets in cloud data warehouse environments.
• Troubleshoot reporting issues and optimize database performance.
• Partner with engineering and product teams to establish sustainable data architecture.

Must Have: Technical Skills

• PostgreSQL
• Snowflake
• Advanced SQL
• Data Modeling
• Data Warehousing
• Reporting & Analytics Infrastructure
• ETL/ELT Development
• Query Performance Tuning

Success Profile:

The ideal candidate is a data-focused engineer who enjoys working with complex datasets, designing scalable reporting solutions, and building foundational infrastructure that empowers analytics and business intelligence teams. They should be comfortable navigating databases, optimizing queries, and translating business reporting needs into robust technical implementations.

Experience Range: 5-10 years

Role Type: Individual Contributor / Senior Engineer

Primary Focus: Reporting Infrastructure, Data Engineering, Data Warehousing, and Analytics Enablement.

Responsibilities:

• Understand and translate business and customer requirements into clear functional requirements, user stories, acceptance criteria, and process flows.
• Act as a consultant to stakeholders by understanding their needs and pain points, identifying gaps, and recommending practical solutions.
• Conduct detailed business, system, and gap analysis to identify problems, opportunities, feasibility, and potential solutions.
• Prepare functional artifacts including PRDs, epics, business process flows, and requirement documentation.
• Collaborate with Product Managers to define, refine, and prioritize the product roadmap based on business value and customer impact.
• Evaluate and recommend AI-driven solutions to improve product capabilities, business processes, and customer experience.
• Collaborate closely with UX/Design, Engineering, QA, and Data teams to validate requirements, assess feasibility, and ensure timely, high-quality delivery.
• Engage with customers, particularly Engineering, DevOps, and FinOps teams, to gather feedback, identify pain points, improve adoption and satisfaction, and validate product direction.
• Track and report key business/product metrics from inception through closure, using insights to identify areas for improvement.
• Support Agile planning, release cycles, sprint delivery, UAT, documentation, training, and enablement for internal teams and external customers.
• Drive product roadmap planning by collaborating with cross-functional stakeholders to prioritize features, define business requirements, and align product initiatives with strategic goals.
• Leverage AI tools and methodologies to enhance requirement gathering, documentation, user story creation, and identify AI-driven opportunities to improve product capabilities and user experience.

Must-Have:

• Bachelor’s degree in Computer Science, Engineering, Business or related field (Master’s preferred).
•  Preferably in cloud infrastructure, FinOps, cloud cost optimisation, or dev tools.
• Strong understanding of AWS or other public-cloud: you should know at least the major compute / storage / services / networking footprint and usage patterns. 
• Proven ability to translate customer needs into product features, write product requirements (PRDs), and work with engineering teams on execution.
• Proficiency with product management, collaboration, and analytics tools (e.g., Jira, Confluence, Figma, Productboard, BI dashboards, PostHog)

Role Overview

We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.

Key Responsibilities

• Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
• Build and maintain data models to support business processes, reporting needs, and integration workflows.
• Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
• Work closely with cross-functional teams to gather data requirements and understand business logic.
• Develop and execute integration test plans, including functional, data validation, and regression testing.
• Support data migration activities, including extraction, transformation, and loading (ETL).
• Monitor and troubleshoot integration issues, ensuring timely resolution.
• Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
• Ensure integration security, data integrity, and compliance with organizational standards.

Required Skills & Qualifications

• 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• Hands-on experience with data mapping, data modelling, and database schema design.
• Proficiency in SQL (complex joins, stored procedures, performance tuning).
• Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
• Strong analytical and problem-solving skills.
• Experience with API-based integrations (REST/SOAP) is a plus.
• Familiarity with testing methodologies for integrations and data validation.
• Ability to work with business users, understand workflows, and translate requirements into technical solutions.

Preferred Qualifications

• Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
• Knowledge of JSON, XML, CSV transformation.
• Exposure to scripting languages (Python, Shell).
• Experience in Agile/Scrum environments.
• Prior involvement in ERP implementation or upgrade projects.

Competencies

• Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
• Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
• Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
• Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
• Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.

Why Join Us?

• Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
• Work on impactful projects that make a difference across industries.
• Opportunities for professional growth and continuous learning.
• Competitive salary and benefits package.

Application Details

Ready to make an impact? Apply today and become part of the QX Impact team!