Job Description:

Company Overview:

The STO Building Group family of companies—Structure Tone, Structure Tone Southwest, Pavarini Construction Co., Pavarini McGovern, LF Driscoll, Govan Brown, Ajax Building Company, BCCI Construction, Layton Construction, Abbott Construction, and RC Andersen—includes over 4,000 employees located in offices throughout the US, Canada, UK, and Ireland. We provide a complete range of construction services, from site selection analysis, design constructability review, and aesthetic enhancements to interior fit-outs, new building construction, and building infrastructure upgrades and modernization. Learn more about us at stobuildinggroup.com.

Data & Analytics Team Overview:

The Data & Analytics Team’s goal is to modernize the construction industry through data and technology. We are working as an internal startup, with the mandate of building a brand-new, world-class data and analytics platform in the construction tech space. Using over 50 years of industry experience and data, we will develop new ways to access KPIs and project metrics along with industry leading machine learning (ML) models to offer us predictive analytics to guide future projects.

Role Description:

STO Building Group is seeking a Data Engineer to build and manage a data pipeline with a wealth of construction data. The pipeline will ingest from various data sources, and then transform the data to the end data product. The Data Engineer will be responsible for building and maintaining the various environments, systems, and their health. They will help establish best practices around data governance, data quality, data lineage, and exception management. The Data Engineer will work directly with the Chief Data Officer (CDO) and other Data & Analytics team members to build the products for a world class construction company: STO Building Group.

Responsibilities:

• Design and build a new data analytics pipeline
• Maintain and enhance the data analytics platform with decades of construction project data spanning multiple business units
• Create and improve database designs and data models
• Perform and document data analysis, data validation, and data mapping/design
• Build repeatable processes to clean and transform data into data products
• Build and maintain separate data pipeline environments for the software development lifecycle
• Review and improve existing systems and collaborate with teams to integrate new systems or data sources
• Conduct quality assurance tests and develop database queries to analyze performance troubleshoot issues
• Participate in building a data governance model, performing data lineage, and managing exceptions
• Build and implement Continuous Integration and Continuous Development (CI/CD) process and practices across the platform

#LI-JA1

• Minimum of 7 years of SQL experience
• Demonstrated experience with data management, data engineering and data analytics
• Demonstrated experience with Python, pandas, R, or other similar data processing and analysis languages
• Demonstrated experience with database management systems including Oracle, MySQL, PostgreSQL, or others
• Demonstrated experience with GitHub or GitLab
• Demonstrated experience building automated database tools and solutions
• Demonstrated experience with Database Disaster Recovery Planning and Testing
• Demonstrated project planning and scheduling experience
• Demonstrated deploying change sets and managing all environments
• Demonstrated experience managing security, performing audits, and ensuring good governance
• Experience with agile process and best practices

Salary Range

• Desired salary range $120,000- $170,000

Benefits: The Company offers the following benefits for this position, subject to applicable eligibility requirements: [Medical Insurance] [Dental Insurance] [Vision Insurance] [Health Savings Account] [Healthcare Flexible Spending Account] [Dependent Care Flexible Spending Account] [401(k) retirement plan with employer match] [Life & AD&D Insurance] [Long-term Disability Insurance] [Short-term Disability Insurance] [Critical Illness Insurance] [Accident Insurance] [Hospital Indemnity Insurance] [Home & Auto Insurance] [Family Support] [Pre-tax Paid Parking/Public Transportation] [Paid time off: 2 Weeks for Non-Exempt and Three Weeks for Exempt] [Time Away Benefits] [8 Paid Holidays] [Group Legal] [Employee Stock Purchase Plan] [Identity Theft Protection] [Group Legal] [Pet Insurance] [Employee Assistance Program]

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. The Company reserves the right to modify this information at any time, subject to applicable law.

EEO Statement:

The STO Building Group family of companies—Structure Tone, Structure Tone Southwest, Pavarini Construction Co., Pavarini McGovern, LF Driscoll, Govan Brown, Ajax Building Company, BCCI Construction, Layton Construction, Abbott Construction, and RC Andersen—includes over 4,000 employees located in offices throughout the US, Canada, UK, and Ireland. We provide a complete range of construction services, from site selection analysis, design constructability review and aesthetic enhancements to interior fit-outs, new building construction, and building infrastructure upgrades and modernization. Learn more about how we partner with our clients to imagine, execute, and realize their vision at stobuildinggroup.com.

We are an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics.