Business Analyst -SQL VBA
- Genpact India
- 2 to 4 Yrs
- Bengaluru
- 5 years ago
- Email to a friend
- Report this job
Job Description
*With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the world s biggest brands and we have fun doing it. Now, we re calling all you rule-breakers and risk-takers who see the world differently, and are bold enough to reinvent it. Come, transform with us.
Are you the one we are looking for
We are inviting applications for the role of Business Analyst, SQL, VBA
We are looking for a Healthcare Data Analyst to gather and analyze healthcare data from multiple sources (e.g. Medical claims and Pharmacy claim, Patient/Provider behavior) to extract trends and business insights. Good understanding on Medicare and Medicaid data. Understanding of healthcare Drug codes, diagnosis & procedures codes. Knowledge of Extract Transform and Load (ETL) frameworks using SQL and analytical tools. Knowledge of Enterprise Data Warehouse (EDW) and data management systems. Excellent analytical and communication skills. Outstanding organizational and problem-solving aptitude.
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 business unit. Should be able to clearly capture the scope and as part of this role, He /She should be able to understand the data structure and involve in developing SQL & VBA codes to store, sort, and retrieve data and build visualization on top of it. The specific SQL & VBA 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 understand how the database and its information will be used
Responsibilities
- Strong in SQL & VBA to have the needed data fetched from the data warehouse and apply needed rules and bring in the appropriate visuals to generate business insights
- Converting VBA codes to open source like R or Python on need basis.
- Developing, maintaining, and managing dashboards and other BI solutions.
- Performing and documenting data analysis, data validation, and data mapping/design.
- Reviewing and improving existing systems and collaborating with teams to integrate new systems.
- Conducting unit tests and developing database queries to analyze the effects and troubleshoot any issues.
- Ability to multitask and manage time between various projects
- Ability to use existing VBA codes and understand the metrics and build on top of it
- an efficient code that could optimize the performance and come up with suggestions and improvements.
- Fix any issues related to database performance and provide corrective measures
Minimum Qualifications
- Bachelor s degree or equivalent and work experience in Healthcare, Statistics, Mathematics, or a related field
- Candidate must have a minimum experience in Healthcare Analytics domain
- Strong in coding VBA coding and Expertise in SQL
- Good understanding of DB structure, Queries builder
- Ability to articulate and document the needs and business understandings for end users
- Experience in Tableau/Python/R will be additional advantage.
- Good Communication Skill
- 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.
Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. For more information, visit www.genpact.com. Follow us on Twitter, Facebook, LinkedIn, and YouTube
,Employement Category:
Employement Type: Full timeIndustry: IT - SoftwareRole Category: Statistics / AnalyticsFunctional Area: Not ApplicableRole/Responsibilies: Business Analyst -SQL VBAContact 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