Senior Power BI Developer

Requirements:

• Experience with Power BI development, visualizations and deployment. (8+ years)
• Experience with the Microsoft BI stack, including TSQL, PowerBI, Power Query, DAX, M, MDX and, SSAS, SSRS, SSIS. (8+ years).
• Experience with configuration / management of Microsoft Power BI Service Experience extracting, manipulating and analyzing data via Dataflows, Datamarts, Dashboards and Apps to recommend and/or take action. (8+ years).
• Demonstrated SQL development experience by writing queries and procedures and also using functions to create curated data for use in reporting.
• Excellent written, verbal and presentation skills.
• AWS Cloud and/or Snowflake experience is a plus.
• Understand glossaries and terminologies in end-to-end skills and financial industry.
• Experience documenting business requirements, processes and workflows. (5+ years)
• Advanced level of MS Excel skills with knowledge of functions, macros, and VBA programming is preferred.
• Must be detail oriented, and able to work independently and self-prioritize tasks.
• Demonstrated experience in working with relational databases: SQL Server (8+ years).
• Bachelor's degree in Computer Science, Design, Statistics, or equivalent.
• Microsoft Power BI Certification is a plus.

Responsibilities:

• Participate in discussions with business partners to define key business questions, translate them into necessary requirements documentation and develop visual data-driven solutions which answer those questions.
• Develop reports, thoughtful visualizations , dashboards and KPI scorecards using Microsoft's Power BI and Azure stack employing leading visualization techniques.
• Perform UX design activities and Power BI navigation features (e.g. bookmarks, drill-through) to guide end-users through a data-driven story.
• Develop calculations in SQL, DAX and Power BI measures which are accurate and performant on large datasets.
• MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX.
• Work with our internal customers to manage User Acceptance Testing (UAT) processes and address their feedback.
• Power Query and coding fundamentals. (ability to use M language to build loops, pull APIs, etc.)
• Assist with governance and deployment of Power BI , including administration, content distribution/sharing, training and support.
• Proficient Data Architecture and Modeling experience (Structuring Tables, Attributes, and Relationships. [One-to-One, One-to-Many, Many-to-One, Many-to-Many])
• Champion the leading Power BI design methodology and best practices.
• Extract data from various data sources ; perform exploratory data analysis, cleanse, reshape, and aggregate data.
• Evangelize data analytics best practices among peers and stakeholders.
• Proactively monitor and evaluate the impact of monthly Power BI releases.
• Conduct deep-dive data analysis for business insights and recommendations, including ad hoc analytics for executive-level requests and priorities.