The Business Intelligence / Report Developer turns raw data into actionable insights for business users and translate requirements into effective data models and visualizations.
Requirements
- 5+ years of experience in MS SQL Server, Reporting Services, PowerBI
- 3+ years of experience creating advanced level calculations on data sets using DAX functions in Power BI
- Very strong enterprise level PowerBI and SSRS design and development
- Very strong Oracle PL/SQL and Microsoft T-SQL experience with proven knowledge in writing complex SQL
- Performance tuning of new and existing reports for optimum execution
- Demonstrates experience in data extraction and manipulation
Responsibilities
- Maintain the portfolio of existing reporting solutions, establishing and implementing a prioritized upgrade schedule to enforce current design and development standards.
- Design, build and maintain comprehensive Business Intelligence (BI) solutions, including SSRS reports, Power BI dashboards and paginated reports, and ad-hoc queries.
- Partner with the IT Infrastructure team to deploy solutions, configure security and provide technical application support.
- Manage and maintain all objects within the change control management systems (Team Foundation Server and GIT).
- Establish and document standards for the development, testing and deployment lifecycle, ensuring all solutions are efficient, scalable and supportable.
- Conduct training and provide technical support to business power users and subject matter experts, empowering them to effectively leverage data models and reporting tools.
- Proactively identify, communicate and resolve issues related to data quality and reconciliation.
Other
- Work with business users to gather, define, and document requirements for new data and reporting initiatives.
- Ability to understand and document business requirements for conversion into effective and supportable solutions on schedule
- Successfully prioritize and execute multiple projects simultaneously
- Prior work experience in financial, accounting, or banking industry preferred
- Build and maintain strong, positive relationships with both internal teams and business stakeholders.
