Data Engineer - No C2C (W2 Only)

Overview: Our client provides automated, cloud-based software for financial operations and is seeking an accomplished Data Engineer. • • • Candidate must be authorized to work in USA without requiring sponsorship • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • Location: Remote-Hybrid (San Jose, CA) • • • Duration: 12+ months Important Items: • Work Arrangement: Onsite, 5 days per week (may require occasional after-hours, evenings, or weekends) Required Skills: • BS/BA in Computer Science, Information Systems, Mathematics, or a related technical field (or equivalent work experience). • 2+ years of experience in data engineering, BI, or analytics role. • 1+ years of experience working in financial services and/or SaaS companies. • Experience in dbt and modern data modeling best practices. • Version control via Git is a must • Experience working in startup environments is a plus. • Strong proficiency in SQL, with experience in Multiple SQL Syntaxes (Redshift, Snowflake, and Trino (Iceberg). • Deep understanding of dbt, including model development, macros, and Jinja templating. • Experience with BI tools, such as Tableau, and a working knowledge of data source construction. • Strong stakeholder communication skills, particularly in guiding teams through infrastructure changes. • Experience refactoring SQL and dbt models to support infrastructure migrations. Job Responsibilities: • You will be responsible for supporting the migration of dbt models from Redshift and Snowflake to Trino (Iceberg) while ensuring compatibility, performance, and best practices in our evolving infrastructure. • Your role will require a deep understanding of SQL dialects, data modeling principles, and dbt best practices. You will collaborate with both engineering and analytics teams to ensure seamless model transitions and maintain quality standards. Specifically, you will: • Fix Redshift and Snowflake SQL Syntax to Trino Syntax in our dbt models. • Version control dbt models via Git . • Refactor and optimize data models to ensure they align with Iceberg best practices. • Work with Tableau assets, ensuring data sources align with the new infrastructure. • Collaborate with workbook owners to validate and test the impact of migration work. • Engage in daily standups and work alongside engineers to execute migration priorities efficiently. • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • I'd love to talk to you if you think this position is right up your alley, and assure a prompt communication, whichever direction. If you're looking for rewarding employment and a company that puts its employees first, we'd like to work with you. Sam Banga Lead Technical Recruiter Company Overview: Amerit Consulting is an extremely fast-growing staffing and consulting firm. Amerit Consulting was founded in 2002 to provide consulting, temporary staffing, direct hire, and payrolling services to Fortune 500 companies nationally, as well as small to mid-sized organizations on a local & regional level. Currently, Amerit has over 2,000 employees in 47 states. We develop and implement solutions that help our clients operate more efficiently, deliver greater customer satisfaction, and see a positive impact on their bottom line. We create value by bringing together the right people to achieve results. Our clients and employees say they choose to work with Amerit because of how we work with them - with service that exceeds their expectations and a personal commitment to their success. Our deep expertise in human capital management has fueled our expansion into direct hire placements, temporary staffing, contract placements, and additional staffing and consulting services that propel our clients’ businesses forward. Amerit Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Applicants, with criminal histories, are considered in a manner that is consistent with local, state and federal laws.