Business Systems Analyst

PayneCrest Electric, Inc.; St. Louis (MO); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Bonus opportunity

Competitive benefits package including

EEO/AA employer

Job summary

PayneCrest Electric, Inc. in St. Louis, MO is seeking a Business Systems Analyst to support contract administration, data integration, and Power BI-driven reporting.

You will collaborate with software developers and business analysts to design, develop, and support data-driven solutions while focusing on automation and data governance. The role emphasizes SQL development, API-based data exchanges, and Power Platform support, with a pathway to optimize processes and improve reporting across

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field.
• 3+ years of experience in data analysis, reporting, application support, or development.
• Strong experience with Power BI, DAX, Power Query, and data modeling.
• Proficiency in SQL and relational databases.
• Experience working with developers in application development environments.
• Intermediate knowledge of Python (or similar) with the ability to develop or modify simple code.
• Functional understanding of APIs, data integration, and ETL processes.
• Strong troubleshooting and analytical skills.

Responsibilities

• Develop and maintain Power BI reports, data models, data security and connections.
• Write, modify, and troubleshoot SQL queries, stored procedures, and data extracts.
• Work closely with developers to design, test, and implement application enhancements.
• Analyze data sources, identify data quality issues, and support data governance efforts.
• Develop simple code, scripts, and automated solutions to improve business processes.
• Assist with system integrations, data mapping, and API-based data exchanges.
• Support troubleshooting and root cause analysis for application and reporting issues.
• Participate in technical design discussions and solution development.
• Perform unit testing, system testing, and user acceptance testing support.
• Create and maintain technical documentation for reports, data flows, and system processes.
• Support Power Platform solutions including Power Apps and Power Automate workflows.

Skills

Power BI

DAX

Power Query

Data modeling

SQL

APIs

ETL

Python

Data integration

Agile/Scrum

Education

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

Tools

Azure data tools

Power Apps

Power Automate

Cognito Forms

Trimble Vista ERP

Job description

BUSINESS SYSTEMS ANALYST

Headquartered in St. Louis, Missouri, PayneCrest Electric, a Primoris Company, is a nationally recognized electrical contractor and trusted partner for delivering the industry's most complex and technically demanding projects. Our competitive advantage is our people-first culture; empowering 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 administration, review, and management of construction contracts and related project documentation. The Business Systems Analyst partners with software developers and business analyst teams to design, develop, and support data-driven solutions. This role focuses on data integration, Power BI reporting and data management, SQL development, and technical analysis while assisting with application enhancements and process automation.

Key Responsibilities

• Develop and maintain Power BI reports, data models, data security and connections.
• Write, modify, and troubleshoot SQL queries, stored procedures, and data extracts.
• Work closely with developers to design, test, and implement application enhancements.
• Analyze data sources, identify data quality issues, and support data governance efforts.
• Develop simple code, scripts, and automated solutions to improve business processes.
• Assist with system integrations, data mapping, and API-based data exchanges.
• Support troubleshooting and root cause analysis for application and reporting issues.
• Participate in technical design discussions and solution development.
• Perform unit testing, system testing, and user acceptance testing support.
• Create and maintain technical documentation for reports, data flows, and system processes.
• Support Power Platform solutions including Power Apps and Power Automate workflows.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field.
• 3+ years of experience in data analysis, reporting, application support, or development.
• Strong experience with Power BI, DAX, Power Query, and data modeling.
• Proficiency in SQL and relational databases.
• Experience working with developers in application development environments.
• Intermediate knowledge of Python (or similar) with the ability to develop or modify simple code.
• Functional understanding of APIs, data integration, and ETL processes.
• Strong troubleshooting and analytical skills.

Preferred Qulaifications

• Experience with Microsoft Azure data and analytics tools.
• Experience with Power Apps and Power Automate.
• Experience with cloud-based forms software such as Cognito Forms.
• Experience with Trimble/Vista ERP.
• Knowledge of data warehousing concepts and dimensional modeling.
• Familiarity with Agile/Scrum development methodologies.
• Experience supporting financial or operational reporting systems.

LOCATION:

St. Louis, MO

Compensation

• Salary commensurate with experience
• Bonus opportunity
• Competitive benefits package including health, dental, matching 401k program, etc.

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