Job Classification: Technical Specialist 1/TS1
Supplier List: MBE
Contract Length: thru FY18- extensions possible
Interview Process: Candidates must be available for onsite interviews- local candidates preferred
Will close to submissions on: Wednesday 11/15 @ 10AM
Note: A PO may take up to 3 weeks to procure- please set this expectation with candidates during the submission/interview process.
Description of Duties:
25% of Total Work Effort: Requires 5-7 years' experience as an SSIS ETL Developer working in Microsoft SQL Server
25% of Total Work Effort: Knowledge of administration of SQL Server for transactional and analysis systems
25% of Total Work Effort: Strong analytical data model design expertise (preferred)
25% of Total Work Effort: Snowflake and Star Schema design
The SSIS ETL Developer is responsible for designing, developing, and delivering high-quality output and proactive involvement in the successful delivery of BI systems; through coordination within the rest of the technology department and the business owners.
The SSIS ETL Developer is responsible for data profiling of new source systems, designing custom reporting tables (such as fact and dimension), and using SSIS to create ETL packages to fully support reporting solutions in Cognos. Has thorough knowledge of data warehousing and ETL (SSIS required).
The Resource must have a good understanding of the business needs and the technical capabilities and be able to help align the BI solutions to meet the business growth objectives.
Must have:
• 5-7 years of experience as an SSIS ETL developer
• Data profiling and data modeling experience
• Strong in data warehousing concepts and techniques
• SQL, T-SQL, PL/SQL techniques
• Experience creating custom reporting tables using SQL (such as fact, dimension, aggregate, slowly-changing dimension)
• Snowflake and Star Schema design
• Effective verbal and written communications skills and effective presentation skills
• Self-motivator, independent, cooperative, flexible, creative
Preferred:
• Strong OLAP/analytical data model design expertise
• Cognos experience
