Data Integration Engineer (with IRS Clearance)

Based in the National Capital Region, Pivot Path Solutions, LLC is a government contracting and management consulting firm that offers enterprise IT solutions, strategic planning, organizational development, and business transformation services to help customers adapt and thrive in changing market conditions. Pivot Path Solutions is seeking a highly skilled and experienced Data Integration Engineer who knows data and how to process it regardless of type, size and complexity. This is a remote position, but candidates are preferred in the Washington D.C. metro area. Key Responsibilities: Specialization in integrating data from various sources such as Mongo DB, DataBricks, Informatica, Oracle etcBe a Big Data Subject Matter Expert for the team and the customer Analyze requirements and Big Data datasets, design data processing solutions around technologies such as Hadoop, Spark, Databricks, etc. and knowledgeable about the infrastructure requirements to support the effort Have broad understanding of the technology landscape for Big Data types (RDBMS, NOSQL, Graph, Document, etc.), analysis and stream processing, clusters, scalability, queries, and reporting Hands-on experience with database design, normalization, data lake, structured/semi-structured/unstructured datasets, and familiarity with HDFS, Kafka, ETL, RDMS, NOSQL, SQL, Data Engineering and data related tools, programming languages and technologies Work with business analysts to gather business requirements from end-users and translate them into technical specifications. Gather requirements to develop solutions, define data extraction, transformation logic, and data models, data flow, and process. Ability to analyze databases, schemas, triggers, stored procedures Verify implemented solution whether requirements have been met Provide end-user support in post-deployment phases; assess and evaluate all feedback to ensure that the requirements necessary to correct issues are addressed. Minimum 15 years of data processing experience Solid understanding of the software development process, including requirement gathering, analysis/design, development tools/technologies, release/version control, contemporary testing methodologies, and deployment management. Minimum Requirements: US citizen, must have an active IRS MBI Public Trust clearance. Minimum of 15 years of professional experience in data science, including planning, conducting, and participating in complex technology implementations or data analytics projects. Bachelor's Degree in Computer Science, Information Technology, or a related discipline is required. Good verbal and written communication skills. Proficiently read, write, and understand the English language What We Offer: Pivot Path Solutions strives to attract, motivate, and retain the best people in the industry. Our benefits package reflects our continued commitment to our employees by prioritizing the health and well-being of each member. These benefits include: Comprehensive benefits package, including health, dental, and vision insurance. Generous Contribution on Dental and Vision Insurances 100% Employer Paid Group Life Insurance, Short Term and Long-Term Disability Safe Harbor 401(K) Plan Health Saving Account (HSA) Healthcare Flexible Saving Account (FSA) and Dependent Care FSA Education Reimbursement Employee Referral Program U.S Citizenship is required for this specific opportunity and all selected applicants will be subject to a government security investigation. This includes but not limited to; meeting the eligibility requirements for access to classified information and the ability to obtain a government-granted security clearance. Individuals may also be subject to a background investigation including, but not limited to criminal history, employment verification, education verification, drug testing, and creditworthiness. Pivot Path Solutions, LLC is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, marital status, disability, veteran status, sexual orientation, or genetic information.