Data Integration Specialist (SQL, ETL, BI) Job at Ledgent Technology, Cypress, CA

YW9sTSthejY3QzVEeUhsT1lqVlp4QWs0cFE9PQ==
  • Ledgent Technology
  • Cypress, CA

Job Description

SUMMARY:

The incumbent in this role ensures seamless data integration across business systems, develops and maintains ETL workflows, supports BI reporting, and assists with projects like onboarding marketplaces and EDI testing. This role focuses on data accuracy, system coordination, and supporting business operations.

KEY RESPONSIBILITIES:

  • Data Integration:
  • Design, implement, and maintain data integration processes between multiple systems.
  • Ensure seamless data flow and synchronization across platforms to enhance business applications.
  • Monitor and troubleshoot integration processes to guarantee timely and accurate data transfers.
  • ETL (Extract, Transform, Load) Development:
  • Develop, manage, and optimize ETL workflows for the extraction, transformation, and loading of data across systems.
  • Create scripts and leverage automation tools to streamline integration tasks in support of business applications.
  • System Coordination:
  • Work closely with the Business Application Manager to align integration efforts with business needs and application requirements.
  • Assist the Business Application Manager in managing integration projects, such as onboarding new marketplaces or conducting EDI (Electronic Data Interchange) testing.
  • BI Reporting and Collaboration:
  • Collaborate with Business Intelligence (BI) users to create and support reports that leverage integrated data from various systems.
  • Ensure data required for BI reporting is properly integrated, accurate, and accessible.
  • Troubleshoot data discrepancies in reports and provide the necessary support for report generation.
  • Reporting and Documentation:
  • Maintain clear and concise documentation of integration processes, including data mapping, workflows, and troubleshooting steps.
  • Provide regular status reports to the Business Application Manager regarding the progress and issues related to data integrations.
  • Other duties as assigned

MINIMUM REQUIREMENTS:

Education/experience:

  • Bachelor's degree in Computer Science, IT related major, or equivalent experience.
  • Experience with data integration, ETL processes, and data management.
  • Strong proficiency in SQL and database management.
  • Experience with data integration and business intelligence tools.
  • Excellent problem-solving and analytical skills.
  • Familiarity with cloud platforms Azure is a plus, but not mandatory.
  • Familiarity with EDI document protocol is a plus, but not mandatory.
  • Strong communication skills to work cross-functionally with teams and stakeholders.
  • Excellent attention to detail and troubleshooting abilities.
  • Ability to manage multiple priorities in a dynamic work environment.


All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county , to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.

Job Tags

Local area,

Similar Jobs

Confidential

Chief Information Officer (CIO) Job at Confidential

 ...Chief Information Officer (CIO) About the Company Well-established healthcare provider Industry Hospital & Health Care Type Non Profit Founded 1925 Employees 1001-5000 Categories Medical Centers Medical Care Health Care Non-Profit... 

LanceSoft

Travel Nurse RN - Telemetry Job at LanceSoft

 ...Description LanceSoft is seeking a travel nurse RN Telemetry for a travel nursing job in...  ...), ACLS (AHA) certificate Required.Acute Care hospital experience & Ventilator...  ...Facilities, Home Health & Community Health, Urgent Care Clinics, and many other provider-based... 

Business Trips by Elite

Virtual Assistant Manager - Entry Level Job at Business Trips by Elite

 ...Job Title: Virtual Assistant Manager - Entry Level Location: Remote Job Type: Full-Time/Part-Time Available We are looking for a highly organized and detail-oriented Virtual Assistant Manager - Entry Level to support our team withscheduling,data entry,administrative... 

Alura Animal Health & Nutrition

Global logistics and Customer Service Manager Job at Alura Animal Health & Nutrition

 ...Reviews and analyzes transportation costs, parts procurement and delivery processes, inventory issues such as back orders, and other fulfillment metrics Responsible for keeping updated the inventory report, sales reports, and outstanding reports in coordination with... 

Highlights Healthcare

Licensed and Board Certified Behavior Analyst (LBA, BCBA) ABA Therapy - $2500 SIGN ON/RETENTION + RELOCATION $ (STVL) Job at Highlights Healthcare

 ...North Carolina, offering a $2500 sign-on/retention bonus and relocation assistance. As a BCBA, you will: ~ Supervise ABA staff and monitor skill-building interventions for children with autism. ~ Conduct psychological analyses and develop child-...