Developer

Ahmc Healthcare Inc.
Alhambra, CA, United States
about 1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$108,139.0
Working hours
Regular working hours
Job source

Tech stack

Business Analytics Applications Information Systems Data Architecture Data Integrity Extract Transform Load (ETL) Data Transformation Data Systems Database Security Software Debugging Microsoft SQL Server Performance Tuning Query Optimization
+9 more
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

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:37 min

Classifying and anonymizing data during system design

Reto Kaeser · LIVE

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu · WWC 2024

1:53 min

Utilizing modern query languages as facades for legacy interfaces

Oliver Sturm · Coffee With Developers

14:14 min

Addressing audience inquiries on analytical implementation and career growth

Julian Joseph · LIVE

1:57 min

Analyzing legacy systems using software data

Markus Harrer Markus Harrer · WWC 2021

4:15 min

Bridging operational and analytical systems using formal data contracts

Matthias Niehoff Matthias Niehoff · WWC 2024

Videos

See all

Related articles

See all