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