ShiftCode Analytics, Inc. · 5 months ago
Sr. Database/ Observability Architect
United States
Full-time
Remote
Senior LevelShiftCode Analytics, Inc. is seeking a Sr. Database/Observability Architect with expertise in multiple SQL/database languages and experience with Grafana. The role involves working with various databases, ETL processes, and custom utilities for data processing and visualization.
AnalyticsConsultingInformation Technology
No H1B
Responsibilities
Someone familiar with Grafana who is proficient in Writing Database Queries in multiple SQL/database languages
Client has Microsoft SQL, Oracle SQL, Posgres SQL, Mongo Databases, Timeseries Databases (Timescale DB, Elkstack DB)
Someone familiar with the ETL Process (Extracting, Transforming, and Loading data)
Data Warehousing, Data Masking, Data Lake
Linux (this is the platform Client uses)
Visualization
They don't want a DBA (who typically only knows 1 SQL/Database language, they want someone that knows multiple languages and is willing to learn if they don't know a particular language)
Required experience - Python ETL
Customer has an existing, working, framework and the candidate would need to copy the framework but this requires deep knowledge of how Python works
Candidate would need to write custom utilities { The scenario is they are reading from an infinite # of data sources (reading from a REST interface or reading from Kafka) and processing that data into a different format then writing that to their time-series database. They have existing libraries for all of this, but there is a lot of custom work that is happening between the data source processing and the writing to the database}
Custom work examples:
Utilizing patterns/pagination to sort data
Need to utilizing timestamps from the data and use this as opposed to when the data arrived from source
Multi-processing framework (this would be a differentiator if a candidate has used this before)
Customer is writing to Influx DB today, but the database they are writing to may change
Grafana experience required
Qualification
Required
Familiar with Grafana
Proficient in Writing Database Queries in multiple SQL/database languages
Experience with Microsoft SQL, Oracle SQL, Posgres SQL, Mongo Databases, Timeseries Databases (Timescale DB, Elkstack DB)
Knowledge of the ETL Process (Extracting, Transforming, and Loading data)
Experience in Data Warehousing, Data Masking, Data Lake
Familiarity with Linux
Experience in Visualization
Experience with Python ETL
Deep knowledge of how Python works
Ability to write custom utilities for data processing
Experience with reading from multiple data sources (REST interface or Kafka)
Ability to utilize patterns/pagination to sort data
Ability to utilize timestamps from the data
Experience with multi-processing framework
Experience writing to Influx DB
Grafana experience required
Company
ShiftCode Analytics, Inc.
ShiftCode Analytics Inc is a Tampa, FL based firm formed with one sole purpose of delivering best and quick services to its clients nationwide.
Founded in 2019
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase