COMPANY OVERVIEW

Artisan Design Group – or ADG – is a leading supply chain partner to homebuilders throughout the United States. Over 3,000 ADG associates operating out of 135 facilities in 25 states provide a full range of design, procurement, and installation services along with products from the top manufacturers of flooring, cabinets, and countertops. Formed in 2016 by the merging of two industry leaders, ADG then acquired over 20 additional companies – each a leader in the geography it serves. We are the premier interior finishings organization in the United States. Our expansive trajectory has been rapid, and we continue to experience explosive growth, thanks to our dedication to high quality work.

JOB SUMMARY 

As an ETL Developer at Artisan Design Group, you will be responsible for designing, building, and managing data pipelines and workflows that support our business needs across both on-premises and cloud environments. This role requires a strong focus on data integration, automation, and optimization of data processes using Azure Data Factory, SQL Server Integration Services (SSIS), Python, and other tools like PowerShell, Power Automate, and Remote Desktop Connections.

ESSENTIAL DUTIES AND RESPONSIBILITIES The essential functions include, but are not limited to, the following. Additional duties may be assigned, as necessary.

1. ETL Pipeline Development  

• Design, implement, and manage ETL processes using Azure Data Factory and SQL Server Integration Services (SSIS).
• Create and maintain data pipelines to extract, transform, and load data from various sources to cloud or on-prem environments.
• Develop, optimize, and troubleshoot complex data workflows for moving data efficiently across systems.

2. Cloud & On-Premise Data Integration  

• Collaborate in managing and integrating data from on-premises and cloud-based servers, including hybrid environments.
• Ensure smooth and secure data transfers using appropriate tools and protocols.

3. Automation & Scripting  

• Automate tasks and data workflows using PowerShell, Python, and Power Automate to enhance productivity and reliability.
• Maintain automated data processes that ensure data availability and quality.

4. Pipeline Management  

• Oversee the performance and stability of ETL pipelines, identifying bottlenecks or errors, and resolve issues quickly to maintain system reliability.
• Document and monitor data flows for compliance and efficiency.

5. Data Movement & Integration  

• Implement secure, reliable, and scalable methods for data transfer, ensuring data integrity during movement.
• Collaborate with different departments to gather and translate data requirements into actionable data flows.

6. Collaboration & Teamwork

• Work as part of a cross-functional team to implement and maintain data solutions that meet the business's needs.
• Actively participate in team meetings, sharing insights and contributing to problem-solving efforts.

7. Independent Work & Problem-Solving  

• Take ownership of assigned tasks, working independently to deliver solutions within deadlines.
• Show initiative in troubleshooting and problem-solving, taking a proactive approach to improving workflows.

8. Remote Connectivity

• Use Remote Desktop Connections and other remote access tools to manage and maintain systems that are not physically accessible.

9.Continuous Learning & Development

• Stay current with the latest tools, trends, and best practices in ETL, cloud technologies, and data management.
• Foster a mindset of continuous improvement and life-long learning, attending relevant trainings or obtaining certifications as needed.

SUPERVISORY RESPONSIBILITIES: 

• None

EDUCATION, EXPERIENCE & QUALIFICATIONS To successfully perform this role, the individual must be able to meet the requirements outlined below. Reasonable accommodation may be provided to enable individuals with disabilities to perform essential functions.

• 3+ years of experience with ETL tools like Azure Data Factory, SSIS, or similar.
• Strong SQL and T-SQL skills for data extraction, transformation, and loading.
• Proficiency with Python for scripting and automation.
• Experience with PowerShell for task automation.
• Familiarity with Power Automate and its role in data workflows.
• Experience with pipeline creation and management in cloud (Azure) and on-premise environments.
• Solid understanding of data security and compliance principles for data movement.
• Ability to work both independently and collaboratively in a team environment.
• Excellent problem-solving skills and attention to detail.
• Commitment to continuous learning and growth in the field of data engineering.

PREFERRED QUALIFICATIONS 

Experience with Azure Data Services such as Azure Data Factory, Azure SQL Database, Azure Blob Storage, and Azure DevOps.

• Knowledge of DevOps practices and CI/CD for pipeline deployment.
• Certification in Azure or Data Engineering is a plus.

PHYSICAL DEMANDS The physical demands described below are representative of those required to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

• Ability to sit at a computer monitor for extended periods throughout the day.

WORK ENVIRONMENT The work environment characteristics described here are representative of those associate encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• General working conditions.

OUR BENEFITS

• Health Insurance (Medical, Prescription, Dental, and Vision)
• Life Insurance
• Disability Insurance
• Paid Holidays and Time Off
• 401(k) Plan with company matching

Artisan Design Group is committed to a policy of equal employment opportunity for applicants and employees. It is the policy of Artisan Design Group to apply recruiting, hiring, training, promotion, compensation, and professional development practices without regard to actual or perceived race, color, religion, sex (including pregnancy, sexual orientation and gender identity), national origin, age (40 or older), disability or certain classifications based on genetic information, or any other characteristic protected by federal, state or local laws, regulations or ordinances. 

We are committed to helping individuals with disabilities participate in the workforce and ensuring equal opportunity to apply and compete for jobs. If you need any assistance at any point in the application or hiring process due to a disability and you need accommodation, please email Accommodations@adgus.net. Please do not use this email address for any other questions. Only inquiries regarding accommodations will be addressed.