SQL BI Developer

Jobsbridge; Burbank (CA); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading data solution provider is seeking an experienced MS SQL Developer to work on Business Intelligence development. The candidate should have strong knowledge of Microsoft SQL Server Solutions, data warehouse methodologies, and experience with tools like Visual Studio 2008 BIDS. Responsibilities include analyzing existing databases, creating technical specifications, and resolving production issues. The ideal candidate will be self-motivated and able to thrive in a fast-paced environment.

Qualifications

• Strong experience and knowledge of Microsoft SQL Server Solutions for Business Intelligence.
• Experience working with MDX and SQL Server security features.
• Proficient in creating technical specifications and documentation.

Responsibilities

• Perform analysis on existing databases and write specifications.
• Testing of new development in MS SQL.
• Troubleshooting production issues in SQL databases.

Skills

Microsoft SQL Server Solutions for BI

Data warehouse design

MDX

Ad-hoc reporting

Business dashboard construction

Tools

Visual Studio 2008 BIDS

Job description

• Working as an MS SQL developer in Business Intelligence development.
• Strong experience and knowledge of Microsoft SQL Server Solutions for BI, SQL Server, Reporting Services (SSRS), Analysis Services (SSAS), Integration Services (SSIS).
• Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.
• Experience working with MDX.
• Working knowledge SQL Server security features such as ownership chaining.
• Experience working with Visual Studio 2008 BIDS.
• Experience with ad-hoc reporting, business dashboard, data visualization, and other tools that are required to make BI results relevant and actionable to the business and business users.
• An ability to be a self-motivated, high performance contributor in a rapidly moving business with tight deadlines and imperfect procedures and requirements.
• Tight focus on results and self-improvement with a desire to drive our business' analytic capabilities and knowledge forward.

Tasks to be performed on a regular basis:

• Perform analysis on existing interfaces / databases / programs and write specifications to convert to another format.
• Perform testing of new development
• Write requirements / documentation / tech specs
• Problem resolution of production issues on MS SQL database
• Perform research on database in response to BAU requests
• Create Change control records / peregrine tickets / EURC requests as required.

Qualifications

• Programming
• Research
• Security
• SQL
• SQL Server
• Testing