Job Description:

Summary:

Barr Engineering Co. is seeking a data engineering consultantto help us build and expand our newly formedEnvironmental Management Analytics and Information Systems team. Your primary focus will be to support the data engineering and architectural needs of our external client projects. When not building end-to-end solutions for external projects, you will assistBarr's internal Information Systems team in advancing our rapidly maturing analyticsdata-related capabilities. You will use the latest cloud-based tools todesign and buildsolutions for IoT and telemetry-basedinstrumentation.

Barr works on thousands of client projects each year.The data-related needs of these projects vary significantly.This role is well suited for a problem solver who ispassionate about data andwants to work in a dynamic environment with significant growth opportunities.You will have the opportunity to learn and develop your technological skills across various platforms and help drive the future of our Environmental Management Analytics and Information Systemsteam.

Responsibilities include:

* Supporting the data engineering, management, and governance needs of an array of engineering and scientific projects for our external clients.

* Identifying, designing, and implementing process improvements; redesigning infrastructure for greater scalability; optimizing data delivery, and automating manual processes.

* Supporting the acquisition and processing of large datasets generated by IoT and instrumentation.

* Integrating systems and data sources through APIsand ETL tools.

* Supporting data science integration, system implementation, and system development efforts.

* Designing data flows and pipelines to optimally extract, transform, and store data using on-prem and cloud technologies.

* Advancing the design and development of Barr's enterprise data warehouse, data lake, dashboarding, and self-service reporting ecosystem using the Microsoft Business Intelligence toolset (SQL Server, SSIS, SSAS tabular, Power BI, Azure).

* Leading the process of engaging business analysts and business unit staff to elicit and document data requirements.

* Writing complex ETL and analytics queries.

* Designing and developing database objects (databases, tables, views, stored procedures, etc.) within a normalized and dimensional data warehouse environment.

* Developing auditing and quality assurance practices to help ensure the accuracy of the data warehouse and reporting.

* Mentoring business unit staff members to advance their data capabilities and understanding.

Minimum Qualifications:

* Bachelor's degree in computer science, information systems, or a related field, or equivalent work experience

* Two years of experience in data engineering, database administration, or business intelligence

* Experience developing data warehouse and data lake tools for business purposes

* Experience supporting the development of analytical tools for business purposes

* High proficiency in SQL queries

* Experience with Python development

* Experience using and developing REST APIs

* Experience with ETL and data modeling technologies (e.g., SSIS, Data Factory, SSAS - Tabular)

* Understanding of security in an integrated on-premises and cloud-based data environment

* Proficiency in working with diverse data types, including structured, semi-structured, and unstructured formats

* Experience... For full info follow application link.

Barr is proud to be an affirmative action/equal opportunity employer. All qualified applicants will receive cons ideration for employment without regard to sex, race, color, religion, gender identity, sexual orientation, age, national origin, disability, protected veteran status, or any other lawfully protected status.