Lead Data Architect, Engineer

Jobtailor; Tennessee; On-site; USD 150,000 - 200,000; Full time

Job summary

Jobtailor is seeking a senior data engineering professional to design and implement a cloud-based data platform for revenue and performance analytics. You will own end-to-end data lifecycle, integrate multiple enterprise systems, and deliver self-service insights through Power BI and Tableau.

The role requires 7+ years in data engineering or analytics architecture, with strong SQL, Python, and data modeling skills, and a proven ability to lead complex initiatives. Travel up to 20% is expected.

Qualifications

• 7+ years of experience in data engineering, analytics engineering, or data and application architecture.
• Expert knowledge of enterprise data pipelines, ETL and ELT processes, and data models supporting sales, revenue, or financial reporting.
• Advanced SQL, Python, and scripting skills.
• Deep knowledge of conceptual, logical, and physical data modeling, including metadata, lineage, and enterprise data standards.
• Hands-on experience with Databricks, Snowflake, and Azure Data Factory.
• Experience integrating Salesforce, Outreach, finance systems, and other enterprise applications.
• Experience designing APIs, real-time integrations, and event-driven solutions.
• Experience building data architecture for sales performance, revenue, commission, or incentive reporting.
• Ability to independently lead complex data and architecture initiatives with minimal oversight.

Responsibilities

• Design, build, and support a cloud-based data environment for revenue data.
• Define Revenue Operations data architecture and cloud data models.
• Own the full data lifecycle from data collection and transformation through dashboards and reports.
• Automate data flows supporting month-end and quarter-end close.
• Build logic for payment, commission, quota, and attainment validation.
• Develop conceptual, logical, and physical data models.
• Design ETL and ELT pipelines, APIs, real-time integrations, and event-driven solutions.
• Integrate data from Salesforce, Outreach, finance systems, and other business platforms.
• Build fact tables, dimensions, and semantic layers for Power BI and Tableau.
• Ensure data products are accurate, reliable, scalable, and maintainable.
• Serve as the primary technical and architecture contact for revenue and performance analytics.
• Define standards for data, integration, backend, frontend, and automation solutions.
• Establish design patterns for cloud, on-premises, and hybrid environments.
• Maintain documentation covering data storage, processing, integration, security, and access.
• Evaluate and recommend technologies.
• Promote automation, consistency, and reuse across analytics and financial close processes.
• Build governed data foundations for AI solutions, including RAG pipelines.
• Apply large language models, vector search, and agentic workflows to Revenue Operations needs.
• Develop natural-language data queries, automated variance explanations, anomaly detection, and self-service insights.
• Apply responsible AI standards, including grounding, guardrails, privacy, security, and auditability.

Skills

Advanced SQL

Python

Data modeling

ETL/ELT

Data architecture

Cloud integration

Automation

Communication

Leadership

Independent initiative

Education

Bachelor's degree or equivalent

Advanced degree preferred

Tools

Databricks

Snowflake

Azure Data Factory

Power BI

Tableau

APIs

PySpark

Job description

• Design, build, and support a cloud-based data environment for structured, semi-structured, and unstructured revenue and performance data
• Define Revenue Operations data architecture and cloud data models
• Own the full data lifecycle from data collection and transformation through dashboards and reports
• Automate data flows supporting month-end and quarter-end close
• Build logic for payment, commission, quota, and attainment validation
• Develop conceptual, logical, and physical data models
• Design ETL and ELT pipelines, APIs, real-time integrations, and event-driven solutions
• Integrate data from Salesforce, Outreach, finance systems, and other business platforms
• Build fact tables, dimensions, and semantic layers for Power BI and Tableau
• Ensure data products are accurate, reliable, scalable, and maintainable
• Serve as the primary technical and architecture contact for revenue and performance analytics
• Define standards for data, integration, backend, frontend, and automation solutions
• Establish design patterns for cloud, on-premises, and hybrid environments
• Maintain documentation covering data storage, processing, integration, security, and access
• Evaluate and recommend technologies
• Promote automation, consistency, and reuse across analytics and financial close processes
• Build governed data foundations for AI solutions, including RAG pipelines
• Apply large language models, vector search, and agentic workflows to Revenue Operations needs
• Develop natural-language data queries, automated variance explanations, anomaly detection, and self-service insights
• Apply responsible AI standards, including grounding, guardrails, privacy, security, and auditability
• Travel up to 20% of the time

Requirements

• Degree or equivalent and typically requires 7+ years of relevant experience
• Bachelor's degree or an equivalent combination of education and experience
• 7+ years of experience in data engineering, analytics engineering, or data and application architecture
• Expert knowledge of enterprise data pipelines, ETL and ELT processes, and data models supporting sales, revenue, or financial reporting
• Advanced SQL, Python, and scripting skills
• Deep knowledge of conceptual, logical, and physical data modeling, including metadata, lineage, and enterprise data standards
• Strong hands-on experience with Databricks, Snowflake, and Azure Data Factory
• Experience integrating Salesforce, Outreach, finance systems, and other enterprise applications
• Experience designing APIs, real-time integrations, and event-driven solutions
• Experience building bots, system integrations, and reusable automation components
• Hands-on experience with PySpark and Power BI or Tableau
• Experience with cloud, on-premises, and hybrid platforms, including SaaS, PaaS, IaaS, and Infrastructure as Code
• Experience building data architecture for sales performance, revenue, commission, or incentive reporting
• Ability to independently lead complex data and architecture initiatives with minimal oversight
• Ability to explain technical work and recommendations clearly to sales and operations leaders
• Must have the ability to travel up to 20% of the time
• Applicants must be located in the United States

Core Competencies

Demonstrates expertise in designing and building cloud-based data environments, including data architecture and models for revenue operations. Proficient in automating data flows and integrating various business platforms to ensure accurate and reliable data products.

Highest-signal resume keywords

• Data Engineering
• ETL and ELT Processes
• Advanced SQL
• Databricks
• Salesforce Integration

ATS Optimization Keywords

Hard Skills

• Data Modeling
• Python
• APIs
• Power BI
• Tableau
• Scripting
• Event-Driven Solutions
• Data Architecture
• Automation Components
• PySpark

Soft Skills

• Clear Communication
• Leadership
• Independent Initiative

Industry Keywords

• Revenue Operations
• Performance Analytics
• Data Lifecycle
• Data Integration
• Financial Reporting

Tools & Technologies

• Snowflake
• Azure Data Factory
• Cloud Platforms
• SaaS
• PaaS
• IaaS