We have a client that is seeking a full-time, permanent
. A data warehouse does not currently exist within the organization and will be built from the ground up. The environment is Microsoft SQL Server 2008 Enterprise Edition (on a 3-node cluster) with SharePoint 2010.
Senior OLAP Architect & Database Developer
. A data warehouse does not currently exist within the organization and will be built from the ground up. The environment is Microsoft SQL Server 2008 Enterprise Edition (on a 3-node cluster) with SharePoint 2010.
Requirements
•
Provide full SDLC of data warehouse design and development
Provide full SDLC of data warehouse design and development
•
Interpret functional BI requirements and translate them into an effective DW logical and physical design using dimensional modeling techniques
Interpret functional BI requirements and translate them into an effective DW logical and physical design using dimensional modeling techniques
•
Research alternatives and provide recommendations for the data warehouse design that are based on the best practices of leading OLAP solutions
Research alternatives and provide recommendations for the data warehouse design that are based on the best practices of leading OLAP solutions
•
Design, develop and maintain ETL processes with the help of team members
Design, develop and maintain ETL processes with the help of team members
•
Develop approaches for maintaining in production optimized DW solutions
Develop approaches for maintaining in production optimized DW solutions
•
Review functional requirements to give development estimates and product development
Review functional requirements to give development estimates and product development
•
Conduct code reviews by and for peers
Conduct code reviews by and for peers
•
Mentor and guide team members
Mentor and guide team members
•
Create thorough and demonstrable unit testing specifications
Create thorough and demonstrable unit testing specifications
•
Implement code upgrades, backups and version control
Implement code upgrades, backups and version control
•
Lead specification development for the target production implementation including performance, capacity planning and storage requirements
Lead specification development for the target production implementation including performance, capacity planning and storage requirements
Qualifications
•
Proven expertise with Data warehouse and ETL design and development with minimum of 4 years of full data warehouse project development
Proven expertise with Data warehouse and ETL design and development with minimum of 4 years of full data warehouse project development
•
Experience with identifying, analyzing and translating business requirements into conceptual, logical and physical data models in complex, multi-application environments
Experience with identifying, analyzing and translating business requirements into conceptual, logical and physical data models in complex, multi-application environments
•
Experienced in creating, reviewing and presenting Source Systems Analysis and Source-To-Target mapping across Staging, Integration and Presentation layers
Experienced in creating, reviewing and presenting Source Systems Analysis and Source-To-Target mapping across Staging, Integration and Presentation layers
•
Experienced in identifying and documenting data integration issues, challenges such as duplicate data, non-conformed data, and unclean data
Experienced in identifying and documenting data integration issues, challenges such as duplicate data, non-conformed data, and unclean data
•
Experienced in incrementally building Staging, Operation Data Stores and Dimensional data marts
Experienced in incrementally building Staging, Operation Data Stores and Dimensional data marts
•
Practical knowledge of modern RDBMS and OLAP
Practical knowledge of modern RDBMS and OLAP
•
Expert level knowledge of SQL Server SSAS ( 2005, 2008)
Expert level knowledge of SQL Server SSAS ( 2005, 2008)
•
Expert level knowledge of MDX (Multi Dimensional eXpressions) language for multi-dimensional OLAP databases
Expert level knowledge of MDX (Multi Dimensional eXpressions) language for multi-dimensional OLAP databases
•
Expert level knowledge in designing and implementing data warehouses, including star schema, dimensions and fact tables
Expert level knowledge in designing and implementing data warehouses, including star schema, dimensions and fact tables
•
Knowledgeable in BI and Data Mining
Knowledgeable in BI and Data Mining
•
5+ years experience in T-SQL skills
5+ years experience in T-SQL skills
•
Expert level knowledge of SQL for the purposes of developing complex and efficient data queries
Expert level knowledge of SQL for the purposes of developing complex and efficient data queries
•
Must have a minimum of 5+ years in financial and investment banking
Must have a minimum of 5+ years in financial and investment banking
Nice to Have Skills
•
Knowledge of storage technology to effectively configure database systems
Knowledge of storage technology to effectively configure database systems
•
Knowledge and expertise in EMC SAN environment is a plus
Knowledge and expertise in EMC SAN environment is a plus
•
Knowledge Microsoft’s .NET framework 3.5/4.0 with Visual Studio 2003/2005/2008, C#, ASP.NET, MVC 3.0/4.0, XML/XSLT, XML Web Services, RSS and AJAX
Knowledge Microsoft’s .NET framework 3.5/4.0 with Visual Studio 2003/2005/2008, C#, ASP.NET, MVC 3.0/4.0, XML/XSLT, XML Web Services, RSS and AJAX
Soft Skills
•
Strong written and verbal communication skills
Strong written and verbal communication skills
•
Ability to effectively work within a team environment
Ability to effectively work within a team environment
To apply for this job please visit www.kovasys.com.