Integration Analyst

Latcha is a Mar Tech agency bringing marketing solutions to life for automotive companies and dealerships.

The Integration Analyst is responsible for the accuracy and process documentation of the data that our internal teams utilize on various accounts. The Integration Analyst will document and map DMS data structures (CDK, Reynolds & Reynolds) for current OEM dealers, translating dealer exports into standardized enterprise data models.

• Interface with internal PMO and Account teams
• Understand & can translate various DMS schemas
• Owns the relationship with the Client & Dealers
• Integrations Analyst takes over from there, often interfacing with dealers while setting up sandbox environments, retrieving permissions/keys and mapping to the MDM
• Owns the relationship with Account >
  Engineering
• Create repeatable onboarding playbooks
• Owns communication regarding DMS changes and data validation

• Demonstrated experience in the development of strategic, logical and creative solutions to challenging problems
• Ability to interact comfortably with both clients and internal departments
• Ability to effectively manage time, prioritize tasks and work within deadlines with little supervision
• Highly accountable individual with excellent communication, collaboration, organizational and project management skills
• Understands ETL and document file validation business rules
• Heavy understanding of modern data Lakehouse architectures, API-based integrations, and enterprise cloud data platforms (Azure/Databricks)
• Attention to detail and quality control
• SQL proficiency:
  Microsoft (Azure and SQL Server) is required
• 2+ years’ experience in advertising agency role, CRM data is required
• Experience with 3rd-party automotive or media data is a plus

• SQL proficiency:
  Microsoft (Azure and SQL Server) is required
• Data Lakehouse architectures, API-based integrations, and enterprise cloud data platforms (Azure/Databricks)
• 2+ years’ experience in advertising agency role, CRM data is required

• Experience with 3rd-party automotive or media data is a plus

In person at our office in Farmington Hills, MI. Must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Latcha+Associates will not sponsor applicants for U.S. work visa status for this opportunity (no sponsorship is available for H-1B, L-1, TN, O-1, E-3, H-1B1, F-1, J-1, OPT, CPT or any other employment-based visa).

All qualified applicants are considered for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, citizenship status, disability, protected veteran status, or any other category protected by applicable federal, state or local laws.