Senior Data Automation Engineer

Senior Data Automation EngineerThe Senior Data Automation Engineer will help enhance operational efficiency and business insight by designing, developing, and managing automated data processes across Salesforce, SQL Server, Snowflake, and Tableau. This role bridges technical expertise with business strategy — optimizing data pipelines, integrating enterprise systems, and enabling secure, scalable, and reliable automation. This role creates and maintains critical datasets, and self-service reporting tools that empower teams with accurate insights to enable better decision making.The ideal candidate is confident serving as a cross-functional expert who will collaborate with stakeholders to streamline workflows, safeguard data quality, and ensure compliance. They bring technical depth and problem-solving agility, with a strong commitment to advancing their data architecture and automation skills.Pay and LocationLocationRemote (WFH)Base pay range$125,000 - $145,000 per year, commensurate with experienceTravelUp to 10%Reports ToSalesforce and Tableau DeveloperWhat You'll DoCustomize Salesforce data model and automations to align with business requirementsManage data governance and integrate external systemsSupport users, optimize performance, and ensure complianceTableau and Database AdministrationDesign dashboards with advanced calculations and manage data layers and securityAdminister access controls and tune performanceDevelop scalable databases in SQL Server and SnowflakeOptimize SQL scripts, support reporting, and maintain ETL pipelinesDesign and schedule automations and workflowsMonitor and optimize job performance and implement alerting mechanismsMaintain documentation and security protocolsCollaborate with stakeholders to enhance automation reliability and effectivenessQualifications and ExpertiseProven expertise with Salesforce, Tableau, Microsoft SQL Server, Azure SQL, Azure Data Factory, and SnowflakeDemonstrated ability to design and manage automated data pipelines across multi-platform environmentsStrong experience developing datasets, procedures, and functions in SQL-based systems (Microsoft SQL Server, Snowflake)Hands-on experience creating self-service, sales-facing reports in TableauSolid understanding of data governance, system integration (APIs, middleware), and automation best practicesSkilled at collaborating across technical and business teams to deliver scalable data solutionsBachelor's degree in Computer Science, Business, or related field3+ years of recent, relevant experience in data engineering and analyticsSalesforce or Snowflake certifications (preferred)Experience with Python integration and notebooks (preferred)Company OverviewSmart 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 RewardsFull-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, 401(k) 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 EmployerWe 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.J-18808-Ljbffr