Marketing Reporting Specialist

Description

Tyler Technologies is looking for a Marketing Reporting Specialist to support the development of scalable data pipelines and reporting solutions that enable data-driven marketing operations. This role is focused on data integration, transformation, and dashboard development, ensuring reliable and consistent data across Tyler's marketing technology ecosystem.

Responsibilities

• Data Pipeline Automation and Management Data Integration & Engineering

• 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

• Assist marketing users with routine task optimizations and process automations as needed

• Reporting & Dashboard Development

• Collaborate/partner with business users and operations teams across marketing and sales to understand reporting needs and develop effective visualizations, KPIs and reports to measure and monitor success

• Build and maintain Advanced Power BI dashboards and reports to support marketing performance tracking for Executive level to individual contributors

• Develop semantic models, reusable datasets, and DAX measures for scalable reporting

• Automate reporting processes, optimize dashboard performance and maintain report refresh schedules

• Prioritize and handle an array of ad hoc requests from the team, including building custom reporting for specific vertical needs and automations to eliminate manual task etc.

• Develop effective presentations for Quarterly business reviews and other read outs

• Collaboration & Project Execution

• Partner with Marketing, Sales and IT teams to clearly understand business processes for effective reporting to support marketing initiatives

• Leverage AI capabilities to reduce manual efforts and deliver faster, more actionable insights to stakeholders at different levels within the organization

• Present reports clearly to technical and non-technical stakeholders

• Own/prioritize/manage projects and tasks and share project/status updates

• Document end to end technical processes for internal use, and report documentation for end users

Qualifications

• Degree or equivalent work experience in Data Analytics, Information Systems, Business, Data Science, Computer Science, or a related field

• Certifications in specific/relevant skills mentioned above is a plus

• 3-5+ years of experience in data engineering, reporting, or BI roles

• Strong experience with:

o Microsoft Fabric (data pipelines, dataflows, notebooks, Lakehouse concepts)

o Power BI (data modeling, DAX, dashboards)

o SQL Server (advanced querying, stored procedures and process automations)

o Interpreting API documentation and building API connections for data pipelines

o Advanced skills in Excel (macros, pivots, formulas)

o Advanced skills in building Power Point presentations for business reviews

• Experience integrating data from Dynamics CRM, Marketo, Google Analytics/Big Query, advertising/social or similar platforms

• Experience with integrating data from customer data platforms like Treasure AI (CDP) is a plus

• Proficiency in Python for data integration, automation and transformation

• Experience with effective use of Generative AI tools for data automation, report building

• Experience with Project Management and collaboration tools like JIRA and Confluence

• Soft Skills

• Strong analytical, problem-solving, and critical-thinking abilities

• Collaborative and team-focused, aligned with Tyler's mission-driven culture

• Highly organized with sharp attention to detail

• Ability to manage multiple priorities in a fast-paced environment

• Ability to communicate at different levels of the organization