Staff Data Warehouse Administrator (Cloud)
Company: GoodRx, Inc.
Location: Santa Monica
Posted on: September 16, 2021
|
|
|
Job Description:
A Telemedicine company in Santa Monica is growing quickly and
searching for a Staff Data Warehouse Administrator to join their
Enterprise Data Platform group as a creative contributor, leader,
and mentor to our data analysis and scalability processes. This
person will use their experience and expertise to provide key
insights that help us make data-driven decisions. They will
Interact with cross-functional teams, project managers and agile
teams to estimate development efforts and ensure complete delivery
of solutions and fulfilling requirements and maintain the data
warehouse and taking data from several source systems into the data
warehouse, monitor health, tuning, and growth, and provide
infrastructure guidance on the platform capabilities to accommodate
business/technical use cases. The ideal candidate has Knowledge
about how to take data from disparate sources and discover,
transform, manage, aggregate, catalog and deliver data to be used
in reports and analytics repositories and thrives off analytical
thinking.
Provides release management support for databases and related
applications.
Ensures security and maintenance of databases, manage and monitor
user access to the databases, diagnose and troubleshoot database
errors.
Provide proactive administration of Data Warehouse platforms such
as Redshift/Snowflake/BigQuery, leveraging your technical expertise
in all aspects of the data platform.
Monitoring health, tuning, and growth of such on cloud data
warehouse instances.
Provide infrastructure guidance on the platform capabilities to
accommodate business/technical use cases.
Automate and manage provisioning needs, such as storage and
compute, Role Based Access Control model and permissions.
Configure and manage monitoring/alerting around replication
latency, performance (cluster & query) and Looker/Airflow.
Provide technical expertise and troubleshooting.
Interact with cross-functional teams, project managers and agile
teams to estimate development efforts and ensure complete delivery
of solutions and fulfilling requirements.
Knowledge about how to take data from disparate sources and
discover, transform, manage, aggregate, catalog and deliver data to
be used in reports and analytics repositories.
- Cloud Certifications (AWS, Google Cloud)
- Experience coding with Python or Smark
- Strong understanding of Looker
- BA Degree (Computer Science)
- 5+ years of experience as DBA supporting cloud data warehouse
platforms
- Experience running the implementation of a cloud warehouse
platform (Snowflake, Databrick, Redshift, ETC)
- Ability to optimize design of data through performance tuning
utilizing EMR, Streaming, Sagemaker or pySpark
- Has gathered, refined, and delivered requirements for
implementation
- Familiar with AWS and GCP to create, monitor, and manage
databases
Keywords: GoodRx, Inc., Santa Monica , Staff Data Warehouse Administrator (Cloud), Other , Santa Monica, California
|
Click
here to apply!
|
