Senior Data Architect

Job not on LinkedIn

November 25

🗽 New York – Remote

Although this job is listed in New York, this company may be open to hiring remote in other states.

💵 $150k - $160k / year

⏰ Full Time

🟠 Senior

🚰 Data Engineer

🦅 H1B Visa Sponsor

Apply Now

Receive Emails with Similar Jobs

Informa

WebsiteLinkedInAll Job Openings

B2B • Media • Education

Informa is a global leader in business intelligence, academic publishing, and events. It is home to hundreds of specialist brands and businesses, focused on connecting people with knowledge through events and digital products. Informa operates in over 30 countries and has a workforce of 12,000 colleagues globally. The company runs divisions such as Informa Markets, which facilitates trade and growth through events, and Taylor & Francis, a leading publisher of academic research. Informa prioritizes sustainability and diversity, aiming to positively impact markets and communities. As a member of the FTSE 100, Informa is known for its strong financial performance and scale within the academic and B2B markets.

10,000+ employees

Founded 1998

🤝 B2B

📱 Media

📚 Education

📋 Description

• Serve as a technical data architect supporting the next generation reporting platform, enabling insights for Finance, Commercial, Product, and Client Success teams • Support the development and implementation of a data strategy that enables current and future data processing, analytics, and reporting requirements in alignment with the overall data strategy and priorities • Maintain and enhance the scalable data warehouse architecture • Ensure robust version control, deployment pipelines, and observability across environments, supporting continuous improvement and governance • Maintain and build new ETL pipelines bringing data from Salesforce, NetSuite, HubSpot, Pendo, ADP and Adaptive Planning, ensuring clean, enriched, and joined datasets for analytics • Manage BI or reporting functions with internal and external reporting outputs. Deliver company-wide dashboards using Power BI (including Embedded) • Prioritize high-volume reporting backlogs across multiple business functions • Collaborate with Finance, Operations, HR and Sales to deliver reporting such as automated revenue and ARR bridges, pricing analysis, P&L reporting, client product usage reporting and headcount reporting in Power BI • Support key data initiatives including ARR bridge, Client Intimacy metrics, Pricing Governance, Customer Health Scoring, Funnel Velocity, and Marketing Attribution • Design KPI frameworks and reporting structures in collaboration with stakeholders. • Lead QA reviews of reporting assets to ensure accuracy, accessibility, and usability • Champion and drive data quality and enrichment across Salesforce and other systems, implementing dashboards and tagging logic to support commercial actions. • Educate and guide Power BI dashboard creators across the business to adopt self-service dashboard creation, promoting best practices and scalable design standards • Train users on reporting tools and implement self-service enablement programs. • Collaborate with business stakeholders to define reporting requirements, validate outputs, and embed dashboards into operational cycles

🎯 Requirements

• Have 5+ years of experience designing and managing scalable data architectures • Demonstrate hands-on experience with Databricks and Delta Lake, including ACID transactions, schema evolution, time travel, and audit logging • Show strong proficiency in SQL (T-SQL, ANSI SQL), and Python, PySpark, and Scala for data engineering within Databricks notebooks • Familiar with Unity Catalog for metadata management, data cataloguing, role-based access control, data lineage, and quality monitoring • Experience using Fivetran or similar tools for building reliable, low-maintenance data ingestion pipelines • Experience integrating and transforming data from Salesforce, NetSuite, HubSpot, Pendo, ADP, Adaptive Planning, and other SaaS platforms • Demonstrate a strong understanding of data governance, including version control (e.g., Git/Azure Repos), CI/CD pipelines, and observability practices • Manage the full report development lifecycle from brief through to release and adoption • Can demonstrate hands-on experience with Power BI, including dashboard development, parameterization, performance optimization, and administration (permissions, server maintenance, upgrades, patching, monitoring etc.). • Comfortable building and optimizing fact and dimension models, including STAR schemas and SCD-2 logic, to support consistent and high-performance reporting • Use the Power BI platform (including DAX, Dataflows, Embedded publishing) • Ability to apply visualization best practices and data storytelling techniques. • Ability to apply business-aligned KPI design and definition governance • Ability to apply transformation logic, data model validation, and documentation • Plan and prioritize work to meet commitments aligned with organizational goals • Develop and deliver multi-mode communications that convey a clear understanding of the unique needs of different audiences • Collaborate with cross-functional teams to define and implement data models that support business use cases and enable self-service analytics • Build formal and informal relationship networks inside and outside the organization and work collaboratively with others to meet shared objectives • Demonstrate excellent communication and stakeholder engagement skills, with a consulting mindset and the ability to translate business needs into scalable data solutions • Learn actively through experimentation when tackling new problems, using both successes and failures as learning fodder • Develop people to meet both their career goals and the organization’s goals. • Consistently achieve results, even under tough circumstances • Hold a Bachelor’s degree in Computer Science, Engineering, or a related discipline; an advanced degree or relevant certifications are a plus

🏖️ Benefits

• Competitive benefits, including a range of Financial, Health and Lifestyle benefits to choose from • Flexible working options, including home working, flexible hours and part time options, depending on the role requirements – please ask! • Competitive annual leave, floating holidays, volunteering days and a day off for your birthday! • Learning and development tools to assist with your career development • Work with industry leading Subject Matter Experts and specialist products • Regular social events and networking opportunities • Collaborative, supportive culture, including an active DE&I program • Employee Assistance Program which provides expert third-party advice on wellbeing, relationships, legal and financial matters, as well as access to counselling services