Artlin Consulting is seeking motivated individuals who are passionate about helping clients achieve excellence. Qualified candidates will have a creative, holistic, and systematic approach to problem-solving.

The Database Engineer will work with system architects, developers, API designers, and business analysts to support development of an enterprise reporting and analysis platform.

POSITION RESPONSIBILITIES:

• Serve as the lead for data/database related activities for development scrum team(s)
• Design and coordinate the database design for new areas of the data model with application developers and API designers, ensuring adherence to best database practices
• Use governed Department of Defense Acquisition data standards, rules and definitions while working with external systems to help develop extract, transform and load (ETL) logic for transfer of data
• Translate requirements documentation and meeting outcomes into language useful for developers in issue tracking software (Jira) and general design documents (in Confluence) to meet specific implementation needs
• Quickly and safely respond to emergency requests for changes to live data in a production environment by determining the types and extent of changes, writing SQL and PL/SQL as necessary to make the changes and coordinating with Ops and Development to run the SQL or PL/SQL scripts
• Develop and maintain the physical data model using tools like TOAD and ERWin
• Develop triggers, trigger functions, stored procedures, and other high-order Data Definition Language, as necessary
• Develop updateable views and highly structured query language, as necessary, to bridge gaps in database best practices, API design best practices and API implementation
• Design architecture; map business rules and processes into technical solutions
• Interface with stakeholders on the data supply side (domain experts on source systems of the data)
• Create highly reusable code modules and packages that can be leveraged across the data pipeline
• Elicit data consumption requirements from a wide range of different teams
• Provide direction to project teams, develop work plans/schedules, conduct weekly status meetings, track issues/progress and report concerns to Program Manager
• Initiate conversations, as necessary, between relevant stakeholders to resolve issues with identified gaps prior to implementation

EXPERIENCE LEVEL:

• 2+ years in Data Engineering, specifically in at least two of the following: Postgres, SQL Server, Oracle, MySQL, SQLLite. Mongo DB development a plus
• Bachelor's degree in related technical/business field
• Experience working on-site with Federal Government Clients
• Experience in System Development Life Cycle/ IT delivery projects; Agile methodology a plus Strong problem solving and troubleshooting skills with experience exercising mature judgment
• Strong computer science and software engineering fundamentals
• Ability to communicate effectively with stakeholders and subject matter experts

TOOLS AND PROFICIENCY LEVEL:

• Experience in one or more of the following highly desired: Java, Hibernate, Spring Framework
• Proficiency in Linux, highly desired
• Experience with Atlassian (Jira, Confluence, Bitbucket) a plus
• Strong proficiency in Microsoft Excel, Access
• Strong Extract, Transform, and Load (ETL) experience
• Familiarity with SharePoint or similar knowledge/collaboration management tools a plus
• Familiarity working with relational, or NoSQL, or columnar data stores
• Familiarity with RESTFul APIs
• Familiarity with Flyway and Git

CERTIFICATIONS:

• Active Secret Clearance Required