Developer III - Database

Intrinsiq Specialty Solutions, Inc. • Conshohocken, PA • 1h ago

Work with business analysts and business users to gather and interpret business requirements for multiple financial and healthcare systems including large data warehouses. Design and develop database applications using SQL Server Integration Services, TSQL, and Stored Procedures. Consult with the business to determine the logical design for new business solutions according to existing data architecture. Perform code reviews, analyze execution plans, and re-factor inefficient code. Follow data standards, resolve data issues, complete unit testing, and complete system documentation for ETL processes. Collaborate with business analysts, source system experts, and other team members to determine data extraction and transformation requirements. Design, develop, test, deploy, and maintain data processing systems and build scalable data pipelines using Azure Data Factory to extract, transform, and load structured as well as unstructured data. Implement secure storage and access controls for sensitive data using Azure Key Vaults. Leverage Azure Databricks for advanced analytics tasks including ETL jobs and machine learning workflows. Utilize Spark fundamentals to optimize the performance of big data processing tasks. Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions. Ensure data quality by implementing appropriate validation checks and error-handling mechanisms. Work closely with DevOps teams to integrate data engineering processes into CI/CD pipelines. Monitor the performance of data pipelines and troubleshooting any issues that arise. Document technical specifications, processes, and best practices. Utilize Azure Databricks, Azure DW, Python and Scripts.

Requires a Bachelor's degree or foreign equivalent in Computer Science, Computer Engineering, Information Technology or a related field. Requires minimum 2 years of experience in a Data Engineer, Software Engineer or related position maintaining data processing systems and building scalable data pipelines using Azure Data Factory. Experience must include: writing complex SQL queries to perform data extraction; troubleshooting issues in production in a timely fashion and working across teams of different skill levels; configuring and supporting managing ETL automation with SQL Server Integration Services; developing Spark applications for data extraction, transformation, and aggregation; and utilizing Azure Functions, Azure Databricks, Azure DW, Python and Scripts. Experience developing Spark applications for data extraction, transformation, and aggregation. Experience in technologies relevant to data/information management, such as SQL, RDBMS, Data Lake/Hadoop, MDM, Metadata, and Data Quality; working with clinical data. Fully remote work permitted.

Resumes to Victoria Maskery - Victoria.Maskery@cencora.com, reference Job code: R2611059

Go to Apply

Mechanical Engineer (Environmental)

Noblis • Philadelphia, PA • 1d ago

IT & Engineering

Responsibilities Noblis MSD's mission is to support the Naval Sea Systems Command (NAVSEA) and, Naval Surface Warfare Center (NSWCPD) and their missions' to enable research, development, test and evaluation, acquisition,...

1d ago

Go to Apply

Mechanical Engineer (Batteries)

Noblis • Philadelphia, PA • 1d ago

IT & Engineering

1d ago

Go to Apply

Software Engineer

Bentley Systems Incorporated • Exton, PA • 1d ago

IT & Engineering

JOB DESCRIPTION: Bentley Systems, Incorporated, (Exton, PA) opening for a Software Engineer, responsible for developing high-quality software using C++, C#, and other relevant languages while implementing new features an...

1d ago

Go to Apply

Software Engineer

Globus Medical, Inc. • Audubon, PA • 1d ago

IT & Engineering

1d ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)