Power BI & Power Apps Developer United States Remote

Aperia; Northern (KY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Aperia Solutions, a Texas-based fintech and managed consultancy, seeks a Power BI & Power Apps Developer to build scalable BI and automation solutions for payments and compliance clients. You will work with stakeholders to define requirements, develop dashboards and apps, and automate business processes using the Microsoft Power Platform.

Ideal candidates have 3+ years of BI/program management experience, strong SQL skills, and hands-on Power BI and Power Apps development experience.

Qualifications

• 3+ years of experience in business/IT data, BI, or related fields.
• Hands-on experience with Power BI and Power Apps development.
• Strong SQL development and data modeling skills.

Responsibilities

• Meet with stakeholders to define data, reporting, and process requirements.
• Develop, maintain, and publish Power BI reports and dashboards for internal and external partners.
• Design and develop Power Apps applications to automate business processes and improve efficiency.
• Lead projects to enhance data, reporting, and app capabilities, focusing on data quality and automation.
• Create Power BI dashboards that surface insights by KPIs, trends, and performance.
• Collaborate with SMEs to analyze data and present findings to management.
• Integrate Power Apps with Dataverse, SQL Server, SharePoint, and other systems.
• Develop and maintain Power Apps solutions including Canvas Apps, forms, workflows, and automation.
• Support data models, datasets, data refreshes, security, and report performance.
• Assist business and finance stakeholders on ongoing initiatives and processes.
• Troubleshoot Power BI reports, Power Apps, data sources, and workflows.

Skills

Power BI

Power Apps

SQL

Data modeling

DAX

Tools

Dataverse

SQL Server

SharePoint

Power Automate

Power Platform

Job description

Join Aperia Solutions, a leader in SaaS solutions for the Payments and Compliance industries. Aperia is a Texas-based fintech and managed consultancy firm that creates custom SaaS applications and other software-based solutions for the payments, banking, and processing industry. Founded in 1999, Aperia offers business intelligence, risk management, compliance, and customer intelligence platforms. With offices in Dallas, Washington DC, and Vietnam, Aperia is a fast-paced, global organization that strives to improve efficiency in compliance, risk, and customer service operations. Aperia’s clients include banks, processors, payment facilitators, merchant service providers, independent sales organizations, and government entities. A career at Aperia promises a great challenge, culture, and opportunities to forge your own path.

At Aperia, we rely on a dynamic team of developers. We’re seeking a Power BI & Power Apps Developer who is ready to work with new technologies and architectures in a forward-thinking organization that’s always pushing boundaries. This person will have a strong SQL development background, hands‑on experience with Power BI development , and experience developing business applications using Microsoft Power Apps .

Core Responsibilities

• Meet with key stakeholders to define data, reporting, application, and business process requirements.
• Develop, maintain, and distribute daily, weekly, and monthly Power BI reports and dashboards for internal and external partners.
• Design and develop Power Apps applications to automate business processes, improve operational efficiency, and address business needs.
• Lead projects to enhance data, reporting, and application capabilities, including data quality, data attributes, workflow automation, and the reduction of manual processes.
• Develop Power BI dashboards and reports that proactively surface useful insights by assessing key performance indicators (KPIs), trends, and business performance.
• Partner with business and technical SMEs to understand relevant data, analyze and perform necessary deep dives to solve business problems, and summarize and present findings to management.
• Integrate Power Apps with data sources such as Dataverse, SQL Server, SharePoint, and other enterprise systems as appropriate.
• Develop and maintain Power Apps solutions, including Canvas Apps, forms, workflows, and business process automation.
• Support Power BI data models, datasets, data refreshes, security, and report performance.
• Provide support to business and finance stakeholders on various ongoing and ad‑hoc initiatives and processes.
• Troubleshoot issues related to Power BI reports, Power Apps applications, data sources, and automated workflows.

Technical Skills

• 3+ years of experience in business and IT program or project management, application development, business intelligence, or a related field.
• Hands‑on experience developing solutions using Microsoft Power BI and Power Apps .
• Strong SQL development experience, including writing complex queries and working with relational databases.
• Experience developing Power BI dashboards, reports, data models, and visualizations.
• Experience with Power Apps development , including Canvas Apps, forms, controls, connectors, and business process automation.
• Experience working with Microsoft Dataverse and/or other Power Platform data sources.
• Experience with Power Automate for workflow and process automation is highly desirable.
• Experience in data‑driven management, metrics, analytics, and reporting.
• Strong Excel skills, including experience with macros, complex pivot tables, and charts/graphs.
• Familiarity with VBA and Python.
• Experience with the Financial Services and/or Payment industries is preferred.
• Strong problem‑solving skills with the ability to analyze complex business requirements and translate them into technical solutions.
• Strong communication and collaboration skills, with the ability to work effectively with business stakeholders, technical SMEs, and management.
• Strong work ethic with the ability to excel in a fast‑paced environment.

Things That Will Separate You from the Rest

• Previous experience in the Finance, Banking, Payments, or FinTech industry .
• Experience building Power Apps applications from requirements through deployment .
• Experience integrating Power Apps with SQL Server, Dataverse, SharePoint, APIs, or other enterprise data sources .
• Experience with Power Automate and end‑to‑end business process automation.
• Experience with Microsoft Power Platform administration, governance, security, and deployment.
• Experience optimizing Power BI data models, DAX, and report performance.
• Experience working with Microsoft Fabric, Azure, or other cloud data platforms .
• Experience translating manual business processes into scalable, automated Power Platform solutions.

Eligibility Requirements

• Must be willing to submit to a background investigation and drug test as part of the selection process.

Job Type

• Remote 3 month contract with possible extension

Schedule

• Monday to Friday

This job description is not intended to be all-inclusive. An employee may also perform other reasonable related business duties as assigned by their immediate supervisor or management. Principals only.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self‑identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Aperia’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service‑connected disability.

A "recently separated veteran" means any veteran during the three‑year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.