Senior Database Engineer – SSIS and Database

Job Title: Senior Database Engineer – SSIS and Database Job Location: Westerville, OH | Onsite 5 days a week IT01 Description: AgreeYa is a global Systems Integrator and is seeking an Senior Databaase Engineer – SSIS and Database to join our growing team. The role combines traditional data engineering with SSIS framework knowledge expertise with modern DevOps practices to build, maintain, and optimize our data infrastructure and pipelines. We are looking for an experienced Data Engineer who specializes in ETL processes, SSIS and SQL. The successful candidate will be responsible for designing, implementing, and maintaining robust data solutions while ensuring seamless deployment processes and providing technical support for data-related issues. Job Responsibilities Data Engineering & ETL Development Design, develop, and maintain ETL processes using SSIS and SQL. Build and optimize data pipelines to process structured and unstructured data Develop automated data validation and quality assurance processes Create and maintain data models, schemas, and database objects in MS SQL Server Implement data transformation logic to support business intelligence and analytics requirements Database Management & Optimization Administer and optimize MS SQL Server databases for performance and reliability Monitor database performance and implement tuning strategies Design and implement data archiving and retention policies Optimize SQL queries and stored procedures for enhanced performance Technical Support & Troubleshooting Provide Level 2/3 support for data-related issues Investigate and resolve data quality issues, pipeline failures, and performance bottlenecks Collaborate with business users to understand and resolve data discrepancies Create and maintain comprehensive documentation for troubleshooting procedures Establish monitoring and alerting systems for proactive issue identification Collaboration & Communication Work closely with data analysts, business intelligence developers, and business stakeholders Participate in agile development processes and sprint planning DevOps & CI/CD Implementation (Nice to have) Design and implement CI/CD pipelines using Azure DevOps for data engineering projects Automate deployment processes for SSIS packages, Python scripts, and database objects Implement infrastructure as code practices for data platform components Required Qualifications: Technical Skills SSIS: Strong experience with SQL Server Integration Services ETL Development: Experience designing and implementing ETL processes MS SQL Server: Strong experience with SQL Server performance tuning, and T-SQL development Data Troubleshooting: Proven experience in diagnosing and resolving complex data issues Familiarity with Git version control and branching strategies Azure DevOps: Experience with Azure DevOps, including build/release pipelines, repositories, and work item tracking CI/CD Pipelines: Strong experience designing and implementing automated deployment pipelines Professional Requirements 6- 8 years of experience in data engineering or related roles Strong analytical and problem-solving abilities Excellent communication and documentation skills Experience working in agile development environments Ability to work independently and manage multiple priorities AgreeYa is a global systems integrator delivering competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 2,200 staff across offices. AgreeYa works with 500+ organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public sector, Pharma & Biotech, and others. Please visit us at www.agreeya.com for more information. AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics. Visit our website to learn about our Career & Culture. Job Type: Contract Benefits: Dental insurance Health insurance Vision insurance Work Location: In person