SQL BI Developer

SQL BI DEV

Design and development of BI systems/applications. Communicate and defend design, requirements, feature set, functionality, usability and limitations of subsystem to team and/or development lead or manager. Participate in Business Requirements and Functional Requirements meetings, identify gaps in requirements and drive discussion around appropriate solutions. Design and code high quality database solutions within a fast paced monthly release cycle. Manage errors gracefully. Document code and work completed. Conduct thorough unit testing of code and document the unit test cases. Conduct appropriate performance testing to ensure all solutions will meet SLAs and performance criteria. Provide support as needed throughout Test and User Acceptance Testing phases. Create Technical Design Specification documentation that clearly articulates the design and code being implemented. Provide client communication as appropriate to project. Develop new reports and provide technical support for the applications.BI developers will be able to translate technical specifications into finished programs and systems and also have a thorough understanding of developing solutions to handle large volume data sets that are typical with BI solutions.

Education

Bachelor’s degree in Engineering, Computer Science or related technical field or equivalent work experience/training.

Work Experience

• 7+ years’ development experience.
• At least 5+ years of SQL Server development experience writing complex stored procedures, triggers, views, etc.

General requirements for All Levels:

• SQL Database Administrator/Analysist experience.
• Experience with TSQL, SSIS package, SSAS or OLAP
• Knowledge of MDX, DAX cube customization is a must.
• Analysis Services/OLAP experience a plus.
• Understands how to create a proper DB schema, ETL package and Analysis Services cube.
• Strong data warehouse design and physical data modeling skills.
• Ability to quickly troubleshoot issues and work on multiple tasks in parallel.
• Excellent coding and debugging skill.
• Excellent communication skills and ability to work under continual deadline constraints are necessary.
• Strong communication skills in both written and spoken English.

Job Type: Full-time

Salary: $95,000.00 to $110,000.00 /year

Required education:

• Bachelor’s

Required experience:

• SQL: 5 years