The Business Intelligence Developer turns raw data into actionable insights for business users and translate requirements into effective data models and visualizations.
Requirements
- 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
- Ability to understand and document business requirements for conversion into effective and supportable solutions on schedule
- 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
- 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.
- Define and document a consistent framework for producing high-quality, impactful and maintainable reporting solutions.
- Work with business users to gather, define, and document requirements for new data and reporting initiatives.
- 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.
Other
- Successfully prioritize and execute multiple projects simultaneously
- Excellent analytical, communication, organizational and problem-solving skills coupled with a strong work ethic
- Prior work experience in financial, accounting, or banking industry preferred
- Experience working in the banking, mortgage or finance industry
- Excellent critical, analytical and problem-solving abilities
