Data Engineer

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., * 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.

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

• Actively demonstrates a commitment to creating an inclusive workplace through active listening to and inclusion of diverse perspectives; demonstrates respect for all and actively works to build trust-based relationships with colleagues and clients.

• Demonstrates commitment to working safely; fully participates in Company's safety initiatives and policies; always looks out for the health and safety of self and others.

• Is consistently responsive and follows through on commitments to self and others; provides the information others need to know to do their jobs and to feel good about being a member of the team and Braun Intertec.

• Shows initiative and commitment to ongoing learning, growth, and development; willingness to openly seek, receive, and give respectful feedback; commitment to continuous improvement of self, responsibilities, and processes.

• Champions the Employee-Owned Stock Ownership Plan through participation in the Plan and ESOP activities and events.

• Actively acknowledges, recognizes, and celebrates the contribution of others.

Position Requirements In addition, this position requires the following skills:

• High customer service orientation.

• Strong written and oral communication skills.

• Experience working in a team-oriented, collaborative environment.

• Attention to detail with excellent organizational and planning skills.

• Balance of business acumen and business process knowledge with technical skills and capabilities.

• Exceptional analytical, conceptual, and problem-solving abilities.

• Ability to work in a dynamic work environment with competing priorities.

• Strong communication and interpersonal skills including the ability to collaborate, influence and partner up and across the organization., * Associate or bachelor's degree in computer science, software engineering or 5+ years equivalent related IT experience.

Knowledge & Experience:

• 5+ years working technical experience with designing, building, installing, configuring, and supporting Lakehouse, data warehouses.

• 3+ years' experience with databases and cloud platforms.

• 3+ years' experience with SQL, Spark SQL and pipelines. Experience with cloud data platforms Microsoft Fabric, Azure Synapse, Azure Data Factory, and Power BI.

• 3+ years' experience with data architecting, data mining, large-scale data modeling, data warehousing, data lake housing, and semantic models is a must.

• Expert in Power BI data models using advanced Power Query and DAX.

• Experience working on business reporting requirements gathering/analysis.

• Familiarity with D365 Financial and Operations, Project Operations and Customer Experience data models is preferred

• Strong understanding of relational database structures, theories, principles, and practices.

• Experience with data processing flowcharting techniques.

• Good knowledge of applicable data privacy practices and laws.

Work/Environment and Physical Requirements (with or without accommodation)

• Office type environment, using computer, telephone, other office equipment as needed to perform duties.

• This position requires the ability to sit for long periods of time, and to work in a fast-paced environment.