01 Sep
|
DocOnline
|
Hyderabad
01 Sep
DocOnline
Hyderabad
Job Description
Job Title: Data Analyst/ Data Engineer
nLocation: Hyderabad
nPosition Type: Full time
n
nJob Overview:
nDatabase engineer with experience in Database management, Data analytics, good knowledge in writing queries to extract the data, automate the report generation through reporting tools.
n
nKey Responsibilities:
n
- n
- Plan and define the overall data analytics architecturen
- Establish data governance to ensure data quality & securityn
- Design end-to-end analytics solutions including Data ingestion, Data storage, Analytics layern
- Understand the data requirements from various departmentsn
- Extract data from database by writing queries and sharing the reports with the stakeholdersn
- Automate the frequently used data reports using the Reporting tool (MS Power Bl) and provide secured access to stakeholders on the reports Query optimizationn
- Capacity planning and Database finetuning from time to time to increase DB performancen
n
nSkills & Knowledge:
n
- n
- RDBMS conceptsn
- Writing SQL queries (DDL, DML, DQL, DCL) using MySQLn
- Extract data/reports by writing complex queriesn
- Data ingestion (ETL/ELT, streaming, batch pipelines)n
- Data storage (Data Lake, Data Warehouse, Data Lakehouse)n
- Data Analytics (Bl tools, dashboards, ML platforms)n
- Expertise in data transformation, cleaning, modeling, DAX, and creating interactive dashboards for actionable business insights in MS Power Bl.n
- End-to-end knowledge on Power Bl Report Development and Publishing to Power Bl Servicesn
- Support development team in Query optimizationn
- Database Capacity Planningn
- Database fine tuning for better performancen
- Basic knowledge of MongoDB data querying and data exportn
- AWS RDSn
- Pythonn
n
nEducation: BTech/MCA
📌 Data Analyst (Hyderabad)
🏢 DocOnline
📍 Hyderabad