Experience level: Mid-senior
Experience required: 5 Years
Education level: Bachelor’s degree
Job function: Information Technology
Industry: Financial Services
Total position: 3
Visa : Only US citizens and Green card holders
This is a contract to hire role !
Key requirements are self-motivated, critical thinker with knowledge of the Microsoft Power Platform (including certifications).
Essential Job Functions
- Translate complex business, functional and technical requirements into custom design and development of Microsoft Power Platform-based applications.
- In depth knowledge of Microsoft Power Platform
- Understanding of complex business requirements and able to turn them into technical solutions using primarily using Microsoft’s Power Platform
Self-motivated, problem solver with critical-thinking and decision-making skills. - Perform analysis, design, development, testing, and debugging of custom developed Microsoft Power Platform-based applications.
- Analyzes functional business applications and design specifications.
- Analyzes functional problems and determines techniques and requirements most feasible for processing the data.
- Develops analytical reports or other products.
- Support existing Power Platform solutions already developed by the team.
- Support projects in development plans, estimation, and code and design reviews.
Technical Requirements
- Build sustainable data pipelines using Power BI dataflows.
- Make connections to a variety of disparate data sources with dataflows including SharePoint online, on-prem databases, and web connections with APIs.
- Develop dataflow using best practices including layered architecture, leveraging enhanced compute engine, performant joins, linked tables, incremental refresh and error handling with try...otherwise
- Write complex SQL queries for relational databases such as Microsoft SQL Server and Oracle
- Write custom M functions where out-of-the-box functions are not sufficient.
- Build Power BI datasets, dashboards, and paginated reports
- Build models according to best practice including star and snowflake schemas,
- Use of relationship modeling DAX functions including but not limited to: RELATED, RELATEDTABLE, USERELATIONSHIP, CROSSFILTER
- Implement Row Level Security
- Build complex DAX functions to create measures, calculated columns, and new tables
- Build a variety of out-of-the-box and custom visualizations. Provide SME guidance on what visualizations to meet business requirements
- Optimize new and existing models and provide best practice guidance including use of the performance analyzer.
- Troubleshoot error messages and perform testing to ensure dashboards are functional.
- Power BI Online Service
- Push reports from Power BI desktop to the Power BI service
- Use Power BI data gateways and schedule refreshes. Troubleshoot refresh error messages
- Administer workspaces including permissions and sensitivity labels.
- Learn new features as they become available such as deployment pipelines and streaming dataflows.
- Power BI Report Builder
- Ability to create and maintain various reports, especially paginated reports, in Power BI Report Builder
- Power Automate
- Create Power Automate Flows that access data from SharePoint Online Lists and Excel files
- Familiar with Power Automate expressions and dynamic content
- Debug Power Automate Flows that may be failing for various reasons
- Build and maintain Microsoft Power Apps solutions for creating and updating data in SharePoint lists
Additional Skills
- Significant subject matter expertise in Microsoft O365 Applications, especially Excel
- Demonstrate deep industry knowledge of Microsoft Power Apps and SharePoint Online is a plus.
- Knowledge of HTML especially tables, formatting, and style
- Use of JIRA for project management
Certification in one or more of the following:
o PL-300: Microsoft Power BI Data Analyst Associate
o PL-400: Microsoft Power BI Developer
o PL-400: Microsoft Power Platform Developer Associate
o PL-500: Microsoft Power Automate RPA Developer Associate
o PL-600: Microsoft Power Platform Solutions Architect
o PL-900: Microsoft Power Platform Fundamentals