Our Financial Services client has an exciting opportunity available for an experienced (SQL) Business Intelligence Architect with 5+ years of experience working with Microsoft SQL Server BI Suite.
The ideal candidate will need to be able to work within a small team and produce high results. The candidate will be involved in new development along with maintaining existing reporting systems.
Responsibilities:
• Design, implement, and maintain data warehouses using SQL Server Replication, SSIS, SSAS, and T-SQL scripting
• Work with business stakeholders to create and maintain reports in SSRS using relational and SSAS data sources
• Create ad hoc reports, including the extraction of client demographics and retention statistics based on various client and service usage attributes
• Provide database administration support during deployments and migrations
• Mentor others on a wide range of database and analytic techniques
• Gathers requirements, analyzes, creates design documents, and performs impact analysis
• Develops Extraction, Transformation and Loading (ETL) processes to acquire and load data from internal and external sources
• Evaluate data systems, operations, and organizational aspects of various departments, and make recommendations
• Build database models, dashboards, reports, interfaces for BI packages
• Identify data security issues and recommend solutions
Job Requirements :
• 5+ years of experience using Microsoft SQL Server BI Suite
• Emphasis on SSAS, and building/processing cubes
• SQL Server 2008 & 2012 –T-SQL, SSAS, SSRS, SSIS
• 5+ years of experience with data warehouses, data marts, dimensional modelling and OLAP technologies
• Experience building Reports, Scorecards and Dashboards
• Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly
• Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem solving skills
• Software Development – VS 2010 & 2012, Excel, Word, Visio
SherlockTalent loves to share $500 referral bonus!
