Data Engineer

Braun Intertec Corporation•Bloomington, MN

5h•$88,000 - $131,000•Remote

About The Position

Under the direction of the D ata & 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 ensur e the efficient flow , management , and consumption of data across our business systems. This role w ill collaborate with cross-functional teams to understand data requirements, implement robust data pipelines, and contribute to the overall data strategy of the organization.

Requirements

Inclusivity & Core Values
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 .
Formal Education: Associate or bachelor’s degree in computer science , software engineering or 5+ years equivalent related IT experience.
5+ years w orking 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 Fabr ic, 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 .
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.

Nice To Haves

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

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.