Assistant Manager - Analytics
- Genpact India
- 5 to 11 Yrs
- Bengaluru
- 4 years ago
- Email to a friend
- Report this job
Job Description
AM, Data Analyst.
In this role the individual will be responsible working with client internal departments owner to understand the challenges and scope out the needed metrics to track performance of the unit. Should be able to clearly capture the scope and As part of this role, You should be able to understand the data structure and involve in developing SQL codes/Packages/tabular models to store, sort, and retrieve data and build visualization on top of it using Tableau. The specific SQL needs can vary based on the organization and application, but the ability to write and optimize these codes is essential in this role. The key success of this role will be in gathering requirements and specifications from the end-users and understanding how the database and its information will be used
Responsibilities
Designing, developing, and managing BI solutions
Craft and execute SQL queries on data using MSBI tools (SSIS, SSAS, SSRS) as and when needed
Draw and customize different reports, analyses, and visualizations using MSBI tools for projects
Collection of data from various sources, storage in the data warehouse, and designing database solutions like OLAP cubes
Building the OLAP Cube based on the Dimension, Facts using SQL Server Analysis
Designing and Implementing the ETL for history load/Incremental loading of data using
Manage, closely monitor MSBI tools, inspecting them for bugs and debugging them where necessary to improve their performance
Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
Perform unit testing and troubleshooting
Collaborate both with clients and other team members in designing powerful BI solutions and integrating them with other systems
Preparing technical documents and reports using SSRS and securing them
Minimum Qualifications
Bachelor s degree or equivalent and work experience in similar field is required
Expertise in MSBI development
Experience in Power BI and Tableau will be additional advantage
Ability to articulate and document the needs and business understandings for end users
Good Communication Skill
Preferred qualifications
Able to nurture robust working relationships with the team, peers and clients, scheduling flexibility required
Overall candidate should have problem solving, macro-level research and analytics approach and good in numbers.
Good people and customer handling skills.
Effective communication and interpersonal skill.
Employement Category:
Employement Type: Full timeIndustry: IT - SoftwareRole Category: DBA / DatawarehousingFunctional Area: Not ApplicableRole/Responsibilies: Assistant Manager - AnalyticsContact Details:
Company: Genpact IndiaLocation(s): Bengaluru
Genpact India
Genpact (NYSE: G) is a global professional services firm focused on delivering digital transformation for our clients, putting digital and data to work to create competitive advantage. We do this by integrating lean principles, design thinking, analytics and digital technologies with our domain and ...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in