Marketing Reporting Specialist

Job title: Marketing Reporting Specialist

About the Role

Marketing Reporting Specialist to support the development of scalable data pipelines and reporting solutions that enable data-driven marketing operations. This role focuses on data integration, transformation, and dashboard development, ensuring reliable and consistent data across Tyler’s marketing technology ecosystem. As part of Tyler’s corporate staff, you will make an impact on outcomes that affect various areas of the company, including team members, clients, stakeholders, and the public sector.

What You'll Do

• Design and build data pipelines using API integrations/ETL tools to integrate data from CRM, marketing automation platforms, Customer data platforms, advertising, web, social platforms, and other MarTech tools

• Develop and maintain centralized marketing datasets and Lakehouse structures in accordance with company standards

• Ensure data integrity, consistency, and governance across systems by developing and maintaining sequential update schedules

• Write and maintain complex SQL queries and Python scripts for data extraction, transformation, and aggregations to prepare clean, standardized datasets for reporting consumption

• Perform data validation, troubleshooting, and reconciliation across integrated sources by developing scripts to monitor automations and identify failure points

• Collaborate with marketing users to optimize tasks and automations; build and maintain Power BI dashboards and reports

• Build semantic models, reusable datasets, and DAX measures for scalable reporting; optimize dashboard performance and set refresh schedules

• Manage ad hoc requests and custom reporting for vertical needs and automations to reduce manual work

• Create presentations for quarterly business reviews and other readouts

• Document end-to-end technical processes for internal use and end-user reports

• What We're Looking For

• Degree or equivalent in Data Analytics, Information Systems, Business, Data Science, Computer Science, or related field; 3–5+ years in data engineering, reporting, or BI roles

• Strong experience with: Microsoft Fabric, Power BI, SQL Server, API data pipelines, Excel, and PowerPoint for business reviews

• Experience integrating data from Dynamics CRM, Marketo, Google Analytics/BigQuery, advertising/social platforms; CDP experience with Treasure AI is a plus

• Proficiency in Python for data integration, automation, and transformation; Generative AI tools for data automation/report building

• Experience with project management and collaboration tools like JIRA and Confluence

• Strong analytical and problem-solving skills; collaborative, organized, detail-oriented; able to manage multiple priorities

• Nice to Have

• Treasure AI CDP experience (as a plus)