Go Back
ETL (SSIS) Developer Loc:Bronx,NY
2016-04-27 10:37:35
Job Type:
Full Time only
Budget $:
100,000 - 200,000
- Lead the translation of complex business data into normalized data sets and able to model the data as well as document them in a way that the less-experienced staff can understand and utilize.
- Develop and document the systems, processes and logic required to expose the existing data sets in the warehouse to end users for reporting and analysis purposes.
- Keep abreast of the tools, techniques and components being used in the industry through research and applies this knowledge to the system(s) being developed.
- Develop testing strategies, including test script formulation and execution, used to validate the accuracy & results of ETL solutions; coordinate user acceptance testing with business partners and IM resources; participation and contribution in quality assurance walk-through of ETL components.
- Manage multiple broader efforts that span multiple projects/initiatives.
- Prioritize and monitor project/task status and risk management/mitigation, by working with appropriate manager on level of effort/estimates, resource assignments, etc.
- Adhere to standard SDLC procedures and ensure the creation of appropriate documentation.
- Ensure adherence to Change Control and release management procedures, including generation of appropriate packages, documentation, and coordination with other technical areas.
- Establishes and maintains productive working relationships with peers and users, including effective collaborative problem solving, responsive communications and cordial interpersonal relationships.
- Demonstrate proficiency with the principles and methodologies of process improvement.
- Apply these in the execution of responsibilities in support of a process focused approach.
- Perform other duties or responsibilities as necessary or assigned.
Requirements for this position include:- Bachelors Degree in Computer Science, Management Information Systems or related field or equivalent knowledge.
- Three (3) plus years of experience in data warehousing, data management, ETL processes and data modeling tools (ERWIN), required with experience in a managed care or health insurance setting preferred.
- Three (3) plus years of experience in database and interface design, data integration, conversion processes and optimization, preferred.
- Hands-on experience with all aspects of designing, developing, testing and implementing ETL solutions.
- Advanced Microsoft SQL experience required; SSIS, SSRS, OLAP preferred.
- Knowledge of .Net languages and Business Objects BI, a plus.
- Ability to learn and implement new and/or different techniques.
- Self-starter with ability to work independently or as part of a team.
- Strong technologist with excellent ability to analyze complex problems and identify and implement solutions.
- Excellent ability to organize tasks and maintain project schedules.
- Strong interpersonal skills demonstrated by an ability to communicate with all levels of staff in a courteous, constructive, patient and informative manner.
- Strong oral and writing skills characterized by the ability to communicate technical and non-technical information thoroughly and clearly to a range of reading and comprehension skill levels.
- Strong Project Management skills.
- Commitment to the corporate mission, vision, and values.
Key Skills: