Sr. Data Engineer

Brown and Caldwell is seeking a Senior Data Engineer to join our data and analytics team. This role will help oversee the development and maintenance of the company's data architecture. The role will work with data engineers to ensure the scalability and reliability of data systems. The role's responsibilities will include defining data standards, creating data models, and optimizing data storage solutions. The role will also collaborate with stakeholders to understand their data needs and provide technical guidance. This role will report to the Director of Data and Analytics.

Job Responsibilities & Expectations:

• Collaborate with interdisciplinary teams of environmental engineers, data scientists, and software developers to understand data requirements and develop scalable data solutions for large/complex projects across the company.

• Design, implement, and maintain data pipelines to collect, clean, transform, and load data from various sources, including sensor data, historical records, and geospatial information.

• Create and manage data warehouses, data lakes, and databases to ensure efficient data storage, retrieval, and management.

• Develop and deploy ETL (Extract, Transform, Load) processes to support data analysis, visualization, and machine learning model training on large/complex projects.

• Assist in the development of data quality and data governance processes to ensure accuracy, consistency, and integrity of data.

• Collaborate with IT teams to optimize data infrastructure, performance, and security.

• Stay up-to-date with emerging technologies, tools, and best practices in data engineering and environmental engineering to drive continuous improvement in BC's data engineering service offering.

• Lead efforts to identify, analyze, and resolve complex issues that may impact the company's operations or strategy.

• Manage SQL database operations for high-value projects, including performance tuning, data migration, and querying.

• Flexibility to adapt and execute various additional assignments based on evolving needs.

Desired Skills and Experience:

• Excellent understanding of and demonstrated capabilities with data engineering, data modeling, database management, and data warehousing concepts as applied to multiple projects.

• Advanced working SQL knowledge and experience working with relational databases.

• Skilled in designing, implementing, managing and optimizing ETL processes and pipelines.

• Highly skilled in Python and other relevant data-related languages and tools.
• Strong comprehension of data quality, governance standards, and big data principles.
• Demonstrated proficiency with best practices for writing clean, maintainable, and scalable code while applying software engineering best practices including use of version control systems (e.g., Git).
• Typically, a minimum of 6 years of data engineering or related experience.
• A degree in data engineering, computer science, information technology, or related field or equivalent experience is required.

Salary Range: The anticipated starting pay range for this position is based on the employee's primary work location and may be more or less depending upon skills, experience, and education. These ranges may be modified in the future.

Location A: Salary $118,000 - $161,000

Location B: Salary $130,000 - $177,000

Location C: Salary $142,000 - $194,000

You can view which BC location applies to you here. If you have any questions, please speak with your Recruiter.

Benefits and Other Compensation: We provide a comprehensive benefits package that promotes employee health, performance, and success which includes medical, dental, vision, short and long-term disability, life insurance, an employee assistance program, paid time off and parental leave, paid holidays, 401(k) retirement savings plan with employer match, performance-based bonus eligibility, employee referral bonuses, tuition reimbursement, pet insurance and long-term care insurance. Click here to see our full list of benefits.

About Brown and Caldwell

Headquartered in Walnut Creek, California, Brown and Caldwell is a full-service environmental engineering and construction firm with 50 offices and 2,100 professionals across North America and the Pacific. For 75 years, we have created leading-edge environmental solutions for municipalities, private industry, and government agencies. We strive to be the company of choice-to our clients, who benefit from our passion for delivering exceptional quality, and to our employees, present and future, who share our commitment to client service, collaboration, and innovation. Join us, and you will find a home where you can do your best work, reach new levels of expertise, and enjoy exceptional development opportunities. For more information, visit www.brownandcaldwell.com

This position is subject to a pre-employment background check and a pre-employment drug test. Notice to Third Party Agencies: Brown and Caldwell does not accept unsolicited resumes from recruiters or employment agencies. In the event a recruiter or agency submits a resume or candidate without a previously signed agreement and approved engagement request with Brown and Caldwell, Brown and Caldwell reserves the right to pursue and hire those candidate(s) without any financial obligation to the recruiter or agency.

Brown and Caldwell is proud to be an EEO/AAP Employer. Minorities/Women/Disabled and Protected Veterans are encouraged to apply. Brown and Caldwell ensures nondiscrimination in all programs and activities in accordance with Title VI of the Civil Rights Act of 1964.