Title: | Junior Engineer |
---|---|
ID: | 1580 |
Praescient Analytics, LLC (Praescient) is a Veteran-led, certified Woman-Owned Small Business (WOSB) founded in 2011 that 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 intel/law enforcement 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.
This position is in support of the Department of Justice US Attorney’s Office, Eastern District of New York (EDNY). The organization requires a modern big data solution to support broad and high profile investigative priorities. As a Praescient employee supporting this effort, you will be on the front lines implementing EDNY’s premier investigative analysis platform.
Praescient Analytics is in search of a Junior-Level Data Analytics Engineer to provide back-end support for projects related to investigations and litigation cases. This includes managing the design, modeling, and implementation of a variety of databases and applications.
Primary Responsibilities:
- Provide input into the selection of the appropriate data architecture for analysis and manage the gathering of a wide variety of data types from primary and secondary sources through diverse channels using a combination of methods that will be populated into the appropriate analytical tools.
- Work with and senior and mid-level team members to perform systems and database maintenance are key components of the work to include designing/implementing ETL pipelines, preservation of source data, performance optimization, monitoring, and suggesting improvements.
- Assist with the analytics and Business Intelligence development and will focus on databases and systems needed in the analysis of mission critical data.
- Assist with the design, development, implementation, maintenance and optimization of a variety of databases and systems to include designing logical and physical database structures, partitioning of tables, data loading and validation, all aspects of security, monitoring, and performance tuning.
- Assist with database dictionaries, and monitoring standards and procedures. Providing technical guidance to management, the team, and the customer in regard to implementation of highly advanced technical solutions.
- Assist with all dimensions of analysis including data transformations, sourcing, mapping, conversion and loading data.
- Collaborate across teams to quickly adapt to emerging and dependent technologies.
- Continually interact with teams to design and implement innovative data solutions that will provide key decision-making abilities.
- Establish and maintain documentation for all design, development, and maintenance activities to include database entity relationship diagrams, ETL processes, source code version control, and automated maintenance processes.
- Assist with routine source code reviews of ETL processes for defects, performance tuning, or changes in source data format.
- Keep management well-informed on a timely basis of progress, status and/or concerns for all team’s assignments.
- Assist with the development and maintain standards for database implementation, maintenance, and optimization.
- Assist with the implementation, maintenance and testing of Disaster Recovery methodology for all production databases.
- Review performance and capacity planning reports and makes recommendations to management.
Required Qualifications:
- Bachelor’s degree
- Minimum of 3 years of applicable experience.
- Experience with being a part of and supporting a team of ETL/Database Administrators.
- Experience with the design, implementation, administration, and maintenance of a variety of highly complex databases (typically SQL Server, Teradata, DB2, Oracle, MySQL, or PostgreSQL) to include implementing security and access methods.
- Experience with ETL of large data sets using Python, Teradata, SSIS, or Talend to source, load, and verify data of various formats.
- Ability to work at OS level on Linux and Windows, writing scripts and configuring storage. Experience administrating databases in AWS cloud environments. Experience with automated tools for database design and implementation.
- Ability to embrace and lead technological change and development.
- Experience with developing procedures relating to database and application security including procedures by which access is authorized, enabled, changed and withdrawn. Experience with identifying and implementing enhancements to improve performance and reliability of existing database systems.
- Experience with the implementation, testing, and maintenance of Disaster Recovery for various databases.
- Experience with performing threshold forecasting, sizing, capacity planning, and trend analysis.
- Experience with performance monitoring and summary table creation.
Desired Qualifications:
- Experience with ETL and Database management in direct support of Tableau Server
- Experience with schema development, ETL, and database management in IBM I2 Enterprise Insight Analysis (EIA) Opal w/ I2 Connect
- Experience with litigation support, investigations, or administering Litigation Support tools
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 recruiting@praescientanalytics.com and please visit our website to apply online at www.praescientanalytics.applicantstack.com/x/opening