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

Mactac North America

Environmental, Health and Safety Manager Job at Mactac North America

 ...Manager, you will manage a comprehensive Environmental, Health and Safety program for the Mactac Spartanburg, SC facility. You will...  ...for all employees. Provide oversight and completion of the industrial hygiene program. Provide direction, training, and ensure compliance... 

Apetan Consulting llc

Mobile UI/UX Developer/ Frontend Developer-100% Remote Job at Apetan Consulting llc

 ...Job Title: Mobile UI/UX Developer Location: Remote Job Summary: We are looking for a talented Mobile UI/UX Developer to design and...  ...visually appealing and user-friendly mobile interfaces for iOS and Android apps. Collaborate with product managers,... 

Queen City Promotions

Charity Account Assistant Job at Queen City Promotions

 ...marketing while supporting meaningful causes. We specialize in hosting dynamic events that raise awareness and funds for impactful nonprofit organizationsand we need enthusiastic individuals like you to help drive our mission forward. Responsibilities: Engage with... 

Firetrol Protection Systems

Fire Alarm Technician Job at Firetrol Protection Systems

 ...Fire Alarm Technician Founded in 1984, Firetrol is the national leader in fire protection & life safety services. We are currently seeking a skilled Fire Alarm Technician to join our team of over 1,200 of the best fire protection professionals in the industry. This... 

U.S. Tsubaki Power Transmission, LLC

Heat Treat (Metal Finishing): Operator (UH) - 24/7 Day Shift Job at U.S. Tsubaki Power Transmission, LLC

Job Description Job Description Description: The TSUBAKI name is synonymous with excellence in quality, dependability, and customer service. U.S. Tsubaki is a leading manufacturer and supplier of power transmission and motion control products. As a part of a vast,...