Job Title: PowerBI Developer Location: New York, NY (Onsite) Duration: Long Term Mostly Required: (Experience in Capital Markets is must) Job Description: Responsibilities:
- Participate in discussions with business partners to define key business questions, translate them into necessary requirements documentation and develop visual data-driven solutions.
- 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.
- Able to develop calculations in SQL, DAX and Power BI measures which are accurate and performant on large datasets.
- Able to use M language to build loops, pull APIs, etc.
- Able to assist with governance and deployment of Power BI, including administration, content distribution/sharing, training and support.
- Able to lead Power BI design methodology and best practices.
- Able to extract data from various data sources; perform exploratory data analysis, cleanse, reshape, and aggregate data.
- Proactively monitor and evaluate the impact of monthly Power BI releases.
- Able to conduct deep-dive data analysis for business insights and recommendations, including ad hoc analytics for executive-level requests and priorities.
Requirements:
- Overall 10+ years of experience is required.
- Minimum 8+ years of experience with Power BI development, visualizations and deployment is required.
- 8+ years of experience with MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX
- 5 + Years of experience in documenting business requirements, processes, and workflows
- Good experience with configuration / management of Microsoft Power BI Service
- Good Experience in extracting, manipulating, and analysing data via Dataflows, DataMart, Dashboards and Apps to recommend and/or take action.
- Strong experience in working with relational databases: SQL Server
- Proficient Data Architecture and Modeling experience (Structuring Tables, Attributes, and Relationships [One-to-One, One-to-Many, Many-to-One, Many-to-Many])
- Experience in Capital Markets is must .
Good to have:
- Microsoft Power BI Certification is a plus.
- AWS Cloud and/or Snowflake experience is a plus.
- Advanced level of MS Excel skills with knowledge of functions, macros, and VBA programming
Benefits: W2 Candidate Required. Pay Rate: $55 - $65/Hr on W2. Benefits Provided. Any Visa who can work on our W2. H1B Transfer is okay.