This position supports the agency to ensure proper planning, coordination and documentation to assimilate, and troubleshoot data and data flows into Latcha and clients’ data environments.The Data Integration Analyst 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).

MAJOR RESPONSIBILITES:

• 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 3rdparty data sources.
• Understand client data and database environments to ensure proper integration of data across multiple systems (data structures, outputs, reporting data marts, front end CRM tools).
• 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.

SUBJECT MATTER KNOWLEDGE and SKILLS: Expert or emerging expert in database design or development from a business perspective. Has experience analyzing systems and business processes to identify user needs, document requirements, and address operation/process issues.Experienced with ETL, advanced SQL and data validation business rules.

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
• Understanding of Data Marts and Data Warehouses and their structures
• 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 3^rd-party automotive or media data is a plus.