Responsibilities:

· Core team member of a high-performance business analytics and executive performance management team that translates business information into business value to achieve corporate business goals and objectives

· Develop, deploy, manage, and support advanced analytic and business performance management solutions for executive leadership teams

· Document requirements and translate into proper system requirements specifications using high-maturity methods, processes and tools.

· Develop visualization, user experience and configuration elements of solution design.

· Execute and coordinate requirements management and change management processes.

· Participates as a member of and leads Azure Analysis Services efforts.

· Designs, prepares and executes testing, performance benchmarking, and subsequent deployment of model improvements across multiple models.

· Completes development to implement complex components.

· Designs solutions for others to develop.

· Participates in cross-functional teams.

· Leads design activities and provides mentoring and guidance to developers.

· Demonstrates technical leadership and makes strategic and tactical recommendations to executive team on design and deployment patterns.

· Participates in Product Roadmap conversations, bringing technical expertise to intersect with Innovation requirements.

· Applies in-depth or broad technical knowledge to provide maintenance solutions across one or more technology areas (e.g. Azure Analysis Services, SQL Server, Power BI, and Power App development).

· Integrates technical expertise and business understanding to create superior solutions for clients.

· Consults with team members and other organizations, clients and vendors on complex issues.

Knowledge and Skills:

· Building business intelligence solutions in a SQL Server environment

· Tabular and Multidimensional SSAS design and development

· Expert level DAX

· Senior level SQL

· Development experience with Snowflake

· Power BI on-Prem and Cloud experience, to include application of security models, RLS

· Leveraging Source Control to document model modifications

· Building and modifying stored procedures, functions, creating tables and views

· SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)

· Experience setting up and tuning data gateways

· Experience in SSAS performance profiling to identify optimization opportunities

· Passion for technology specifically related to data, dashboards, reports and analytics

· Strong working knowledge of star and snowflake schema(s)

· Strong analytical skills and the ability to learn new technologies

· Ability to meet tight deadlines

· Must be a team player who loves to code and can thrive on a team that is mostly remote

· Predictive analytics experience is a plus as well as strong understanding of basic Database Administration

· Able to define quality and security standards

· Good verbal and written communication and negotiation skills

· General project management/team leader skills

· Ability to work effectively in a globally dispersed team and with clients and vendors

· Demonstrated technical leadership skills