Business Solutions Analyst

Get AI-powered advice on this job and more exclusive features. Direct message the job poster from BruntWork Mondays to Fridays, 9:00 am to 6:00 pm, Edmonton, Canada (EST) Overview We are seeking a Business Solutions Analyst who will act as the bridge between business stakeholders and technology teams, ensuring that data driven solutions, automation, and process improvements are effectively designed and implemented. This role combines business analysis skills (requirements gathering, process mapping, stakeholder management) with technical expertise in Power BI, SQL, and Power Automate to deliver insights and streamline workflows. Responsibilities Engage with stakeholders to gather and document business requirements. Analyze current workflows, identify inefficiencies, and design future state process maps. Translate business needs into clear functional specifications for technical teams. Support change management and adoption of new solutions. Develop and maintain Power BI dashboards that provide real-time, actionable insights. Build optimized data models and use DAX and Power Query for advanced calculations. Collaborate with business units to design dashboards that support decision-making. Design and deploy workflow automations using Power Automate (cloud and desktop). Automate manual tasks to improve efficiency and accuracy. Integrate automation solutions with applications, databases, and reporting tools. Write and optimize SQL queries to extract, clean, and transform data from relational databases. Partner with IT/data teams to design data pipelines that feed into BI and automation solutions. Ensure data accuracy, consistency, and compliance with governance policies. Act as a liaison between technical teams and business users, ensuring alignment on requirements and outcomes. Provide training and support to business teams adopting new dashboards or workflows. Identify opportunities for ongoing automation, analytics, and process improvements. Requirements Proven experience as a Business Analyst, Data Analyst, or Business Solutions Specialist. Strong expertise in Power BI (DAX, Power Query, data modeling). Proficiency in SQL for querying, reporting, and data transformation. Experience with Power Automate (cloud and desktop) for workflow automation. Strong skills in process mapping (Visio, Lucidchart, or similar tools). Ability to communicate technical solutions clearly to non-technical stakeholders. Knowledge of the Software Development Lifecycle (SDLC) and Agile principles. Preferred Skills Familiarity with Power Apps or other low-code application platforms. Experience working with cloud platforms (Azure, AWS, or GCP). Background in change management and business transformation projects. Strong problem-solving skills with a focus on delivering measurable business outcomes. HMO coverage for eligible locations Permanent work from home Immediate hiring Steady freelance job Please note that since this is a permanent work-from-home position and an “Independent Contractor” arrangement, the candidates must have their own computer and internet connection. They will handle their benefits and taxes. The professional fees are at hourly rates, and the rate depends on your performance in the application process. Note Please apply directly to the link provided; you will be redirected to BruntWork’s Career Site and must complete the initial requirements, including pre-screening assessment questions, a technical check of your computer, and a voice recording. Applications with complete requirements will be prioritized. Seniority level Mid-Senior level Employment type Contract Job function Research and Business Development Industries Staffing and Recruiting #J-18808-Ljbffr