Database Engineer

Praescient Analytics, LLC is a Veteran-led, certified Woman-Owned Small Business (WOSB) founded in 2011 which specializes in implementing advanced analytics solutions across the defense, intelligence, and law enforcement communities. With over 40 contracts across 6 continents, over 70% of our employees are veterans and or have intelligence, law enforcement or counter fraud experience. We fully understand the unique challenges of our clients and work to identify, vet, implement, and enhance commercial and proprietary technologies to provide full scope solutions, because we have been there. Praescient has extensive experience designing, developing, and integrating solutions for customers including the US Army, Special Operations Command (SOCOM), US Navy (USN), US Marine Corps (USMC), US Coast Guard (USCG), Department of Justice (DOJ), Drug Enforcement Administration (DEA), and Federal Bureau of Investigation (FBI), Immigration and Customs Enforcement (ICE), intelligence community, and local law enforcement agencies, among others.

To support the mission of the Offices of Inspectors General (OIG), the Pandemic Response Accountability Committee (PRAC) has established the Pandemic Response Center of Excellence (PACE) for the purpose of conducting data analysis and visualization; sharing leading practices; providing tools and services; and providing investigative intelligence. The mission of the PRAC is to promote transparency and conduct and support oversight of covered funds and the Coronavirus response to (1) prevent and detect fraud, waste, abuse, and mismanagement (FWA&M); and (2) mitigate major risks that cut across program and agency boundaries. As part of this mission, the PRAC works with Federal Inspectors General (IGs) to develop recommendations on measures to prevent or address fraud, waste, abuse and mismanagement; provides support in conducting investigations, audits, and reviews relating to the covered funds and Coronavirus response; and refers matters for criminal investigations.

Praescient Analytics is in search of a Database Engineer with experience administering and monitoring databases to migrate CARES Act and related data sources identified by Small Business Administration (SBA) OIG to Azure Data Lake Storage (ADLS), develop sustainable ETL pipelines, normalize entity attributes, such as addresses, phones numbers, and other common fields, and creating cross-program lookup tables for investigative analysis.

Primary Responsibilities:

• Implement a logical and sustainable directory structure for ADLS storage blobs, utilizing naming conventions tiered to easily incorporate additional data sources
• Implement pipelines to transfer sever-based data sources into ADLS, or directly to Synapse where appropriate.
• Establish quality controls for any manual uploads of flat file extracts into ADLS
• Implement ETL/ELT process and architecture, creating lookup tables in Synapse for all common fields related to individuals, entities, and attributes, including IP address, email, address, phone number, and bank account.
• Lookup tables should assist analysts in querying across disparate datasets.
• Implement fraud flag tables by entity and individual, linking all identified fraud flags for easy access via SQL query.
• Normalize all shared attributes, such as address, in support of master lookup tables.
• Develop Synapse architecture, utilizing clustered columnstore indexes and optimized distributions to enhance performance.
• Implement aggregate views to quickly summarize by program award and disbursement totals, along with other key fields identified by SBA OIG and the vendor.
• Reconstruct existing Caseware IDEA macros to reproduce working tables used by Investigative Analysts within Azure Synapse. Currently, SBA OIG runs macros for PPP and COVID-19 EIDL datasets, resulting in joined tables with several derived and aggregate fields.
• Document all transformation processes and data architecture, including any derived or aggregate fields created to support the architectural design.
• Establish quality controls for maintaining all pipelines for automated or manual refresh, as appropriate.

Required Qualifications:

• Must have five (5) years of hands-on experience maintaining SQL databases, including expert level skills in SQL and T-SQL.
• Demonstrate at least five (5) years of hands-on experience working in cloud-based environments with distributed SQL pools.
• Must be able to demonstrate at least five (5) years of hands-on experience designing and implementing ETL/ELT processes in support cloudbased data analytics environments.
• Bachelor's degree in Computer Science, Software Engineering, Information Technology, or related field.

Desired Qualifications:

• Experience with data warehousing.
• Experience with cloud infrastructure providers, including Azure, AWS and others.

What you can expect from us:

• Real opportunity for career growth in an environment where your achievements will be celebrated
• Constant collaboration with numerous teams to ensure client success
• A team that respects and embraces your ideas and expertise
• Coworkers that are motivated by pursuing excellence, rather than the prospect of personal gain
• A workplace dedicated to supporting and bettering public safety and government agencies

Benefits:

• Very competitive salary based on qualifications and experience
• Comprehensive, Company paid United Health Care Medical for you and your family (We pay your premiums and deductibles)
• 401(k) & 4% matching
• Travel & performance incentives
• 3 weeks paid time off (plus Federal Holidays)
• $5K annual training allowance
• $500 book allowance
• Tuition reimbursement program

Praescient Analytics is committed to providing equal employment opportunities for all. Employees and applicants without regard to race, color, age, religion, sex, sexual orientation, marital status, gender identity, national origin, legally protected physical or mental disability, genetic information, citizenship status, or status in the uniformed services of the United States, status as a disabled veteran or veteran of the Vietnam era, or on any other basis which is protected under applicable law. This includes a commitment to provide a work environment that is free from all forms of illegal harassment including sexual harassment.

This covers all terms and conditions of employment including (but not limited to):

• Hiring, placement, promotion, transfer, or demotion of all job classifications;
• Recruiting, advertising or solicitation for employment;
• Treatment during employment;
• Rates of pay or other forms of compensation;
• Benefits;
• Selection for training;
• Company sponsored social and recreational activities; and
• Layoff or termination

Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information.
US Citizenship Required
Praescient Analytics is an Equal Opportunity Employer.
Interested Candidates: Please forward your resume to [email protected] and please visit our website to apply online at www.praescientanalytics.applicantstack.com/x/openings.