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 Data Solutions
- Connect business needs 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 owns ETL, ingestion, and source-system modeling. Own the ELT process that turns landed data into curated, business-ready models
- Data Modeling & Analytics Enablement
- 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
- AI & Innovation
- Use AI tools and connectors to work faster, while validating everything that reaches production
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
- 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
- Experience working within BI standards (CoE, code review, Git)
- Everyday use of AI as a working partner for ideation and QC, with the judgment to verify its output
How You'll Standout
- SQL Server to Snowflake migration experience
- Experience reporting on replicated Salesforce data
- Finance/FP&A, Sales Ops, or field marketing reporting background
- Experience preparing semantic layers for AI agents
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.