Database Engineer
Job Category: Information Technology
Time Type: Full time
Minimum Clearance Required to Start: None
Employee Type: Regular
Percentage of Travel Required: Up to 10%
Type of Travel: Continental US
What You’ll Get to Do
Work closely with cross-functional Agile SAFe teams to implement data requirements, resolve data-related technical issues, and support operational infrastructure needs
Develop data pipeline scripts and stream processing to implement data requirements in support of software releases using JavaScript, Python, MongoDB, PostgreSQL, Kafka, Elasticsearch, Spark/Pandas, and other data technologies
Perform data profiling and analysis using SQL and Mongo Query Language (MQL) to understand and accurately interpret and implement data requirements and performance tuning enhancements
Develop and maintain Elasticsearch index mappings and settings
Identify data anomalies, address data issues by applying data validation rules and remediation routines
Perform root cause analysis on data and processes to resolve technical issues and identify opportunities for improvements
More About the Role
You’ll Bring These Qualifications
Typically requires bachelor’s degree or equivalent and two to four years of related experience
Active security clearance/investigation required at NACLC level or above
Required experience in Oracle PL/SQL, PowerBuilder
MUST BE ABLE TO OBTAIN A SECRET CLEARANCE
Desired Skills/Experience:
Experience in Service Medical Logistics Business Processes and the Defense Medical Logistics Standard System application to include Materiel Management, Facility Management, Equipment Management, System Service and Financial Management
Experience in .Net, Java, and Business Objects
Experience in systems development best practices and methods
This position is in support of future opportunities. As we get closer to filling this position, we will be contacting qualified candidates. If you are selected to interview, you will be contacted directly by a recruiter.
These Qualifications Would Be Nice to Have
Experience extracting data from diverse databases and file structures (e.g., JSON, XML, CSV, TXT, MongoDB) to leverage in a different target system.
Experience forward and reverse engineering data architecture and associated tools (ERwin, ER/Studio) and databases (Oracle, MongoDB, ElasticSearch, Hadoop, PostgreSQL)
Full comprehension of SQL, cardinality, levels of granularity, normalization vs. de-normalization, and database and tool optimization techniques
Possess a professional understanding of data management best practices (e.g., Data Management Association (DAMA))
Must have a strong desire to drive toward data standardization (industry-driven, open standards, enterprise-wide) and employ data management best practices.
Experience managing metadata in a repository or supporting a data management program
Experience with data warehouse design and dimensional data modeling
Experience with data quality programs, data profiling and data cleansing techniques
Company Overview:
CACI is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other protected characteristic.
Pay Range : There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits. Learn more here (https://careers.caci.com/global/en/employee-benefits)
Since this position can be worked in more than one location, the range shown is the national average for the position.
The proposed salary range for this position is:
$68,400-$143,700