USM Business Systems · Raleigh
Software Engineeringposted 120mo ago
SSIS Developer
6 month contract to hire
Dayton, OH
Consultant must be Greencard holder or Citizen
Top Skills:
1) 7+ years of ETL (SSIS) development experience
2) Experience working in an agile environment
3) Strong overall SQL & DW knowledge
4) Healthcare experience
Job Description:
Responsibilities:
• Expand the company’s use of data as a strategic enabler of corporate goals and objectives.
• Facilitate information gathering sessions and provides data analysis and data mapping.
• Work with various customers, prospects and stakeholders, understands and translates business use cases and/or requirements into data models, data integration routines and analytics reports.
• Identifies data sources, develop and maintain data architectures, constructs data catalog and data decomposition diagrams, provide data flow diagrams and documents the process.
• Have the ability to facilitate the development of data integration efforts with the development team in addition to hands on design and development of large complex ETL jobs.
• Develop, manage and maintain data models, including physical and logical models of the data warehouse, data marts, development and staging areas and source systems as necessary to meet new and changing business requirements.
• Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
• Establish methods and procedures for tracking data quality, completeness, redundancy and improvement; and processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.
Qualifications:
• Hands on ETL development in tools such as SSIS
• Working experiences in design and modeling normalized and dimensional (e.g. star schema) data warehouses.
• Self-motivated team player who excels in a collaborative environment.
• Strong sense of accountability, adaptability, flexibility and a sense of urgency.
• They should have a bias for action and achieving results for themselves as well as their team.
• Excellent analytic and problem solving skills.
• Ability to work effectively with associates at all levels within the organization.
• Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.
• Proven ability to handle multiple tasks and projects simultaneously.
• Familiar with the Agile Methodology.
• Excellent analytical skills, attention to detail, and problem-solving skills.
• Self-motivated team player who excels in a collaborative environment.
• Strong sense of accountability, adaptability, flexibility and a sense of urgency.
• They should have a bias for action and achieving results for themselves as well as their team.
• Passionate about continuously improving organizational practices. Ability to learn and apply new technologies quickly and self-directed.
• Familiarity and working knowledge of SQL Server Database, SSIS, SSAS, Kalido DIW and Kalido MDM is a plus.
If you are interested in the below position please forward your profile to preethib@usmsystems(dot)com or call me on 703 468 0398.