Senior Data Engineer

Job Description

Position Summary

DPR is seeking an experienced Data Engineer to join our Data Engineering team. This role is part of the Data Engineering and AI team and will ensure DPR is moving towards data-driven decisions based on modern data engineering techniques, applications, and AI. The right candidate will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives. Having experience working with Supply Chain, Procurement, Commercial Construction, Manufacturing, and Prefabrication will be a huge plus.

Responsibilities

Strategic Partnership / Roadmap / Execution / Delivery

1. Participate in and collaborate with cross-functional Workgroups and functional teams to align Data Engineering efforts and resources with business goals and objectives.
2. Drive strategic conversations with stakeholders to fully understand and document pain points and business requirements, define the key deliverables required to improve business processes, and develop required integrations and apply other data engineering approaches.
3. Develop and maintain relationships with business stakeholders and a deep understanding of their processes, tools, and goals.

Data Engineering / Technology / Data Integrations

1. Design, build, and maintain robust data pipelines and architectures, ensuring high availability and reliability.
2. Develop complex data models and algorithms to extract insights from large Supply Chain, Procurement, and Construction datasets.
3. Utilize Snowflake for efficient data storage, data warehousing, and Azure Data Factory for orchestrating and automating data workflows.
4. Script and program in Python and use DBT for transformation tasks to optimize data processes.
5. Responsibilities include solutions implementation from cloud-first thinking using Agile, Scrum, and Data Ops.
6. Assemble data sets that meet functional/non-functional business requirements.
7. Design and implement process improvements like automating manual processes, optimizing data pipeline from source to consumption, scaling the data infrastructure, etc.
8. Collaborate closely with stakeholders to understand data requirements and translate these into technical solutions.
9. Maintain data integrity and compliance, adhering to industry standards and best practices.
10. Stay on top of emerging trends and technologies in data engineering and construction tech.

Position Requirements

1. Bachelor’s/Master’s in Computer Science or a related technical field.
2. 4+ years prior experience as a Data Engineer/Integrations Engineer in a fast-paced, technical, problem-solving environment. (Internship experience does not apply)
3. 2+ years of experience with a public cloud (AWS/Microsoft Azure/Google Cloud)
4. 2+ years of data warehousing experience (Redshift or Snowflake)
5. 2+ years of experience with Agile engineering practices
6. Experience with enterprise data lakes, data warehouses, data marts, and big data.
7. Expert-level proficiency in Azure Data Factory, Integration Platforms, Python programming, DBT, and data modeling.
8. Demonstrated experience with API development and management for data integration.
9. Advanced SQL knowledge and experience working with relational databases, query authoring (SQL), and working familiarity with various databases.
10. Strong analytic skills related to working with unstructured datasets.
11. Strong project management and organizational skills.
12. Experience with SQL, JSON and XML, LookML.
13. Knowledge of APIs, REST, and GraphQL.
14. Experience with programming languages like Python.
15. Exposure to the Construction Industry is a huge plus.
16. Excellent communication skills to ask questions, clarify requirements, and engage with the team and stakeholders.
17. Strong logic, reasoning, and critical thinking skills to solve problems as they arise.
18. Must be an independent problem solver who can evaluate a situation and build solution options.

DPR has been nationally recognized for its strong company culture, based on a well-defined purpose “We Exist to Build Great Things,” and four core values: integrity, enjoyment, uniqueness and ever forward. A flat, title-less organization that empowers people at all levels to make decisions, DPR ranked on FORTUNE’s “100 Best Companies to Work For” list for five consecutive years. For more information, visit .