Business Intelligence Developer

Overview

This position involves designing, developing, and sustaining the business intelligence infrastructure that converts data from trading, brokerage, asset management, and corporate finance activities into actionable insights for decision-making throughout the organization. The role includes ownership of semantic data models, crafting DAX and Power Query transformations, creating executive-focused dashboards, and managing the Power BI Service comprehensively. A critical responsibility is to translate business inquiries into well-structured, high-performance, and secure analytics, ensuring all reports are accurate, trustworthy, and adhere to data governance and compliance standards.

Key Responsibilities

• Design and upkeep strong semantic data models such as star schema, relationships, and hierarchies optimized for Power BI.
• Develop efficient DAX measures and calculation groups to support complex business and financial calculations.
• Create reusable Power Query (M language) transformations for producing clean, consistent, and refreshable datasets.
• Transform reporting requirements into scalable and well-designed analytical models with a single source of truth.
• Produce clear, interactive, and visually coherent dashboards tailored for executive and operational users.
• Apply principles of data visualization to effectively communicate insights beyond raw data.
• Create parameterized, drill-through, and paginated reports to address diverse reporting needs.
• Work iteratively with stakeholders to enhance usability, clarity, and business relevance of reports.
• Collaborate with business leaders, finance, and operations teams to understand reporting and analytics needs.
• Gather, clarify, and document requirements, KPIs, and precise metric definitions.
• Resolve ambiguous or conflicting metrics ensuring a trusted single version of data.
• Effectively communicate insights, constraints, and data limitations to non-technical stakeholders.
• Integrate data from SQL Server, APIs, files, and internal business systems into BI environment.
• Create and schedule dataflows and dataset refresh operations with monitoring for reliability.
• Ensure data quality through validation and reconciliation before publishing reports.
• Collaborate with engineers to optimize upstream data architecture for efficient reporting.
• Optimize data models, DAX expressions, and queries to deliver high performance and responsiveness in reports.
• Maintain consistent naming conventions, designs, and modeling standards across all BI reports.
• Test and verify report accuracy against source systems prior to release.
• Reduce dataset sizes and refresh expenses by implementing efficient model and query design.
• Implement row-level security and role-based access control consistent with business requirements.
• Manage Power BI Service components including workspaces, apps, content lifecycle, and security.
• Enforce data governance policies, sensitivity labeling, and controlled sharing aligned with regulations.
• Administer Power BI infrastructure including service management, gateways, capacities, and scheduled refreshes.
• Manage deployments across development, testing, and production environments.
• Monitor refresh failures, report performance, usage statistics, and resolve related issues promptly.
• Coordinate with Information Security, Compliance, and Risk teams to align BI platform with corporate and regulatory standards.
• Maintain documentation such as data dictionaries, metric definitions, model documents, and operational runbooks.
• Document report logic, data lineage, and architecture decisions to support ongoing maintenance.
• Report on report adoption metrics, user engagement, and data quality to leadership.
• Support training and user enablement initiatives to encourage self-service BI usage within the business.

Qualifications & Experience

• Bachelor's or Master's degree in Computer Science, Information Systems, Data Analytics, or related discipline.
• Microsoft certifications such as PL-300 (Power BI Data Analyst) or certifications in Microsoft Fabric/Azure Data technologies are highly advantageous.
• Experience in financial services or regulated industries is preferred but not mandatory.
• Minimum of four years hands-on experience in Power BI development with expertise in DAX and Power Query.
• Strong background in data modeling and advanced proficiency in SQL for data extraction and transformations.
• Proven ability to deliver executive-level dashboards and promote self-service analytics.
• Experience managing Power BI Service including gateways, scheduled refreshes, and implementing row-level security.
• Prior exposure to regulated or data-sensitive environments is strongly desirable.

Technical Skills

• Advanced skills in Power BI including DAX, Power Query (M), semantic modeling, and report creation.
• Proficiency in SQL Server and T-SQL, including query optimization for analytical tasks.
• Strong expertise in star schema and dimensional data modeling techniques.
• Experienced with Power BI Service administration such as workspaces, apps, gateways, capacities, and security management.
• Expertise in data visualization and dashboard design best practices.
• Familiarity with Microsoft Fabric, Azure data services, and implementing dataflows.
• Knowledge of Excel, Power Automate, and the broader Microsoft data ecosystem.
• Basic understanding of cloud-native architectures on platforms like Azure or AWS.

Behavioral Competencies

• High integrity and sound judgment in handling data.
• Strong attention to detail and dedication to accuracy.
• Analytical mindset with curiosity and problem-solving capabilities.
• Excellent stakeholder engagement skills with both technical and non-technical audiences.
• Accountability and strong ownership of deliverables.
• Clear, structured, and effective communication skills.
• Collaborative team player with a cooperative attitude.