• Assist in designing, developing, and maintaining data pipelines and data models for various integrated analytics solutions • Support the ingestion, cleaning, transformation, and flow of structured and unstructured data. • Collaborate with data analysts and business stakeholders to deliver reliable datasets. • Monitor data workflows, troubleshoot issues, and optimize performance. • Ensure downstream data quality and integrity. • Participate in maintaining data documentation, dictionaries, and metadata. • Learn and apply best practices related to data architecture, data modeling, and data governance.

• Design, build, and maintain scalable data pipelines (ETL/ELT) to process structured and unstructured data, including PDF-based data extraction workflows • Model and transform data into clean, reliable datasets optimized for analytics and business intelligence • Ensure data quality, consistency, and availability across systems • Partner with business and executive teams to understand data needs and enable data-driven decision-making • Develop and maintain dashboards and reports using tools such as Power BI • Automate data workflows and reporting processes to improve efficiency and scalability • Collaborate with backend and engineering teams to integrate data systems and APIs • Contribute to the definition of data architecture and best practices • Support exploratory analysis and provide high-quality datasets for analytics and future machine learning use cases • Communicate technical concepts and data insights clearly to both technical and non-technical stakeholders

• Design, build, and optimize data pipelines using CData connectors • Ingest and transform data into Snowflake for analytics and reporting • Develop and maintain scalable data models within Snowflake • Build and optimize Looker schemas (LookML) for business intelligence use cases • Ensure data quality, consistency, and reliability across systems • Collaborate with stakeholders to understand reporting requirements and translate them into technical solutions • Troubleshoot and resolve data pipeline and modeling issues • Implement best practices for data governance, performance optimization, and scalability

Job DetailsJob Location: Smart Circle International - Newport Beach - Newport Beach, CA 92660Salary Range: $125,000.00 - $145,000.00 Salary/yearWe’re looking for a Senior Data Engineer to play a key role in shaping how data drives decisions across the business. You’ll design and scale data systems that connect Salesforce, Snowflake, SQL Server, and Tableau—transforming fragmented data into reliable, actionable insights. This is a high-impact role where you’ll own data pipelines end-to-end, influence architecture decisions, and build the foundation for self-service analytics used by business teams daily. The Basics: Location: Remote/WFH (U.S. Based Only) Compensation: $125,000-$145,000/year, commensurate with experience In accordance with applicable law, the compensation range listed above 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. Travel: Up to 5% What You'll Do: Own and evolve our data ecosystem Design, build, and optimize scalable data pipelines across Salesforce, Snowflake, and SQL Server Improve reliability, performance, and observability of data workflows Lead data modeling efforts to support analytics and reporting Enable better business decisions Partner with stakeholders to translate business needs into data solutions Develop clean, trusted datasets and power self-service analytics in Tableau Ensure data accuracy, consistency, and accessibility across teams Drive automation and efficiency Build and manage automated workflows and scheduling systems Implement monitoring, alerting, and performance tuning Continuously identify opportunities to streamline processes and reduce manual work Strengthen governance and integration Maintain data quality, security, and compliance standards Integrate systems using APIs and modern data tools Document systems and promote best practices across teams Additional responsibilities may be assigned as needed to support team and organizational priorities What You'll Bring: 3+ years of experience in data engineering, analytics engineering, or similar roles Strong hands-on experience with SQL (SQL Server, Snowflake) and data modeling Experience building and maintaining ETL/ELT pipelines across multiple systems Proficiency with Tableau for building business-facing dashboards Experience working with Salesforce data and integrations Familiarity with Azure Data Factory or similar orchestration tools Understanding of data governance, APIs, and system integration 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. Our corporate offices are in Newport Beach and Toronto. Visit smartcircle.com to learn more! 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 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. 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