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. The role involves integrating data from various sources, including SAP S4, APIs, and other enterprise systems, ensuring efficient data flow and accurate analysis. The Data Engineer collaborates closely with cross-functional teams to optimize performance, enhance data quality, and implement data governance standards. Additionally, this role 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) 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; provides training for internal teams on the data platform.
-
Non-essential Functions
- Adheres to Border States’ System Development Life Cycle (SDLC) best practices and application change management procedures.
- Actively tracks and reports on the effectiveness of deployed technologies in supporting program/project goals.
- Maintains familiarity with front-end reporting tools, including Power BI, for enhanced data visualization and reporting.
- Other duties as assigned by supervisor or designated personnel.
Qualifications
- Bachelor’s degree in Computer Science, Information Technology, Management Information Systems, Mathematics, or equivalent experience.
- 4-7 years of proven experience in developing technical data solutions within cloud environments, focusing 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 to effectively collaborate 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 with both technical and non-technical teams.
Physical Requirements
- Frequency of lifting/carrying:
- Less than 10 lbs.: Occasionally
- 10 to 25 lbs.: Occasionally
- 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:
- Sitting: Continuously
- Standing: Frequently
- Walking: Frequently
- Bending/stooping: Occasionally
- Grasping: Continuously
- Use of a computer: Continuously
- Talking: Frequently
- Driving: Occasionally
Additional Information
This job description is a summary of job duties and responsibilities and is not intended to cover all possible duties. It is subject to change at the employer’s discretion. Employees must be able to perform essential job duties and satisfy job requirements with or without 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 excel in delivering top-notch customer service and demonstrate extraordinary 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.
Values
As a Border States employee-owner, you’re responsible for living our mission, service philosophy, and service standards.
Your Career
Join an experienced team at one of the largest electrical distributors in the United States. Border States offers a competitive benefits package including:
- 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 and Volunteer Time
- Personal Leave Time and more!
Equal Opportunity For All
It’s not just the law. It’s part of our core values. We value the diversity of all our employee-owners and are an equal opportunity employer.
Drug Free/Smoke Free Workplace
.png)
