Power BI & SQL Data Analyst

Paynecrest-Electric,-Inc.; Creve Coeur (MO); On-site; USD 85,000 - 110,000; Full time

Job summary

PayneCrest Electric, Inc. in Saint Louis, Missouri, is seeking a Business Systems Analyst to support contract administration, data integration, and reporting.

The role partners with software developers and business teams to design, develop, and support data-driven solutions, focusing on Power BI reporting, SQL development, and automation. The ideal candidate has a Bachelor’s degree in a related field and 3+ years of experience in data analysis, reporting, and application support, with strong

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

Python basics

APIs

ETL processes

Education

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

Tools

Power BI

DAX

Power Query

Data modeling

SQL

Python (basic)

APIs

ETL

Job description

PayneCrest Electric, Inc. in Saint Louis, Missouri, is seeking a Business Systems Analyst to support contract administration, data integration, and reporting.

The role partners with software developers and business teams to design, develop, and support data-driven solutions, focusing on Power BI reporting, SQL development, and automation. The ideal candidate has a Bachelor’s degree in a related field and 3+ years of experience in data analysis, reporting, and application support, with strong