Senior Data Architect

Overview

Lynker Corporation is a leading provider of innovative solutions in weather and climate science. With a commitment to excellence and a passion for innovation, Lynker leverages cutting‑edge technologies and scientific expertise to support the creation and delivery of improved operational weather forecasts. As part of our ongoing growth and expansion, we are seeking a dynamic and experienced Senior Data Architect to join our growing team.

We’re looking for a senior, hands‑on Data Architect who is deeply involved in the technical execution of the program. This role helps keep a large statistical data warehouse running smoothly day‑to‑day. That includes making sure data transfers come in accurately, keeping the Oracle data warehouse performing well, coordinating with survey contractors to keep data flowing efficiently, and handling some system admin work in Unix and Linux environments.

This Data Architect will be responsible for the following:

• 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
• 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 through standardization/automation of ETL processing
• Maintain knowledge of industry 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 based data warehouse
• Provide database support activities for all Oracle database environments, including: periodic database management such as performance tuning, backup/recovery, expansion, security management, etc.
• Provide 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 Unix system and Oracle database administrators for security patching and incident troubleshooting

Candidate must be able to pass a government background check.

• 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
• Oracle Database 11g Administrator (OCP) certification

Data Architect

Qualifications:

• 8‑10+ years of data architecture experience
• A Bachelor’s Degree in Computer Science or similar

The Ideal Data Architect will also have the following:

• Oracle Certifications
• Exposure to development processes, SDLC or Agile, is a plus

Lynker is a growing, employee‑owned, small business, specializing in professional, scientific and technical services. Our continually expanding team combines scientific expertise with mature, results‑driven processes and tools to achieve technically sound, cost‑effective solutions in hydrology/water sciences, geospatial analysis, information technology, resource management, conservation, and business process improvement.

We focus on putting the right people in the right place to be effective. And having the right people is critical for success. Our streamlined organization enables and empowers our talented professionals to tackle our customers' scientific and technical priorities – creatively and effectively.

Lynker offers a team‑oriented work environment and the opportunity to work in a culture of exceptionally skilled professionals who embrace sound science and creative solutions. Benefits include:

• Comprehensive healthcare for the employee at no monthly cost
• Coverage of medical, prescription drug, dental, and vision benefits
• Personal Time Off…