Designs custom reports based on customer access requirements, data requirements, analysis of data sources, current reporting environment and functional design and in accordance with Reporting Development standards and best practices.
Performs the detailed design of reports.
Performs analysis of report requirements and build reports using best practices and efficiencies.
Assesses availability of data (sources & target) and recommends required changes to enable reporting.
Provide guidance as the subject matter expert for SSRS, DAX and Power BI Report Server deployments and configuration.
Utilize professional code of ethics regarding confidentiality of information and protecting rights of end-users and owners of data.
Develops reports that are in compliance with customer requirements, security requirements and best practice.
Works with technical and functional Leads to complete the build and deployment activities needed to support BI reporting/analytics requirements.
Participates in code reviews with peers in the reporting services group.
Test, Support and Maintenance:
Develops and executes unit test plans to ensure reporting is operating to specifications.
Attends meeting with functional partners to prototype reports and refine based on feedback.
Develops and executes technical unit test plans.
Provides support for issues and enhancements.
Works with internal IT resources for coordination, installation and testing of required software upgrades.
Knowledge, Skills & Abilities:
Demonstrated proficiency with SSRS creating highly formatted reports with complex scripting and parameter pages.
Demonstrated proficiency with DAX and complex reporting logic.
Demonstrated proficiency in deploying reports and configuring the on premise Power BI Report Server.
Excellent oral and written communication, organizational, and planning skills
Excellent problem solving and critical thinking skills are essential
Excellent interpersonal skills, ability to work independently but as a member of a team
Excellent understanding of complex financial and business processes
Must be able to understand complex requirements and design reports to meet needs
Must be able to develop solutions independently with little technical oversight
Ability to work effectively with a diverse group
Self-motivated and organized with a well-developed sense of time, projects, and priorities management.
Education / Related Experience
Bachelor's degree preferably in Computer Science or Management Information Systems and more than 7 years of working experience.