Software Developer

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

Responsibilities

• Work closely with Business Intelligence and Data Warehouse teams to understand the underlying data structure of the databases.
• Analyze the source data and work with business users and developers to develop the Data Model.
• Develop and schedule jobs for extracting, cleaning, transforming and loading data into data warehouse using SSIs
• Create Stored Procedures, functions and database triggers in SQL Server database using Management Studio
• Develop, test, implement and document the Microsoft SSIS packages, SSRS reports and Tableau
• Dashboards according to the functional and technical specifications given by the users
• Create various types of data visualization reports using Bar and column charts, Stacked Area charts, Combo charts, Doughnut charts, Maps and varieties of dashboards using Tableau 10.0
• Work on the enhancements or the changes requested by the users in the project
• Support/Troubleshoot or debug the existing jobs which currently load the data into the project environment.
• Provide production support and help solve any issues with the failure in production jobs
• Participate in team and project meetings and presentations as needed
• Create Scripts to perform various data validation testing in all environments and deploy code to the next environment
• Log defects and fix bugs for Quality Check
• Document the technical specifications and modifying the Work Tracker, Design document, Release document and Matrices, etc. based on the requirement
• Support management in recommending process enhancements and analyze new procedures to enhance efficiency

Qualifications

• Required Qualification: Bachelor's in Computer Science or Computer Engineering or Information Technology or Computer Information Systems

Job Details

• Job Code: SW456
• Job Location: San Francisco, CA
• Type Of Job: Full time
• Hours Per Week: 40
• Experience: 2-4