PowerApps Specialist

Role Purpose

The Senior Software Developer is responsible for designing, developing, and maintaining internal software products that support the operations of J Browne Construction Co Ltd. Working primarily on Microsoft PowerPlatform, the developer will have responsibility for a number of pioneering construction products and will be at the forefront of developing technology for the business.

Key Responsibilities

• Application Development
  • Designing, developing, and maintaining PowerApps solutions using the low-code platform.
  • Creating user interfaces, integrating with data sources, implementing business logic, and ensuring the application meets functional requirements.
• Database Design and Management
  • Creating and managing SQL databases to store application data.
  • Designing the database schema, defining relationships between tables, setting up indexes for performance optimization, and ensuring data integrity.
• Data Integration
  • Integrating various data sources, including SQL databases, SharePoint lists, Excel files, and external APIs.
  • Configuring data connections, importing/exporting data, and implementing data transformation processes.
• Business Logic Implementation
  • Implementing complex business logic within PowerApps using formulas, functions, and expressions.
  • Validating user input, performing calculations, enforcing security policies, and automating workflows.
• Performance Optimization
  • Optimising the performance of solutions and SQL databases to ensure fast response times and efficient resource utilisation.
  • Tuning SQL queries, optimizing data retrieval processes, and minimising network latency.
• Security Implementation
  • Implementing security measures to protect sensitive data and prevent unauthorized access to PowerApps and SQL databases.
  • Configuring role-based access controls, encrypting data at rest and in transit, and implementing authentication mechanisms.
• Testing and Debugging
  • Testing PowerApps solutions to identify and fix bugs, ensuring the application functions correctly across different devices and screen sizes.
  • Performing unit tests, integration tests, and user acceptance testing.
• Documentation and Governance
  • Documenting the design, implementation, and configuration of PowerApps solutions and SQL databases.
  • Creating technical documentation, user manuals, and training materials to help users understand and use the applications effectively.
• Collaboration and Communication
  • Collaborating with stakeholders, including business users, project managers, and other developers, to gather requirements, provide updates on project progress, and solicit feedback.
  • Effective communication skills are essential for clarifying requirements and resolving issues.
• Continuous Learning
  • Staying updated with the latest developments in PowerApps, SQL, and related technologies to enhance skills and improve the quality of solutions.
  • Attending training sessions, participating in online communities, and experimenting with new tools and techniques.
• Additional Responsibilities
  • Carrying out any other duties appropriate to this post.

Key Competencies

Candidate Specification

Personal Attributes

• Excellent communication and interpersonal skills
• Strong problem-solving and analytical skills, with a focus on delivering results
• Ability to manage multiple projects concurrently and meet tight deadlines

Technical Specification

Experience Required

• Proven experience in project management, with a focus on digital change and transformation projects
• Strong experience with the Microsoft PowerPlatform, SQL, HTML, DAX and a thorough understanding of respective capabilities
• Demonstrated experience managing projects using Agile and Waterfall methodologies
• Experience in the water utilities construction industry or similar related field

Essential Qualifications

• Versatile, low-code and ideally pro-code developer with significant MS PowerApps experience.

Required Technologies

• Microsoft Power Platform
• MS Fabric
• MS PowerApps
• Microsoft Power Automate
• Data Warehousing
• Microsoft - SQL Server
• Microsoft - SQL Server Management Studio (SSMS)
• MS Azure - SQL Database

Desirable Qualifications

• Dual qualification (software development and civil engineering) ideally construction/ utilities sector experience, degree qualified Civil Engineer.
• Useful:
• Python
• PHP
• PostgreSQL
• Java
• Microsoft - PowerBI
• Microsoft - Visual Studio
• Microsoft - SharePoint
• MS Azure - Data Factory
• MS Azure - Synapse
• MS Azure - DataBricks
• MS Azure - DevOps
• PowerShell
• MS Azure - Logic Apps
• MS AI Builder/ Azure ML

Benefits

• Competitive Salary
• 25 days annual leave
• Long Service Scheme
• Car allowance (if deemed business user) - £5,670 per annum
• Access to Group Pension Scheme after completion of probation
• Life Assurance and Critical Illness cover if joining pension scheme
• Healthcare cover for employee only
• Access to Employee Assistance Programme & Medicash after successful completion of probation
• CSR Programme (3 days supported per annum)
• Continuous Development Opportunities

Equal Opportunities Employer

J Browne Construction Co Ltd is an equal opportunities employer and is committed to the equal treatment of all current and prospective employees. We do not condone discrimination on the basis of age, disability, sex, sexual orientation, pregnancy and maternity, race or ethnicity, religion or belief, gender identity, or marriage and civil partnership.

Job Type

Full-time

Pay

£70,000.00-£80,000.00 per year

Schedule

• Monday to Friday

Application Question(s)

• Do you have proven experience in project management, with a focus on digital change and transformation projects?
• Do you have strong experience with the Microsoft PowerPlatform, SQL, HTML, DAX and a thorough understanding of respective capabilities?
• Can you demonstrate experience managing projects using Agile and Waterfall methodologies?
• Do you have experience in the water utilities construction industry or similar related field?

Work Location

In person