Data Engineer - ARCO a Family of Construction Companies

Are you an expert with SQL? Do you have the ability to harness logic and reasoning to identify complex relationships. Do you thrive in a fast paced environment and are you looking to join a growing and dynamic team? If the answer is, "Yes!" then we have an exciting, long-term opportunity for you. Who are we? We are ARCO, a Family of Construction Companies.

We are building our core Data Team, as a Data Engineer, you will play a crucial role in building foundational datasets, designing pipelines, and developing the infrastructure to support them. Your work will accelerate decision-making processes for key project and business functions. If you're passionate about analytics, data models, and solving complex data problems, then this is the team for you!

We are dedicated to the well-being of our associates and are proud to be consistently recognized as a Best Place to Work. Our compensation and benefits package not only supports our associates and their families but benefits local communities and communities around the world.

• Industry-leading performance-based bonus program
• Employee Stock Ownership Plan (ESOP)
• Traditional and Roth 401k
• Tuition reimbursement for associates
• Scholarship for associates’ children up to $28,000 per child
• 1-month paid sabbatical after every five years of employment, plus $5,000 for travel
• 1-week paid volunteer leave each year
• 100% charitable match
• Medical, dental, and vision insurance coverage
• 100% paid 12-week maternity leave

At ARCO, our first core value is to treat people fairly and do the right thing. We are committed to building and sustaining a culture that supports diversity and inclusion. We are proud to be a drug-free workplace and an equal opportunity employer, and all qualified applicants will receive consideration for employment.

From recruiting, training, and hiring practices to selecting our subcontractors, we understand that diversity of all those involved in the construction process enhances our ability to deliver the best solutions to our customers. We hire the best and the brightest from across the country – constructing a team of experts in architecture, design, engineering, project management, and business services.

• Define processes and ETL infrastructure to transform and make data readily available across the company.
• Build core datasets to serve as unique sources of truth for various business functions including project management, estimating, procurement, finance, operations, and engineering.
• Partner with project managers, business leaders, and internal stakeholders to understand their needs and design, build, and monitor pipelines that meet current requirements while also scaling gracefully with our growing data size.
• Implement automated workflows to reduce manual/operational costs for stakeholders, define and uphold SLAs for timely data delivery, and move the company closer to democratizing data and a self-serve model (query exploration, dashboards, data catalog, data discovery).

• Self-starter mentality with the ability to gather and synthesize high-impact needs from business partners, design and implement technical solutions, and effectively communicate about deliverables, timelines, and trade-offs.
• 5-7 years of experience as a data engineer building core datasets and supporting business verticals as needed. Passionate about analytics use cases, data models, and solving complex data problems.
• Hands-on experience shipping scalable data solutions in the Azure Cloud (e.g., AWS, GCP, Azure), across multiple data stores (e.g., Snowflake, Redshift, Hive, SQL/NoSQL, columnar storage formats), and methodologies (e.g., dimensional modeling, data marts, star/snowflake schemas).
• SQL expertise with an understanding of aggregation functions, window functions, UDFs, self-joins, partitioning, and clustering approaches to run correct and highly-performant queries.
• Highly comfortable with object-oriented programming paradigms (e.g., Python, Java, Scala).
• Experience working at a fast-growing company, a construction company, or eagerness to contribute in such an environment (Preferred).
• Hands-on experience in designing and building highly scalable and reliable data pipelines using Big Data stack (e.g., Airflow, Azure Data Pipeline, Spark, Hive, Parquet/ORC, Protobuf/Thrift, etc.) (Preferred).