Watson Health - Data Warehouse Developer

Job Description

We are searching for a Data Warehouse Developer to join out Data Management team within the Technology Department. The Data Warehouse Developer will be responsible for collaboratively working with Data Warehouse users to understand and gather their requirements and devise a strategy to fulfill such requirements. The holder of this position will work with Application Developers, Data Warehouse Developers, Data Warehouse Architects, Database Administrators and others to implement a robust ETL processes to extract, transform and load data from transactional databases to the Data Warehouse. Data Warehouse Developer must understand IBM's business model in order develop a data warehouse capable of supporting current requirements while offering scalability. Data Warehouse Developer will proactively monitor and understand Microsoft SQL Server 2012/2014/2016 database performance counters to identify and correct issues that could negatively affect Data Warehouse performance and availability.

Title: Data Warehouse Developer
Location: Dallas, TX

Duties to include:

  • Gather and understand user requirements in order to develop the best strategy to fulfill those needs
  • Support and enhance existing Data Warehouse and constantly find opportunities for improvement
  • Stay abreast with new product development efforts and coordinate with others to integrate new changes to the existing Data Warehouse structure
  • Perform impact analysis to determine how changes in source systems affect the Data Warehouse
  • Design and develop scalable and reusable ETL components that reflect complex business logic using MS SQL Server 2012/2014/2016 SSIS or Data Stage
  • Extend and maintain existing ETL processes to accommodate new or changed data feeds
  • Develop data access objects to build a data presentation layer using SSAS and other technologies
  • Proactively diagnose, research, monitor and resolve SSIS /database-related faults and performance problems including high CPU, memory, blocking, deadlocking and timeouts
  • Develop ETL specifications, source to target mapping and other documentation required for ETL development
  • Ensure appropriate documentation is complete and stored in the appropriate repository
  • Implement adequate ETL monitoring and auditing to accurately measure and trend ETL performance
  • Provide after hours and weekend support for Data Warehouse processes as needed
  • Design indexing strategies that provide optimum query perform, while balancing ETL and query performance
  • Conduct or participate in meetings with organizational stakeholders to identify and build solutions to address growing data acquisition and consumption needs
  • Leverage performance monitoring tools to identify performance bottlenecks and devise strategies to address performance issues

Requirements:
  • 4+ years of hands-on OLAP database development experience particularly in a fast and high volume environment
  • 4+ years of dimensional data modeling experience
  • Demonstrated expertise in Transact-SQL and the ability to create complex queries, stored procedures, triggers, user-defined functions, views, SSIS packages, and other database objects
  • Experience working with end users to understand their needs and provide solutions
  • 4+ years of experience developing ETL solutions for large data warehouse environments
  • Demonstrated track record of successful software delivery on the Microsoft SQL Server tool set/platform particularly in SQL Server 2008/2012/2014 and Integration Services
  • Understanding SQL Server data types and their implications to performance and storage
  • Demonstrated understanding of SQL Server performance tuning including query execution plans, indexing strategies, and SQL performance counters
  • Demonstrated ability to take direction and operate efficiently under minimal supervision during all phases - requirements, design, development, QA, deployment and documentation
  • Team player with solid communication skills that excel in a collaborative environment
  • Ability to be flexible and quickly adapt to a changing and high growth environment


Preferred:
  • Experience with Tablue is a plus
  • Experience with MongoDB is a plus
  • Healthcare industry experience a plus


Keywords
Microsoft SQL Server; Data Warehouse; Performance Tuning; T-SQL; Dimentional Modeling; Data Warehouse Development; OLAP; SSIS; SSRS; InfoSphere DataStage; Cubes; Cognos

Required Technical and Professional Expertise

  • 4+ years of Data Warehouse Development on Microsoft SQL Server platform
  • 4+ year experience with Dimensional modeling in a Data Warehouse
  • 4+ year of ETL development using SSIS
  • 2+ years of SSRS development experience


Preferred Tech and Prof Experience

  • MongoDB experience
  • Tableau experience
  • SSAS experience


EO Statement
IBM is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.


Meet Some of IBM's Employees

Peter M.

Leadership Development Solutions Leader

Peter works with a variety of teams within IBM to increase organizational clarity, equip leaders to serve well, and provide opportunities for employees to continually grow and expand their skills.

Rashida H.

Director, IBM Watson Client Delivery

Rashida leads the IBM Watson Delivery Team, which focuses on providing Watson implementation training for clients around the world, helping companies achieve the solutions they seek.


Back to top