Power BI & Power Apps Developer

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’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.