Job Location: Noida
Job Description
Designation: Lead Reporting & BI.
Experience: 4-8 Years
Location: Gurgaon/Noida
Job Roles & Responsibility:
- Develop and implement standardized MIS procedures across all business applications.
- Use business acumen to be able to analyze, drive insights and create meaningful reports using large datasets
- Directs and troubleshoots database issues to keep existing databases running efficiently.
- Supports strategic direction for database platforms by evaluating and making recommendations for new platforms.
- Source data from disparate systems with good understanding of Qlik/ other BI tool architecture
- Extract, transform and load (ETL) data from proprietary SQL databases into BI application
- Advanced knowledge of script editor to connect and retrieve data from various data sources at the extraction stage
- Data transformation using advanced joints, functions and sets on SQL database
- Ability to write complicated yet efficient SQL queries and stored procedures
Skills and Requirements:
- Strong quantitative and analytical skills with ability to translate data into meaningful insights using SSRS, SQL databases(any ETL tool – good to have)
- Experience with Data Visualization tools like Qliksense, Power BI
- Strong Excel capabilities including pivot table, lookup, and VBA programming skills.
- Strong programming skills in Excel and VBA
- Proficiency in SQL with broad working knowledge of methodologies used for advanced reporting is required.
What can you expect?
- Becoming a part of a high performance team
- Being bold in thinking and bringing innovative solutions to any barriers faced
- Through the first 3-6 months, you will be provided adequate training and will be actively supported by your peers to help understand the ways of working
- Generate and distribute standard reports on schedule using Excel, and other reporting software
- Use the data to prepare regular and insightful reports which should show the key trends
- Use business acumen to be able to analyze, drive insights and create meaningful reports using large datasets
Submit CV To All Data Science Job Consultants Across India For Free
