Data Engineering Architect – Salesforce Sales & Service Analytics at Ampera Technologies · Chennai, Bengaluru (Bangalore) · 10 - 15 years · ₹40L - ₹70L / yr · Profitable · Posted 13 Mar 2026

Data Engineering Architect – Salesforce Sales & Service Analytics
Hi,
We are seeking a senior data leader with deep functional expertise in Salesforce Sales and Service domains to own the enterprise data model, metrics, and analytical outcomes supporting Sales, Service, and Customer Operations.
This role is business‑first and data‑centric. The successful candidate understands how Salesforce Sales Cloud and Service Cloud data is generated, evolves over time, and is consumed by business teams, and ensures analytics accurately reflect operational reality.
Snowflake serves as the enterprise analytics platform, but Salesforce domain mastery and functional data expertise are the primary requirements for success in this role.
Core Responsibilities
Salesforce Sales & Service Data Ownership
· Act as the data owner and architect for Salesforce Sales and Service domains.
- Own Sales data including leads, accounts, opportunities, pipeline, bookings, revenue, forecasting, and CPQ (if applicable).
- Own Service data including cases, case lifecycle, SLAs, backlog, escalations, and service performance metrics.
- Define and govern enterprise‑wide KPI and metric definitions across Sales and Service.
- Ensure alignment between Salesforce operational definitions and analytics/reporting outputs.
- Own cross‑functional metrics spanning Sales, Service, and the customer lifecycle (e.g., customer health, renewals, churn).
Business‑Driven Data Modeling
· Design Salesforce‑centric analytical data models that accurately reflect Sales and Service processes.
- Model sales stage progression, pipeline history, and forecast changes over time.
- Model service case lifecycle, SLA compliance, backlog aging, and resolution metrics.
- Handle Salesforce‑specific complexities such as slowly changing dimensions (ownership, territory, account hierarchies).
- Ensure data models support operational dashboards, executive reporting, and advanced analytics.
Analytics Enablement & Business Partnership
· Partner closely with Sales Operations, Service Operations, Revenue Operations, Finance, and Analytics teams.
- Translate business questions into trusted, reusable analytical datasets.
- Identify data quality issues or Salesforce process gaps impacting reporting and drive remediation.
- Enable self‑service analytics through well‑documented, certified data products.
Technical Responsibilities (Enabling Focus)
· Architect and govern Salesforce data ingestion and modeling on Snowflake.
- Guide ELT/ETL strategies for Salesforce objects such as Opportunities, Accounts, Activities, Cases, and Entitlements.
- Ensure reconciliation and auditability between Salesforce, Finance, and analytics layers.
- Define data access, security, and governance aligned with Salesforce usage patterns.
- Partner with data engineering teams on scalability, performance, and cost efficiency.
Required Experience & Skills
Salesforce Sales & Service Domain Expertise (Must‑Have)
· Extensive hands‑on experience working with Salesforce Sales Cloud and Service Cloud data.
- Strong understanding of sales pipeline management, forecasting, and revenue reporting.
- Strong understanding of service case workflows, SLAs, backlog management, and service performance measurement.
- Experience working directly with Sales Operations and Service Operations teams.
- Ability to identify when Salesforce configuration or process issues cause reporting inconsistencies.
Data & Analytics Expertise
· 10+ years working with business‑critical analytical data.
- Proven experience defining KPIs, metrics, and semantic models for Sales and Service domains.
- Strong SQL and analytical skills to validate business logic and data outcomes.
- Experience supporting BI and analytics platforms such as Tableau, Power BI, or MicroStrategy.
Platform Experience
· Experience using Snowflake as an enterprise analytics platform.
- Understanding of modern ELT/ETL and cloud data architecture concepts.
- Familiarity with data governance, lineage, and access control best practices.
Leadership & Collaboration
· Acts as a bridge between business stakeholders and technical teams.
- Comfortable challenging requirements using business and data context.
- Mentors engineers and analysts on Salesforce data nuances and business meaning.
- Strong communicator able to explain complex Salesforce data behavior to non‑technical leaders.
Thanks,
Ampera Talent Team

About Ampera Technologies
About
At Ampera Technologies, we empower businesses with cutting-edge data analytics, quality assurance, and data engineering solutions
Company social profiles
Similar jobs (10)

Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.
We are looking for a Lead – Information Systems who can combine strong Salesforce/CRM expertise, advanced Excel skills, MIS reporting and business analytics to support data-driven decision-making.
🔹 What We’re Looking For
• Minimum 4 years of hands-on experience with CRM systems, preferably Salesforce
• Minimum 3 years of practical Salesforce experience preferred
• Advanced proficiency in Microsoft Excel, including:
Advanced formulas, Pivot Tables, Power Query, Data analysis, Automation
• Strong experience in MIS reporting, data validation, analysis and presentation of insights
• Proven experience creating and maintaining dashboards, KPI reports and management reports
• Good technical aptitude with the ability to understand business processes and convert them into effective reporting solutions
• Basic to intermediate understanding of finance and business metrics, including revenue, costs, budgeting and financial reporting concepts
• Strong analytical and problem-solving skills
• Excellent stakeholder management and communication skills
• Ability to work independently and convert data into actionable business insights
🔹 Key Responsibilities
• Manage and analyze data from Salesforce/CRM and other business systems
• Develop and maintain MIS reports, dashboards and KPI trackers
• Ensure data accuracy, validation and consistency across reports
• Analyze business data and identify trends, gaps and opportunities
• Translate business requirements into meaningful reports and dashboards
• Work closely with business and functional stakeholders to understand reporting requirements
• Support management with timely and accurate business insights and performance reports
• Identify opportunities to improve reporting processes through Excel, Power Query and automation
• Support CRM-related reporting and process improvements
🎯 Ideal Candidate
Someone who is comfortable working at the intersection of CRM + MIS + Excel + Business Analytics, and can go beyond preparing reports to explain what the data means and what action the business should take.

Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.
About the Role
You'll be at the forefront of designing and implementing robust data platform solutions that power advanced analytics, AI, and machine learning. Working with modern cloud technologies, you'll build scalable data foundations that enable clients to make smarter, data-driven decisions.
Key Responsibilities
- Build scalable data pipelines using Snowflake, AWS, GCP, and Databricks.
- Design and optimize data models for AI and machine learning workloads.
- Develop reliable data foundations for MLOps, governance, and data lineage.
- Integrate data from multiple sources into modern data platforms.
- Leverage Snowpark ML and Snowflake's native AI capabilities.
- Ensure data platforms are secure, scalable, and high-performing.
What We're Looking For
- 5+ years of hands-on experience with Snowflake.
- Strong proficiency in SQL and Python.
- Experience with AWS, Azure, or GCP.
- Knowledge of cloud storage services such as S3, ADLS, or GCS.
- Strong understanding of Dimensional Modeling and Data Vault.
- Experience with Scala or Java is a plus.
Tech Stack
- Data Warehouse: Snowflake
- Programming: SQL, Python, Scala (Good to Have), Java (Good to Have)
- Cloud: AWS, Azure, GCP
- Storage: S3, ADLS, GCS
- AI/ML: Snowpark ML, MLOps
Perks & Benefits
- Public Speaking & Communication Program
- Mentoring Program with Senior Support Leads
- 360° Progress Reviews
- Weekly Learning Sessions & Guilds
- Paid Certifications
- Hackathons & Innovation Days
- Recognition & Rewards Programs
- Team Socials & Annual Offsites
- Employee Assistance Program (24/7 Wellbeing Support)
The Data People Shaping Tomorrow
Our client helps organizations unlock the power of data through modern cloud, analytics, and AI solutions. We believe in creating an environment where talented technologists can learn, innovate, and make a real impact while building cutting-edge data platforms for global clients. If you're passionate about data engineering and want to work with the latest technologies in AI, cloud, and analytics, we'd love to hear from you.

Sr. Data Engineer
Location: Pune
Responsibilities
· Lead the end-to-end design and development of scalable, high-performance data pipelines and ETL/ELT frameworks aligned with modern data engineering best practices.
· Architect complex data integration workflows that bring together structured, semi-structured, and unstructured data from both cloud and on-premise sources.
· Build robust real-time, batch, and on-demand pipelines with built-in observability—monitoring, alerting, and automated error handling.
· Partner with analysts, data scientists, and business leaders to define and deliver reliable data models, quality frameworks, and SLAs that power key business insights.
· Ensure optimal pipeline performance and throughput, with clearly defined SLAs and proactive alerting for data delivery or quality issues.
· Collaborate with platform, DevOps, and architecture teams to build secure, reusable, and CI/CD-enabled data workflows that align with enterprise architecture standards.
· Establish and enforce the best practices in source control, code reviews, testing automation, and continuous delivery for all data engineering components.
· Lead root cause analysis (RCA) and preventive maintenance for critical data failures, ensuring minimal business impact and continuous service improvement.
· Guide the team in establishing standards for data modeling, transformation logic, and governance, ensuring long-term maintainability and scalability.
· Design and execute comprehensive testing strategies—unit, integration, and system testing—ensuring high data reliability and pipeline resilience.
· Monitor and fine-tune data pipeline and query performance, optimizing for reliability, scalability, and cost-efficiency.
· Create and maintain detailed technical documentation, including data architecture diagrams, process flows, and integration specifications for internal and external stakeholders.
· Facilitate and lead discussions with business and operational teams to understand data requirements, prioritize initiatives, and drive data strategy forward.
Qualifications
· 7 to 10 years of hands-on experience in data engineering roles with a proven record of building scalable and secure data platforms.
· Over 5 years of experience in scripting languages such as Python for data processing, automation, and ETL development.
· 4+ years of experience with Snowflake, including performance tuning, security model design, and advanced SQL development.
· 5+ years of experience with data integration tools such as Azure Data Factory, Fivetran, or Matillion.
· 5+ years of experience in writing complex, highly optimized SQL queries on large datasets.
· Proven experience integrating and managing APIs, JSON, XML, and webhooks for data acquisition.
· Hands-on experience with cloud platforms (Azure/AWS) and orchestration tools like Apache Airflow or equivalent.
· Experience with CI/CD pipelines, automated testing, and code versioning tools (e.g., Git).
· Familiarity with dbt or similar transformation tools and best practices for modular transformation development.
· Exposure to data visualization tools like Power BI for supporting downstream analytics is a plus.
· Strong interpersonal and communication skills with the ability to lead discussions with technical and business stakeholders.
Education
Bachelor’s or Master’s degree in Computer Science/Information technology or related field.
Equivalent academic and work experience can be considered.
Immediate Joining
We are looking for a Dedicated Resource on Contract for –
Role: Data Engineer
Experience: 5+ Years
Location: Remote
Duration: 3+ Months
Strong hands-on experience with Snowflake, including writing SQL queries, creating views, stored procedures, and functions.
Good knowledge of AI tools such as Claude.
Experience with ETL tools like Alteryx is good to have.
Power BI experience is good to have.
Strong communication skills.
Hiring: Data Modeler
Experience: 6+ years
Location: Bangalore/Gurugram/Pune
Required Skills
- Hands-on experience in conceptual, logical, and physical data modeling.
- Strong knowledge of ER modeling, dimensional modeling, star/snowflake schemas, fact/dimension tables, and SCDs.
- Strong SQL skills for data profiling, validation, and quality checks.
- Experience with source-to-target mapping, data dictionaries, metadata, and data lineage.
- Proficiency in Erwin, ER/Studio, or similar modeling tools.
- Exposure to Snowflake, Databricks, Redshift, SQL Server, or other data platforms.
- Understanding of data governance, UAT, reconciliation, and Agile methodologies.
- Strong analytical, documentation, and stakeholder management skills.
Preferred Qualifications
- Experience in enterprise data warehousing or lakehouse modeling.
- Knowledge of data products, data contracts, quality SLAs, and reusable datasets.
- Exposure to dbt, data cataloging, metadata management, and governance tools.
- Ability to work independently in a fast-paced environment.
If interested please share your cv at : snigdhaattheratebeanhr.com
Strong Data Analyst Profile with Python, SQL, and data-pipeline expertise, ideally with retail / e-commerce datasets
2
Mandatory (Experience 1): Must have 4+ years of hands-on data-analyst experience, working with large datasets across areas such as sales, inventory, pricing, promotions, and customer behaviour.
3
Mandatory (Tech skill 1): Must have strong hands-on Python for data processing, transformation, automation, and analysis
4
Mandatory (Tech skill 2): Must have strong SQL skills, including complex queries, joins, aggregations, and data validation.
5
Mandatory (Tech skill 3): Must have a solid understanding of Data Lake architecture, ingestion, storage, and processing workflows
6
Mandatory (Tech skill 4): Must have hands-on experience with ETL / ELT pipelines, data integration, and transformation
7
Mandatory (Tech skill 5): Must have experience with Azure or GCP data services.
8
Mandatory (Tech skill 6): Must have understanding of or experience with Databricks and distributed data processing.
9
Mandatory (Tech skill 7): Must have knowledge of data modeling, data warehousing, and Lakehouse architecture
10
Mandatory (Tech skill 8): Must have experience with Power BI, Tableau, or Excel for reporting.
11
Mandatory (Communication): Must have strong analytical, documentation, and stakeholder-communication skills.
12
Mandatory (Education): Must hold a Bachelor’s degree in Computer Science, IT, Engineering, or a related field.
13
Mandatory (Note1): This is a 6-month contract role. Candidate must be comfortable with the contract engagement and able to join immediately (urgent — onboarding within ~a week)

Job Title: Senior Data Analyst
Location: Sharnam Metrolinks, Amraiwadi, Ahmedabad
Working Days: 6 Days a Week
Department: MDO
Reporting To: COO
Employment Type: Full-Time
Job Summary
We are seeking a highly analytical and detail-oriented Senior Data Analyst to lead data management, reporting, automation, and system development initiatives across the organization.
The role focuses on transforming raw data into meaningful insights, designing and implementing automated systems, strengthening data structures, and supporting cross-functional teams with accurate, actionable intelligence to drive strategic and operational business decisions.
Key Responsibilities
1. Data Management & Reporting
● Collect, clean, validate, and consolidate data from multiple internal and external sources.
● Prepare and deliver daily, weekly, and monthly MIS reports for management and departments.
● Design, develop, and maintain dashboards to track KPIs, performance metrics, and operational trends.
2. Database & Data Accuracy Management
● Manage and regularly update internal databases, spreadsheets, and reporting systems.
● Ensure data accuracy, consistency, integrity, and confidentiality across all platforms.
● Implement best practices for data validation, version control, and audit checks.
3. Data Analysis & Business Insights
● Analyze large and complex datasets to identify trends, patterns, gaps, and anomalies.
● Translate data findings into clear, actionable insights and recommendations to support
strategic and operational decision-making.
4. Reporting Automation, System Recommendation & Implementation
● Identify opportunities to replace manual or semi-manual processes with automated, data-driven systems.
● Design and implement automated reporting frameworks, dashboards, and data pipelines using Excel (Power Query, VBA, Macros), SQL, BI tools, and Python.
● Proactively suggest new automation tools, system enhancements, or integrations to
improve efficiency, accuracy, and scalability.
● Lead the end-to-end implementation of approved automation initiatives, including requirement gathering, system design, testing, deployment, and stabilization.
● Continuously monitor and optimize automated systems in line with business growth and evolving data needs.
5. Cross-Functional Coordination & Support
● Collaborate with Sales, HR, Finance, Operations, and other departments to understand
reporting and data requirements.
● Provide support for ad-hoc analysis, custom reports, and special data requests.
● Act as a data partner to department heads for decision support and performance tracking.
6. Documentation & Compliance
● Maintain complete and updated documentation for MIS processes, reports, data models,
automation logic, and system changes.
● Ensure compliance with company data governance policies and applicable data protection standards.
System Development & Data Structuring Responsibilities
● Study and understand departmental workflows to evaluate how data is generated, processed, and utilized.
● Review existing manual and digital data systems to identify operational gaps, risks, and
mprovement opportunities.
● Recommend structured data models, reporting formats, and storage solutions aligned with
business requirements.
● Coordinate with department heads to define data structures, access levels, and reporting
standards.
● Implement new or upgraded data systems (Excel-based models, cloud platforms, ERP
integrations) with minimal operational disruption.
● Design structured data formats and role-based access controls to ensure secure and
organized data management.
● Train employees on newly implemented systems and provide post-implementation
support.
● Monitor system performance, resolve issues, and continuously improve systems based on
user feedback and organizational growth.
Qualifications & Experience
● Bachelor’s degree in Commerce, Statistics, Computer Applications, or a related field.
● 3–5 years of experience in data analytics, reporting, or system automation roles.
● Strong analytical thinking, logical reasoning, and problem-solving abilities.
● High attention to detail with excellent organizational and documentation skills.
Technical Skills (Must Have)
● Advanced Excel: Power Query, Power Pivot, VBA basics, Macros, Charts
● BI Tools: Power BI or Tableau (DAX, data modeling, dashboard optimization)
● Google Apps Script: Automation in Google Sheets, custom functions, triggers, API integrations, workflow optimization
● Vlook
Preferred Skills
● Strong verbal and written communication skills
● Ability to handle sensitive and confidential information responsibly
● Quick learner with a tech-savvy, improvement-driven, and solution-oriented mindset

Experience: 7–10+ years | Industry Preference: Financial Services / BFSI
Role Overview
We are seeking a Senior Reporting Analyst / Business Intelligence Lead to own and drive
enterprise reporting, analytics, and data insights across the organization. This is a senior,
hands-on role requiring deep technical expertise across the Microsoft data and BI stack,
strong business acumen, and the ability to operate with minimal hand-holding. The ideal
candidate will act as a bridge between business leadership and technical teams, translating
complex business questions into scalable, reliable data models and executive-ready insights.
Key Responsibilities
Serve as the primary owner of enterprise reporting and BI solutions, from data
ingestion through executive dashboards.
Design, build, and maintain scalable Power BI / Microsoft Fabric semantic models using
STAR schema best practices.
Partner closely with business stakeholders and C-level executives to define KPIs,
metrics, and reporting requirements.
Lead and present weekly reporting and insights sessions with senior and executive
leadership.
Ensure data accuracy, consistency, and trust across all reports and analytics outputs.
Proactively identify data quality issues, root causes, and remediation strategies.
Drive automation of reporting, alerts, and data refresh processes to reduce manual
effort.
Collaborate with engineering, data, and application teams to align business logic with
source system data structures.
Mentor junior analysts and establish BI standards, best practices, and documentation.
Technical Skills – Data & Backend
Advanced SQL: complex queries, views, stored procedures, and validation against
source systems (RDN, Recovery Connect).
Azure Data Factory: build and manage copy pipelines from SQL sources to data
warehouses / dedicated pools.
Incremental refresh, parameterized pipelines, and schema replication.
Data warehouse design: STAR schema, fact vs dimension tables, handling deleted
records and SCDs.
Technical Skills – Reporting & Frontend
Power BI / Microsoft Fabric: Power Query, DAX, and M language expertise.
Semantic model design (1-to-many, 1-to-1, many-to-1 relationships).
Query folding and performance optimization best practices.
Paginated Report Builder (SSRS-style) for automated Excel and PDF reporting.
Power Automate integration for alerts and workflow-driven notifications.
Data Quality & Analytics
Ability to clean, normalize, and reconcile data across multiple systems.
Strong troubleshooting skills when business definitions and data do not align.
Translate business terminology into accurate technical mappings and calculations.
Communication & Leadership
Serve as a key liaison between business stakeholders and technical teams.
Comfortable working directly with C-level executives and senior leadership.
Ability to lead executive-level meetings and clearly communicate insights.
Self-starter mindset with minimal hand-holding.
Qualifications
7–10+ years of experience in BI, analytics, or enterprise reporting roles.
Preferred experience in financial services or regulated environments.
Strong experience across the Microsoft BI ecosystem.
Preferred Certifications
Microsoft PL-300 (Power BI Data Analyst)
Microsoft DP-600 (Fabric Analytics Engineer)
Microsoft DP-700 (Fabric Data Engineer)
What Success Looks Like
Executive leadership trusts and relies on BI dashboards for decisions.
Reporting is automated, accurate, and scalable.
BI functions as a strategic partner to the business.
We are looking for a dynamic Data Engineer to join our team of technology enthusiasts. You will leverage data to drive strategic decision-making and pioneering solutions, working with complex datasets, collaborating closely with stakeholders, and transforming data into actionable insights to drive innovation.
Qualifications and Skills:
- Minimum 5 years of experience as a Data Engineer
- Hands-on experience with Azure cloud-based data solutions
- Expertise in database design and management, including SQL databases such as SQL Server
- Proficient in ETL (Extract, Transform, Load) design for data integration and processing
- Strong knowledge of data modeling principles and techniques
- Ability to analyze and translate data into actionable insights, reports, and visualizations
- Proficiency in Power BI for reporting and data visualization
Desirable Skills:
- Experience with Power BI Report Builder / Reporting Services
- Knowledge of statistical analysis or Data Science
- Experience within the UK Insurance industry is a plus
- Python or R coding skills
Responsibilities:
- Implement efficient data exchange between internal and external systems to increase efficiency and reduce re-keying and translation errors
- Support the Broking business by developing high-quality information resources, ensuring data availability and accessibility for decision-making
- Engineer data inputs and outputs from core applications and semi-structured remote service data through data syncs between data lake, ODS (SQL database), and leveraging Fabric and ADF
- Perform data engineering tasks including ingestion, cleansing, and collation from a wide range of internal and external sources
- Implement different methods of streaming data and create reconciliations for datasets
- Build analytical models to support reporting and analytics
- Collaborate with an agile delivery team to work on the backlog of specified work

Designation: Data Architect
Reporting: VP, Engineering
Desired Experience: 12 – 18 Years
Qualification: BE/ B Tech/ M Tech/ MCA and any Graduate.
Job Location: Noida Sec-6 (Nearest Metro Station 15)
(WFH/Work from Home Available)
Total Employees: 100+ Members
Working Days: Monday to Friday
Key Responsibilities
- Define, own, and evolve the enterprise data architecture
- Design scalable, secure, high-performance end-to-end data platforms
- Establish data modeling standards (conceptual, logical, physical)
- Act as architectural authority for data pipelines, APIs, and integrations
- Ensure platform design meets security, compliance, availability, and cost-efficiency standards
- Define and enforce data governance, data quality, metadata, lineage, and master data principles
- Collaborate with Data Engineers for implementation of architecture designs
- Align data architecture with product roadmaps and business priorities
- Define standards for data sharing, data products, and external data exposure
- Contribute to long-term data platform roadmap and technology adoption
- Support leadership with architecture reviews and strategic decisions
Required Experience & Technical Expertise
Experience
- 12+ years in Data domain
- 3–5 years as Data Architect / Lead Data Role
- Experience designing enterprise-scale data platforms
Data Architecture & Modeling
- Deep expertise in Data Modeling & Data Warehousing
- Advanced SQL knowledge
- Strong experience with Snowflake & modern cloud data stacks
- Experience with relational and cloud-native databases
Security & Compliance
- Knowledge of Data Security (Dynamic Masking, Row-Level Security, Access Control)
- Strong understanding of GDPR & Data Privacy regulations
Integration & Engineering
- Experience with streaming & event-driven architectures
- APIs & integration patterns (REST, event-based systems)
- Familiarity with CI/CD, DevOps & Infrastructure-as-Code in data environments
- Architecture reviews & technology evaluations
Key Technical Skills (Must Have)
- Snowflake
- Matillion (or equivalent data integration tools)
- Python
- SQL
- REST APIs & Event-driven integrations
- Power BI / Qlik / Tableau
- Experience with CRM / Marketing Automation / PIM platforms
- Agile & Continuous Delivery practices
Personal Skills
- Strong architectural mindset with focus on scalability
- Collaborative leadership ability
- Analytical and business-oriented thinking
- Strong communication skills (technical & non-technical stakeholders)
- Proactive, autonomous, and accountable
Why Join Us?
- Work with best-in-class data & cloud technologies
- Influence core data architecture of a global digital platform
- Strong engineering culture focused on ownership & quality
- Hybrid work model (mostly remote)
- 25+ years of industry leadership with strong growth trajectory
Please fill the following details:
1) Current CTC
2) Expected CTC
3) Notice Period
4) Current Location
5) Reason of Change
6) Years of Experience
Kindly provide us the references for the same openings.
WhatsApp your CV at 7 5 0 3 8 6 6 1 9 6









