Data Analyst / Data Engineer

Job Title: Data Analyst/ Data Engineer

Location: Hyderabad

Position Type: Full-time

Job Overview:

Database engineer with experience in Database management, Data analytics, good knowledge in writing queries to extract the data, automate the report generation through reporting tools.

Key Responsibilities:

• Plan and define the overall data analytics architecture
• Establish data governance to ensure data quality & security
• Design end-to-end analytics solutions including Data ingestion, Data storage, Analytics layer
• Understand the data requirements from various departments
• Extract data from database by writing queries and sharing the reports with the stakeholders
• Automate the frequently used data reports using the Reporting tool (MS Power Bl) and provide secured access to stakeholders on the reports Query optimization
• Capacity planning and Database finetuning from time to time to increase DB performance

Skills & Knowledge:

• RDBMS concepts
• Writing SQL queries (DDL, DML, DQL, DCL) using MySQL
• Extract data/reports by writing complex queries
• Data ingestion (ETL/ELT, streaming, batch pipelines)
• Data storage (Data Lake, Data Warehouse, Data Lakehouse)
• Data Analytics (Bl tools, dashboards, ML platforms)
• Expertise in data transformation, cleaning, modeling, DAX, and creating interactive dashboards for actionable business insights in MS Power Bl.
• End-to-end knowledge on Power Bl Report Development and Publishing to Power Bl Services
• Support development team in Query optimization
• Database Capacity Planning
• Database fine tuning for better performance
• Basic knowledge of MongoDB data querying and data export
• AWS RDS
• Python

Education: BTech/MCA