Senior ETL Developer (T-SQL, ADF, AI)

• Architect and implement highly scalable ETL data pipelines utilizing Azure Data Factory.
• Engineer and optimize complex T-SQL queries to extract and transform massive datasets.
• Stage and prepare clean enterprise data to fuel advanced machine learning and AI applications.
• Construct robust integration pipelines to support Large Language Models and RAG architectures.
• Optimize data extraction and loading processes across modern Microsoft cloud data environments.
• Automate data transformation workflows to ensure high-performance data delivery for AI tools.
• Collaborate cross-functionally with data science teams to align data engineering with AI objectives.

Database Extract Transform and Load (ETL), Artificial Intelligence (AI), Microsoft Transact-SQL (T-SQL), Database Extract Transform and Load (ETL), Microsoft Product Family, Enterprise Data Integration, Scalable System Development, Microsoft Windows Azure, Data Management, Query Optimization, * 7 or more years of experience in complex ETL data engineering and Microsoft stack development.

• Proficiency in Azure Data Factory and building scalable enterprise data integration pipelines.
• Experience in advanced T-SQL programming and database query optimization.
• Experience with data engineering to support artificial intelligence and machine learning pipelines.
• Experience in staging and transforming massive datasets for Large Language Models.
• Experience with architecting and deploying Retrieval-Augmented Generation architectures.
• Excellent verbal and written communication skills to collaborate with technical teams.

Founded in 1999, Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization. Headquartered in Marlborough, MA, the company serves the technology needs of its clients nationwide. Resourcesoft has often been recognized by prominent rating agencies for its exemplary growth and stability. With over two decades of industry experience, the Company has evolved as a front runner in enabling project optimization. We partner with leading organizations to provide technology solutions within the financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We take pride in mentoring a workforce that is well positioned to respond to the emerging IT trends and needs. With the employees at the crux of every business endeavor, our success is driven by our expertise in pairing the right talent with the best jobs in the technology sector. We forge long term, personalized relationships with our employees to advance their career to the next level. We engage them in technology centric client projects that provide opportunities for them to evolve, innovate and deliver world class products and services. Our career opportunities offer challenging assignments and exposure to emerging and cutting edge technologies. We are committed to providing our employees with the tools necessary to accelerate their career progression, while maintaining a healthy, work-life balance. We are deeply committed to providing a workplace ambience that is both challenging and fulfilling. Resourcesoft is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. For more information about Resourcesoft and our services, please visit our website.