Job Seekers, Please send resumes to resumes@hireitpeople.com

Detailed Job Description:

Analyzes functional business applications and design specifications. Develops and prepares computer systems requirements and develops procedures to process data. Analyzes functional problems and determines techniques and requirements most feasible for processing the data. Prepares definition of functional problems and makes recommendations for equipment and/ or software to deliver solutions. Develops analytical reports or other products. Translate complex business, functional and technical requirements into custom design and development of Microsoft Power Platform-based applications. Perform analysis, design, development, testing, and debugging of custom developed Microsoft Power Platform-based applications. Support projects in development plans, estimation, and code and design reviews. Self-motivated, problem solver with decision-making skills.

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

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

DA-100 Power BI Data Analyst Associate or PL-300: Microsoft Power BI Data Analyst (preferred)

Minimum years of experience*: 8