SQL Server BI Developer

Recruiter
ALT
Location
Shelton
Salary
Competitive
Posted
Sep 03, 2016
Closes
Sep 29, 2016
Role
IT
Industry
Service
Employer Type
Direct Employer
Employment Type
Permanent
Hours
Full Time
Job Description:

Job Description The SQL Server BI Developer in this position will work on creating SQL queries, BIDS packages, and reports for the business. The developer will work collaboratively with end users and application teams from within the database unit. They will work in coordination and support of all managers and users requiring any data and decision support. In addition, the developer also will create, enhance, or leverage reporting solutions to solve organizational problems through ETL, reports, analysis, or data visualization. They work on developing data warehouses and any auxiliary needs of this kind. Required Qualifications6+ years of very strong SQL Server development experience on (2008 and 2012+) leveraging SSMS, SSIS, and SSRSExperience with Windows Server 2000+ and virtual environmentsStrong experience with Microsoft Office 2003+ for word processing and database/spreadsheets2+ years with Microsoft SQL Server Analysis Services and/or Data Warehouse developmentPerformance tuning experience with Profiler, Perf Mon, and other toolsPanorama NovaView/Necto, Tableau, Excel PowerPivot/Pivot Tables, or equivalent BI front-end experienceStrong analytical and troubleshooting skills with regards to SQL database systems Key Attributes:Over 6 years of experience providing Business Intelligence/Data Warehousing solutions using MS SQL Server 2005/08/R2/12/14Proficient in T-SQL and Microsoft SQL Server BI tools such as BIDS/SSDT, SSIS, SSAS and SSRS1.5 years' experience loading data from OracleExperience Monitoring and Tuning SQL Server performance using SQL profiler and Database Tuning Advisor (DTA) and other tools Position ResponsibilitiesDesign and develop packages and code using the of MS SQL BI toolkit (BIDS) to develop data warehouse and reporting solutionsDemonstrate a strong attention to detail to ensure accuracy and efficiency of the dataWrite code using T-SQL and other SQL-based languages for development, test, and production environmentsAnalyze data using Excel and SSMS to help streamline business users with their processesTechnically troubleshoot, debug, and performance tune database processesAssist in implementing effective BA practices that drive decision support, efficiency, and performance with lead developer(s)Perform independent audits and reviews and validate data integrityInteract with non-technical business users for to gather requirements for BI solutionsLeverage Microsoft Office toolset efficiently mainly in regards to word processing, presentation, and database/spreadsheet(s) to create documentation and presentation materialWork in a project-based environment with low oversight and self-motivation, using critical thinking skills towards innovation or enhancementsWork in a team environment, including but not limited to, business, database, application, and infrastructure units Additional QualificationsExperience with Oracle 11g and appropriate tool (ie: SQL Developer/TOAD/etc)C# / Java entry-level experienceStrong MDX experience is a plus

More jobs like this