Senior Integration Engineer

This is a fully remote position, open to applicants in New York.

📋 Description

• Design, construct, deploy, consume, document, and integrate APIs across development, testing, and production environments.

• Develop functional databases, applications, and servers that support website back ends.

• Integrate datasets from diverse source systems into cohesive formats.

• Collaborate with analysts, product managers, business users, and architects to gather requirements and formulate specifications.

• Author, debug, test, and document program code.

• Conduct data cleansing and validation to ensure compliance with enterprise data quality standards.

• Optimize software workflows to enhance process efficiency.

• Build and maintain data pipelines that retrieve, standardize, and transform data from source systems.

• Load processed data into analytical data stores for use by developers and analysts.

• Create user stories and estimate effort and duration within an agile development framework.

• Monitor performance and quality of data transfers between source and target systems.

• Integrate testing suites into CI/CD pipelines.

• Optimize data flows for increased efficiency, scalability, and reliability.

• Develop back-end database applications utilizing T-SQL/PL-SQL in Microsoft SQL Server.

• Write complex stored procedures and PL/SQL code.

• Troubleshoot data accuracy and performance issues by creating indexes, modifying transaction isolation levels, and optimizing code.

• Lead the complete software and application lifecycle from conception to completion.

• Comply with BSA/AML/OFAC regulatory training and requirements.

• Perform related tasks and special projects as assigned.

⛳️ Requirements

• Bachelor’s degree in information systems, Computer Science, Engineering, or a related field, or an equivalent combination of education, training, and experience.

• Proficient in SQL and data pipeline tools such as Fabric and Azure Data Factory.

• Expertise in .NET-based architecture and enterprise application integration.

• In-depth knowledge of C# for creating scalable, high-performance systems.

• Demonstrated experience in delivering and enhancing data quality in cloud Big Data environments, including Enterprise Data Lake, Data Warehouse, and Data Hubs.

• Strong grasp of ETL processes and data warehousing concepts.

• Familiarity with DevOps toolsets such as Azure DevOps.

• Experience in designing, executing test cases, and tracking defects.

• Knowledge of QA methodologies such as Agile and Scrum.

• Excellent verbal and written communication abilities.

• Experience in data modeling and metadata management.

• Capability to troubleshoot and resolve data-related issues.

• Advanced skills in Microsoft SQL Server, including database optimization, performance tuning, and complex SSIS package development.

• Familiarity with core integration concepts and optimization techniques.

• Preferred experience with Microsoft tools for collaborative products and workflows.

• Ability to thrive in a high-volume environment while maintaining exceptional attention to detail.

• High ethical standards and effective communication skills with team members and stakeholders.

🏝️ Benefits

• Discretionary bonus eligibility.

• 401(k) plan with a 6% employer match per pay period.

• Comprehensive medical, vision, dental, life, and disability insurance.

• Flexible paid time off policy.

• 11 paid holidays each year.

• Commitment to equal employment opportunities and a welcoming, inclusive workplace.