Data Architect

3 days ago

⚔️ Virginia – Remote

Although this job is listed in Virginia, this company may be open to hiring remote in other states.

💵 $125k - $165k / year

⏰ Full Time

🟠 Senior

🔴 Lead

🚰 Data Engineer

Apply Now

Receive Emails with Similar Jobs

Lynker

WebsiteLinkedInAll Job Openings

Lynker is a premier science, engineering, and technology company that specializes in providing innovative solutions in weather and climate science, marine/ocean science and engineering, and space weather and space climate. The company partners with governments, communities, and industries to deliver impactful services that address global environmental security and economic prosperity. By leveraging a team of skilled scientists, engineers, and educators, Lynker tackles some of the nation’s most important missions and challenges, while also focusing on training, communications, and outreach for effective environmental policy and compliance.

Scientific and Technical Consulting Services • Water Resources • Geospatial Solutions • Program & Portfolio Management

501 - 1000 employees

Founded 2007

🔬 Science

📋 Description

• 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 database management such as performance tuning, backup/recovery, expansion, manage security, etc. • Technical Support for other developers in the team • Write, troubleshoot and improve SQL • Provide System Administration and development support for Qlik Sense Enterprise: - Knowledge of the following is a plus: • 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 • Coordinate between with Unix System and Oracle Database Administrators for security patching and incident troubleshooting • Responsible for managing the daily activities for a large statistical data warehouse, including (1) ensuring the accuracy of all data transfers into the data warehouse, (2) maintaining the performance of a large Oracle Data Warehouse including both database and application performance, (3) coordinating activities with survey contractors to provide efficient and accurate data transfers, and (4) provide System Administration activities for both Unix and Linux environments.

🎯 Requirements

• 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.

🏖️ 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