Data Engineer II

Be part of a growing, successful company in an exciting and challenging field. Border States is 100% employee-owned, which means you’re empowered to make decisions, find solutions and receive rewards for your hard work.

This position will be located in : Fargo , ND

Job Summary

The Data Engineer II designs and develops scalable, metadata-driven ETL / ELT data pipelines within the Azure ecosystem, primarily using Azure Synapse, Spark, SQL, and Python.

Integrates data from various sources, including SAP S4, APIs, and other enterprise systems, ensuring efficient data flow and accurate analysis.

Works closely with cross-functional teams to optimize performance, enhance data quality, and implement data governance standards.

Contributes to building an advanced cloud data engineering platform leveraging Azure Synapse, Azure Purview, Power BI, and SAP Datasphere, while supporting the overall data engineering strategy of the organization.

Responsibilities

Essential Functions

• Develops, optimizes, and manages ETL / ELT pipelines.
• Designs scalable architectures for large-scale data processing within the Azure ecosystem.
• Implements data integration solutions using Azure Synapse Pipelines, Azure Data Factory, and other Azure-native tools.
• Integrates data from enterprise data sources (SAP, API, etc.) into cloud-based data solutions.
• Establishes CI / CD pipelines using Git (Azure DevOps), and related tools for automated deployment and monitoring of data solutions.
• Troubleshoots, optimizes, and maintains the performance of data pipelines and cloud-based platforms.
• Collaborates with business and technical teams to architect robust data solutions and drive insights from data.
• Applies best practices for data governance, security, and data quality using Azure Purview and other governance tools.
• Documents technical solutions and processes and provides training for internal teams on the data platform.

Non-essential Functions

• Adheres to Border States’ System Development Life Cycle (SDLC) best practice guidelines and application change management procedure.
• Actively tracks and reports on the effectiveness of deployed technologies in supporting the goals of the program / project / initiative.
• Maintains familiarity with front-end reporting tools, including Power BI, for enhanced data visualization and reporting.
• Other duties as assigned by supervisor or designate.

Qualifications

• Bachelor’s degree in Computer Sciences / Information Technology / MIS / Mathematics, or equivalent experience.
• 4-7 years of proven experience in developing technical data solutions within cloud environments, with a strong focus on Azure Synapse.
• Expertise in designing and developing ETL / ELT processes using metadata-driven pipelines.
• Proficient in SQL, Spark, Python, and Git for data engineering and pipeline automation.
• Extensive experience with Azure cloud services, including Azure Storage, Azure Data Factory, Azure DevOps, and Azure Purview.
• Hands-on experience with data quality management and governance.
• Familiarity with SAP systems, including SAP Datasphere and HANA S / 4, specifically in working with Core Data Services (CDS) and HANA views.
• Solid understanding of Agile methodologies and tools such as Jira.
• Strong communication skills, able to work effectively with cross-functional teams and explain technical concepts to non-technical stakeholders.

Skills and Abilities

• Ability to troubleshoot and resolve complex data engineering challenges.
• A team player with a passion for learning and applying new technologies and methodologies.
• Skilled in working in a fast-paced environment and delivering high-quality results under pressure.
• Strong problem-solving skills and resilience in overcoming obstacles.
• Effective communicator who can build relationships and work well with both technical and non-technical teams.

Physical Requirements

Frequency at which you would carry / lift in a typical day :

Occasionally 0 33% Frequently 34 66% Continuously : 67 100%

• Lift from Waist :
• 10 to 25 lbs. - Not at all
• 26 to 50 lbs. - Not at all
• 51 to 75 lbs. - Not at all
• 75 to 100 lbs. - Not at all
• 100+ lbs. - Not at all
• Lift from Floor :
• 10 to 25 lbs. - Frequently
• 26 to 50 lbs. - Occasionally
• 51 to 75 lbs. - Not at all
• 75 to 100 lbs. - Not at all
• 100+ lbs. - Not at all
• Carried for Distance :
• 10 to 25 lbs. - Not at all
• 26 to 50 lbs. - Not at all
• 51 to 75 lbs. - Not at all
• 75 to 100 lbs. - Not at all
• 100+ lbs. - Not at all

Physical Activity

Frequency at which you would do the following in a typical day :

• Sitting (a continuous period of being seated) - Continuously
• Standing (for sustained periods of time) - Frequently
• Walking (moving about on foot to accomplish tasks) - Frequently
• Bending / stooping (downward and forward) - Occasionally
• Crawling (moving about on hands and knees or hands and feet) - Not at all
• Climbing / Walking Stairs (ascending or descending) - Frequently
• Reaching (extending arms in any direction) - Frequently
• Crouching / squatting (bending the body downward and forward by bending leg and spine) - Occasionally
• Kneeling (bending legs at knee to come to rest on knee(s)) - Occasionally
• Balancing (maintaining body equilibrium to prevent falling) - Occasionally
• Repetitive motion (substantial movement (motions) or the wrists, hands, and / or fingers) - Continuously
• Pivoting (movement in any direction with one foot, keeping the other in contact with the floor) - Frequently
• Pushing / Pulling (using upper extremities to press against or draw or tug) - Occasionally
• Grasping (Applying pressure to an object with the fingers and palm) - Continuously
• Fingering (picking, pinching, typing; working with primarily fingers and not whole hand) - Continuously
• Talking (expressing or exchanging ideas by means of the spoken word) - Frequently
• Driving (the control and operation of a motor vehicle) - Occasionally
• Desk work (work usually performed at a desk) - Continuously
• Use of a computer - Continuously
• Use of a telephone - Frequently
• Hearing (Perceiving the nature of sounds at normal speaking levels) - Continuously
• Exposure (to adverse weather & temperature conditions) - Not at all
• Travel (travel needed to perform job duties) - Occasionally

Additional Information

This job description is a summary of the job duties and responsibilities and is not intended to cover all possible job duties and is subject to change at the employer’s discretion.

Employees must be able to perform the essential job duties and satisfy job requirements either with or without a reasonable accommodation.

Our History

Border States is a leader in the electrical supply distribution industry with over 120 locations in 31 states. Our employee-owners are second to none in delivering top-notch customer service and in demonstrating extra-ordinary people skills.

We are one of the largest independent electrical distributors in the United States providing products and services to the construction, industrial and utility industries.

Border States has a competitive benefit package and is a 100 percent employee-owned company. Employee-ownership is a significant part of our culture and our success stems from the dedication of our employee-owners.

We practice open-book management and our employee-owners are empowered with clearly defined levels of authority to be innovative and decisive, allowing us to respond quickly to the needs of customers.

Employee-owners understand their roles in the success of the company and care about customers’ needs, which drives our focus on adding value to everything we do.

We recognize that not all customers are the same and each has specific requirements. Our employee-owners understand these diverse needs and have the commitment, resourcefulness and flexibility to outperform all others.

Values

As a Border States employee-owner, you’re responsible for living our mission, service philosophy and service standards.

Our Purpose

We believe unstoppable businesses shouldn't go it alone. We are owners - of relationships, of outcomes, of every moment these unstoppable businesses need to deliver.

Service Philosophy

We earn customer loyalty and confidence by caring about their needs and adding value to everything we do.

Service Standards

Border States employee-owners are competent, accurate, responsive, and engaged .

Your career

Join an experienced team at one of the largest electrical distributors in the United States. What are you waiting for?

Border States has a competitive benefits package which includes but is not limited to :

Health, Dental and Vision Benefits

Accident, Critical Illness, Hospital Indemnity

FSA & HSA

Employee Stock Ownership Plan (ESOP)

Disability Benefits

401(k) Retirement Plan

Life Insurance

Employee Assistance Program

Paid Holidays

Paid Volunteer Time

Personal Leave time and more!

Border States provides bonuses to their employee-owners upon the achievement of branch and company goals.

Equal Opportunity For All

It’s not just the law. It’s something we’ve believed in since our founding. We value the diversity of all of our employee-owners and will always be an equal opportunity employer.

Drug Free / Smoke Free workplace