Senior Integrations Developer (Dynamics Azure)

We are currently seeking a skilled and motivated senior-level software developer for an exciting opportunity. This position will be based at our Corporate Headquarters in Orange, CA or Plano, TX. As part of our dedicated team, you will play a key role in leading software development for application and data integration functions. Your responsibilities will include defining solutions, developing, and maintaining Azure Data Factory pipelines and SSIS ETLs, leading .NET application integration efforts, producing software development lifecycle artifacts, performing proof-of-concepts, and effectively communicating deliverables to leadership and technology teams.

Collaborating closely with other IT service and business teams, you will be responsible for overseeing the software development lifecycle for multiple systems to support our company's strategic goals.

Responsibilities:

• Designing and developing data integration and processing pipelines using Azure Data Factory and Azure Synapse.
• Developing ETL (extract, transform, load) processes to move and transform data across various on-prem and cloud data sources using SSIS.
• Creating .NET applications and APIs to support data integration and processing.
• Configuring and managing data sources, datasets, and linked services within Azure Data Factory, Azure Synapse, and Dynamics 365 Customer Insights.
• Developing SQL queries and stored procedures to support data integration and processing.
• Designing and developing business solutions utilizing Microsoft SQL Server and SSIS/ETL.
• Integrating Azure Data Factory and Azure Synapse with other Azure services, such as Azure Blob Storage and Azure SQL Database.
• Developing Power Apps and Power Automate workflows to support customer data integration and processing.
• Building scalable, reusable, high-performing, and highly available software solutions.
• Identifying and promoting standardized, reusable technology functionality aligned with business and technology strategy to reduce cost of ownership and improve information flow.
• Producing and maintaining software artifacts and high-level designs in collaboration with development, infrastructure, and other IT and business teams.
• Understanding the impact of changes to existing processes, functions, and systems and documenting these relationships with processes and information flow diagrams.
• Delivering presentations that clearly articulate technology solutions to leadership and technology staff in simple terms.
• Establishing relationships with third-party partners and vendors and defining secure and reliable integration solutions as required.
• Providing production support for data pipelines and data integration processes, and demonstrating leadership during troubleshooting.
• Requirements:

• Strong understanding of the Azure platform, including its various services and data storage options.
• Solid hands-on experience with Azure Data Factory and SSIS.
• Proficiency in Azure Synapse and modern data warehousing solutions, including creating and managing Synapse SQL pools, building data pipelines, and integrating with other Azure services.
• Expertise in programming languages such as SQL, Python, and .NET, along with experience in data integration and ETL processes using SSIS.
• Familiarity with advanced analytics and machine learning techniques, including the use of tools such as Azure Machine Learning and Azure Cognitive Services for building predictive models.
• Good understanding of JSON, XML, XSLT, XSD, and XML parsing processes.
• Knowledge of scripting languages like Perl, C#, and JavaScript.
• Strong SQL experience, preferably with Microsoft SQL Server.
• Experience in agile development practices and methodologies.
• Good understanding of microservices architecture, cloud-native technologies (SaaS, PaaS), multi-tenancy, multi-tiered infrastructure, serverless computing, and CI/CD.
• Familiarity with data protection standards and associated security processes.
• Highly detail-oriented with excellent interpersonal and communication skills.
• Strong problem-solving abilities and effective communication skills.
• Preference will be given to candidates with healthcare industry experience.
• Bachelor's degree in Computer Science, Information Systems, or a related discipline.