Developer

Ahmc Healthcare Inc.
Alhambra, United States of America
19 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 108K

Job location

Alhambra, United States of America

Tech stack

Business Analytics Applications
Information Systems
Data Architecture
Data Integrity
ETL
Data Transformation
Data Systems
Database Security
Software Debugging
Microsoft SQL Server
Performance Tuning
Query Optimization
Software Engineering
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
Data Ingestion
Information Technology
SQL Server Management Studio (SSMS)
Data Pipelines
Legacy Systems

Job description

Under direction, performs a wide range of application development related duties including analysis, design, evaluation, development, coding, testing and maintenance of complex application systems., * Design, build, and maintain scalable data pipelines and analytics solutions as part of migrating legacy systems to modern cloud-based platforms.

  • Develop and support ETL (Extract, Transform, Load) processes and data architectures (e.g., layered/medallion approaches) to ensure reliable data ingestion, transformation, and delivery during and after migration.
  • Monitor and optimize data solutions for performance, cost efficiency, and security in a cloud environment.
  • Collaborate with cross-functional teams to support system migration, validate data integrity, and troubleshoot production issues.
  • Design and develop SQL Server stored procedures, functions, views, and triggers to be used during the ETL process.
  • Design and develop SSIS / SQL ETL solutions that consume data from numerous upstream systems for data transformation and processing.
  • Design, implement, and maintain database objects (tables, views, indexes) and database security.
  • Proficient with ETL tools, expert in industry standard best practices on Microsoft SSIS and SSMS (2016 or higher)
  • Analyze and develop strategies to import and transfer data between source, staging, and Development/Production Warehouse destinations.
  • Troubleshoot and correct ETL warnings and errors and resolve critical issues promptly.
  • Provides analytical and technical expertise on performance tuning, index optimization, and query optimization.
  • Stays informed of new developments and technologies by reading journals and other pertinent publications, maintaining contact with vendors, and participating in professional organizations, meetings, and seminars.
  • Work closely with MED IT to assist in patch update reboot, capacity planning, and performance tuning.
  • Perform additional duties as assigned.

Requirements

Do you have experience in Testing and evaluation?, Do you have a Bachelor's degree?, * Good communication skills, both written and verbal.

  • Healthcare experience preferred.
  • Three (3) years of full-time experience performing coding, testing, and debugging application programs obtained within the last three (3) years.
  • Help desk experience required
  • Multi-facility support desired
  • Experience in firewall management
  • Experience in managing systems administration operations required
  • Technical certifications are a plus

EDUCATION/CERTIFICATION/LICENSE

  • A Bachelor's degree from an accredited college or university in Computer Science, Information Systems, or Data Science

Apply for this position