Marketing Data and Reporting Analyst
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 pipelineso 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