Senior Software Engineer

Position at WebMD

We are seeking an experienced and passionate Senior Software Developer to join our team. In this role, you will work closely with cross-functional teams, developers, stakeholders, and business units to gather and analyze business requirements, design, build and implement ETL Solutions, and maintain the infrastructure. The ideal candidate will have a strong background in business analysis, SQL, Unix, Python, ETL Tools to ensure the successful execution of projects.

Responsibilities:
 Lead requirements gathering sessions with key stakeholders to understand business needs and objectives.
 Collaborate with and across Agile teams to design, develop, test, implement and support ETL processes for data transformation and preparation.
 Manage data pipelines for analytics and operational use.
 Ensure data quality, data accuracy and integrity across multiple sources and systems.
 Perform unit tests and conduct reviews with other team members to make sure your code is rigorously designed, elegantly coded, and effectively tuned for performance.
 Should be able to come up with multiple approaches to any ETL problem statement/solution/technical challenge and take well informed decision to pick the best solution.
 Automate ETL Processes using Cron and/or using Job Scheduler tools like AirFlow.
 Adhere to company standards and Serve as a key contributor to the design and development of exception handling, code/data standardization procedures, resolution steps and Quality Assurance controls.
 Maintain a version repository and ensure version control.
 Create visual aids such as diagrams, charts, and screenshots to enhance documentation.
 Work with Infrastructure/systems team and developers to ensure all modules are up-to- date and are compatible with the code.
 Identify opportunities for process optimization, automation, and system improvements.

Requirements:
 Bachelor’s degree in computers or related field.
 8+ years of IT experience.
 6+ years of development experience in Unix Shell Scripting, Python.
 Strong background in Data Warehousing, data modelling and experience with ETL Tools like (Informatica or Pentaho).
 6+ years of experience in SQL and database technologies.
 Experience with Vertica, and BigQuery is a plus.
 Experience with Visualization Tools like Tableau is a plus.

 Excellent written and verbal communication skills with the ability to interact with both technical and non-technical stakeholders.
 Experience with YouTrack and Agile development methodologies.
 Strong understanding of technical concepts and the ability to learn new technologies quickly.
 Proficiency in using documentation tools and software such as Visio, Microsoft Word, Confluence or similar.
 Experience with version control systems such as SVN and Git.
 Ability to work independently and as part of a team.
 Strong attention to detail and accuracy.
 Ability to manage multiple projects and meet deadlines.
 Familiarity with content management systems (CMS) and documentation repositories.
 Strong organizational and time management skills.
 Ability to adapt to changing requirements and priorities.