Data Engineer

***LOCAL CANDIDATES TO Minneapolis/St. Paul ONLY***

Under the direction of the Data & BI lead, the Data Engineer will play a key role in designing, developing, and maintaining our data architecture and business intelligence capabilities.  The Data Engineer will ensure the efficient flow, management, and consumption of data across our business systems. This role will collaborate with cross-functional teams to understand data requirements, implement robust data pipelines, and contribute to the overall data strategy of the organization. 

ESSENTIAL AND PRIMARY RESPONSIBILITIES 

• Plan and execute phases of the software development life cycle (SDLC) for a variety of data warehouse projects and business intelligence support activities. 

• In conjunction with Business Systems Analysts and Business Process Owners, is responsible for communication and interaction with various stakeholders. 

• Facilitate the preparation and documentation of requirements including functional and technical design specifications. 

• Design, code, test, and document all new or modified BI systems, data pipelines, applications, and programs. 

• Develop the semantic layer, metadata, reports, and report definitions. 

• Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system. 

• Coordinate and work with other technical staff to develop and implement database architectures, coding standards, and quality assurance policies and procedures. 

• Plan and implement capacity and resource expansion to ensure data warehouse scalability. 

• Build relationships with application and infrastructure teams to gain an understanding of data architectures and required functionality. 

• Orchestrate business intelligence projects and corresponding strategies between business units and development teams. 

• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective availability, protection, and integrity of data assets. 

• Identify inefficiencies and gaps in current data warehouses and leverage solutions to ensure data standards. 

• Diagnose and resolve data warehouse access and performance issues. 

REQUIRED COMPETENCIES & SKILLS  

Inclusivity & Core Values. Braun Intertec employee owners are required to carry out Braun Intertec Values every day and as such must possess