Business Analyst

2 Months ago • 5 Years +

Job Summary

Job Description

The Business Analyst will be responsible for designing, developing, and supporting multiple data quality projects in relational databases (Oracle/PostgreSQL) and non-traditional databases (Vertica/MongoDB/Hive). They will analyze business requirements, design and implement SQL-based test scenarios, and implement ETL processes. The role involves collaborating with teams outside of IT, such as Business Intelligence, Finance, Marketing, and Sales, to understand data quality requirements. Additionally, the analyst will build an enterprise-level data quality validation inventory, build MDI components in Pentaho, connect and integrate complex datasets, and translate SQL into understandable terms for both technical and non-technical audiences.
Must have:
  • 5+ years of database development experience on Oracle/PostgreSQL/Vertica
  • Experience with ETL tools
  • Experience with reporting platforms such as Tableau
  • Strong communication and SQL skills, with great documentation
Good to have:
  • 2+ years of experience with databases such as Postgres/GBQ
  • Experience with Web analytics or Business Intelligence tools
  • Knowledge of scripting languages such as Perl or Python
  • Knowledge of Unix shell scripting
  • Understanding of Omniture, Exact Target, Google Analytics, DFP, Salesforce

Job Details

About WebMD:

WebMD Health Corp., an Internet Brands Company, is the leading provider of health information services, serving patients, physicians, health care professionals, employers, and health plans through our public and private online portals, mobile platforms, and health-focused publications. The WebMD Health Network includes WebMD Health, Medscape, Jobson Healthcare Information, prIME Oncology, MediQuality, Frontline, QxMD, Vitals Consumer Services, MedicineNet, eMedicineHealth, RxList, OnHealth, Medscape Education, and other owned WebMD sites. WebMD®, Medscape®, CME Circle®, Medpulse®, eMedicine®, MedicineNet®, theheart.org®, and RxList® are among the trademarks of WebMD Health Corp. or its subsidiaries.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.
For Company details, visit our website: www.webmd.com

Education: B.E. Computer Science/IT degree (or any other engineering discipline)
Experience: 5+ years of relevant experience
Work Timings: 2 PM to 11 PM IST

Position Requirements:
• 5+ years of experience with database development on Oracle/PostgreSQL/Vertica
• Experience with ETL tools.
• Experience with Pentaho is preferred or with Informatica or other similar ETL tools, with an understanding ofMetadata Ingestion
• Experience with the reporting platforms such as Tableau
• 2+ years of experience with databases such as Postgres/GBQ is good to have
• Experience with Web analytics or Business Intelligence tools
• Strong communication,strong SQL and great documentation is a must
• Knowledge of scripting languages such as Perl or Python is an added advantage
• Knowledge of Unix shell scripting is good to have
• Understanding of one or more of: Omniture, Exact Target, Google Analytics, DFP, Salesforce
• Self-motivated, willingness to learn new technologies and business and willing to take initiative beyond basic
responsibilities

Role & Responsibilities:
• Design, Develop and support multiple data quality projectsin relational databases(Oracle/PostgreSQL) as well as non- traditional databases (Vertica/MongoDB/Hive)
• Analyze business requirements, design and implement required SQL based test scenarios and implement ETL processes
• Work closely with teams outside of IT (i.e. Business Intelligence, Finance, Marketing, Sales) to understand data quality requirements
• Build an enterprise level data quality validation inventory for different data sources within new Pentaho framework
• Build MDI components in Pentaho to support data quality checks
• Connect and integrate complex datasets for better analysis and data validation
• Translate SQL into terms that can be understood by both technical and non-technical audiences

Similar Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Skill Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Jobs in Navi Mumbai, Maharashtra, India

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

The WebMD Health Network includes WebMD, Medscape, MedicineNet, eMedicine, RxList, WebMDRx, Medscape Education, Frontline Medical Communications, MedSims, MediQuality, QxMD, Vitals.com, Jobson Healthcare, and WebMD Magazine. WebMD and our network of sites and mobile applications for consumers help them take an active role in managing their own health and wellness. Medscape and our network of sites and mobile applications for healthcare professionals help them improve their clinical knowledge and practice of medicine. In addition, WebMD Health Services provides customizable health and wellness solutions for employers and health plans that help them improve the health of their employee and plan participant populations.

Boise, Idaho, United States (On-Site)

Newark, New Jersey, United States (On-Site)

United States (On-Site)

London, England, United Kingdom (On-Site)

United Kingdom (On-Site)

Atlanta, Georgia, United States (Hybrid)

Newark, New Jersey, United States (On-Site)

London, England, United Kingdom (On-Site)

Yardley, Pennsylvania, United States (On-Site)

View All Jobs

Get notified when new jobs are added by WebMD

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug