BI Developer - Redmond, WA (EG)

Job description

At Avanade we create change for a living, and joining us is your chance to do the same. Founded in 2000 by Accenture LLP and Microsoft Corporation, we have 25,000 people in more than 20 countries helping the world's biggest and most innovative organizations realize results in a digital world – with business technology solutions, cloud and managed services that combine insight, innovation and expertise in Microsoft technologies. Find out more at avanade.com/careers

As a Business Intelligence (BI) Developer, your focus will be on developing and testing mission critical enterprise solutions and implementation of custom application development and selection using the SQL Server BI stack including SQL Server Integration Services, Reporting Services and Analysis Services 2005/2008/2008 R2,, SharePoint 2010, SharePoint 2007, Office 2010, Office 2007 and other advanced components of Microsoft technology. A BI Developer should be able to develop ETL packages, Reporting Services reports, T-SQL, and SQL Server objects (views, Stored Procedures, etc). Additional desired skills include MDX, C#, .NET Framework, and ASP.NET.

Responsibilities may include:

·  Design logical and physical databases with data modeling tools
·  Write SSIS packages, Reporting Services Reports and/or Analysis Services cubes
·  Write scripts and processes for development
·  Review database design changes with the team to determine the impact to the physical database and other systems
·  Recommend technical changes to support evolving business and IT processes
·  Support production issues for cubes, DW Reporting, and ETL jobs
·  Manage and perform maintenance, backups and security for the development databases
·  Troubleshoot database issues
·  Configure and maintain SQL Server and database settings
·  Perform data migrations; Set up automated processes
·  Monitor database and SQL Server performance
·  Perform capacity planning

Qualifications

You will have excellent communication skills and will have hands-on experience working on component based applications in a distributed environment.

Qualified candidates should possess:

3-5 + years of Database Development

·  Proficiency in Microsoft SQL Server 2000/2005/2008 in the following areas: database design; SQL Server architecture; T-SQL programming; performance tuning; stored procedures, function and trigger design and coding; index implementation and maintenance
·  3-5 + years experience on SQL Server Reporting Service and Integration Service 2005/2008.

3-5 + years experience designing, developing, testing, and supporting of ETL, cube, and reports.

·  Advanced knowledge of OLAP technologies, dimensional modeling, and reporting.
·  Experience with cubes and complex SQL queries and sprocs. Desired: MDX, MOSS , XML, XSLT, JavaScript, , ERP or CRM.
·  Understanding of BI application design
·  The ability to extrapolate database schema to meet the business needs of the application
·  Excellent communication skills and hands-on experience working on component based applications in a distributed environment.
·  Bachelor's Degree in Computer Science, Computer Engineering, MIS or related field

Preferred Requirements:

Microsoft certification

Functional Microsoft technology knowledge of the following:

·  SQL Server Analysis Services 2012
·  SharePoint 2012
·  PerformancePoint Services or PerformancePoint Server .
·  PowerPivot

Avanade® Is An Equal Opportunity Employer. Avanade prohibits discrimination and harassment against any employee or applicant for employment because of race, color, age, religion, sex, national origin, gender identity or expression, sexual orientation, disability, veteran, military or marital status, genetic information or any other protected status.