BUSINESS SYSTEMS ANALYST

 

Headquartered in St. Louis, Missouri, PayneCrest Electric, a Primoris Company, is a nationally recognized electrical contractor and trusted partner in delivering some of the industry's most complex and technically demanding projects. Our competitive advantage is our people-first culture, which empowers teams to make decisions, solve problems, and deliver safe, efficient, and innovative solutions while growing and succeeding together.

We are seeking a Business Systems Analyst to support the development, integration, and optimization of business systems and data-driven solutions. This role works closely with software developers, business analysts, and internal stakeholders to enhance reporting capabilities, improve data integrity, streamline business processes, and support application development. Key areas of focus include Power BI reporting, SQL development, data integration, systems analysis, and process automation.

 

KEY RESPONSIBILITIES:

  • Design, develop, and maintain Power BI reports, dashboards, data models, security configurations, and data connections to support business intelligence and decision-making.

  • Develop, optimize, and troubleshoot SQL queries, stored procedures, and data extracts to support reporting, analytics, and application functionality.

  • Collaborate with software developers and business stakeholders to identify requirements, design solutions, and implement application enhancements.

  • Analyze data sources, identify inconsistencies, and support data quality, integrity, and governance initiatives.

  • Develop and maintain scripts, code, and automated solutions to streamline workflows, improve efficiency, and reduce manual processes.

  • Support system integrations, data mapping, and API-based data exchanges across business applications.

  • Investigate, troubleshoot, and resolve application, database, and reporting issues through effective root cause analysis.

  • Participate in technical design discussions, evaluate system capabilities, and recommend improvements to existing applications and processes.

  • Conduct unit testing, system testing, and support user acceptance testing (UAT) to ensure functionality, accuracy, and reliability.

  • Develop and maintain technical documentation, including reporting specifications, data flows, system configurations, and business processes.

  • Support the development, implementation, and maintenance of Microsoft Power Platform solutions, including Power Apps and Power Automate workflows.

 

QUALIFICATIONS:

  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.

  • 3+ years of experience in business systems analysis, data analytics, business intelligence, application support, or software development.

  • Strong proficiency in Power BI, including DAX, Power Query, data modeling, and dashboard development.

  • Demonstrated experience writing, optimizing, and troubleshooting SQL queries and working with relational databases.

  • Experience collaborating with software developers and business stakeholders in application development or enhancement initiatives.

  • Working knowledge of Python or a similar programming language, with the ability to develop, modify, and troubleshoot scripts or basic applications.

  • Understanding of APIs, data integration, ETL processes, and system connectivity.

  • Strong analytical, problem-solving, and troubleshooting skills, with the ability to translate business requirements into technical solutions.

  • Effective communication and organizational skills, with the ability to collaborate across technical and nontechnical teams.

 

PREFERRED QUALIFICATIONS:

  • Experience with Microsoft Azure data and analytics tools.

  • Experience developing or supporting solutions using Microsoft Power Apps and Power Automate.

  • Familiarity with cloud-based forms and workflow platforms, such as Cognito Forms.

  • Experience with Trimble Vista ERP or similar construction management and accounting systems.

  • Knowledge of data warehousing concepts, dimensional modeling, and database architecture.

  • Familiarity with Agile/Scrum development methodologies.

  • Experience supporting financial, operational, or project-based reporting systems.

  • Previous experience in the construction, engineering, or related industries.

 

LOCATION:

St. Louis, MO

 

COMPENSATION:

  • Competitive salary commensurate with experience

  • Bonus opportunity

  • Comprehensive benefits package, including medical, dental, and vision insurance, a matching 401(k) program, and additional employee benefits.

 

We are proud to be an EEO/AA employer M/F/D/V. As part of the hiring process, all applicants will be required to submit to and successfully pass a pre-employment urine drug screening and background check.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Equal Opportunity Employer, including disabled and veterans.
View Company Information

To see other positions, click here.