Data Scientist- Mid Level

• Design and maintain enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, and PL/SQL.
• Develop and optimize cloud data warehouse solutions using Azure Synapse SQL/Spark pools and Microsoft Fabric Lakehouse.
• Build and tune SQL/PL/SQL procedures, packages, functions, queries, and data integration processes.
• Create analytics-ready datasets, semantic models, dashboards, and reporting solutions for Power BI.
• Integrate advanced analytics and AI capabilities through Azure Machine Learning and Azure OpenAI services.
• Implement data quality, governance, access controls, and security processes using Microsoft Purview and Entra ID.

Data Science, Database Extract Transform and Load (ETL), Data Analysis, SQL (Structured Query Language), Oracle PL-SQL, Performance Tuning/Optimization, Python Programming/Scripting Language, Query Optimization, Scala Programming Language, Microsoft Windows Azure, * 7 years or more of enterprise data analytics, data engineering, ETL/ELT development, SQL, and PL/SQL experience.

• Proficiency in Azure Synapse Analytics, Azure Data Factory, Microsoft Fabric, and cloud data warehousing.
• Experience with Python, PySpark, Scala, complex SQL development, query optimization, indexing, and performance tuning.
• Experience with Azure data modeling, Microsoft Entra ID, RBAC, cloud security, performance tuning, and cost optimization.
• Experience in Power BI, Azure OpenAI, generative AI integration, Agile, Scrum, Kanban, or SAFe environments.
• Excellent verbal and written communication skills.

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.