AgreeYa Solutions
SQL Server Developer
AgreeYa Solutions, Basking Ridge, New Jersey, us, 07920
Looking for candidates with more experience on SSIS as mentioned in the requirement. The previous resumes have SSIS but not actual working experience in SSIS - Microsoft SQL Server Integration Services 2014 or later.
Responsibilities:• 10+ years of experience in data engineering.• Design, develop, and maintain new data capabilities and infrastructure for utilizing, third-party, and partner data to enhance data products and solutions• Design, develop, and implement scalable data pipelines and ETL/ELT processes using SSIS, Python and API integrations• Identify existing data capability and infrastructure gaps or opportunities within and across initiatives and provide subject matter expertise in support of remediation• Collaborate with technical team and business stakeholders to understand data requirements and translate them into technical solutions• Work with large datasets, ensuring data quality, accuracy, and performance• Implement data transformation, integration, and validation processes to support analytics and reporting needs• Optimize and fine-tune data pipelines for improved speed, reliability, and efficiency• Implement best practices for data storage, retrieval, and archival to ensure data accessibility and security• Troubleshoot and resolve data-related issues, collaborating with the team to identify root causes• Document data processes, data lineage, and technical specifications for future reference• Review and analyze existing data collection systems, and make recommendations on improvement, maintenance, or other factors to improve the system.• Develop, build, and implement new data collection systems where needed.• Provide training and guidance on new systems that are being implemented.• Participate in code reviews, ensuring adherence to coding standards and best practices• Collaborate with other teams to automate deployment and monitoring of data pipelines• Proven experience in data engineering, with a strong track record of designing and implementing data solutions• Proficiency in programming languages such as Python, Java, or Scala, and experience with data processing frameworks (Spark, Hadoop, etc.)• In-depth understanding of data warehousing concepts, cloud platforms (GCP), and data modeling techniques• Strong knowledge of SQL and NoSQL databases, as well as data integration and transformation tools(SSIS)• Passion for and engagement with emerging trends in data, AI/ML, analytics, and digital experiences• Experience in data product development, analytical models, and model governance• Experience in anonymizing data and managing the use of data• Experience in data hygiene procedures, identity resolution capabilities or data management a plus• Familiarity with BI technologies (e.g. Microsoft Power BI, Tableau)
MUST HAVE SKILLS:Microsoft SQL ServerMicrosoft Business Intelligence(SSIS,SSAS & SSRS)Python
EDUCATION/CERTIFICATIONS:• Bachelor's or Master's degree in Computer Science, Engineering, or a related field• Microsoft/Oracle SQL, Tableau Data Analyst Certification
AgreeYa Solutions is a global systems integrator delivering technology-enabled business solutions to small, medium and global Fortune 1,000 organizations. It leverages leading-edge technology, consulting and outsourcing services to boost customer efficiency, productivity and deliver a competitive advantage. Through its consultative approach and utilization of a global delivery model, AgreeYa provides software, services and solutions that are cost-effective, achieve results and transform businesses.
Founded in 1999 and headquartered in Folsom, California, with a global footprint, AgreeYa is an SEI CMMI- and ISO 9001:2015-certified Microsoft Gold Partner, with multiple certifications, and operations with a team of over 1,800 employees across the world. Its extensive software portfolio includes AgreeYa Chatbot, BeatBlip, QuickApps, Site Administrator, Recovery Manager and Cogent. AgreeYa is a staffing industry leader, providing full-service staffing solutions to meet client workforce needs while driving business value. It also recently introduced a new intelligent automation and digital transformation suite to its existing technology stack to help organizations combat future crises and venture into the digital-first world with confidence. For more information, visit www.agreeya.com
Responsibilities:• 10+ years of experience in data engineering.• Design, develop, and maintain new data capabilities and infrastructure for utilizing, third-party, and partner data to enhance data products and solutions• Design, develop, and implement scalable data pipelines and ETL/ELT processes using SSIS, Python and API integrations• Identify existing data capability and infrastructure gaps or opportunities within and across initiatives and provide subject matter expertise in support of remediation• Collaborate with technical team and business stakeholders to understand data requirements and translate them into technical solutions• Work with large datasets, ensuring data quality, accuracy, and performance• Implement data transformation, integration, and validation processes to support analytics and reporting needs• Optimize and fine-tune data pipelines for improved speed, reliability, and efficiency• Implement best practices for data storage, retrieval, and archival to ensure data accessibility and security• Troubleshoot and resolve data-related issues, collaborating with the team to identify root causes• Document data processes, data lineage, and technical specifications for future reference• Review and analyze existing data collection systems, and make recommendations on improvement, maintenance, or other factors to improve the system.• Develop, build, and implement new data collection systems where needed.• Provide training and guidance on new systems that are being implemented.• Participate in code reviews, ensuring adherence to coding standards and best practices• Collaborate with other teams to automate deployment and monitoring of data pipelines• Proven experience in data engineering, with a strong track record of designing and implementing data solutions• Proficiency in programming languages such as Python, Java, or Scala, and experience with data processing frameworks (Spark, Hadoop, etc.)• In-depth understanding of data warehousing concepts, cloud platforms (GCP), and data modeling techniques• Strong knowledge of SQL and NoSQL databases, as well as data integration and transformation tools(SSIS)• Passion for and engagement with emerging trends in data, AI/ML, analytics, and digital experiences• Experience in data product development, analytical models, and model governance• Experience in anonymizing data and managing the use of data• Experience in data hygiene procedures, identity resolution capabilities or data management a plus• Familiarity with BI technologies (e.g. Microsoft Power BI, Tableau)
MUST HAVE SKILLS:Microsoft SQL ServerMicrosoft Business Intelligence(SSIS,SSAS & SSRS)Python
EDUCATION/CERTIFICATIONS:• Bachelor's or Master's degree in Computer Science, Engineering, or a related field• Microsoft/Oracle SQL, Tableau Data Analyst Certification
AgreeYa Solutions is a global systems integrator delivering technology-enabled business solutions to small, medium and global Fortune 1,000 organizations. It leverages leading-edge technology, consulting and outsourcing services to boost customer efficiency, productivity and deliver a competitive advantage. Through its consultative approach and utilization of a global delivery model, AgreeYa provides software, services and solutions that are cost-effective, achieve results and transform businesses.
Founded in 1999 and headquartered in Folsom, California, with a global footprint, AgreeYa is an SEI CMMI- and ISO 9001:2015-certified Microsoft Gold Partner, with multiple certifications, and operations with a team of over 1,800 employees across the world. Its extensive software portfolio includes AgreeYa Chatbot, BeatBlip, QuickApps, Site Administrator, Recovery Manager and Cogent. AgreeYa is a staffing industry leader, providing full-service staffing solutions to meet client workforce needs while driving business value. It also recently introduced a new intelligent automation and digital transformation suite to its existing technology stack to help organizations combat future crises and venture into the digital-first world with confidence. For more information, visit www.agreeya.com