Data Analyst / Data Engineer
Summary
Data Analyst/Data Engineer designing analytics architecture, managing databases, writing SQL queries, and automating Power BI reports for stakeholders.
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