Data Warehouse BI Developer (SSIS, Tableau)

Sumas Corporation Inc; San Francisco (CA); On-site; USD 80,000 - 110,000; Full time

Job summary

Sumas Corporation Inc is seeking a full-time position in San Francisco, CA, focusing on Business Intelligence and Data Warehouse functionalities. The role involves closely collaborating with teams to analyze data requirements, develop data models, and create ETL processes. Candidates should have a Bachelor’s degree in Computer Science or related fields and 2-4 years of experience. Proficiency in SQL Server, SSIS, and Tableau is essential, and the position offers 40 hours of work per week.

Qualifications

• Bachelor's in Computer Science, Computer Engineering, Information Technology, or Computer Information Systems required.
• 2-4 years of experience in a related field.

Responsibilities

• Work closely with BI and Data Warehouse teams.
• Analyze source data and develop the Data Model.
• Develop and schedule jobs for data extraction and loading.
• Create Stored Procedures and functions in SQL Server.
• Develop and implement SSIS packages and SSRS reports.
• Create data visualization reports in Tableau.
• Provide support and troubleshoot existing jobs.
• Document technical specifications and recommendations.

Skills

Data modeling

SQL Server

Microsoft SSIS

Tableau

ETL processes

Education

Bachelor's in Computer Science or related fields

Tools

SQL Server Management Studio

Tableau 10.0

Job description

Sumas Corporation Inc is seeking a full-time position in San Francisco, CA, focusing on Business Intelligence and Data Warehouse functionalities. The role involves closely collaborating with teams to analyze data requirements, develop data models, and create ETL processes. Candidates should have a Bachelor’s degree in Computer Science or related fields and 2-4 years of experience. Proficiency in SQL Server, SSIS, and Tableau is essential, and the position offers 40 hours of work per week.