BI Developer

In person interview is needed after phone screen.

 

Location: Baltimore, MD

Duration: 6+ months

Rate: Open

 

This candidate works in synchronization with the Data warehouse team to understand the data needs of the organization in order to build, and support a sustainable, scalable architecture in an IT sanctioned environment. The candidate maintains the production data infrastructure which will support production reporting, ad-hoc reporting, the business intelligence portal, and analytics for the organization.

 

Responsibilities:

·         Devises and builds data processing jobs for the creation and maintenance of tables, views, data marts.

·         Develops SSIS ETL packages, data mining algorithms, SSRS reports, T-SQL stored procedures in support of OLAP cubes.

·         Manages the logical and physical design of BI data warehouse, creation of tables, views, procedures, packages and other database objects in support of SSAS cubes for analytics and Production Reporting.

·         Designs Data Warehouse components for solutions that take into consideration the value of performance, scalability, operability, flexibility, affordability, and ability to be audited.

·         Designs and develops dimensional data models, etc. ETL/ELT frameworks and processing, metadata management, operational data integration, master data definition and quality, data auditing, data profiling and reporting solutions.

 

Required Skills:

• Significant prior experience in database design and development including working with stored procedures, indexes and views

• Microsoft SQL Server 2008 R2

• SQL Server Integration Services (SSIS)

• SQL Server Reporting Services (SSRS)

• Must be a methodical and pragmatic problem-solver

• Excellent written, verbal and interpersonal skills.

 

Desired Skills for BI Developer Job:

·         SQL Server Analytical Services (SSAS)

·         Share Point Development

·         .Net Development (VB.Net, ASP.Net)

 

Thanks

Sandeep

 

Sandeep Jain

Software People Inc.

www.softwarepeople.us

sandeep.jain@softwarepeople.us

Ph: 631-863-0299, 631-410-4741, 631-921-2111 ©

Fax: 631-574-3122

Certifications: SBA 8a/SDB, NY MWBE, VA SWaM, DE OMWBE, MA MWBE