Senior Business Intelligence Developer
About The Position
The Senior Business Intelligence Developer is an experienced technical contributor on the Enterprise Data & Reporting (EDR) team, responsible for designing, developing, testing, deploying, and supporting enterprise reporting and business intelligence solutions. The role partners with Business Intelligence Analysts, business stakeholders, data engineers, developers, technical teams, and external partners to deliver solutions supporting the Bank’s strategic and operational objectives and data-driven decision-making. The position develops Power BI reports, dashboards, scorecards, semantic models, datasets, paginated reports, SQL queries, and other business intelligence assets. It also provides technical guidance and mentoring to Business Intelligence Developers and supports development standards, documentation, and best practices. The role investigates reporting and data issues, helps users with report functionality and data questions, and identifies ways to improve solution performance, usability, scalability, and maintainability.
Requirements
- At least 3 years of experience in SQL development and business intelligence development.
- At least 3 years of experience developing reports and dashboards using Microsoft Power BI.
- At least 3 years of experience with Microsoft SQL Server, Visual Studio, Azure DevOps, SSRS, and SSIS.
- Experience developing and supporting enterprise reporting solutions.
- Experience working within structured software development lifecycle practices.
- Strong knowledge of SQL development, query optimization, and database concepts.
- Experience developing Power BI semantic models and understanding dimensional modeling concepts.
- Experience creating Power BI reports, dashboards, and paginated reports.
- Knowledge of DAX, Power Query (M), and data transformation techniques.
- Understanding of ETL/ELT concepts and data integration principles.
- Familiarity with source control and deployment practices using Azure DevOps or GitLab.
- Understanding of business intelligence and data warehousing concepts.
- Strong analytical and problem-solving skills.
- Strong attention to detail and commitment to data accuracy.
- Excellent verbal and written communication skills.
- Ability to work independently while managing multiple priorities.
- Ability to collaborate effectively with technical and business stakeholders.
- Strong organizational and time management skills.
- Demonstrated ability to learn new technologies and adapt to changing business needs.
- Results-oriented approach and focus on delivering high-quality solutions.
Nice To Haves
- Experience with Microsoft Fabric.
Responsibilities
- Review documented report specifications and collaborate with stakeholders to clarify business requirements.
- Design, develop, test, and deploy Power BI reports, dashboards, scorecards, and datasets aligned with business requirements.
- Build and maintain Power BI semantic models using enterprise dimensional modeling standards and best practices.
- Develop complex DAX measures, calculated columns, KPIs, and performance-optimized reporting solutions.
- Use Power Query (M) to extract, transform, and prepare data from enterprise source systems.
- Develop and maintain SQL queries, stored procedures, views, and other database objects to support reporting requirements.
- Develop and support paginated reports using SQL Server Reporting Services (SSRS).
- Perform unit testing and validation to ensure data accuracy, quality, and completeness.
- Investigate, troubleshoot, and resolve complex reporting and data-related issues.
- Support Quality Assurance (QA) and User Acceptance Testing (UAT) activities.
- Collaborate with Business Intelligence Analysts, business stakeholders, developers, data engineers, and external partners to deliver reporting solutions.
- Participate in report design discussions and recommend technical approaches aligned with enterprise standards.
- Conduct peer code reviews and contribute to development best practices.
- Assist in establishing and maintaining reporting development standards and documentation.
- Support and mentor Business Intelligence Developers through knowledge sharing and technical guidance.
- Create and maintain technical documentation in accordance with Enterprise Data & Reporting standards.
- Identify opportunities to improve reporting performance, usability, scalability, and maintainability.
- Support business users with report functionality and data-related questions as needed.
- Stay current on emerging technologies, including Microsoft Fabric, Power BI enhancements, and business intelligence best practices.
- Perform other project duties as assigned.
Benefits
- Annual incentive plan eligibility.
- 11 paid holidays.
- 5 weeks of paid time off.
- Work culture that values work/life balance.
- Hybrid work schedule for most roles.
- 100% match on the first 6% contributed to the 401(k).
- Additional 4% non-discretionary 401(k) contribution at the end of the year.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
