JOB DETAIL

Business Intelligence Analyst

Job Description

Currently, we have an outstanding opportunity for a Business Intelligence Analyst in our Tax department at BDO. This critical role will be responsible for managing the growth and evolution of the company’s data and reporting, including enterprise application databases, current and future reporting tools, and websites, including ensuring appropriate maintenance and support. 

We are seeking an individual who thrives on building effective business relationships, has a customer-driven focus and strong follow up skills. If you are energetic, enthusiastic, and have an unquenchable desire to grow and succeed, your opportunity to grow and prosper will be limitless!

Primary Duties and Responsibilities:

• Ensure careful analysis of requirements with customers to understand their data and reporting needs.
• Analyze data contained in the database to identify data reporting issues with existing data and proposed system tools.
• Document detailed specifications for each report including both the technical specifications and a summary to the report.
• Create and edit Stored Procedures, Views, Functions and Queries on SQL Server 2008/2012 to extract data required for reporting purposes.
• Develop and Maintain Azure Data Factory tasks and data flows
• Create dynamic data models in SQL and Power BI Dataflows
• Develop dynamic reports that enable end users to filter and aggregate defined parameters according to their needs, and custom reports.
• Create report subscriptions, dashboards, etc.
• Proactively identify and communicate dependencies, issues, risks and, or barriers to completing assignments, and escalates to appropriate project stakeholders and, or supervisors. Accountable for supporting and contributing to the management of project scope, schedule, and quality within the respective team/area.
• Analyze how workflow decisions translate into report requirements.

Requirements

• Bachelor’s degree highly preferred, or equivalent experience
• Ability to maintain and manage several projects while meeting expectations
• Excellent written and oral communication skills

Skills Experience

• Relational and Dimensional Data Model
• 3+ years with Power BI, Tableau, or Qlik
• Data Modeling (Conceptual & Logical)
• Knowledge of Azure Data Factory and Blob Storage
• Knowledge of PeopleSoft is a plus.
• Experience delivering business intelligence solutions in a Tax or Accounting environment is a plus.