Technical Solutions Consultant

TITLE: Technical Solutions Consultant

LOCATION: San Francisco, CA (hybrid, on-site Tuesday – Thursday)

ANTICIPATED DURATION: 6 months

Responsibilities:

• Develop and maintain data models and SQL pipelines to assist in visualization, analysis, and interpretation of business data, with direct guidance.
• Help scale repeatable data solutions by identifying manual data pulls that can be automated via scheduled queries.
• Provide ongoing support for internal data users by maintaining and debugging complex reports, queries, and dashboards.
• Help troubleshoot technical data issues by analyzing raw logs and query execution plans, proposing fixes with direct guidance.
• Consult with users, partners, or decision-makers to identify data sources, required data elements, and data validation standards.
• Translate non-technical business requirements into precise technical specifications for data schemas and views.
• Perform exploratory data analysis and profiling utilizing relevant tools to ensure high data fidelity.
• Implement validation checks to ensure accuracy in reporting and analytics, under direct guidance.
• Support collaboration with internal stakeholders by providing technical guidance on data availability and feasibility.
• Help scale existing solutions by creating documentation for data dictionaries, schema definitions, and SQL tutorials for the wider team.

Requirements:

• Strong proficiency in SQL (writing complex queries, joins, subqueries, CTEs, window functions).
• Proficiency in code comprehension (SQL) and debugging.
• Proficiency in data pipeline (ETL) maintenance and data modeling.
• Experience with internal data warehousing technology (GoogleSQL, PLX) or BigQuery.
• Developing proficiency in system design.
• Developing proficiency in stakeholder management.
• Developing proficiency in data exploration and statistics.

The hourly pay rate range for this position is $70 to $75.57 (dependent on factors including but not limited to client requirements, experience, statutory considerations, and location). Benefits available to full-time employees: medical, dental, vision, disability, life insurance, 401k, and commuter benefits.

Synergis is proud to be an Equal Opportunity Employer. We value diversity and do not discriminate on the basis of race, color, ethnicity, national origin, religion, age, gender, gender identity, political affiliation, sexual orientation, marital status, disability, military/veteran status, or any other status protected by applicable law.

Qualified applicants with arrest or conviction records will be considered for employment in accordance with the requirements of applicable state and local laws, including but not limited to, the San Francisco Fair Chance Ordinance, the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, and the California Fair Chance Act.

For immediate consideration, please forward your resume to dreeves@synergishr.com.

If you require assistance or an accommodation in the application or employment process, please contact us at dreeves@synergishr.com.

Synergis is a workforce solutions partner serving thousands of businesses and job seekers nationwide. Our digital world has accelerated the need for businesses to build IT ecosystems that enable growth and innovation along with enhancing the Total Experience (TX). Synergis partners with our clients at the intersection of talent and transformation to scale their balanced teams of tech, digital and creative professionals. Learn more about Synergis at www.synergishr.com.