Share this Job

Go Back

SSIS (MS BI) Data Warehouse Developer (EDW)


2015-03-05 11:45:03
Job Type: Full Time only
Budget $: 100,000 - 200,000

This position is responsible for developing, supporting and integrating new and existing business systems.
Major Job Accountabilities:
Developing, supporting and integrating a variety of financial and airline operations systems.Ã? Integrate data between operational systems and business reporting tools.Gather business requirements based on process analysis and user interviews to develop application specifications.Must be a self starter, able to work independently and as part of team.Efficiently manage time for timely project deadlines as well as ad hoc requests.Qualifications:Ã? MS or BS in computer science or equivalent education At least 5 years of experience in data warehouse and/or data integration development and maintenance. At least 2 years of experience in working with ETL & BI tools (IBM Cognos)Ã? At least 2 years of experience working SQL Server (T-SQL and Stored Procedures)An excellent knowledge of data warehousing concepts, theories and best practices. At least 2 years of experience working with SSRS and SSIS. Ability to design and develop complex ETL structures to extract, transform and load data from multiple data sources into data warehouse and other databases based on requirements. Provide senior technical knowledge of ETL solutions for application integration and BI projects. In depth knowledge of data modeling and database design, life-cycle development methodology and user training.Ability to lead meetings with technical peers regarding the solution designs. Ability to collaborate with Business Analysts and Project Mangers to convert functional specifications into technical specifications. Ability to QA and document own code is essential Lead unit and integration testing activities and participate in user acceptance testing as needed. Excellent communication (oral and written) and interpersonal skills, is a proficient problem solver, ability to acquire new skills quickly and thrive in a collaborative team environment. Solid critical thinking & trouble shooting skills.Provides status updates to appropriate levels of management. Familiarity with Clarity a plus.
Key Skills: