Junior Database Developer

Title: Junior Database Developer

Lead. Grow. Impact. Founded in 1994, LGI provides strategic and technical expertise to support the public safety and national security needs of federal, state, and local government agencies. From emergency communications services and technical assistance support, to mission-critical law enforcement management, LGI is at the forefront of public safety and national security innovations.

With a diverse team of professionals, who have served on the front lines of law enforcement, criminal justice, emergency management, the military and government, LGI offers its customers a broad array of talent and capabilities. Key areas of expertise include management of law enforcement and public safety programs, data analytics, development of advanced technologies, support of cross-border interoperability initiatives, and outreach to state and municipal agencies. LGI manages a comprehensive portfolio of local law enforcement and U.S. Government programs in the areas of cybersecurity, countering violent extremism, public safety broadband, counter-terrorism, crime control, corrections, national security and intelligence, counter-narcotics policy, and emergency communications.

United in our mission and values, LGI seeks to provide unparalleled service to our clients by supporting the evolving public safety and national security environment.

LGI’s core values are the fundamental beliefs that guide our actions, unite our employees, and define our brand. These guiding principles dictate the behavior that all LGI employees are expected to embody and uphold.

Job Summary: The Database Developer will function as part of the Enterprise Analytics team and is required to design stable, reliable, and effective database solutions. The role requires the person to understand the business requirements and translate them into database solutions used by the Enterprise Analytics team to create dashboards, perform advanced analytics, and answer ad hoc questions. In addition to being the team expert in database development, the role requires the ability to teach, coach, and mentor junior team members. The critical tasks for this role include, but are not limited to:

• Optimize and maintain legacy systems
• Modify databases according to customer requirements
• Solve database usage issues and malfunctions
• Liaise with other developers to improve applications and establish best practices
• Gather user requirements and translate to database design
• Assist in the development of rigorous software testing procedures
• Provide data management support to the team with such tasks as writing advanced SQL queries
• Research and suggest new database products, services, and protocols

Required Qualifications:

• At least 2 years of proven work experience as a Database developer
• Hands-on experience with SQL databases such as MS-SQL or Oracle SQL
• Excellent verbal and written communication skills with either consulting experience or the desire to consult with customers up to senior manager level
• In-depth understanding of ETL processes
• In-depth understanding of data management such as user permissions, recovery, security, and monitoring
• Knowledge of software development processes and tools
• An ability to understand front-end users’ requirements and translate to database development

Desired Qualifications:

• Familiarity with Agile frameworks and testing
• Excellent analytical and organization skills
• Experience with cloud-based data management tools such as Azure or AWS
• Familiarity working with .Net Framework, JavaScript, HTML and Oracle to develop web-based applications
• Experience with Microsoft PowerApps
• Familiarity with Informatica
• Familiarity with creating and deploying PowerShell scripts
• Experience with producing high-quality customer reports using MS Word and MS PowerPoint
• Familiarity with business intelligence software such as Tableau and Power BI
• Secret Clearance

Required Clearance:  None

This position involves working on federal contracts that require all workers on the contract to be U.S. Citizens. Additionally, some contracts may require the ability to obtain a security clearance.

Lafayette Group provides equal employment opportunities to all persons and prohibits employment decisions based on race, religion, color, creed, national origin, sex, age, disability, political affiliation, protected veteran status, or sexual orientation.

Equal Opportunity Employer, including disabled and veterans.