Data Analyst

Data Analyst at Control Risks - Mumbai, India

Control Risks is seeking a highly technical and detail-oriented Data Analyst to join our Data & Technology Consulting (DTC) team in Mumbai. This role is integral to our data analytics, scripting, ETL workflows, and reporting functions. The ideal candidate will possess strong proficiency in Python, SQL, Power BI, Microsoft Fabric, and PowerApps, playing a crucial part in developing and implementing data solutions that enhance our consulting engagements.

We are looking for a proactive problem-solver adept at navigating complex, fast-paced environments. You should be confident in writing production-level code and capable of developing intuitive, scalable reporting solutions.

Key Responsibilities:

• Interrogate, clean, and assess structured and unstructured data for integrity, completeness, and business relevance.
• Build and optimize robust ETL pipelines to normalize disparate datasets and enable downstream analysis.
• Write efficient SQL and Python scripts to support custom data transformations, enrichment, and automations.
• Design, build, and maintain interactive Power BI dashboards and PowerApps solutions aligned with client and internal requirements.
• Interpret and analyze complex financial, operational, and transactional datasets to uncover insights and support investigative work.
• Document methodologies, code logic, data assumptions, and business context throughout the project lifecycle.
• Collaborate across multi-disciplinary teams to ensure timely delivery of work products and reporting solutions.

Requirements:

• Minimum 3 years of hands-on experience in:
• Writing production-level SQL and Python for data transformation and automation.
• Building and maintaining ETL pipelines for large, complex datasets.
• Designing and deploying workflows and reports using Power BI, PowerApps, and Microsoft Fabric.
• Advanced proficiency in Excel (pivoting, modeling, formulas, data wrangling).
• Demonstrated experience working with relational databases and open-source tools.
• Strong understanding of data structures, normalization, and query optimization.
• Proven ability to manage multiple priorities in a deadline-driven environment.
• Self-motivated, methodical, and committed to high-quality outcomes.
• Excellent written and verbal communication in English.

Preferred Skills:

• Experience in consulting, compliance, or risk advisory environments.
• Comfort navigating ambiguity and changing priorities.
• Exposure to version control systems (e.g., Git), cloud data tools, or APIs is advantageous.

Education:

• Bachelor’s Degree in Computer Science, Data Science, Information Systems, or a relevant quantitative field.