Data Management Specialist - Data Engineer

Posted Yesterday
Be an Early Applicant
Hiring Remotely in USA
Remote
Senior level
Financial Services
The Role
Designs and maintains scalable data pipelines, ETL/ELT processes, data models, and data integration solutions for Department of Defense systems. Ensures data quality, governance, security, metadata management, cataloging, and discoverability across structured and unstructured sources. Uses Python, SQL, Databricks, Spark, Erwin, and Collibra to normalize, reconcile, and optimize data. Collaborates with analysts, data scientists, stakeholders, and Advana business lines to deliver reliable data products.
Summary Generated by Built In

Great Hill Solutions, LLC is part of the Seneca Nation Group (SNG) portfolio of companies. SNG is Seneca Holdings' federal government contracting business that meets mission-critical needs of federal civilian, defense, and intelligence community customers. Our portfolio comprises multiple subsidiaries that participate in the Small Business Administration 8(a) program. To learn more about SNG, visit the website and follow us on LinkedIn.

Our team of talented individuals is what makes us successful. To support our team, we provide a balanced mix of benefits and programs. Your total rewards package includes competitive pay, benefits, and perks, flexible work-life balance, professional development opportunities, and performance and recognition programs. We offer a comprehensive benefits package that includes medical, dental, vision, life, and disability, voluntary benefit programs (critical illness, hospital, and accident), health savings and flexible spending accounts, and retirement 401K plan. One of our fundamental principles is to offer competitive health and welfare benefits to our team members, providing coverage and care for you and your family. Full-time employees working at least 30 hours a week on a regular basis are eligible to participate in our benefits and paid leave programs. We pride ourselves on our collaborative work environment and culture, which embraces our mission of providing financial and non-financial benefits back to the members of the Seneca Nation.


Great Hill Solutions is seeking a Data Management (DM) Specialist / Data Engineer in the National Capital Region to support our Department of Defense client.  The candidate will support the Defense Security Cooperation Agency (DSCA) Chief Data and Artificial Intelligence Officer (CDAO) with data analytics, data integration and pipeline ingest, data management, and catalog and metadata management.  The candidate will:

  • Design, build, and maintain scalable data pipelines and ETL/ELT processes to support analytics and business intelligence based on the DSCA OLTP systems.
  • Develop and optimize data models for both operational and analytical systems.
  • Implement best practices for data ingestion, transformation, storage, and retrieval across environments.
  • Collaborate with data scientists, analysts, and business stakeholders to define data requirements and deliver reliable solutions.
  • Ensure data quality, consistency, and governance through monitoring, testing, and validation frameworks.
  • Write and maintain efficient SQL queries, stored procedures, and scripts for data processing.
  • Work with structured and unstructured data from multiple sources (databases, APIs, streaming platforms, third-party feeds).
  • Optimize performance and scalability of large datasets using distributed computing frameworks (e.g., Spark,).
  • Apply security, compliance, and privacy standards to data solutions.
  • Ensure that Data is curated based on requirements and designed with reusability in mind.
  • Normalize data elements across systems. Build data index, apply deduplication logic to align data, investigate data mismatches, identify data quality gaps, and reconcile metadata for a unified view of business data.
  • Troubleshoot data-related issues, ensuring minimal downtime and reliable delivery of data products.
  • Provide Data Quality (DQ) measures and improvements in accordance with defined criteria for silver and gold data zones.
  • Ensure data is easily discoverable, well-managed, and integrated with metadata and business rules using tools like Collibra.
  • Coordinate work across various Advana lines of businesses (Acquisition, Procurement, Supply Chain, and Finance) to continually improve the ability to link mission critical data with other domain data.
  • Data sources are to be auto cataloged and integrated with data dictionaries metadata that provide understanding through exposure of data descriptions and business rules that facilitate data integration.

Minimum Qualifications

  • Must have active SECRET clearance (an Interim Secret is acceptable).
  • Bachelor of Science or Arts from an accredited university or college, scientific or technical discipline preferred.
  • Must have a minimum of 5 years of experience supporting Federal clients with implementing data management practices.
  • Ability to develop collaborative, cooperative and constructive working relationships, resolve conflicts and negotiate with others, with strong cultural awareness.
  • Strong organizational skills, results oriented, willingness to prioritize workload and drive operations to completion.
  • Must have competent writing skills, and the ability to work independently in Microsoft 365.
  • Experience with Python programming language.
  • Experience with enterprise data tools like Databricks, Databricks SQL Editor, Erwin data modeler, etc.  
  • Up to date knowledge of Collibra Data Governance Center functionalities.
  • Understanding of Procurement Lifecycle (e.g., DoD's Procure to Pay end-to-end process) will be beneficial.

Equal Opportunity Statement:
Seneca Holdings provides equal employment opportunities to all employees and applicants without regard to race, color, religion, sex/gender, sexual orientation, national origin, age, disability, marital status, genetic information and/or predisposing genetic characteristics, victim of domestic violence status, veteran status, or other protected class status. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leave of absence, compensation and training. The Company also prohibits retaliation against any employee who exercises his or her rights under applicable anti-discrimination laws. Notwithstanding the foregoing, the Company does give hiring preference to Seneca or Native individuals. Veterans with expertise in these areas are highly encouraged to apply.
 


Skills Required

  • Active Secret security clearance; Interim Secret is acceptable
  • Bachelor's degree from an accredited university or college
  • Bachelor's degree in a scientific or technical discipline
  • At least 5 years of experience supporting Federal clients with data management practices
  • Ability to build collaborative and constructive working relationships, resolve conflicts, and negotiate effectively
  • Strong organizational skills and ability to prioritize workload and complete operations
  • Competent writing skills
  • Ability to work independently in Microsoft 365
  • Experience with Python
  • Experience with enterprise data tools such as Databricks, Databricks SQL Editor, and Erwin Data Modeler
  • Current knowledge of Collibra Data Governance Center functionality
  • Understanding of the Department of Defense Procure to Pay lifecycle
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Salamanca, New York
196 Employees

What We Do

Seneca Holdings is the investment holding company of the Seneca Nation of Indians. Through its subsidiaries, Seneca Holdings'​ mission is to provide financial diversification and economic success to the Seneca Nation and its partners. We are a team of experienced business and investment professionals committed to realizing a sustainable economic future for the Seneca Nation and its citizens.

Similar Jobs

Motive Logo Motive

Director, FP&A

Artificial Intelligence • Fintech • Hardware • Information Technology • Sales • Software • Transportation
Easy Apply
Remote
United States
4000 Employees
175K-241K Annually

New York Life Logo New York Life

Consultant

Artificial Intelligence • Cloud • Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
In-Office or Remote
New York, NY, USA
12000 Employees
90K-110K Annually

Samsara Logo Samsara

Senior Program Manager

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
4 Locations
4000 Employees
102K-154K Annually

Samsara Logo Samsara

Staff Marketing Communications Manager

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
7 Locations
4000 Employees
95K-161K Annually

Similar Companies Hiring

Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees
Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
85 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account