Senior Business Systems Analyst - Data, Power BI, ETL

Partner with Business Transformation and functional leaders (operations, finance, HR, safety, marketing, project management, etc.) to understand questions and translate them into data requirements and reports.

· Build, maintain, and improve Power BI reports and dashboards that surface KPIs for projects, plants, and business units (safety, production, margins, utilization, etc.).

· Write and optimize SQL queries to extract, join, and transform data from ERP systems and other data platforms as integrations mature.

· Develop and maintain data models, semantic layers, and reusable datasets to reduce report sprawl and standardize definitions across the business.

· Perform ad-hoc analysis to support project bids, cost investigations, process improvement initiatives, and leadership requests.

· Document data sources, metric definitions, and report logic in clear, business-friendly language.

· Help define and implement data quality checks, reconciliation routines, and simple monitoring for data pipelines in collaboration with IT or vendors.

· Educate and support stakeholders on how to use dashboards, interpret metrics, and self-serve where appropriate.

Do you have experience in SharePoint?, Do you have a Bachelor’s degree?, · Bachelor’s degree in data Analytics, Business, Information Systems, Finance, or related field (or equivalent experience)

· 9-12+ years of experience in a Data Analyst or similar role

· Experience with Power BI: data modeling, DAX, measures, calculated columns, basic row-level security, and dashboard design.

· Strong proficiency in SQL for querying and manipulating data

· Microsoft 365: strong Excel (Power Query, PivotTables, lookups), OneDrive/SharePoint, Teams, and PowerPoint for executive-ready presentations. Data modeling concepts: fact/dimension design, star schemas, basic normalization/denormalization.

· Basic ETL/ELT concepts: understanding data refresh schedules, incremental loads, and source-to-target mappings (hands-on with tools is a plus but not required).

· Familiarity (or willingness to learn) construction and heavy civil data structures: jobs, cost codes, phases, equipment, labor, materials.

· Power Automate for light workflow automation, Python or R for advanced analytics, experience with cloud data platforms (e.g., Azure SQL, Synapse, Snowflake).

$115,000 - $125,000 a year - Full-time, Contract, Pulled from the full job description

• Tuition reimbursement
• Parental leave
• 401(k)
• Retirement plan
• Dental insurance
• Flexible schedule, * 401(k)
• Dental insurance
• Flexible schedule
• Parental leave
• Retirement plan
• Tuition reimbursement