Share this Job

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: