Position Summary
Technology & Innovation turns Southland's data and processes into working software: integration, data platforms, analytics, AI and automation, plus the architecture that keeps them coherent. The function is growing substantially over the next several years, and this role sits inside a defined job architecture with published levels and a technical career track that goes as far as the management track does.
Position Details
Data moves from source systems such as Stratus, COINS and Autodesk through Fabric pipelines into bronze (raw), silver (cleaned and conformed), and gold (business-ready) layers, and from gold into Power BI. You will understand the full flow, with your primary focus on the reporting side, working with the Senior Database Administrator, Data Platform, who owns ingestion and the data layers. This is a senior individual contributor role: you own your domain end to end, make independent design decisions, and mentor others. We build on Microsoft Fabric today and expect to adopt new tools as the platform grows, so experience across modern data platforms counts.
What You Will Do
- Run requirements sessions with business leaders and turn their needs into KPIs and report designs.
- Define and document KPIs and business rules, with one governed definition per metric.
- Design shared semantic models on the gold layer with conformed dimensions and certified measures.
- Build Power BI reports for executive, operational, and field audiences, from wireframe to production.
- Write SQL against the lakehouse and warehouse to validate data and reconcile reports to source.
- Partner with the data platform team on gold-layer design, and trace data issues back to the source.
- Implement row-level security, workspace governance, and Dev/Test/Prod releases; tune performance.
- Migrate business-built dashboards and Excel reporting into the enterprise model, then retire them.
- Evaluate new BI and AI capabilities, such as Copilot in Power BI, and recommend what to adopt.
- Set report standards and templates, maintain the KPI catalog, track adoption, and mentor others
Basic Qualifications
Education: Bachelor's degree in a relevant field, or equivalent experience.
Experience: Five or more years in Power BI development, including ownership of shared semantic models and reporting for a business domain.
Certifications: Professional certification in the specialism is common and is never a substitute for scope.
An advanced degree in a quantitative field is common at the senior levels and maps to experience at hire. It does not map to a level.
- 5+ years building production Power BI reports and semantic models, including DAX and Power Query (M).
- 5+ years writing SQL to query, validate, and reconcile data.
- 3+ years designing dimensional models (star schema, fact and dimension tables) for reporting.
- 2+ years on a cloud data platform such as Microsoft Fabric, Azure Synapse, Databricks, or Snowflake, including medallion (bronze, silver, gold) patterns.
- Working knowledge of ETL/ELT pipelines and how data quality issues travel from source to report.
- Experience administering Power BI Service: workspaces, apps, deployment pipelines, row-level security, and gateways.
- Experience leading requirements and KPI definition with business leaders and presenting to senior leadership.
Preferred Qualifications
- Building pipelines or transformations with Fabric Data Factory, Dataflows Gen2, notebooks, dbt, or similar tools; Python or PySpark.
- Version control and CI/CD for BI with Git (Azure DevOps or GitHub), Tabular Editor, and DAX Studio.
- AI features in BI, such as Copilot in Power BI and Fabric, and preparing semantic models for natural-language Q&A.
- Other BI tools such as Tableau, and report UX design and adoption measurement.
- Construction, MEP, or field service reporting (job costing, WIP and percent complete, AR aging, retainage) from systems such as Stratus, COINS or Autodesk Construction Cloud.
Travel
- Office or hybrid, based at a Southland office and working with teams across the company's regions.
- Occasional visits to project sites, fabrication shops and other offices.
- Occasional travel between Southland offices, project sites and regions.
Physical Requirements
- Prolonged periods working at a desk and on a computer.
- Occasionally lifts or moves items up to 20 pounds.
- Occasional visits to active construction sites and fabrication facilities, where personal protective equipment is required.
Pay
Final pay is determined by the education, experience, knowledge, skills, and abilities of the applicant, internal equity, and alignment with market data. For California this ranges from $112,983.00 - $144,368.00 plus annual incentive, benefits, and retirement program as outlined above.