Job Description:

Summary: Barr Engineering Co. seeks 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 and analyticsdata-related capabilities. You will use the latest cloud-based tools todesign and buildsolutions for IoT and telemetry-basedinstrumentation, a cloud-based data lake, API integration of internal and external platforms,and many other tools to support various fascinating engineering effor

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 an environment with significant growth opportunities. You will be given 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:

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

Identify, design, and implement process improvements, re-designing infrastructure for greater scalability, optimize data delivery, and automate manual processes

Support the acquisition and processing of large datasets generated by IoT and instrumentation

Integrate systems and data sources through APIsand ETLtools

Support data science, system implementation, and system development efforts

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

Advance 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)

Lead the process of engaging business analysts and business unit staff to elicit and document data requirements

Write complex queries

Design and develop database objects (databases, tables, views, stored procedures, etc.) within a normalized and dimensional data warehouse environmen

Develop auditing and quality assurance practices to help ensure the accuracy of the data warehouse and reporting

Mentor business unit staff to advance their data capabilities and understanding

Minimum Qualifications:

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

Three years of experience in a data engineering, database administrator, or business intelligencerole

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 withPython developer

Experience developing Rest APIs

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

Strong understanding of security in an integrated on-premises and cloud-based data environment

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

Proficiency with Azure technologies such as Data Factory, Data Lake, and Azure Analysis Services

Experience leading requirement-gathering efforts for data engineering projects

Strong organizational skills, including the ability to plan, monitor, and follow through on work commitments and confirm priorities with stakeholders

High level of commitment to delivering exceptional client... For full info