Technical Solutions Consultant (Junior II)

Location: San Francisco, CA

Salary: $50.00 USD Hourly - $70.00 USD Hourly

Description: Our client is currently seeking a Technical Solutions Consultant

Project Overview:

Responsibilities include:

• Develop and maintain data models and SQL pipelines to assist in the 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 (e.g., data discrepancies, latency) 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 (PRDs) 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.
• Consult with application engineers and data scientists to understand logging, transactional storage, and data exchange formats.
• Support the collaboration with internal stakeholders to provide technical guidance on data availability and feasibility.
• Help scale existing solutions by creating documentation for data dictionaries, schema definitions, and "best practice" SQL tutorials for the wider team.
  
  

Additional skills required include:

• 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 tech (SQL, PLX) or BigQuery
• Developing proficiency in System Design
• Developing proficiency in Stakeholder Management
• Developing proficiency in Data Exploration and Statistics
  
  

By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.

Contact:

This job and many more are available through The Judge Group. Please apply with us today!