Data Engineer

***NO SPONSORSHIP LOCAL CANDIDATES to Minneapolis/St. Paul ONLY***

Under the direction of theData & BI leadtheData Engineer will play a key role in designing developing andmaintainingour data architectureand business intelligence capabilities.The Data Engineer willensurethe efficient flowmanagement and consumptionof data across ourbusinesssystems.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

• Planand executephases of the software development life cycle (SDLC) for a variety ofdata warehouseprojectsand business intelligence support activities.

• In conjunction with Business Systems Analystsand Business Process Ownersisresponsible for communicationand interactionwith various stakeholders.

• Facilitate thepreparation and documentation ofrequirementsincludingfunctional and technical designspecifications.

• Design code test and document all new ormodifiedBI 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 developand implementdatabase architectures codingstandards and quality assurance policies and procedures.

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

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

• Orchestratebusiness intelligenceprojects 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.

• Identifyinefficiencies and gaps in current data warehouses andleveragesolutions to ensure data standards.

• Diagnose and resolve data warehouse access and performance issues.

REQUIREDCOMPETENCIES &SKILLS

Inclusivity &Core Values.BraunIntertecemployee ownersare required tocarry outBraunIntertecValues every day and as such mustpossessthe followingcompetencies:

• Activelydemonstratesacommitmenttocreatingan inclusive workplacethrough active listeningto and inclusion of diverse perspectives;demonstratesrespect for alland actively works to build trust-based relationships with colleaguesand clients.

• Demonstratescommitment to working safely; fullyparticipatesin Companys safety initiatives and policies; alwayslooksout for thehealth andsafety of self and others.

• Isconsistentlyresponsive and follows through on commitments to self andothers; providesthe information others need to know to do their jobs and to feel good about being a member of the team andBraunIntertec.

• Shows initiative and commitment to ongoing learning growth and development; willingness to openlyseekreceive and give respectfulfeedback; 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 RequirementsIn 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 communicationand interpersonal skills including the ability to collaborate influence and partner up and across the organization.

Minimum ExperienceEducation and Technical Skills:

Formal Education:

• Associate orbachelorsdegree in computer sciencesoftwareengineeringor5years equivalentrelatedIT experience.

Knowledge & Experience:

• 5 years working technical experience with designing building installingconfiguringand supportingLakehousedata warehouses.

• 3years experiencewithdatabasesand cloudplatforms.

• 3 years experience withSQLSparkSQLandpipelines. Experiencewith cloud dataplatformsMicrosoft Fabric Azure Synapse Azure Data FactoryandPower BI.

• 3 years experience with data architecting data mining large-scale data modeling data warehousing data lake housing and semanticmodels isa must.

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

• Experience workingonbusinessreportingrequirements gathering/analysis.

• Familiarity with D365 Financial and OperationsProject Operations andCustomer Experiencedata modelsis 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 withoutaccommodation)

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

• This position requires the ability to sit forlong periodsof timeand towork in a fast-paced environment.

Travel Requirements

• Position isprimarilyremotewith the occasional need to come to the office (Bloomington MN).

• Position may require some limited travel (locally and throughout United States); Less than 5% annually.