POSITION SUMMARY
Designs, develops, and executes Business Intelligence and analytics and processes. Supports all analytic and business intelligence efforts of the company’s internal and external business for report development, quality assurance, and analysis. Responsible for ensuring team members are meeting delivery timelines. Mentoring others and acts as subject matter expert for analytics. Designs and builds scalable data models, cleaning, and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations.
LOCATION
Remote - (US)
FUNCTIONS OF THE JOB
Essential Functions: Which may be representative but not all inclusive of those commonly associated with this position.

• Provides technical leadership, guidance and direction to other team members
• Provides technical leadership on all assigned projects to ensure delivery of valuable solutions in alignment with BMI’s business needs, technological platform architecture, and overall SDLC. This includes understanding business requirements, adhering to technical architecture standards, recommending technical design, monitoring development and testing efforts, resolving technical issues, making technical decisions, and supporting deployment of the product.
• Leverages all aspects of BI technologies and architecture such as delivery mechanisms (i.e. portals, dashboards, OLAP), data model/architecture, data integration/ETL and reporting tools
• Integrates data from various sources including on system and off system sources
• Meets with project team(s) regularly to review project deliverables and deadlines
• Analyzes data, design and develops complex custom reports and dashboards using in-house reporting platform with little or no supervision
• Validates report results against requirements for consistency and accuracy
• Troubleshoots and analyzes data issues within reports
• Communicates results to business staff and supports business decisions
• Develops standard processes for business user requests for BI and analytics
• Develops and maintain other BI and analytics standards for BMI including data sources, report catalog and a data dictionary
• Actively participates as an analytics and BI advocate and expert on teams to help promote the development of an analytics and BI culture within BMI
• Regularly updates management of development status
• Regular attendance
• Other duties as assigned
• Supports our BMI Core Values and cultivates a culture of diversity and inclusion

POSITION QUALIFICATION REQUIREMENTS

Education: Bachelor's Degree or higher in Computer Science or Math or equivalent industry experience

Experience: Minimum seven years of experience with business intelligence tools, SSRS, SSAS, Power BI and Cognos preferred. Experience of leading and executing BI programs required. Should have 10 + years of experience in BI space (mostly Reporting)

SKILLS AND ABILITIES

• Expert-level Knowledge of Power BI architecture and infrastructure is a must.
• Expert-level Dimensional Modelling experience is a must.
• Power BI Service Security (i.e. Row Level).
• Expertise in DAX Measures, Calculated Columns, and Dax Pattern implementations
• Experience with PBI Report performance tuning, DAX query plans.
• Strong data warehousing fundamentals
• Excellent written and verbal communication skills
• Experience implementing PBI Embedded a plus
• Expert level of proficiency with Microsoft PowerBI
• Strong Power BI enterprise solution experience, including enterprise gateway, security, application integration and deployment
• Hands-on solution experience of Cognos and SSRS reports conversion to Power BI is a plus
• Power BI Service Tenant administration & Power BI Premium Capacity management experience is a plus
• Power BI Report and Dashboard development using industry design principles like gestalt
• Monitoring and troubleshooting Power BI Reports and sites utilizing tools like DAX Studio
• Power Query (M), Dataflows and Data Analysis Expressions (DAX)
• Implementing and testing row-level security
• End-to-end Power BI best practices and processes
• Proficiency estimating work assignments and delivering to these estimates
• Expert level of proficiency with IBM Cognos 8.x and/or 10.x, 11 a plus (Analytics)
• Proficient with Data Warehouse technologies and concepts such as dimensional modeling and cube development
• Knowledgeable of all aspects of Microsoft Power Platform is a plus
• Ability to write reports, business correspondence and procedural manuals
• Ability to effectively present information and respond to questions from groups of managers, clients, and customers
• Ability to define problems, collect data, establish facts and draw valid conclusions
• Working knowledge of data repository needs of the Microsoft Azure product stack
• Familiar with Agile / Scrum methodologies

SALARY RANGE 
The specific base salary offered to a successful applicant will be based on individual qualifications, skills, experience, and education. The pay range is subject to change at any time based on various internal and external factors. The position may also be eligible for one or more performance-based bonuses. In addition to cash compensation, BMI offers a competitive portfolio of benefits to its employees, as described below.

What We Give to You:

• Health, dental, and vision insurance
• 401K with employer match
• Flexible spending accounts
• Paid vacation and paid sick/personal time
• 12 paid calendar holidays
• Paid volunteer time off
• Summer hours that offer more time for fun in the sun
• Company paid life insurance
• Up to 12 weeks paid parental leave
• Tuition assistance for qualified team members
• Commuter benefits (New York)
• Amazing and engaging culture
• Employee Resource Groups

BROADCAST MUSIC, INC. IS AN EQUAL OPPORTUNITY EMPLOYER: All applicants will receive equal opportunity for employment without regard of race, color, sex, religion, nationality, age, sexual orientation, gender identity and/or expression, veteran’s or marital status, disability, or any other cultural factor.

#LI-Hybrid