Power BI (Business Intelligence) Analyst

Essential Functions:

• Utilize Power BI to deliver high quality BI solutions in a mature enterprise data warehouse environment
• Assist in the collection of user requirements and creation of functional specifications
• Translate functional specifications into technical specifications, including tasks, timelines, and time estimates
• Working from technical specifications
• Create or modify existing reporting assets
• Analyze relational and multidimensional data sets
• Design or enhance relational and dimensional data models
• Build data visualizations including dashboards and reports
• Document data profiling and quality assurance results, data dictionaries and analytical findings
• Comply with team development, IT, and company processes and policies
• Assist/train users in the use of business reporting assets
• Work with teammates to plan mid- and long-term product and technical strategies
• Assist with crafting the development lifecycle process to fit tools and needs
• Communicate clearly with business users and IT professionals about enhancements that are being made to the existing system
• Participate in a rotating on-call schedule for production support

Job Skills:

• Experience writing Power Query, DAX, MDX for complex data projects
• Experience authoring, diagnosing, and altering SQL Server objects and T-SQL queries
• Experience creating and maintaining reporting assets in Power BI
• Knowledge of general data modeling concepts
• Understanding of process engineering concepts and measurements
• Excellent written and verbal communication skills
• Ability to work effectively with remote teammates and users
• Ability to disagree with civility and respect
• Designing beautifully organized analytics dashboards for upper management

Qualifications - External

Minimum Requirements:

• Bachelor’s Degree with concentration in Business, Accounting, Finance, Economics or Mathematics
• 5+ years of Business Intelligence Experience in a data warehouse environment
• 3+ years of experience with Power BI
• Azure Data Lake
• Experience with T-SQL is required
• 2+ years' experience with DAX, Power Query, and MDX is required
• Experience with Oracle Fusion is preferred but not required
• Experience with Dynamics is preferred but not required
• Industry Experience is preferred but not required

Travel Requirements:

• Required travel 20%