Data Engineer - Clayco

About Us

Clayco is a full-service, turnkey real estate development, master planning, architecture, engineering, and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $5.8 billion in revenue for 2023, Clayco specializes in the "art and science of building," providing fast track, efficient solutions for industrial, commercial, institutional, and residential related building projects.

The Role We Want You For

We are seeking a highly skilled and motivated Data Engineer to join our dynamic Data Analytics team in Overland, MO. As a Data Engineer at Clayco, you will play a vital role in designing, building, and maintaining data pipelines and complex data sets to support reporting, advanced analytics, and ad-hoc analysis. We are looking for a candidate with deep technical knowledge, a strong background in testing code, platform support, and data performance management. This position requires excellent communication skills to effectively collaborate with technical teams and translate business requirements into scalable data solutions.

The Specifics of the Role

• Design, build, and maintain data pipelines from various source systems into Snowflake.
• Analyze data elements, data flow, dependencies, and relationships from different systems and assist in designing conceptual, physical, and logical data models.
• Develop complex data sets to fulfill diverse business needs in reporting, advanced analytics, and ad-hoc analysis.
• Coordinate with third-party service providers for the construction and maintenance of data pipelines.
• Execute and enable data migrations across systems, such as SQL Server to Snowflake or other cloud data platforms.
• Develop and implement scripts for data hub maintenance, monitoring, and performance tuning.
• Collaborate with data and business analysts to deploy and support a robust data quality platform.
• Work with data and business analysts to deploy and support a comprehensive data cataloging strategy.
• Assist various business and technical stakeholders with data-related technical needs and issues.
• Collaborate closely with cross-functional teams to understand and transform business requirements into scalable and manageable data solutions.
• Present solutions and options to leadership, project teams, and stakeholders, adapting the communication style to both technical and non-technical audiences.
• Ensure adherence to documented design and development patterns and standards within the team.
• Proactively monitor and resolve ongoing production issues.
• Promote the approach of self-service data solutions and enable other teams with analytics solutions delivery through a 'Data as a Service' model.

Requirements

• Hands-on experience in designing, developing, and implementing data solutions.
• Advanced SQL knowledge with strong query writing and stored procedures skills.
• Strong experience with relational databases such as SQL Server and Oracle.
• Proficiency in object-oriented/object function scripting languages such as Python, Java, Scala, etc.
• Basic knowledge and understanding of Azure cloud services.
• Basic knowledge and understanding of stream-processing systems such as Storm, Spark-Streaming, etc.
• Experience with data analysis, ETL, and workflow automation.

Some Things You Should Know

• No other builder can offer the collaborative design-build approach that Clayco does.
• We work on creative, complex, award-winning, high-profile jobs.
• The pace is fast!

Why Clayco?

• Best Places to Work – St. Louis Business Journal, Los Angeles Business Journal, Phoenix Business Journal.
• ENR – Top Midwest Contractors (#1), Top Design Build Contractors (#4), Top 400 Contractors (#23), ENR – Top Green Builders (#5).

Compensation and Benefits

• Salary Range: Competitive Annual Salary based on qualifications, skills, training, experience, and location.
• Discretionary Annual Bonus: Subject to company performance and individual contribution.
• Comprehensive Benefits Package Including: Medical, dental and vision plans, 401k, generous PTO and paid company holidays, employee assistance program, flexible spending accounts, life insurance, disability coverage, learning & development programs and more!