Marketing Data and Reporting Analyst

Marketing Yarmouth, Maine Plano, Texas


Description

Tyler Technologies is looking for a Marketing Data & Reporting Analyst 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