Business Analyst (Data Quality)
Shine.com · Navi Mumbai, Maharashtra, India
This listing has closed — view similar roles below.
- On site
- Full-time
- $70,000 / year
- Navi Mumbai, Maharashtra, India
Job highlights
- Analyze data quality, identify anomalies, and define rules.
- Translate business needs into technical data specifications.
- Investigate data failures and implement permanent fixes.
- Manage stakeholders and present data quality findings.
- Requires SQL, data visualization, and data governance experience.
About the role
Business Analyst Data Quality
Aquilasys Consultancy Pvt. Ltd. is seeking a Business Analyst with 3-7 years of experience to join their team. This role is based in Mumbai, Pune, or Chennai, with shift timings aligned with EMEA.
Position Overview
As a Data Quality Business Analyst, you will be the crucial link between business stakeholders and technical data teams. Your main objective is to ensure the integrity, accuracy, and reliability of organizational data. You will identify data anomalies and design the necessary frameworks, rules, and documentation to maintain a "Single Source of Truth" across the enterprise.
Key Responsibilities
- Data Profiling Quality Assessment: Conduct in-depth data profiling to identify gaps, inconsistencies, and anomalies in large datasets. Define and implement Data Quality Rules (Accuracy, Completeness, Consistency, Timeliness, and Validity). Develop and maintain Data Quality Dashboards for real-time visibility into business-critical data health.
- Requirement Sourcing Documentation: Collaborate with business units to understand data requirements and translate them into technical specifications for data engineers. Maintain the Enterprise Data Dictionary and Business Glossary for standardized definitions. Create detailed Mapping Documents (Source-to-Target) for data migration or integration projects.
- Root Cause Analysis (RCA) Remediation: Investigate the causes of data failures and coordinate with IT teams for permanent fixes. Lead data clean-up initiatives by identifying duplicate records and obsolete data points.
- Stakeholder Project Management: Act as a Subject Matter Expert (SME) during User Acceptance Testing (UAT) to ensure data outputs meet business expectations. Present data quality findings to senior leadership, highlighting risks and mitigation strategies.
Qualifications & Skills
Must-Have (Technical):
- SQL Proficiency: Ability to write complex queries for data extraction and analysis.
- Data Visualization: Experience with tools like Tableau, Power BI, or QlikView.
- Excel Mastery: Advanced functions (VLOOKUP, Pivot Tables, Macros).
- Methodologies: Strong understanding of SDLC and Agile frameworks.
Must-Have (Functional):
- Proven experience in Data Governance or Master Data Management (MDM).
- Strong analytical mindset for spotting patterns in data.
- Excellent communication skills for explaining technical data issues to non-technical stakeholders.
Good-to-Have:
- Knowledge of Data Quality tools (Informatica IDQ, Collibra, Talend).
- Experience in Capital Markets domain.
- Certifications such as CBAP or CDMP.
If interested, please reply with your updated resume and best connect time.
Key skills/competency
- Business Analysis
- Data Quality
- SQL
- Data Governance
- Master Data Management (MDM)
- Capital Markets
- Data Profiling
- Data Visualization
- SDLC
- Agile
Skills & topics
- Business Analyst
- Data Quality
- Data Governance
- SQL
- Capital Markets
- Data Profiling
- Business Analysis
- MDM
- Tableau
- Power BI
- Agile
- SDLC
- EMEA
- Mumbai
- Pune
- Chennai
How to get hired
- Tailor your resume: Highlight SQL proficiency, data quality experience, and Capital Markets knowledge.
- Showcase your skills: Emphasize your ability to define data quality rules and perform root cause analysis.
- Prepare for technical questions: Be ready to discuss complex SQL queries and data visualization tools.
- Understand the domain: Demonstrate knowledge of the Capital Market Trade Lifecycle and EMEA shift timings.
- Apply strategically: Submit your updated resume and clearly state your availability and interest.
Technical preparation
Practice complex SQL queries for data analysis.,Build sample data quality dashboards in Tableau/Power BI.,Review SDLC and Agile methodologies for business analysis.,Prepare to discuss data governance and MDM concepts.
Behavioral questions
Describe a time you identified critical data anomalies.,How do you explain technical data issues to non-experts?,Share an experience managing stakeholders during UAT.,How do you approach root cause analysis for data failures?
Frequently asked questions
- What is the primary focus of the Business Analyst Data Quality role at Aquilasys?
- The primary focus of the Business Analyst Data Quality role at Aquilasys is to ensure the integrity, accuracy, and reliability of organizational data by identifying anomalies, defining data quality rules, and collaborating with technical teams to implement solutions. This involves a deep understanding of data profiling, root cause analysis, and stakeholder management within the Capital Markets domain.
- What technical skills are essential for this Business Analyst position?
- Essential technical skills for this Business Analyst position include strong SQL proficiency for data extraction and analysis, experience with data visualization tools like Tableau or Power BI, mastery of advanced Excel functions, and a solid understanding of SDLC and Agile methodologies. Familiarity with Data Quality tools is also a plus.
- Does this Business Analyst role require specific industry experience?
- Yes, experience in the Capital Markets domain, particularly with an understanding of the Capital Market Trade Lifecycle, is highly preferred for this Business Analyst role. Knowledge of benchmarks, indices, and corporate actions further strengthens an application.
- What are the location and work arrangement for this Business Analyst job?
- This Business Analyst job is located in Mumbai, Pune, or Chennai. The shift timings are aligned with EMEA, indicating a need for availability during those hours. The specific work arrangement (on-site, hybrid, remote) is not explicitly stated, but the locations suggest an on-site or potentially hybrid model.
- How does Aquilasys approach data quality management in this role?
- Aquilasys approaches data quality through a structured process that includes data profiling to identify issues, defining and implementing data quality rules, developing dashboards for monitoring, conducting root cause analysis for remediation, and ensuring data consistency through enterprise data dictionaries and business glossaries.
- What is expected in terms of data analysis and visualization for the Business Analyst?
- For the Business Analyst role, strong data analysis skills are crucial, including the ability to perform deep-dive data profiling and identify patterns in 'noisy' data. Experience with data visualization tools like Tableau, Power BI, or QlikView is required for reporting on quality metrics and presenting findings to stakeholders.
- Can candidates with Data Governance or MDM experience apply for this role?
- Absolutely. Proven experience in Data Governance or Master Data Management (MDM) is listed as a 'Must-Have (Functional)' skill, indicating that it is a key requirement for this Business Analyst Data Quality position at Aquilasys.