About the Company

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

About the Role

The Data Integration Engineer is responsible for the accuracy and process documentation of the data that our internal teams utilize on various accounts. This role requires developing and translating technical specification documents internal and external teams put together into a format that stakeholders are able to read and understand (with various amounts of data knowledge and expertise).

Responsibilities

• Identify, gather and document requirements for database procedures and applications
• Collaborate with all stakeholders including client-side IT professionals for purposes of Campaign Operations platform efficiencies and readiness.
• Work closely with agency, client and data management professionals including 1st and 3rd party data sources.
• Understand varying client data ecosystems to ensure proper integration across multiple systems (DMS platforms, CRM tools, marketing activation systems, MDM, and analytics environments).
• Understand data gaps and limitations of current tool set/available data and work towards solutions to bridge gaps independently or with client-side resources.
• Continually QA data to ensure accuracy, consistency, fidelity.
• Proactively communicate ideas and opportunities to Leadership and peers.
• Develop new data integrations based on client needs and agency objectives.
• Document integration processes for current and future state.
• Create, design and execute data test plans.
• Work closely with remote teams (internal and external) to continually troubleshoot data issues or create data enhancements to improve processes.
• Provide business approvals for User Acceptance Testing (UAT).
• Identify opportunities to optimize and streamline current business processes.
• Create documentation, test, QA and finalize.

Qualifications

• 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.

Work Location: 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).

Equal Opportunity Statement

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.