Business Intelligence Developer, APS

Control Solutions, Inc.; Pasadena (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

ADAMA Professional Solutions (APS) seeks a remote Senior BI/Applications Developer to design and maintain scalable business apps using Power Apps and Power Automate. You will design back-end data sources with SQL, build Power BI dashboards, and extend automation with Python.

You will collaborate with stakeholders across departments, ensure data governance, and integrate solutions with Microsoft 365 tools. 3+ years in similar roles preferred.

Qualifications

• Bachelor's degree required in CS/IS or related field.
• 3+ years in a business environment.
• 2+ years with Power BI, Tableau, or similar software.
• Proven experience building apps with Power Apps and Power Automate.
• Strong SQL skills: complex queries, views, stored procedures, joins, CTEs, window functions, aggregations.
• Strong troubleshooting and data governance understanding.
• Ability to translate business requirements into technical solutions.
• Excellent communication and stakeholder engagement; experience supporting Commercial Ops.

Responsibilities

• Design, develop, and maintain Power Apps applications to support business processes.
• Build intuitive UIs and robust app logic for approvals and decisions.
• Implement security, permissions, and role-based access controls for data governance.
• Manage application lifecycle: development, testing, deployment, training, support.
• Create Power Automate flows to automate repetitive tasks and enable Power Apps functionality.
• Integrate Power Platform with Microsoft 365 tools and enterprise systems.
• Monitor automation reliability and improve workflow performance.
• Adopt Python and other languages to expand capabilities and integration.

Skills

SQL proficiency

Data analysis

Communication

Stakeholder collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

Power Apps

Power Automate

SQL Server

Power BI

Tableau

SharePoint

Python

Job description

Job Description

Direct Manager: Business Intelligence Director

Direct Manager: Business Intelligence Director
Direct Reports: None
Location: Remote within US (Eastern, Central, Mountain time zone preferred)

The Company

ADAMA Professional Solutions (APS) brings together the strengths of Control Solutions, Inc. (CSI) and Alligare, LLC into a unified commercial unit within the ADAMA Group. This alignment enhances operational efficiency and customer support by combining CSI’s expertise in innovative and post‑patent chemical solutions with Alligare’s leadership as the nation’s largest post‑patent herbicide provider.

As a combined force, ADAMA APS delivers a broader, more integrated portfolio of professional vegetation management and pest control solutions—backed by ADAMA’s global scale, supply chain, and commitment to practical, high‑value product innovation.

Role Summary

This role is responsible for designing, building, and maintaining practical, scalable business applications and automations across the organization. This role primarily leverages Microsoft Power Apps and Power Automate to deliver user-friendly tools that improve process efficiency, data accuracy, and the ability to track business processes.

The developer will also use SQL to design and maintain back-end data sources and logic—including tables, views, stored procedures, and other database features—to support applications and related operational workflows. Over time, the role will expand to include additional coding languages (e.g., Python) as needed to enhance automation, integrate systems, and broaden technical capabilities.

Duties And Responsibilities

Power Apps & Power Automate

• Design, develop, and maintain Power Apps applications to support business processes across departments
• Build intuitive user interfaces and robust app logic to support approval workflows, exception handling, and operational decision-making
• Implement security, permissions, and role-based access controls to ensure appropriate data governance
• Manage application lifecycle activities including development, testing, deployment, training, and support
• Build and maintain Power Automate flows to automate repetitive tasks and enable Power Apps functionality
• Integrate Power Platform solutions with Microsoft 365 tools (SharePoint, Teams, Outlook, Excel) and other enterprise systems where applicable
• Monitor automation reliability, troubleshoot failures, and improve workflow performance over time
• Implement error-handling strategies and notifications to ensure operational continuity

SQL Development

• Create and maintain SQL Server data structures to support application development and other activities
• Support data cleansing, transformation, and logic required for workflow applications
• Over time, build the skills necessary to optimize SQL queries and database performance to support scalable app performance and reporting workloads

Reporting & Analytics Support

• Develop, maintain, and troubleshoot Power BI reports and dashboards as requested by the business
• Identify and resolve data issues impacting reporting accuracy or refresh performance

Skill Development/Broader Engineering Support

• Learn and apply Python and other programming or scripting languages as needed to expand solution capabilities
• Contribute to continuous improvement of internal development standards and best practices
• Proactively identify areas of concern for the business in the domain of analytics and application development and propose solutions
• Perform other duties as assigned or required.

Skills And Abilities

• Bachelor's degree required. Focus in Computer Science, Finance, Business Administration or related field preferred.
• A minimum of three (3) years of relevant experience in a business-related environment required.
• A minimum of two years of experience with Power BI, tableau, or similar software is required.
• Proven experience building business applications using Microsoft Power Apps and Power Automate
• Strong SQL skills, including experience writing and optimizing complex queries, view, stored procedures, joints, CTEs, window functions, and aggregations
• Strong troubleshooting skills—able to diagnose issues across applications, automations, and data sources
• Ability to translate business requirements into functional technical solutions
• Strong communication skills and ability to partner directly with stakeholders
• Experience supporting Commercial Operations functions (sales operations, pricing, forecasting, customer/account management, etc.)
• Familiarity with Power BI, including DAX and data modeling fundamentals
• Familiarity with Power BI Dataflows, refresh schedules, and troubleshooting refresh errors
• Exposure to Python for automation, ETL, or scripting
• Experience with SharePoint lists/libraries as operational data sources
• Understanding of data governance concepts (permissions, auditing, controlled)

ADAMA Professional Solutions is an Equal Opportunity Employer and does not discriminate in recruitment, hiring, training, promotion or any other employment practices for reasons of race, color, religion, gender, national origin, age, sexual orientation, marital or veteran status, disability, or any other legally protected status