(a) Design and development of BI systems/applications as part of Monthly releases and data acquisition process needs.
(b) Communicate design, requirements, feature set, functionality, usability and limitations of subsystem to team and/or development lead or manager.
(c) Participate in Business Requirements and Functional Requirements meetings, identify gaps in requirements and drive discussion around appropriate solutions.
(d) Design and code high quality database solutions within a fast paced monthly release cycle.
(e) Manage errors gracefully. Document code and work completed.
(f) Conduct thorough unit testing of code and document the unit test cases.
(g) Conduct appropriate performance testing to ensure all solutions will meet SLAs and performance criteria.
(h) Provide support as needed throughout Test and User Acceptance Testing phases.
(i) Create Technical Design Specification documentation that clearly articulates the design and code being implemented.
(j) Provide client communication as appropriate to project.
(k) Develop new reports and provide technical support for the applications.
(l) 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.
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.
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.