Job Specification: Data Architect
Who we are
Sustainability software specialist, AMCS, is headquartered in Ireland, with offices in Europe, USA, Canada and Australasia. With over 1,400 highly skilled employees across 22 countries, we specialize in delivering technology solutions to facilitate a carbon neutral future.
What we do
Our innovative SaaS solutions increase efficiency and boost sustainability in resource-intensive industries. Over 5,000 customers across 23 countries already benefit from our Performance Sustainability software, ensuring we deliver practical solutions for improved profitability and environmental resilience across the globe.
Job Summary:
AMCS are embarking on a Digital Transformation effort with a key component being the provision of a foundational data platform for AMCS, enabling reliable reporting and analytics across Finance, Sales, and Operations.
AMCS are recruiting a Data Architect (DA) who will be responsible for the design and implementation of this data platform ensuring that data systems are structured efficiently to support business objectives, enhance decision-making capabilities, and improve the overall customer experience. The DA will Bridge the business process transformation (led by an external consultant) and technical execution, ensuring the resulting architecture supports both short-term reporting and longer-term analytical use-cases such as more advanced customer reporting/analytics, churn prevention, upsell prioritization, and product rationalization.
The ideal candidate will be a hands-on data architect/engineer with experience modernizing data landscapes in B2B SaaS (ideally with Salesforce + NetSuite), who’s pragmatic about cost and simplicity within Azure/Microsoft ecosystem. Initially this will be a 6-12 month FTC
Key Responsibilities:
Data Architecture Design:
Own the architecture, technology stack, and data model for the AMCS internal data platform.
Focus in the first 3–6 months on:
Selecting and implementing an Azure-based platform (warehouse/lakehouse, ingestion, orchestration, transformation, quality).
Collaborating closely with external consultants to:
Design and operationalize the core data model around customers, products, contracts, billing, usage, and related concepts to support initial reporting needs.
Build data pipelines from systems such as Salesforce and NetSuite.
Delivering a solid foundation for financial and operational reporting (ARR, CARR, FX, churn, product usage, etc).
Collaboration and Stakeholder Engagement:
Liaise with Finance, Sales/Ops, Product, and other areas of the company to understand more advanced needs or requirements beyond short-term reporting needs.
Core Capabilities:
Data Platform Architecture:
Can design and justify a modern architecture, including specific technology choices among potential candidates (e.g. Azure Data Lake, Synapse or Fabric, Data Factory; Databricks; Snowflake; dbt; Power BI; etc). Preferably has experience with the Azure family of data-related products.
Can design and validate a data flow between systems to ensure there is a master view of the data about each business concept across the company.
Balances performance, maintainability, and cost.
At least 5 years of data engineering experience working with complex data environments (data from multiple systems, managed by different business units, with differences over time, etc.)
Data Modelling:
Deep understanding of dimensional and normalized modelling. Can design flexible data models for business concepts, addressing reporting needs while enabling more advanced use-cases.
Systems Integration (ERP/CRM):
Practical experience integrating with/building data pipelines for CRM/Billing systems, ideally with Salesforce and NetSuite. Understands object models such as accounts, opportunities, orders, invoices, and subscriptions, and how they connect across systems.
Data Quality Best Practices:
Hands-on experience designing modular pipelines with version control, CI/CD, and data validation checks. Understands the need for clear data ownership/governance.
BI and analytics:
Experience designing BI applications and connecting to data platforms. Ideally, understands basic approaches to customer analytics for commercial purposes, e.g., lead prioritization for cross-sell.
Strong analytical thinking and problem-solving skills, with the ability to interpret complex data and communicate findings to non-technical stakeholders.
Passionate about data and its ability to drive business decisions and enhance customer experiences.
Strategic and Business Competencies:
Stakeholder Communication:
Excellent communication skills, both written and verbal, with the capability to influence at all levels of the organization.
Able to translate between technical and business audiences, explaining constraints, trade-offs, and options in practical business terms.
Experience working with External Consultants:
Has experience working alongside/managing external consultants, ideally in process transformation projects.
Experience in post-M&A environments (Nice to Have):
Has experience unifying data from acquired companies and reconciling differences in system structure and taxonomies.
Experience with reporting needs of B2B software companies (Nice to Have):
Understands metrics such as ARR, CARR, churn, FX exposure, contract renewals, and license utilization