Job Description
Job Requirement:
- 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-throughs) 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
Job Types: Full-time, Permanent
Salary: $100,000.00-$115,000.00 per year
Benefits:
- Disability insurance
- Life insurance
Schedule:
Ability to commute/relocate:
- Montreal, QC: reliably commute or plan to relocate before starting work (required)
Education:
- Bachelor's Degree (preferred)
Language:
Speak with the employer
+91 7000810082
Apply
Go Back