Mid-Level Database Developer (Usmc)

Logistics Management Institute Washington , DC 20319

Posted 3 months ago

Overview

LMI is a mission-oriented consulting firm dedicated to improving the management of government. LMI provides leaders with the objective analysis, tools, and program support needed to deliver value. As a not-for-profit, LMI develops practical solutions with the potential for broad impact in the public sector. With more than 55 years of experience, LMI serves more than 40 U.S. agencies, as well as government organizations around the world in the defense, healthcare, and national security markets. LMI developers use the latest technologies, databases, and components in a fast paced agile team environment to provide creative and cost effective solutions to our clients.

Responsibilities

Position is for a Database Developer with strong SQL skills on the software development staff of a private, non-profit government consulting firm. We are looking for great developers who have a passion to code and a desire to learn new technologies working on high-profile projects. This position is full-time, benefits eligible, and based at LMI Tysons, VA location.

PRINCIPAL DUTIES AND RESPONSIBILITIES (Essential Job Functions)

Perform activities in support of database development to design, build and support relational and non-relational database systems in a high volume, high availability environment.

  • Design, construct, and implement database architectures for optimal data acquisition, maintenance, and extraction of information according to application requirements and specifications.

  • Develop logical and physical data models that are used in the creation of databases and design secure access and usage of database tables, view and storage procedures.

  • Create query statements, functions and procedures to support software application development, reporting and data extraction as well as define and implement standards and best practices ensuring data accuracy, security and consistency in accordance with DoD Information Assurance policies and procedures across multiple systems.

  • Support data warehouse architectural decisions and development standards.

  • Conduct activities with On-Line Transaction Processing (OLTP) and On-Line Analytical Processing (OLAP) design, implementation, troubleshooting and performance tuning.

  • Utilize BI / Reporting tools like Cognos or Business Objects.

Perform software development activities including requirements gathering and analysis, systems design, development, documentation, testing and integration.

  • Support all phases of life-cycle software implementation and application development.

  • Actively participate in agile/scrum software development activities.

  • Build and maintain relationships with internal and external customers.

Qualifications

  • Minimum Bachelor's degree in computer science, engineering, or a related field.

  • 5+ years of professional experience with an emphasis on full life-cycle systems development including database design, development, and maintenance/support.

  • Expertise in one or more structured database management system types/vendors to include ORACLE, IBM, My Structured Query Language (MySQL), PostgreSQL, and SQLite.

  • Knowledge and expertise in business intelligence platforms such as Cognos and ORACLE BI.

  • Strong demonstrated experience working with relational databases (i.e. Microsoft SQL Server) and developing database-driven applications. Including: ability to write, troubleshoot, and optimize complex queries and stored procedures.

  • Programming expertise in one or more scripting languages such as AnyLogic, VBA, JavaScript, R, or Python.

  • Expertise in one or more unstructured data management systems such as MarkLogic, SAS, Teradata, Splunk, HortonWorks Platform, and IBM InfoSphere.

  • Strong communication skills and the ability to work well with a team of software developers.

PREFERRED EXPERIENCE/SKILLS:

  • Hands-on experience using agile software development methodologies and practices such as Test Driven Development (TDD).

  • Experience using Object Role Models (ORM) such as the Entity Framework / LINQ to SQL.

  • Familiarity with Distributed Source Control tools such as Git.

  • Familiar with Design Patterns (implementation and explanation).

  • Experience with Microsoft SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) and third party OLAP and data analysis tools.

  • Familiar with task and ticketing tools such as Atlassian JIRA or Bugzilla.

  • Experience working in a consultant/client environment.

Clearance

  • Secret clearance required.
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Rec 5705 Looking For A Jr To Mid Level Data Analytics Consultant Full Time In Washington DC 20006 US Citizens And G

Seneca Resources

Posted Yesterday

VIEW JOBS 12/11/2018 12:00:00 AM 2019-03-11T00:00 <strong>THIS IS A FULL TIME OPPORTUNITY WITH GUIDEHOUSE / PWC<br /> <br /> US Citizens and GC Only !!!  NO CTC !!!!! </strong><br /> <br /> This a Michael Perozzi a Technical Recruiter at Seneca Resources. Any interest in this opportunity below.<br /> Seneca Resources is client driven provider of strategic Information Technology consulting services and Workforce Solutions to government and industry.  Seneca Resources is a leading IT services provider with offices in Virginia, Alabama, Texas, and Florida that service clients throughout the United States.  The key to our success lies within our strong corporate culture which drives our business.  We challenge our staff through engaging work, and we reward our staff through competitive compensation, extensive professional training, and excellent opportunities for career advancement.  In turn, we look for only the best and brightest to join our team.<br /> <strong>Rec# 5705</strong><br /> <strong>Position Title: </strong><strong>Jr to Mid-Level  “ Data Analytics “ </strong><br /> <strong>Location: </strong><strong>1730 Pennsylvania Ave AW Washington, District Of Columbia 20006</strong><br /> <strong>Work Status: Full Time  </strong><br /> <strong>Compensation: Open – Depends on Experience</strong><br /> <strong>Minimum Degree Required: Bachelor's degree in Computer Science or any MIS related field</strong><br />  <br /> <strong>POSITION DESCRIPTION:</strong><br /> While the job description below doesn’t say so, please look for candidate’s w/R, <strong>Tableau & Python</strong>.  We are looking for both Experienced Associates (1-3 yrs expr) & Sr. Associates. (3-6 yrs).  Let me know if you have any questions.  <ul> <li style="padding: 0; margin: 0;">Guidehouse provides management, technology, and risk consulting to clients around the world through more than 1,600 professionals in over 20 locations.  At our core, we focus on building trust in society, solving important problems, and having a seat at the table for our clients’ most pressing matters. Formerly PricewaterhouseCoopers US Public Sector, Guidehouse provides the exceptional quality our clients demand with the agility and innovation to go beyond the expected.</li> <li style="padding: 0; margin: 0;">Guidehouse is one of four organizations to receive the 2014 Malcolm Baldrige National Quality Award. The Baldrige Award is the nation’s highest Presidential honor for performance excellence, recognizing U.S. organizations for superior quality and world-class results across six categories defined by Baldrige including Leadership, Strategic Planning, Customer Focus, Measurement, Analysis and Knowledge Management, Workforce Focus, and Operations Focus. For more information on our journey to performance excellence, view our winner profile on the NIST website.</li> <li style="padding: 0; margin: 0;">Professionals at Guidehouse may be subject to a government security investigation and may need to meet related eligibility requirements for access to classified information</li> </ul> .Our Data and Analytics consultants help clients maximize the value of their data.  This high performing team helps clients define their  information strategy, architecture and governance, get the most value from business intelligence and analytics, and implement enterprise content and data management solutions to enable business insights, reduce cost and complexity, increase trust and integrity, and improve operational effectiveness.<br />  <strong>Knowledge Preferred:</strong> <ul> <li style="padding: 0; margin: 0;">Demonstrates thorough knowledge of contributing on client engagement teams that design and develop business intelligence (BI) and predictive models for data warehouse (DW) information management architecture, including:</li> <li style="padding: 0; margin: 0;">Evaluating enterprise DW architecture feasibility, risk and technologies related to business change (i.e. assessing, identifying and recommending BI and related business stakeholders' data requirements; BI solution prototyping and development; processes and performance from business and technical standpoints; and the impact of data changes on business and/or IT processes);</li> <li style="padding: 0; margin: 0;">Advising CXO's on emerging BI/DW technologies and strategies consistent with clients' business strategies;</li> <li style="padding: 0; margin: 0;">Prioritizing, preparing and implementing BI and/or DW architectural improvements (i.e. developing and recommending alternative DW technical and data management solutions, methodologies, strategies and architectural improvement plans);</li> <li style="padding: 0; margin: 0;">Developing and validating business stakeholders' conceptual data models, including socializing and implementing logical and physical DW/data mart data models; identifying data sources and metadata (including business rules, definitions, attributes, etc.) to deliver analytic requirements.</li> </ul> <strong> Skills Preferred:</strong> <ul> <li style="padding: 0; margin: 0;">Demonstrates thorough abilities to interact with end users to understand and document business and functional requirements for complex projects, including full software development life cycle, DW/BI/ETL tools and other related technologies, including:</li> <li style="padding: 0; margin: 0;">Enterprise data management, data warehousing and/or business intelligence; data modeling, integration and/or synchronization, quality, security, conversion and analysis; database administration; and/or enterprise data management policies, procedures, compliance & risk management. This includes a minimum of having participated in two full life cycle implementations</li> <li style="padding: 0; margin: 0;">Architecture, design and development of enterprise business intelligence and data warehousing solutions, including utilizing leading ETL/BI tools and the ability to architect a solution</li> <li style="padding: 0; margin: 0;">Design and development of data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching that leverages knowledge within data, master data, metadata and technology management.</li> <li style="padding: 0; margin: 0;">Demonstrates proven thorough skills and success participating in consulting-related projects within a professional services environment that utilize creative thinking skills and individual initiative, including the following:</li> <li style="padding: 0; margin: 0;">Collaborating and contributing as a team member: understanding personal and team roles; contributing to a positive working environment by building solid relationships with team members; proactively seeking guidance, clarification and feedback</li> <li style="padding: 0; margin: 0;">Identifying and addressing client needs: building solid relationships with clients; developing an awareness of Firm services; approaching client in an organized manner; delivering clear requests for information; demonstrating flexibility in prioritizing and completing tasks; communicating potential conflicts to a supervisor</li> <li style="padding: 0; margin: 0;">Prioritizing and handling multiple tasks; researching and analyzing pertinent client, industry, and technical matters; utilizing problem-solving skills; and, communicating effectively in written and verbal formats to various audiences (including various levels of management and external clients) in a professional business environment</li> <li style="padding: 0; margin: 0;">Coaching and collaborating with associates who assist with this work, including providing coaching, feedback and guidance on work performance.</li> <li style="padding: 0; margin: 0;">The information transmitted, including any attachments, is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited, and all liability arising therefrom is disclaimed. If you received this in error, please contact the sender and delete the material from any computer. Guidehouse LLP is a Delaware limited liability partnership.</li> <li style="padding: 0; margin: 0;">The information transmitted, including any attachments, is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited, and all liability arising therefrom is disclaimed. If you received this in error, please contact the sender and delete the material from any computer. Guidehouse LLP is a Delaware limited liability partnership.</li> </ul>  <br /> <strong>Michael Perozzi</strong><br /> Senior Recruiter<br /> 5151 Headquarters Dr. | Suite 105<br /> Plano | Texas | 75024<br /> Direct: 469.629.6055<br /> Cell: 214.753.9254<br /> <strong>SENECA</strong> <strong>| </strong><strong>RESOURCES</strong><br /> <a href="http://www.senecahq.com/" target="_blank" title="http://www.senecahq.com/ Ctrl+Click or tap to follow the link">www.senecahq.com</a><br /> <a href="mailto:mperozzi@senecahq.com">mperozzi@senecahq.com</a><br />  <br />  <br />   Seneca Resources Washington DC

Mid-Level Database Developer (Usmc)

Logistics Management Institute