Business Intelligence Developer at Fintrak Software

Responsibilities

• Collaborate with colleagues to improve on current software (s) in line with company policies.
• Extend technical support during preparation, installation and system maintenance to cross functional teams.
• Work collaboratively with Project Manager to ensure timely delivery of projects.
• Resolve application defects and issues in a timely manner.
• Documentation of all products and processes
• Document and maintain software functionality
• Troubleshoot, debug and upgrade existing systems
• Design storage definitions for all enterprise data such as databases, tables, schema, etc.
• Develop stored procedures for efficient access and manipulation of data
• Build data warehouse and reporting infrastructure from the ground up using T-SQL, SSIS, SSAS, SSRS and power bi
• Create SQL Server Agent job scripts to execute SSIS packages
• Utilize Microsoft PowerBI to design multiple scorecards and build analytical dashboards.
• Build Model on analysis service using SSAS Tabular for Live connection Database
• Write DAX Queries to build PowerBI Model for existing and new solutions.
• Schedule Jobs for executing the stored SSIS packages which were developed to update the database on daily basis.