Lynker

Senior Data Architect

Lynker

full-time

Posted on:

Location Type: Remote

Location: Remote • Virginia • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

💰 $130,000 - $180,000 per year

Job Level

Senior

Tech Stack

ApacheETLOracleSDLC

About the role

  • Designing and building relational databases for data storage or processing
  • Developing strategies for warehouse implementation, data acquisition and access, and data archiving and recovery
  • Working closely with a team of Data analysts, database administrators, and data quality analysts
  • 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 thru standardization/automation of ETL processing
  • Maintain knowledge 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
  • Manage all transformation activities for a large Oracle based data warehouse
  • Provide database support activities for all Oracle database environments including periodic database management such as performance tuning, backup/recovery, expansion, manage security, etc.

Requirements

  • 8-10+ years of data architecture experience
  • A Bachelors Degree in Computer Science or similar
  • Oracle Certifications
  • Exposure to development processes, SDLC or Agile, is a plus
  • Candidate must be able to pass a government background check
  • Knowledge of the following is not necessary but is a plus:
  • o Qlik Sense Enterprise
  • o Apache Webserver
  • o JBoss 6 Application server
  • o SAS metadata server 9.4
  • o SAS OLAP server 9.4
  • o SAS Web Infrastructure Platform 9.4
  • o Oracle Database 11g Administrator (OCP) certification
Benefits
  • Comprehensive healthcare for the employee at no monthly cost
  • Healthcare benefit covers medical, prescription drug, dental, and vision
  • Personal Time Off (PTO) Policy plus paid holidays
  • Highly competitive compensation plan regularly calibrated against industry and location benchmarks
  • 401(k) retirement plan with company-matching
  • Employee Stock Ownership Plan (ESOP) – we’re all company owners!
  • Flexible spending accounts
  • Employee assistance program (EAP)
  • Short- and long-term disability insurance
  • Life and accident insurance
  • Tuition assistance/Training/Workforce improvement reimbursement per year
  • Spot bonuses for exceptional performance
  • Annual Employee Recognition Awards with bonuses
  • Employee Referral Program
  • Free centralized, self-directed Learning Management System to learn at your own pace
  • Personalized career growth plans for every employee

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
relational databasesETL processingdata warehousingdata acquisitiondata archivingdata recoverydata quality assuranceperformance tuningdata management life cycledata transformation
Soft skills
team collaborationdocumentationbest practices establishmentcoordinationstandardizationautomation
Certifications
Oracle CertificationsOracle Database 11g Administrator (OCP)