Business Intelligence Analyst

Scope:

· Modernization initiatives across the fundamentally changing how ministry users collect, manage, analyze, and use data as legacy systems are transformed into modern Data Management and Geospatial Platforms.

· This shift requires dedicated analytical capacity to ensure that the value of modernized data assets is fully realized.

· DRAS is a regulatory transformation initiative led by Environment and Protected Areas (EPA) to modernize, digitize, and streamline environmental and natural resource regulatory processes.

· DRAS supports the full regulatory lifecycle, from application and authorization to monitoring, compliance, remediation, and closure through a single, consolidated digital platform.

· The increasing scale of DRAS data creates a strong and ongoing need for dedicated business intelligence and analytics capability to support operational monitoring, compliance oversight, performance measurement, and strategic decision‐making.

· These needs span the full data lifecycle, including data collection and integration, data quality management, analysis of trends, patterns, compliance and regulatory reporting, and the delivery of clear, actionable insights through dashboards and visualizations.

· This position will primarily support the Digital Regulatory Assurance System (DRAS) program, where high‐quality, timely analytics are essential to regulatory and compliance functions. As data and analytics maturity increases, the role may be expanded to support additional enterprise data initiatives.

Duties: This is the standard description of services – revise as needed.

· Design and develop complex dashboards, scorecards, and visual analytics using Power BI

· Design, develop, and maintain data models and visualizations using Microsoft Power BI and Azure-based data platforms

· Data Modeling & ETL Development

· Create optimized, reusable data models using DAX and Power Query M for enterprise-wide reporting

· Build interactive dashboards and reports tailored to business needs using Microsoft Power BI

· Integrate Power BI with various Microsoft Azure data sources and on-premises databases

· Work closely with Business users, data architects and data engineers to manage data pipelines, staging areas, and semantic models.

· Work with business units to gather reporting requirements and KPIs.

· Translate ambiguous business questions into concrete BI solutions.

· Present insights and findings in clear, executive-friendly formats.

· Provide end-user training and support to ensure adoption of BI tools

· Maintain and publish datasets and dashboards in Power BI Service with scheduled refreshes and alerts

· Optimize dashboards and reports for performance

· Implement security and user access controls within Power BI

· Implement incremental data refresh, row-level security (RLS), and performance tuning strategies in Power BI.

· Conduct deep-dive analytics to uncover trends, anomalies, and business opportunities.

· Ensure data accuracy, consistency, and security compliance across all reporting assets

· Integrate AI capabilities to augment analytical processes by automating data exploration identifying trends and anomalies and generating insights.

· Other duties as needed

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.