17 Sep
|
DocOnline
|
Hyderabad
17 Sep
DocOnline
Hyderabad
Job Description
Job Title: Data Analyst/ Data Engineer
n
Location: Hyderabad
n
Position Type: Full time
n
Job Overview:
n
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.
n
Key Responsibilities:
n
n
- Plan and define the overall data analytics architecture
n
- Establish data governance to ensure data quality & security
n
- Design end-to-end analytics solutions including Data ingestion, Data storage, Analytics layer
n
- Understand the data requirements from various departments
n
- Extract data from database by writing queries and sharing the reports with the stakeholders
n
- Automate the frequently used data reports using the Reporting tool (MS Power Bl) and provide secured access to stakeholders on the reports Query optimization
n
- Capacity planning and Database finetuning from time to time to increase DB performance
n
n
Skills & Knowledge:
n
n
- RDBMS concepts
n
- Writing SQL queries (DDL, DML, DQL, DCL) using MySQL
n
- Extract data/reports by writing complex queries
n
- 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 Services
n
- Support development team in Query optimization
n
- Database Capacity Planning
n
- Database fine tuning for better performance
n
- Basic knowledge of MongoDB data querying and data export
n
- AWS RDS
n
- Python
n
n
Education: BTech/MCA
📌 Data Analyst / Data Engineer (Hyderabad)
🏢 DocOnline
📍 Hyderabad