TestHiring - Require a Data Analyst in Bangalore

Data Analyst is needed in Bangalore, India.

Client: TestHiring

Location: Bangalore North, KA, in

Contract: Freelance

Job Description

Analyze complex business datasets using exploratory data analysis techniques to uncover trends, patterns, and anomalies that directly inform strategic decisions and operational improvements across the organization.

Develop robust data models and analytical frameworks in Python that standardize calculations, support predictive insights, and enable scalable reuse across teams and projects.

Good experience in Power BI is required.

Design and maintain advanced Excel workbooks and macro-driven solutions that automate repetitive tasks, improve data accuracy, and significantly reduce manual processing time for stakeholders.

Build interactive Tableau dashboards and visual analytics that clearly communicate key performance indicators, helping business partners quickly understand results and act on data-driven recommendations.

Collaborate with cross-functional teams to gather requirements, translate business questions into analytical problems, and deliver clear outputs that align with enterprise priorities and industry essentials.

Implement rigorous data quality checks using MS Excel, Python, and other tools to validate sources, reconcile discrepancies, and ensure decision-makers can rely on consistent and accurate information.

Optimize data pipelines and reporting workflows by reviewing existing processes, identifying bottlenecks, and proposing automation strategies that improve efficiency in a hybrid work environment.

Document analytical methods, datasets, assumptions, and business rules in a detailed yet accessible manner to support transparency, reproducibility, and onboarding of new team members.

Provide actionable insights through well-structured reports and presentations that highlight business impact, quantify opportunities, and support continuous improvement across day shift operations.

Partner with stakeholders to perform scenario analyses and what-if assessments using Excel VBA and Python models, evaluating potential outcomes and supporting risk-aware planning.

Apply industry essentials knowledge to benchmark performance, interpret external trends, and ensure that analytical outputs reflect relevant regulations, standards, and market dynamics.

Support governance practices by adhering to data security policies, respecting privacy considerations, and promoting ethical use of analytics that benefits customers, communities, and the company mission.

Contribute to a culture of analytical excellence by sharing best practices, mentoring peers on modern data techniques, and championing the use of evidence-based decision-making in everyday work.

Requirements

Demonstrate strong proficiency in Python for data analysis including data manipulation, statistical exploration, and integration with visualization and reporting tools.

Show advanced expertise in MS Excel and Excel macro VBA development to construct automated workflows, complex formulas, and template-driven reporting solutions.

Apply solid experience in Tableau to design user-friendly dashboards that transform technical metrics into intuitive visuals tailored to diverse business audiences.

Exhibit deep understanding of exploratory data analysis principles including data profiling, feature exploration, and visual techniques that reveal meaningful patterns and outliers.

Bring practical domain exposure in industry essentials allowing effective alignment of metrics with business realities, regulatory contexts, and evolving market expectations.

Operate effectively in a hybrid work model using collaborative platforms to coordinate tasks, communicate findings, and maintain productivity during onsite and remote work.

Additional Information

This role requires a proactive approach to identifying inefficiencies and proposing solutions, with an emphasis on collaboration and mentorship within the team.