DATABASE MANAGER III/SR - AHTNA ENGINEERING

Company: Ahtna Engineering Services, LLC
Location: Anchorage
Posted on: November 11, 2024

Job Description:

Description Summary: The Database Manager will establish a database solution for managing environmental data derived from various remediation projects and investigations. The Database Manager will lead the organizing, storing, querying, and reporting of data to support multiple environmental projects. This position requires hands-on experience across a range of applications and platforms involving data transformation, manipulation, validation, warehousing, analysis, and visualization. The Database Manager will be organized, self-motivated, detail-oriented, and interested in a career involving analytical data management, database programming, or data science. This position requires the ability and desire to collaborate with others, develop new skills, and stay updated on current and new technologies. Must be comfortable working with colleagues representing many different disciplines and experience levels. The salary range for this position is $107,711/year - $157,042/year, please note this is a tiered position. This position may qualify for a Telecommute option. Essential Duties and Responsibilities (including, but not limited to): All Levels

• Designing, building, implementing, and maintaining various types of relational databases, including metadata development and documentation.
• Working with data from different sources, often provided in different formats (i.e. XML, CSV, ASCII, txt, accdb, etc).
• Developing client-specific databases, including ERPIMS, FUDSChem, and various state agency databases.
• Querying, coding, and exporting to facilitate department functions, such as data analysis and reporting.
• Analyzing and determining information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities.
• Ensuring, via QA/QC and peer review processes, that the quality data standards of project deliverables are met.
• Willingness to learn new applications and successfully employ them into the workflow of the data management process.
• Staying up to date on hardware/software upgrades, identifying and troubleshooting problems, and effectively communicating ideas for the improvement of database quality control.
• Securing the database by developing policies, procedures, and controls, including data entry, QA/QC, and reporting; working with outside entities.
• Supporting staff's production of reports, queries, exports, and coding to facilitate department functions.
• Providing a positive working environment and building solid relationships with clients and team members.
• Perform and manage multiple tasks within scope/budget/schedule expectations.
• Must be able to work a minimum of a 40-hour workweek, plus additional as required to complete assignments on time.
• Other duties as assigned by management.
  Level-Specific Responsibilities (may include but not limited to): Level - III
  • Provide client assistance to program and project managers; adhere to scope, schedule, and budget on projects
  • Maintain 2 areas of technical expertise
  • Ability to write code in SQL, VBA, Python, or other appropriate languages to map data from one database platform to another accurately and efficiently.
  • Lead teams performing project tasks.
  • Lead technical project execution and document preparation, peer review project documents
  • Assist with task order and project proposals
  • Project staffing/coordination and technical mentoring
    Level - Senior
    • Provide client assistance to program and project managers; adhere to scope, schedule, and budget on projects
    • Maintain 2 or more areas of technical expertise.
    • Ability to write code in SQL, VBA, Python, or other appropriate languages to map data from one database platform to another accurately and efficiently.
    • Lead technical project execution and maintain quality control requirements for the program.
    • Aid Project and Program Managers in the preparation of proposals
    • Project staffing and technical mentoring
    • Manage projects involving site characterization, long-term monitoring, and similar tasks
    • Ability to manage multiple individuals across several AORs
      
      
      Minimum Qualifications: All levels:
      • Bachelor's degree in a quantitative subject (engineering, science, computer science, statistics, math, or equivalent).
        • Experience may be substituted for education on a 1:1 basis.
          
          
        • Experience with database structures, design, maintenance, and integrity.
        • Strong working knowledge of quantitative research methods, emphasizing the importance of maintaining functional, consistent, and integral data.
        • Strong set of skills in computer programs, including Microsoft Office suite (particularly Excel and Access).
        • Working knowledge of ArcGIS and geological visualization tools such as EVS, Leapfrog, and gINT.
        • Strong analytical skills in reviewing and assessing data.
        • Ability to pass background checks by various Federal Agencies (e.g., DOD, DHS, FAA, etc.) to obtain security access badges.
          Level - III
          • Seven (7) to ten (10) or more years of work experience in environmental data management with strong analytical/database skills or a clear aptitude for data science, specialized training, and/or an advanced degree such as MS may be substituted for work experience.
          • Ability to write code in SQL, Python, or other appropriate languages to map data from one database platform to another accurately and efficiently.
          • Ability to mentor and/or start managing staff.
            Level - Senior
            • Ten (10) or more years of previous work experience in environmental data management with strong analytical/database skills or a clear aptitude for data science, specialized training, and/or an advanced degree such as MS may be substituted for work experience.
            • Ability to write code in SQL, Python, or other appropriate languages to map data from one database platform to another accurately and efficiently.
            • Supervision experience for personnel and data management teams or programs.
              Preferred Qualifications:
              • Experience with one or more relational database systems: Microsoft SQL Server, Microsoft Access, MySQL, Oracle, and EarthSoft's EQuIS.
              • Familiarity with AutoCAD ERPIMS and/or FUDSChem.
              • A background in chemistry or experience with laboratory analytical databases (LIMS), electronic data deliverables (EDDs), detection limits, lab qualifiers, etc.
              • Experience working with geospatial data, often implemented through GIS platforms such as ArcGIS or Trimble Business Center.
              • Ability to implement Python onto ArcGIS.
              • Understanding of powerful data analysis tools involving, but not limited to, scripting and extension languages such as SQL, R, Python, VBA, Perl, or MATLAB.
              • Interest and/or experience in GPS data and technology.
              • Experience and knowledge of Alaska Native cultures.
                Shareholder Preference: Pursuant to PL 93-638, as amended, preference will be given to qualified Ahtna Native Corporation Shareholders, Descendants, and Spouses in all phases of employment. Core Competencies:
                • Self-motivated - Ability to be internally inspired to perform a task to the best of one's ability using his or her own drive or initiative.
                • Communication, Oral - Ability to communicate effectively with others using the spoken word.
                • Time Management - Ability to utilize the available time to organize and complete work within given deadlines.
                • Goal Oriented - Ability to focus on a goal and obtain a pre-determined result.
                • Accuracy - Ability to perform work accurately and thoroughly
                  Working Environment:
                  • Must be able to sit for extended periods of time while talking on the telephone, using computers for typing and entering data for up to 3 - 4 hours at a time.
                    Physical Demands (including but not limited to):
                    • Must be able to lift boxes weighing up to 20 pounds - maintaining files and documentation requires stooping as well as carrying and/or lifting materials.
                    • Work requires computer usage with strength, dexterity, coordination, and visual acuity to use a keyboard and video display terminal and other office equipment.
                      Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Work Schedule: Monday-Friday 8:00 a.m.-5:00 p.m. or as needs dictate Qualifications
                      Education Bachelors of Engineering (preferred)
                      Experience 7 years: *Bachelor's degree in a quantitative subject (engineering, science, computer science, statistics, math, or equivalent).
                      oExperience may be substituted for education on a 1:1 basis.
                      *Experience with database structures, design, maintenance, and integrity.
                      *Strong working knowledge of quantitative research methods, emphasizing the importance of maintaining functional, consistent, and integral data.
                      Level - III
                      *Seven (7) to ten (10) or more years
                      Level - Senior
                      *Ten (10) or more years
                      (required)
                      Skills
                    • MS Office (required)
                      
                      Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
                      
                      The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

Keywords: Ahtna Engineering Services, LLC, Anchorage , DATABASE MANAGER III/SR - AHTNA ENGINEERING, IT / Software / Systems , Anchorage, Alaska