Skip to Main Content
← Back to Jobs

SQL Database/ETL Developer

Shield Compliance Seattle, WA
  • Expired: over a month ago. Applications are no longer accepted.

We are seeking an SQL Database/ETL Developer to become an integral part of our development team! You will design strategies for database systems as well as set standards for operations, programming and security.

Responsibilities:

  • Collaborate with U/I developers to define technical requirements for new data entities, tables and procedures
  • Create database diagrams to communicate data architecture to developers and internal stakeholders
  • Create required databases, tables and test data for effective development and test processes
  • Create stored procedures, views, triggers and SQL scripts in support of application processes
  • Review and optimize queries for performance, create supporting indices
  • Manage SQL-related Jira sub-tasks in support of U/I changes for multiple developers, organizing work for efficiency
  • Participate in Agile Dev/Ops style development process
  • Communicate scope of work, change requests and delivery of work proactively
  • Create and maintain ETL integration pipelines in Azure Data Factory or other appropriate tools.
  • Assist Product Team in defining Integration requirements for multiple state agencies and partner data sources

Qualifications:

  • Bachelor’s degree in computer science, information technology, computer science, engineering, or related field
  • Five to seven years SQL server database development experience in a commercial environment or equivalent work experience
  • Experience with the following: Microsoft SQL Server; Microsoft Azure SQL; Microsoft Transact-SQL; Microsoft SQL Server Management Studio; Microsoft Azure, Azure DevOps; Azure SQL Database Administration
  • Experience in a DevOps team environment using Agile methodology
  • Ability to translate complex business requirements into relational data structures
  • Ability to translate data from disparate external sources into efficient, consumable structures
  • Excellence in writing clean, efficient queries, understanding of common table expressions, built-in SQL functions and data types
  • Experience with database integrations, performance tuning and optimization, and setting up and managing database connections
  • Deep understanding of SQL query plans, indices and query analysis
  • Expertise in data warehouse services and large datasets
  • Expertise in various ETL tools and experience including Azure Data Factory
  • Strong analytical and critical thinking skills
  • Ability to prioritize and multitask
  • Deadline and detail-oriented

Shield Compliance

Why Work Here?

Get in on the ground level with a start-up fintech.

Shield's purpose built compliance platform manages the risk, compliance and operational demands associated with banking in the legalized cannabis industry. With Shield's transactional and operational transparency tools, bank compliance officers are notified of non-compliant activity quickly reducing risk and operational overhead.

Address

500 Union St #310, Seattle, WA 98101
Seattle, WA
USA

Website