Designs and builds relational databases for data storage or processing
Develops strategies for warehouse implementation, data acquisition and access, and data archiving and recovery
Builds data models and defines the structure, attributes and nomenclature of data elements
Evaluates new data sources for adherence to the organization's quality standards and ease of integration
Provides subject matter expertise regarding information architecture
Develops and enforces the data architecture standards
Develops and maintains documentation that maps data models to information systems and business applications
Validates and fixes information management issues related to data quality framework (completeness, accuracy, availability, timeliness, consistency, etc.)
Manages data dictionary to improve documentation and coordination
Assists in building of enterprise architecture information blueprints and data models
Requirements
A Bachelor's degree in a quantitative or business field (e.g., statistics, mathematics, engineering, computer science)
6 – 8 years of related experience
Experience with Extract Transform Load (ETL)
Experience with Microsoft SQL Servers
Experience with Oracle Database Management System (DBMS)
Knowledge of Python
Experience with Snowflake, PowerDesigner, AWS Technologies, HealthCare Knowledge
Knowledge of Data Catalog, Metadata, Lineage tools and usage: Alation, Manta
Knowledge of Business Intelligence
Knowledge of Streaming data ingest tools and platforms: Informatica, Talend, Kafka, AWS Glue, Matillion, SSIS
Tech Stack
AWS
ETL
Informatica
Kafka
Matillion
Oracle
Python
SQL
SSIS
Benefits
competitive pay
health insurance
401K and stock purchase plans
tuition reimbursement
paid time off plus holidays
flexible approach to work with remote, hybrid, field or office work schedules