Job Information
Barr Engineering Co Data Engineering Consultant Mid Level Environment in Ann Arbor, Michigan
Job Description:
Summary: Barr Engineering Co. seeks a data engineering consultant to help us build and expand our newly formed Environmental Management Analytics and Information Systems team. Your primary focus will be to support data engineering and architectural needs for our external client projects. When not building end-to-end solutions for external projects, you will assist Barr's internal Information Systems team with advancing our rapidly maturing and analytics data-related capabilities. You will use the latest cloud-based tools to design and build solutions for IoT and telemetry-based instrumentation, a cloud-based data lake, API integration of internal and external platforms, and many other tools to support various fascinating engineering efforts.
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 is passionate about data and wants 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 Systems team.
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 APIs and ETL tools
Supporting data science, system implementation, and system development efforts
Designing data flows and pipelines to optimally extract, transform, and store data using on-premesis 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 queries
Designing and developing database objects (databases, tables, views, stored procedures, etc.) in 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 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 data engineering, database administration, or a business intelligence role
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 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, andAzure 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 deliveri