Analytics Engineer

The Analytics Engineer bridges business stakeholders, BI, and Data Engineering teams. This role focuses on designing scalable data solutions, building business-ready data models, and enabling trusted analytics across the organization.

The ideal candidate brings deep data expertise across multiple platforms, with strong experience in SQL, Snowflake, data modeling, and semantic layer design. While Tableau experience is required, the primary focus is on analytics engineering, data architecture, and partnering with the business to deliver scalable, enterprise-ready data solutions.

What You'll Do

• Connect business needs to the right data solution: decide where each change belongs (source, model, semantic layer, or report) and right-size the investment.
• Partner with stakeholders at all levels to scope requirements and develop BRDs.
• Partner with IT and Data Engineering, who own ETL, ingestion, and source-system modeling. Own the ELT process that turns landed data into curated, business-ready models.
• Design and maintain layered data models (raw → curated → gold) with documented business definitions for BI and AI use.
• Uphold CoE standards (version control, code review, documentation) and standardize KPI definitions and data quality checks.
• Own Tableau published data sources and provide tier-2/3 Tableau support.
• Own Data Product (tables, SP, views, Semantic Layers) in SQL, Snowflake.
• Use AI as a thought partner to accelerate analysis and code review, with full ownership of production work.

What You'll Bring

• Strong business acumen and a track record of right-sizing solutions, including choosing not to build.
• Experience writing BRDs and communicating with technical and non-technical stakeholders.
• 2+ years of Salesforce Experience (object, relationship, reporting)
• 6+ years of advanced SQL development, including stored procedures and performance tuning, with skills that transfer across platforms.
• 3+ years of hands-on Snowflake experience (clustering, cost and performance tuning).
• Dimensional modeling and layered/semantic-layer design.
• 4+ years of hands-on Tableau (Desktop, Prep, Server/Cloud), including LOD expressions, data source design, and performance tuning. Other BI tools don't substitute.
• Proven experience establishing and enforcing BI CoE standards across data, workbooks, and process: certified data sources, KPI definitions, naming and field conventions, workbook structure, content lifecycle, and Git-based code review.
• Familiarity with AI as a working partner for ideation and QC, with the judgment to verify its output.

How You'll Standout

• Database migration experience (SQL Server, Salesforce, Snowflake).
• Cross-functional reporting experience.
• Experience with AI engineering or AI agent management.

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. Smart Circle operates from two locations: our headquarters in Newport Beach, California, and an office in Toronto, Ontario. Visit smartcircle.com to learn more!

Why You’ll Love It Here:

Smart Circle is committed to cultivating an environment that sparks curiosity, encourages bold thinking, and supports continuous development. We believe people thrive when they’re in roles that align with their strengths and ambitions, so we make space for individuals to stretch and explore new possibilities. Your next move matters so if you're looking for a place where ambition is celebrated and growth is tangible, Smart Circle may be the place for you!

Total Rewards:

Full-time positions qualify for 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.

Equal Opportunity Employer:

We are an Equal Opportunity Employer, committed to building a workplace where every individual is valued, respected, and empowered to grow, regardless of background or identity.

We recruit, hire, evaluate, and promote based on talent and potential, without regard to race, color, national origin, age, sex, disability status, or any other protected characteristic under state or federal law. Discrimination or harassment of any kind has no place here, and we expect every team member to uphold a culture of dignity and respect.

In accordance with applicable law, the compensation range listed within this job posting reflects our good faith estimate of the expected salary for this role at the time of posting. Final compensation will be determined based on a variety of non-discriminatory factors, including a candidate’s qualifications, skills, and experience.

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.