Business Intelligence Developer

Job Summary

Dynamo Technologies LLC is seeking a Business Intelligence Developer to support the Consumer Financial Protection Bureau (CFPB). The selected candidate will design, develop, and maintain business intelligence solutions that transform enterprise data into meaningful insights for stakeholders across the organization.

• Design, develop, and maintain interactive dashboards, reports, and data visualizations using Microsoft Power BI Desktop, Power BI Service, DAX, and related Power Platform tools.
• Develop and maintain Canvas and Model-Driven applications using Microsoft Power Apps.
• Identify, troubleshoot, and resolve complex technical issues related to business intelligence solutions, data sources, reporting content, user access, and application performance.
• Develop and maintain data models that support enterprise reporting and analytics initiatives.
• Extract, transform, cleanse, and prepare data using ETL tools, scripting languages (Python, R, or similar), and other data preparation technologies.
• Write and optimize complex SQL queries against enterprise databases such as PostgreSQL and Microsoft SQL Server.
• Develop automated reporting workflows and integrations utilizing Power BI REST APIs and Microsoft Power Platform capabilities where appropriate.
• Support users by providing technical assistance, troubleshooting, and documentation for business intelligence solutions.
• Deliver end-user training on Microsoft Power Platform applications, including Power BI and Power Apps, in both one-on-one and classroom settings.
• Collaborate with business stakeholders to gather reporting requirements and translate business needs into scalable reporting solutions.
• Participate in the full software development lifecycle, including requirements analysis, development, testing, deployment, and maintenance.
• Maintain documentation for data models, reporting solutions, and development standards.

• Minimum of two (2) years of experience developing data models, dashboards, and interactive visualizations using Microsoft Power BI (Power BI Desktop, Power BI Service, DAX, and related tools).
• Minimum of two (2) years of experience developing Canvas Apps and Model-Driven Apps using Microsoft Power Apps.
• Minimum of two (2) years of experience developing data transformation, analytics, or ETL solutions utilizing scripting languages such as Python or R.
• Minimum of one (1) year of experience developing complex SQL queries against enterprise databases such as PostgreSQL or Microsoft SQL Server.
• Experience developing user interface components using HTML, CSS, JavaScript, or similar front-end technologies (preferred but not a primary focus).
• Strong understanding of data modeling principles and relational databases.
• Experience troubleshooting and supporting business intelligence applications.
• Ability to communicate technical concepts effectively with both technical and non-technical users.
• Strong analytical, problem-solving, and organizational skills.
• Experience providing end-user training and documentation.
• Proficiency with Microsoft Office Suite.

• Experience developing workflows using Power Automate (cloud flows).
• Experience working with Microsoft Dataverse.
• Experience using Power BI REST APIs.
• Experience developing solutions using Power Virtual Agents (Power Virtual Data Agents).
• Experience working in Linux environments.
• Experience deploying or supporting Azure or AWS cloud services.
• Experience developing embedded analytics solutions.
• Experience with additional ETL or data integration tools.

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, Statistics, Economics, or a related quantitative field.

Minimum of two (2) years of professional experience developing business intelligence solutions using Microsoft Power Platform technologies. Equivalent combination of education and relevant experience may be considered.

Must be able to successfully complete and maintain the background investigation required to obtain and retain access to Consumer Financial Protection Bureau (CFPB) systems and facilities.

105,000k to 125,000k annually.

Dynamo Technologies is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, pregnancy, disability, protected veteran status, age, or any other characteristic protected by law.