Power BI Developer

We are looking for a business intelligence (BI) engineer to design, implement, and maintain
systems used to collect and analyze business intelligence data in a large public safety
organization. The primary tool is Microsoft PowerBI. As an engineer, you will create
dashboards, databases, and other platforms that allow for efficient collection and evaluation of
BI data. You will work with internal staff and other stakeholder to gain an understanding of BI
goals and objectives to ensure the systems and their capabilities support competitive research
efforts that achieve those goals. You may train other staff members on the use of BI tools and
programs.

Requirements

You must be comfortable designing and implementing data collection and analysis systems.
Familiarity with data visualization software programs such as Microsoft PowerBI and related
tools is essential. Experience with computer programming or an engineering background is an
advantage.

Responsibilities

Specify, design, build, and support data warehousing and BI solutions.
Create dashboards and KPIs to show the business performance to management.
Design and maintain data models used for reporting and analytics.
Help the broader team identify new features and business opportunities through your
analysis.
Build various data visualizations to tell the story of trends, patterns, and outliers.
Monitor and tunes BI tools to ensure optimum level of performance.
Automate report generation and data refresh processes.
Develop and manage role-based security (RLS) in Power BI.
Monitor and troubleshoot Power BI Service, including gateway configurations and
refresh schedules.
Stay updated on Power BI updates, best practices, and emerging trends in data
visualization and analytics.
Provide updates to customers, business and staff on a timely basis for projects and
tasks.
Ensure data accuracy by validating data for new and existing tools.
Support upgrades, configuration and troubleshooting for business intelligence tools.
Responsible for program design, coding, testing, debugging and documentation.
Lead ad-hoc business deep dive analysis and present findings to senior leadership.
Modify existing reports, extracts, dashboards and cubes as necessary.
Collect, analyze and share data to help make strategic product decisions.
Maintain current inventory of reports and publishes this information to users.
Identify development needs in order to improve and streamline operations.
Prepare detailed specifications from which programs will be written.
Own the design and development of automated solutions for recurring reporting and in-
depth analysis.

Qualifications

Bachelor's or Graduate's Degree in computer science, engineering, mathematics or
information systems.
Experience with Microsoft PowerBI.
Experience with SQL, SQL Server, ETL, and SSRS software, systems, and programs.
Experience with Python 3x, cloud (Azure), and R language software and systems is
desired.
Understanding of CI/CD pipelines and DevOps for Power BI deployments.
Familiarity with Power Automate and Power Apps for workflow automation.
Knowledge of data governance, security roles, and compliance standards.
Fluent in statistics and datasets.
Comfortable making decisions and leading.
A problem solver and critical thinker.
Familiar with version control and relational databases.
Fluent in written and spoken English.