Your resume and cover letter, tailored to exactly what they’re hiring for.
Get past ATS filters
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.