Lead Snowflake Data Engineer
Medsuite Inc
ApacheAzureCloudETLKafkaMatillionPythonSparkSQL
Salary
💰 $125,000 - $165,000 per year
Job Level
SeniorLead
Tech Stack
ApacheETLLinuxOracleSQLUnix
About the role
- Leading a team of Data analysts, database administrators, and data quality analysts
- Database architectural design and construction for both new database and existing database environments
- Establish best practices for ETL processing in Oracle relational databases
- Lead team members in developing and maintaining documentation regarding data quality assurance and data loading processes
- Coordinate with survey contractors to provide efficient and accurate data transfers and loading of survey data from SAS and other sources thru standardization/automation of ETL processing
- Mentor team members on industries best practices regarding data processing and relational database design
- Refine/improve data standards and structures for all aspects of the data management life cycle
- Experience designing and building dimensional structures and star schemas
- Manage all transformation activities for a large Oracle 19c-based data warehouse
- Provide database support activities for all Oracle 19c database environments including periodic management such as performance tuning, backup/recovery, expansion, manage security
- Technical Support for other developers in the team
- Write, troubleshoot and improve SQL
- Provide System Administration and development support for Qlik Sense Enterprise
- Coordinate between with Unix System and Oracle Database Administrators for security patching and incident troubleshooting
- Manage the daily activities for a large statistical data warehouse, ensuring accuracy of data transfers, maintaining performance, coordinating with survey contractors, and providing Unix/Linux System Administration support
Requirements
- 8-10+ years of data architecture experience
- A Bachelors Degree in Computer Science or similar
- Candidates must possess a certification as an Oracle Database 11g Administrator Oracle Certified Professional
- Ability to pass a Government Background Check
- Experience leading a team of Data analysts, database administrators, and data quality analysts
- Database architectural design and construction for both new database and existing database environments
- Establish best practices for ETL processing in Oracle relational databases
- Develop and maintain documentation regarding data quality assurance and data loading processes
- Coordinate with survey contractors to provide efficient and accurate data transfers and loading of survey data from SAS and other sources
- Mentoring team members on industry best practices regarding data processing and relational database design
- Experience designing and building dimensional structures and star schemas
- Manage transformation activities for a large Oracle 19c-based data warehouse
- Provide database support activities for Oracle 19c (performance tuning, backup/recovery, expansion, manage security)
- Write, troubleshoot and improve SQL
- System Administration and development support for Qlik Sense Enterprise
- Knowledge of Qlik Sense Enterprise, Apache Webserver, JBoss 6 Application server, SAS metadata server 9.4, SAS OLAP server 9.4, SAS Web Infrastructure Platform 9.4 is a plus
- Coordinate with Unix System and Oracle Database Administrators for security patching and incident troubleshooting
Similar jobs on JobTailor
Data Scientist
EUROPEAN DYNAMICS
AngularETLHadoopMongoDBNoSQLOraclePerlPythonSQLTableau
Manager, IT Manufacturing Execution Systems
Vericel® Corporation
ETLOracleSQL
Snowflake Data Engineer
Medsuite Inc
ApacheAzureCloudETLKafkaMatillionPythonSparkSQL
Staff Data Architect
Transact Campus
ApacheAWSAzureCloudETLKafkaNoSQLPythonSparkSQL