LatchaLatcha is a MarTech agency bringing marketing solutions to life for automotive companies and dealerships.
As a Data Integration engineer, a successful candidate will have a broad technical understanding of ETL, Database Structures, Data Warehousing, Enterprise level data management, and CRM data needs while also having strong problem solving, analytical and communication skills.
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).
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 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.
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
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.
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.
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.
¿Te interesa este puesto?