[Remote] Marketing Data Analyst

Note: The job is a remote job and is open to candidates in USA. Optomi is partnering with a leading financial services company to find a Marketing Data Analyst. This role involves bridging the technical data infrastructure with marketing strategy, ensuring marketing decisions are supported by clean data, and managing project timelines for data integration projects.ResponsibilitiesIdentify the business use cases from our stakeholders. Source the data from the relevant platform to fulfill the use cases. Understand and perform relational data-modelingAct as the custodian of the marketing data warehouse. Ensure data from various sources (CRM, Ads, Web Analytics etc.) are properly integrated and structured for consumption by the analysts and other usersWrite and optimize database queries to develop regular and ad-hoc reportsEducate analysts on leveraging specific data sets to meet business objectives, including technical, hands-on instructionsServe as the "connective tissue" between the Data Engineering and the Marketing Analytics teams. Define and manage project scopes, and ensure technical deliverables meet marketing business use cases and requirements and project timelinesIdentify and resolve data discrepancies between various marketing platforms and the Enterprise data warehouseSkillsStrong Oracle SQL / database expertiseDeep understanding of Data Warehousing (e.g., Snowflake, BigQuery) and Relational Database Management Systems (RDBMS)Working proficiency of SQL (joins, CTEs, window functions) for data extraction and manipulationWorking proficiency in Marketing in general, and Marketing Analytics in specific, including attribution modeling, funnel analysisProficient in both Marketing & Sales tools and data. Tools: Google Analytics, Adobe Analytics, Marketo, MS Dynamics 365, Salesforce etcWorking proficiency in data visualization tools like Tableau, Power BIStrong Project Coordination skills; experience with Agile/Scrum or tools like Jira, Asana, or TrelloAbility to translate complex data findings into 'plain English' for non-technical marketing stakeholdersCompany OverviewOPTOMI is an IT staffing firm that serves its consultants, clients, and employees through its consultant-focused approach. It was founded in 2012, and is headquartered in Roswell, Georgia, USA, with a workforce of 501-1000 employees. Its website is http://www.optomi.com/.Company H1B SponsorshipOptomi has a track record of offering H1B sponsorships, with 7 in 2025, 6 in 2024, 2 in 2023, 5 in 2022, 8 in 2021, 7 in 2020. Please note that this does not guarantee sponsorship for this specific role.