Avatar for ZoomSystems

Data Developer

$50k – $120k
Apply now
We are looking for a talented Database software developer to be part of our growing Data and Analytics team and participate in implementing new capabilities and enhancements to our database systems.

Our environment is unique in that it contains both Microsoft SQL databases as well as Google Firebase Databases. Successful candidate will work collaboratively with our Product Management and Software Engineering teams on a wide variety of database, reporting, and business intelligence projects in an Agile environment to meet our external customers’ and internal stakeholders’ requirements.



Scope and Responsibilities:

• Create complex functions, stored procedures, triggers, and scripts to support application development
• Analyze existing database designs and code, and develop/alter stored procedures, SSIS packages, SQL jobs as required
• Develop and maintain reports using SSRS, Excel, or other tools as required
• Create and maintain data warehouse ETL processes
• Prepare design specifications and technical documentation for assigned database projects
• Perform database space management and capacity planning; identify performance issues using profiling tools and provide corrective measures
• Participate in architecture reviews and database design in support of application development projects
• Ensure data quality and integrity across databases
• Work with the Software development teams to identify bottlenecks and opportunities for improvement in database design and report generation
• Help troubleshoot issues and work with the team to address root cause to minimize the chance of a second occurrence
• Develop and advocate for Database best practices, standards and processes



Requirements:

• BS or MS in Computer Science, Information Systems, or equivalent relevant experience
• 5 years software engineering experience with a minimum of 2 years in database development
• Experience in data modeling, or data integration using relational, star schema, multi-dimensional data models, and document databases
• Experience in SQL databases that includes query development, views, triggers, indexes, and stored procedures
• Experience developing SSRS reports and SSIS packages
• Experience in schemaless databases, especially Firebase/Firestore is a plus
• Experience developing in a data warehouse environment and experience with data modeling tools are both desirable
• Knowledge of best practices, theories, and approaches to performance tuning and optimization of data integration processes, collection of metadata, table partitioning, materialized views, and parallel processing. Proficient in PL/SQL.
• Familiarity with FoxPro as well as Microsoft Dynamics are a plus
• Experience working with revision control systems including Git
• Experience working in an Agile development environment is required; JIRA experience is desirable
• General understanding of machine learning a plus
• Comfortable performing code/design reviews and providing constructive feedback
• Working knowledge of basic security systems, permissions/roles, and firewalls is desirable
• Excellent communication skills and experience working in a matrix organization
• Desire to learn and continually improve self and others though knowledge sharing



This is a full-time position with our growing team in our beautiful office in the heart of the Financial District in San Francisco.

As an employee, you’ll be eligible for our benefits, such as

• Comprehensive health care, dental care, vision care,
• Life insurance, short term disability and long-term disability
• PTO
• Gym in the roof top of our beautiful building at a highly discounted price
• And of course, our dog-friendly policy because… who doesn’t love dogs!


Swyft, Inc. embraces diversity. We are proud to be an equal opportunity workplace and do not discriminate on the basis of sex, race, color, age, sexual orientation, gender identity, religion, national origin, citizenship, marital status, veteran status, or disability status. Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

ZoomSystems at a glance

ZoomSystems focuses on Hardware + Software. Their company has offices in San Francisco. They have a mid-size team that's between 51-200 employees. To date, ZoomSystems has raised $87M of funding; their latest round was closed on January 2010.

You can view their website at http://www.zoomsystems.com or find them on Twitter.

Similar jobs to Data Developer at ZoomSystems

Avatar for Plaid
Infrastructure and API's to power FinTech
Avatar for Loop
Private social network for families
Avatar for Woopra
Customer Analytics to Unify, Visualize and Engage Through Every Customer Touchpoint
Avatar for Docker
Modernize your applications, accelerate innovation
Avatar for BlueOwl
Creating technology solutions for good. creating a safer, happier, and more sustainable future
Avatar for TechLink Systems
Founded in 1998, TechLink Systems is a WMBE certified
Avatar for Primer
We accelerate human understanding of the world with machines that read and write