Job Details
Senior Data Automation Engineer
2025-09-02 SMART CIRCLE INTERNATIONAL GROUP Newport Beach,CA
Description:
Strong hands-on expertise with Salesforce, Tableau, Microsoft SQL Server, and Snowflake.
Proven experience delivering self-service, sales-facing reports in Tableau
Demonstrated ability to manage data pipelines in multi-platform environments
Deep understanding of data governance, system integration, and automation
Excellent communication and collaboration skills across technical and non-technical teams.
Experience with system integration tools and strategies (e.g., APIs, middleware)
Salesforce Platform and Administration certifications (preferred)
Snowflake certifications (preferred)
Strong leadership, communication, and problem-solving abilities in sales operations environment
Minimum Qualifications::
Bachelor's degree in Business Administration, Computer Science, or a related field
At least 5 years of recent experience developing datasets, procedures, and functions in Microsoft SQL Server and Snowflake
Our Commitment:
Smart Circle International is passionate about creating an inclusive workplace that promotes and values diversity and celebrates differences. We are committed to creating an environment that fosters growth opportunities for all team members. Wherever practical, Smart Circle International wants team members in the position that best suits their unique abilities, interests, and skills, as well as our business needs. We strongly believe that bringing our team members' diverse backgrounds, cultures, and perspectives together is the best way to serve our clients and the independent sales companies with which we work side by side.
Equal Opportunity Employer:
We believe in equal opportunity. Each team member is recruited, employed, evaluated, and considered for promotion without regard to race, color, national origin, age, sex, disability status, or any other protected characteristic under state or federal law. We will not tolerate discrimination or harassment based on any protected characteristic and expect all team members to treat others with dignity and respect.
*In accordance with the applicable law, the following represents a good faith estimate of the minimum and maximum compensation range for this position: the estimated annual compensation range for this role is $130k - $160k.The compensation range reflects the Company's reasonable expectation at the time of posting. Exact compensation for this role will be determined based on permissible, non-discriminatory factors such as candidates' qualifications, skills, and experience.
Full-time positions also include a benefits package that includes vacation, sick leave, paid holidays, medical (with an HSA plan option), dental, vision and company paid Basic Life insurance, opportunity to enroll in Voluntary Life plans, Employee Assistance Program, 401K with employer match, employee referral program, home office stipend and opportunities for team building, growth, and development. Team members have on-demand access to an LMS with a variety of courses to further their professional and personal development.
DISCLOSURE TO JOB APPLICANTS PURSUANT TO THE CALIFORNIA CONSUMER PRIVACY ACT
As part of your job application and our evaluation of your candidacy, we collect, receive, maintain, and use your personal information, which as used herein, means information that identifies, relates to, describes, is reasonably capable of being associated with, or could reasonably be linked, directly or indirectly, with you or your household. The following is the personal information we may collect as part of the application process:
Personal contact details, such as name, title, address, telephone number, and email address; and
Application information, such as your qualifications, skills, education, references, and other information that may be in your resume, cover letter, and materials you provide to us when applying for employment.
We collect your personal information to evaluate your job application and candidacy for employment, to check your eligibility to work in the country in which you have applied, for background checks, and to comply with employment and other laws. If you become employed by us, we will notify you of additional categories of personal information that we collect, receive, and maintain for business purposes.
Qualifications
What You Bring:
Our Commitment:
Smart Circle International is passionate about creating an inclusive workplace that promotes and values diversity and celebrates differences. We are committed to creating an environment that fosters growth opportunities for all team members. Wherever practical, Smart Circle International wants team members in the position that best suits their unique abilities, interests, and skills, as well as our business needs. We strongly believe that bringing our team members' diverse backgrounds, cultures, and perspectives together is the best way to serve our clients and the independent sales companies with which we work side by side.
Equal Opportunity Employer:
We believe in equal opportunity. Each team member is recruited, employed, evaluated, and considered for promotion without regard to race, color, national origin, age, sex, disability status, or any other protected characteristic under state or federal law. We will not tolerate discrimination or harassment based on any protected characteristic and expect all team members to treat others with dignity and respect.
*In accordance with the applicable law, the following represents a good faith estimate of the minimum and maximum compensation range for this position: the estimated annual compensation range for this role is $110k - $160k.The compensation range reflects the Company's reasonable expectation at the time of posting. Exact compensation for this role will be determined based on permissible, non-discriminatory factors such as candidates' qualifications, skills, and experience.
Full-time positions also include a benefits package that includes vacation, sick leave, paid holidays, medical (with an HSA plan option), dental, vision and company paid Basic Life insurance, opportunity to enroll in Voluntary Life plans, Employee Assistance Program, 401K with employer match, employee referral program, home office stipend and opportunities for team building, growth, and development. Team members have on-demand access to an LMS with a variety of courses to further their professional and personal development.
DISCLOSURE TO JOB APPLICANTS PURSUANT TO THE CALIFORNIA CONSUMER PRIVACY ACT
As part of your job application and our evaluation of your candidacy, we collect, receive, maintain, and use your personal information, which as used herein, means information that identifies, relates to, describes, is reasonably capable of being associated with, or could reasonably be linked, directly or indirectly, with you or your household. The following is the personal information we may collect as part of the application process:
Personal contact details, such as name, title, address, telephone number, and email address; and
Application information, such as your qualifications, skills, education, references, and other information that may be in your resume, cover letter, and materials you provide to us when applying for employment.
We collect your personal information to evaluate your job application and candidacy for employment, to check your eligibility to work in the country in which you have applied, for background checks, and to comply with employment and other laws. If you become employed by us, we will notify you of additional categories of personal information that we collect, receive, and maintain for business purposes.
Job Details
Job Location
Smart Circle International - Newport Beach - Newport Beach, CA
Position Type
Full Time
Education Level
4 Year Degree
Salary Range
$110000.00 - $160000.00 Salary/year
Travel Percentage
Up to 25%
Job Category
Information Technology
Description
Smart Circle International is a leading broker of outsourced sales and customer acquisition services. We help clients and independently owned and operated sales companies grow together through versatile in-person marketing and sales campaigns inside retailers, businesses and through door-to-door canvassing. We have corporate offices in Newport Beach and Toronto.
The Basics:
Location: Hybrid, 3 days on-site at our Newport Beach, CA office
Compensation: $110,000-$160,000/year, commensurate with experience
Travel: Up to 25%
Position Overview and Impact:
As the Sr. Data Automation Engineer, you will engineer, integrate, and enable critical insights from Salesforce, Microsoft, and Snowflake platforms. This pivotal role bridges data strategy, automation, and business enablement. You will enhance our data pipeline for performance, reliability, and scalability across platforms to drive insights, automation, and operational efficiencies. You will secure and manage the data pipeline, orchestrate enterprise automations, create and maintain mission-critical datasets and reports in Tableau, and maintain compliance with data privacy laws and policies.
As a cross-functional leader, you'll collaborate with stakeholders across sales, finance, and operations to design data flows, streamline processes, and ensure secure, high-performing environments for insight. The ideal candidate is a problem solver at heart, with strong technical expertise and a passion for data architecture and continuous improvement.
Primary Functions:
Salesforce Platform:
- Customize Salesforce data model and automations to align with business requirements.
- Manage data governance and integrate external systems.
- Support users, optimize performance, and ensure compliance.
- Design dashboards with advanced calculations and manage data layers and security.
- Administer access controls and tune performance.
- Develop scalable databases in SQL Server and Snowflake.
- Optimize SQL scripts, support reporting, and maintain ETL pipelines.
- Design and schedule automations and workflows.
- Monitor and optimize job performance and implement alerting mechanisms.
- Maintain documentation and security protocols.
- Collaborate with stakeholders to enhance automation reliability and effectiveness.
Strong hands-on expertise with Salesforce, Tableau, Microsoft SQL Server, and Snowflake.
Proven experience delivering self-service, sales-facing reports in Tableau
Demonstrated ability to manage data pipelines in multi-platform environments
Deep understanding of data governance, system integration, and automation
Excellent communication and collaboration skills across technical and non-technical teams.
Experience with system integration tools and strategies (e.g., APIs, middleware)
Salesforce Platform and Administration certifications (preferred)
Snowflake certifications (preferred)
Strong leadership, communication, and problem-solving abilities in sales operations environment
Minimum Qualifications::
Bachelor's degree in Business Administration, Computer Science, or a related field
At least 5 years of recent experience developing datasets, procedures, and functions in Microsoft SQL Server and Snowflake
Our Commitment:
Smart Circle International is passionate about creating an inclusive workplace that promotes and values diversity and celebrates differences. We are committed to creating an environment that fosters growth opportunities for all team members. Wherever practical, Smart Circle International wants team members in the position that best suits their unique abilities, interests, and skills, as well as our business needs. We strongly believe that bringing our team members' diverse backgrounds, cultures, and perspectives together is the best way to serve our clients and the independent sales companies with which we work side by side.
Equal Opportunity Employer:
We believe in equal opportunity. Each team member is recruited, employed, evaluated, and considered for promotion without regard to race, color, national origin, age, sex, disability status, or any other protected characteristic under state or federal law. We will not tolerate discrimination or harassment based on any protected characteristic and expect all team members to treat others with dignity and respect.
*In accordance with the applicable law, the following represents a good faith estimate of the minimum and maximum compensation range for this position: the estimated annual compensation range for this role is $130k - $160k.The compensation range reflects the Company's reasonable expectation at the time of posting. Exact compensation for this role will be determined based on permissible, non-discriminatory factors such as candidates' qualifications, skills, and experience.
Full-time positions also include a benefits package that includes vacation, sick leave, paid holidays, medical (with an HSA plan option), dental, vision and company paid Basic Life insurance, opportunity to enroll in Voluntary Life plans, Employee Assistance Program, 401K with employer match, employee referral program, home office stipend and opportunities for team building, growth, and development. Team members have on-demand access to an LMS with a variety of courses to further their professional and personal development.
DISCLOSURE TO JOB APPLICANTS PURSUANT TO THE CALIFORNIA CONSUMER PRIVACY ACT
As part of your job application and our evaluation of your candidacy, we collect, receive, maintain, and use your personal information, which as used herein, means information that identifies, relates to, describes, is reasonably capable of being associated with, or could reasonably be linked, directly or indirectly, with you or your household. The following is the personal information we may collect as part of the application process:
Personal contact details, such as name, title, address, telephone number, and email address; and
Application information, such as your qualifications, skills, education, references, and other information that may be in your resume, cover letter, and materials you provide to us when applying for employment.
We collect your personal information to evaluate your job application and candidacy for employment, to check your eligibility to work in the country in which you have applied, for background checks, and to comply with employment and other laws. If you become employed by us, we will notify you of additional categories of personal information that we collect, receive, and maintain for business purposes.
Qualifications
What You Bring:
- A minimum of 5 years of strong hands-on experience with Salesforce, Tableau, Microsoft SQL Server, and Snowflake
- Proven experience delivering self-service, sales-facing reports in Tableau
- Demonstrated ability to manage data pipelines in multi-platform environments
- Deep understanding of data governance, system integration, and automation
- Excellent communication and collaboration skills across technical and non-technical teams.
- Experience with system integration tools and strategies (e.g., APIs, middleware)
- Salesforce Platform and Administration certifications (preferred)
- Snowflake certifications (preferred)
- Strong leadership, communication, and problem-solving abilities in sales operations environment
- Bachelor's degree in Business Administration, Computer Science, or a related field
- At least 5 years of recent experience developing datasets, procedures, and functions in Microsoft SQL Server and Snowflake
Our Commitment:
Smart Circle International is passionate about creating an inclusive workplace that promotes and values diversity and celebrates differences. We are committed to creating an environment that fosters growth opportunities for all team members. Wherever practical, Smart Circle International wants team members in the position that best suits their unique abilities, interests, and skills, as well as our business needs. We strongly believe that bringing our team members' diverse backgrounds, cultures, and perspectives together is the best way to serve our clients and the independent sales companies with which we work side by side.
Equal Opportunity Employer:
We believe in equal opportunity. Each team member is recruited, employed, evaluated, and considered for promotion without regard to race, color, national origin, age, sex, disability status, or any other protected characteristic under state or federal law. We will not tolerate discrimination or harassment based on any protected characteristic and expect all team members to treat others with dignity and respect.
*In accordance with the applicable law, the following represents a good faith estimate of the minimum and maximum compensation range for this position: the estimated annual compensation range for this role is $110k - $160k.The compensation range reflects the Company's reasonable expectation at the time of posting. Exact compensation for this role will be determined based on permissible, non-discriminatory factors such as candidates' qualifications, skills, and experience.
Full-time positions also include a benefits package that includes vacation, sick leave, paid holidays, medical (with an HSA plan option), dental, vision and company paid Basic Life insurance, opportunity to enroll in Voluntary Life plans, Employee Assistance Program, 401K with employer match, employee referral program, home office stipend and opportunities for team building, growth, and development. Team members have on-demand access to an LMS with a variety of courses to further their professional and personal development.
DISCLOSURE TO JOB APPLICANTS PURSUANT TO THE CALIFORNIA CONSUMER PRIVACY ACT
As part of your job application and our evaluation of your candidacy, we collect, receive, maintain, and use your personal information, which as used herein, means information that identifies, relates to, describes, is reasonably capable of being associated with, or could reasonably be linked, directly or indirectly, with you or your household. The following is the personal information we may collect as part of the application process:
Personal contact details, such as name, title, address, telephone number, and email address; and
Application information, such as your qualifications, skills, education, references, and other information that may be in your resume, cover letter, and materials you provide to us when applying for employment.
We collect your personal information to evaluate your job application and candidacy for employment, to check your eligibility to work in the country in which you have applied, for background checks, and to comply with employment and other laws. If you become employed by us, we will notify you of additional categories of personal information that we collect, receive, and maintain for business purposes.