Senior Data Analyst

ZK Technologies; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

A technology consulting firm is seeking a Senior Data Analyst to design and implement business intelligence solutions. The role requires strong expertise in Power BI and related database technologies, with at least 7 years of experience. Responsibilities include managing large datasets and creating impactful reports. Candidates should have a Bachelor's degree in a relevant field and be excellent team players.

Qualifications

• 7+ years of software development experience required.
• Experience with building data pipelines is necessary.
• Strong ability to understand business processes and design reports.

Responsibilities

• Design, develop, and implement business intelligence solutions.
• Work with large datasets to ensure data integrity.
• Create impactful dashboards and reports for business decision-making.

Skills

Power BI

Power Query

DAX

Python

SQL

SSRS

Marketing Analytics tools

Education

Bachelor’s degree in computer science or related engineering field

Tools

Azure Data Factory

SQL Server

MySQL

Oracle

PostgreSQL

SSIS

Azure Synapse Analytics

Job description

Get AI-powered advice on this job and more exclusive features.

Note :

Immediate joiners preferred

Mandatory Skills :

• Power BI
• Power Query
• DAX Queries
• Python
• SQL
• SSRS
• Marketing Analytics tools

Job Description: Seeking a Senior Data Analyst with strong expertise in database technologies to design, develop, and implement business intelligence solutions. The ideal candidate will possess advanced Power BI skills along with hands‑on experience in database design, development, and optimization. This role involves working with large datasets, ensuring data integrity, and creating impactful dashboards and reports to support business decision‑making.

Requirements:

• Proficient in Power BI Desktop, Power BI Service, and Power BI Mobile.
• Advanced knowledge of DAX (Data Analysis Expressions) and Power Query (M Language).
• Expertise in creating custom visuals, slicers, and drill‑through reports.
• Knowledge of ETL tools and processes.
• Familiarity with data warehousing concepts and cloud platforms like Azure Data Factory or AWS.
• Ability to work with APIs and other third‑party tools for data integration.
• Hands‑on experience with relational databases (e.g., SQL Server, MySQL, Oracle, PostgreSQL).
• Proficient in writing complex SQL queries, stored procedures, and database scripts.
• Strong understanding of data modeling concepts (e.g., star schema, snowflake schema).
• Experience with indexing, query tuning, and database optimization techniques.
• ETL and Data Integration:
• Experience with ETL tools (e.g., SSIS, Azure Data Factory, Informatics).
• Knowledge of cloud platforms like Azure, AWS, or GCP for data storage and processing.
• Ability to work with APIs, JSON, and flat files for data extraction.
• Other Tools & Technologies:
• Knowledge of Azure Synapse Analytics, Data bricks, or other big data platforms.
• Familiarity with Python or R for data analysis (optional but preferred).
• Advanced Excel skills, including VBA (preferred).

QUALIFICATIONS:

• Mandatory Skills: Power BI, Power Query, DAX, Python, SQL, SSRS, Marketing Analytics tools
• Bachelor’s degree in computer science / related engineering field OR equivalent experience in a related field
• 7+ years of software development experience
• Experience with building data pipelines
• Possess the ability to understand business processes and design reports.
• Great team player

Seniority level

Mid‑Senior level

Employment type

Full‑time

Job function

Information Technology

Industries

IT Services and IT Consulting

Referrals increase your chances of interviewing at ZK Technologies by 2x