Data Architect
Alexandria, VA, United States
Overview
Lynker is seeking a talented Data Architect to join our team in support of a long term government contract. 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.
Responsibilities
The Data Architect selected will be responsible for the following:
- 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 relational databases, Oracle DB
- 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 OLAP cubes.
- Manage all transformation activities for a large Oracle 11g-based data warehouse
- Provide database support activities for all Oracle 11g database environments including
o Periodic database management such as performance tuning, backup/recovery, expansion, manage security, etc.
o Technical Support for other developers in the team
o Write, troubleshoot and improve PL/SQL
o Tune PL/SQL and stored procedures and packages for performance
- Provide System Administration support for the following middleware technologies:
o Apache Webserver 2.2
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 Pentaho
- Coordinate between with Unix System and Oracle Database Administrators for security patching and incident troubleshooting
Responsible for managing the daily activities for a multi-terabyte 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. Candidates for this position must possess a certification as an Oracle Database 11g Administrator Oracle Certified Professional and be able to pass a Government Background Check.
Qualifications
The Data Architect selected should have the following qualifications:
- 10+ years of data architecture experience.
- A Bachelors Degree in Computer Science or similar.
The Ideal Data Architect will have the following:
- Oracle Certifications.
- Exposure to development processes, SDLC or Agile, is a plus.
About Lynker
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 management 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. Lynker's benefits include the following:
- 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
Lynker is an E-Verify employer.
Lynker is an equal opportunity employer and makes all employment decisions based on merit, qualifications, and business needs. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, marital status, veteran status, or any other legally protected status under federal, state, or local laws.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Architecture Computer Science Data management Data quality Data warehouse ETL Linux OLAP Oracle Pentaho RDBMS SAS SDLC Security SQL Survey data
Perks/benefits: Career development Competitive pay Equity / stock options Flex vacation Health care Insurance Salary bonus Team events
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.