ETL Lead

RESPONSIBILITIES:

- Responsible for the technical specification and implementation of data migration strategies.
- Implement new Business Intelligence and data warehouse requirements through the use of SQL, ETL, Business Intelligence tools, database programming and reporting tools.
- Meet with business and technical leaders to identify and scope the business opportunities, document and vet business requirements, identify effective reporting techniques, identify the best data sources for reach report field, identify risks and constraints, and design reporting formats.
- Prepare technical design documents, including the documentation of extended use cases, class diagrams, collaboration diagrams, sequence diagrams and non-functional and functional prototypes, as needed.
- Develop, implement, and maintain ETL (extract, transform, and load) solutions to bring new data into the data warehouse.
- Develop optimized database design to achieve acceptable performance by tuning view, tables and indexes for proper response time.
- Develop new capabilities and architectures that capitalize on the development of client portal, and ad-hoc BI capabilities.
- Lead and Implement best practices for full life cycle development and maintenance of data warehouse, ETL, and Business Intelligence solutions.
- Demonstrate Data Analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners.

SKILLS
SQL Server 2008 (5+ Years Exp). Expert knowledge of database theory and design (logical & physical design). Expert knowledge of SQL Server Analysis Services (SSAS) (5+ Years Exp). Expert knowledge of Structured Query Language (SQL) (5+ Years Exp). Strong knowledge of SQL Server Reporting Services (SSRS) (5+ Years Exp). Working knowledge of Transact-SQL programming (stored procedures, triggers, views). Experience working with Microsoft Visual Studio and TFS. Proficient with the design of database architectures, data migrations, Business Intelligence packages, and implementing user reporting solutions based upon business requirement and content knowledge. Must have management skills to drive projects to completion on schedule with junior team members and mid-level business professionals. Strong understanding database methodology, data analysis, advanced SQL queries, ETL and Business Intelligence application required. Outstanding interpersonal and presentation skills. Excellent written and verbal communication skills.

Synectics is an Equal Opportunity Employer.