Application & Integration Developer, SQL, Integrations, Power BI

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

📋 Description

• Create, develop, and sustain integrations between internal systems and external business applications.

• Design, enhance, and provide support for Microsoft SQL Server databases, including stored procedures, views, and queries.

• Construct and manage data integration and ETL processes utilizing SSIS and associated technologies.

• Develop and maintain Power BI reports, dashboards, and datasets.

• Design, utilize, and troubleshoot REST APIs, web services, and application interfaces.

• Assist with data migrations, synchronization tasks, and system-to-system integrations.

• Investigate and resolve issues related to data quality, reporting, and integrations.

• Collaborate with business stakeholders to gather requirements and provide effective technical solutions.

• Maintain technical documentation and assist with deployment and release activities.

⛳️ Requirements

• 3-6 years of experience in application development, database development, or systems integration.

• Strong expertise in Microsoft SQL Server and T-SQL, SQL Server Integration Services (SSIS), Power BI, and ETL/data integration development.

• Experience in designing and supporting integrations between business applications.

• Familiarity with REST APIs, JSON and XML data formats, SOAP web services, file-based integrations (CSV, flat files, EDI), and data migration and synchronization processes.

• Experience in troubleshooting production issues related to integration, data quality, and reporting.

• Strong analytical, problem-solving, and communication abilities.

• Preferred: Experience in developing solutions within at least one Microsoft Dynamics 365 platform, including Customer Engagement (CRM), Business Central, or Finance & Operations (F&O).

• Preferred: Experience in integrating ERP, CRM, e-commerce, warehouse, and other enterprise applications.

• Preferred: Familiarity with Microsoft Fabric, Azure Synapse Analytics, Azure Data Factory, Azure Logic Apps, Azure Functions, Azure SQL Database, Azure DevOps, C#/.NET development, and data warehousing and analytics solutions.

🏝️ Benefits

• Competitive salary and comprehensive benefits package.

• Opportunities for professional growth and development.

• Flexible working hours and a supportive work environment.