Data Architect (contract)

Remote — must be able to work in PST time zone Responsibilities • Architect and code data structure from ingestion to visualization using Snowflake, DBT, and Tableau • Implement best practices for the data platform that provides maintainability, reliability, and efficiency • Provide expertise in data warehouse modeling and development for Snowflake using DBT • Exercise best practices in optimal data modeling for nonuniform sets of data • Provide best practices for source code control with Github • Design and maintain data security access controls • Develop SQL, HTML, and/or JavaScript code to optimize the stack or to generate views for visualization • Work with cross-functional teams to gather requirements and deliver to respective stakeholders • Provide guidance and mentorship to junior data developers Qualifications • BS in Computer Science; emphasis in Data Engineering is a plus • 10–12 years of data engineering development and visualization experience • 8–10 years of data warehouse experience (Snowflake DWH preferred) • 8–10 years of SQL experience (Snowflake SQL preferred) • 4–6 years of dbt Cloud experience; semantic layer experience is a plus • 3–5 years of experience with Github • 3–5 years of experience with CI/CD tools for the modern data stack • 3–5 years of building Tableau data sources and dashboards • 2+ years of Python development • HTML and JavaScript experience as it relates to Looker preferred • Experience with enterprise systems such as Salesforce, Oracle, Workday, Jira, Adaptive, Anaplan • Fluent written and verbal communication skills The pay range that the employer in good faith reasonably expects to pay for this position is $39.86/hour - $62.29/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis. Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.