Ssrs developer vs business intelligence developer

Differences between ssrs developer and business intelligence developer duties and responsibilities

Ssrs developer example responsibilities.

• Involve in DBA responsibilities such as managing users and permissions, creating audit triggers, and overlook the daily back up.
• Create facts, dimensions, data model, star schema representation for the data mart of OLTP and OLAP databases.
• Work with XML configuration files for deploying SSIS packages from development to production environment.
• Design and implement OLAP database utilizing star schema structure.
• Develop and support nightly batch processes for application data updates and imports on the Linux environment.
• Create drill through reports so that end users can see the TFS page of the particular work item.
Show more

Business intelligence developer example responsibilities.

• Used TFS for managing versions of the code with in the development team.
• Develop VBA base application to automate testing of report output and test scenarios.
• Manage security privileges for each subject area and dashboards according to user requirements.
• Develop various T-SQL store procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
• Develop QlikView dashboards using drill down and cyclic grouping and also using input field, table box, list boxes etc.
• Introduce use of statistics, regression, supervise and unsupervise predictive analytics and visualization.
Show more