The Leukemia & Lymphoma Society (LLS) currently uses multiple systems (both siloes and integrated) for tracking constituent and related transactional data across its many functional areas (Campaigns, Patient Access, Research, Donor Development). Primary systems include a complex proprietary system and multiple instances of Salesforce.com. Additional systems will include Master Data Management, self-service analytics layer and external data repositories such as the LLS Copay system, Dun & Bradstreet, and clinical research data.
LLS is looking for a hands-on technologist and developer who has deep experience in extracting information from complex proprietary systems in order to transform data into a state that can be easily loaded into a Master Data Management Framework and an Analytical reporting layer. The Senior ETL Specialist will work jointly with the Director of Data Management towards defining a Data Integration platform constituting an ETL Framework and a Service Oriented Architecture with a key focus on consistency, reusability, support and lineage enabling the easy exchange of information across systems intended for different business purposes. The candidate will work closely with product creation and development staff to design, implement, and support scripts, programs, services, software components and perform analyses that will support product quality and an in depth understanding of potential uses of the data across the enterprise. The Senior ETL Specialist will be responsible for creating and maintaining detailed documentation regarding the process and services including metadata. In order to be effective in this role, the individual will need to possess a combination of business knowledge, technical skills, and people skills.
- Perform detailed analysis of complex, highly normalized operational systems and external third-party vendor systems.
- Work collaboratively with multiple IT resources in order to define the ETL Framework and a Service Oriented Architecture for easily, effectively and consistently integrating and exchanging information to support the development of a LLS Data Integration Platform.
- Work with staff and customers to understand the business requirements and business processes. Will be defining and coding the extract-translate-load (“ETL”) and/or extract-load-translate (“ELT”) processes.
- Definition and standardization of Data Processing Environments for enhanced traceability and lineage.
- Define an effective change management process towards consistently deploying code and processes across the ETL Framework in accordance with the corporate data standards.
- Expertise in design & development, performance tuning, deployment and maintenance of ETL Processes and Data Services.
- Creating and following standards and procedures around ETL development and recording metadata for end to end data lineage.
- Production and maintenance of detailed documentation including the recording of business process flows and corresponding data process flows and mappings.
- Ability to multitask and positively contribute towards projects in a fast paced environment.
- A deep understanding of several Data Warehousing technologies such as Operational Data Store, Data Marts and Enterprise Data Warehouse including dimensional modeling concepts.
- Extensive experience with developing an ETL framework and working with multiple ETL Tools like Microsoft SQL Server Integration Services (SSIS) and Informatica PowerCenter.
- Prior Experience with Master Data Management Implementations including hands on working knowledge of the Informatica Data Quality tool.
- Excellent troubleshooting skills and advanced problem solving ability.
- Ability to perform comprehensive unit and system integration testing for overall quality assurance of functional and technical quality of deliverables.
- Actively participate in and provide valuable insights in development code reviews.
- Excellent accountability and reliability in actively monitoring and supporting processes that run on a daily and weekly basis.
- Provides advanced technical direction towards the maintenance of existing ETL processes and supporting evolving applications and business processes. Strategically plan on migrating existing ETL processes into the newly developed data integration platform.
- Advanced degree in Applied Mathematics, Business Analytics, Statistics, Machine Learning, Computer Science or related fields is a plus.
- A minimum of 10 years of progressively responsible experience in a directly related area, during which professional capabilities have been clearly demonstrated.
- Must have experience working with multiple business units using numerous technology platforms with incongruent data models.
- Extensive experience working with enterprise systems as well as with multidimensional data modeling, normalized and de-normalized models.
- Extensive experience in developing information integration and exchange platforms in conjunction with EDW tools and technologies.
- Solid experience with Master Data Management, Data Warehouse and BI systems.
- Knowledge of relational SQL databases and SQL (including SQL Server tables, triggers, unions, joins, complex queries and stored procedures) in at least one of the following environments: Oracle, Microsoft SQL Server.
- Proven success in the design and implementation of enterprise data integration solutions and technologies.
- In depth knowledge of ETL tools and/or Data Integration products (e.g.SQL Server Integrations Services (SSIS), Informatica, Jitterbit, Mulesoft, Boomi, WebMethods, Castiron, Biztalk).
- Ability to leverage knowledge of MS Excel towards gathering preliminary requirements in order to effectively engage the business users.
- Prefer familiarity with Salesforce object model.
- Experience in leveraging components of the Mulesoft Anypoint Platform for batch and real-time data processing and integration is a plus.
- Working knowledge of designing, managing, testing and deploying API’s (RAML, REST, SOAP) using the Mulesoft Anypoint Platform.
- Knowledge of cloud computing and considerations for scalable, distributed systems.
Position Requirements & Skills:
- Possess excellent written and oral communication skills with the ability to explain technical issues clearly and accurately to both technical and non-technical audiences.
- Ability to use logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to complex problems.
- Ability to work independently, establishing strategic objectives, project plans and milestone goals.
- Ability to engage directly with a very wide of stakeholders in mission, operations, management, oversight and development roles, as well as volunteers, as needed.
- Self-starter with the ability to multi-task in a fast paced work environment.
- Must be organized and detail oriented.
- Strong oral and written communication skills.
- Ability to work collaboratively as a member of a team, regardless of the task at hand.
- Takes independent actions and calculated risks, looks for and takes advantages of opportunities, solicits feedback to improve processes or actions.
- Makes rational and realistic decisions which are based on logical assumptions, reflects factual information and shows consideration of organizational resources.
- Uses appropriate interpersonal styles and methods in guiding individuals or groups.
- Demonstrates stability of performance under pressure and/or opposition. Ability to cope with uncertainty, change and performance demands.
- Establishes and develops effective relations. Exhibits utmost tact and consideration.
- Anticipates long term opportunities, defines a desired future state and communicates direction of vision and values.
- Incorporates long-term goals into tangible results and day-to-day activities; reinforces with the team.
- Facilitates the development of others knowledge and skills, providing timely feedback and guidance to help them reach goals.
Physical Demands & Work Environment:
- Occasional travel to Chapters and events.
- Physical demands are minimal and typical of similar jobs in comparable organizations.
- Work environment is representative and typical of similar jobs in comparable organizations.
The statements herein are intended to describe the general nature and level of work being performed by employees, and are not to be constructed as an exhaustive list of responsibilities, duties, and skills required of employees. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the Company. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.