• Design enterprise data models using dimensional modeling, Data Vault 2.0, or similar methodologies • Architect and maintain data warehouses, data lakes, and lakehouse environments • Define and enforce data standards, naming conventions, and schema governance across domains • Implement data governance frameworks including cataloging, lineage tracking, and metadata management • Build automated data quality checks, validation rules, and anomaly detection into pipelines • Ensure compliance with data privacy regulations through access controls and data classification • Build and maintain batch and streaming data pipelines with full observability and alerting • Implement change data capture patterns, real-time ingestion, and ELT/ETL frameworks • Administer and scale cloud data platforms; optimize storage, compute, and cost efficiency • Partner with analytics engineers, data scientists, and BI teams to deliver trusted data products • Define data contracts between producers and consumers; mentor junior engineers

• Design and execute data import strategies into Drupal, based on datasets extracted from SharePoint environments. • Develop and maintain ETL processes and migration scripts to transform and load structured and unstructured data into Drupal. • Translate legacy SharePoint data (lists, libraries, metadata, permissions) into Drupal-compatible structures and formats. • Perform data mapping, transformation, and normalization, ensuring consistency with Drupal content models and taxonomy. • Implement migration workflows that preserve: • Content relationships • Metadata and taxonomy • User permissions and access controls • Conduct test migrations, validation, and reconciliation to ensure completeness and accuracy of migrated data. • Troubleshoot and resolve migration issues such as data inconsistencies, transformation errors, or missing relationships. • Document mapping rules, transformation logic, and migration runbooks. • Collaborate with Drupal developers and architects to define content types, entities, and taxonomy structures that support incoming data. • Configure and/or extend Drupal migration capabilities (e.g., Migrate API, custom scripts, or modules). • Support implementation of Drupal-side migration pipelines, ensuring alignment with platform architecture and performance considerations. • Contribute to data model design and content architecture decisions to enable scalable and maintainable ingestion patterns. • Participate in debugging and optimizing Drupal-based migration processes and data ingestion workflows. • Collaborate with DevOps teams to integrate migration activities into CI/CD pipelines and deployment workflows. • Support user acceptance testing and post-migration validation.

Location: Remote Clearance: Public Trust Job Overview: LCG Inc. is seeking a Data Processing Specialist, Associate (PRN) to support the accurate intake, processing, and quality control of federal grant applications. This fully remote, as-needed (PRN) role is a great opportunity for a detail-oriented and tech-savvy professional with a strong grasp of data validation processes and excellent communication skills. In addition to supporting internal documentation processes, the specialist will assist applicants and panelists in navigating grant systems and requirements. Key Responsibilities Collect and organize incoming applications from Grants.gov and transfer data to GrantSolutions. Review application submissions for completeness, accuracy, and compliance using structured checklists. Validate and manage application data through quality control protocols and log findings in central databases. Download and upload review panel summaries between ARM and GrantSolutions. Update federal databases with applicant status, reviewer activity, and screening outcomes. Support end-users in navigating the Application Review Module (ARM) platform. Coordinate with subject matter experts (SMEs) to confirm availability for review panel participation. Set up SME webinars and/or panel rooms using MS Teams or Zoom. Generate and disseminate panel review documents (e.g. panel sheets, etc.) Requirement Qualifications High school diploma and 7 years of relevant experience, or a combination of training and education that provides equivalent knowledge and skills. Computer proficiency, especially with Microsoft Excel, Word, and web-based platforms. Strong attention to detail with experience in data entry, validation, and quality assurance. Proficiency in Microsoft Office Suite and ability to quickly adapt to new systems. Effective communicator with strong interpersonal skills to support applicants and internal teams. Professional, dependable, and capable of handling confidential data with care. Knowledge of the discretionary federal grant lifecycle is a plus. Compensation and Benefits The projected compensation range for salary is $20/hr to $25/hr benchmarked in the Washington, D.C. metropolitan area. The salary range provided is a good faith estimate representative of all experience levels. Salary at LCG is determined by various factors, including but not limited to role, location, the combination of education/training, knowledge, skills, competencies, certifications, and work experience. LCG offers a competitive, comprehensive benefits package which includes health insurance options (medical, dental, vision), life and disability insurance, retirement plan contributions, as well as paid leave, federal holidays, professional development, and lifestyle benefits. Devoted to Fair and Inclusive Practices All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. If you are interested in applying for employment with LCG and need special assistance or an accommodation to apply for a posted position, contact our Human Resources department by email at hr@lcginc.com. Securing Your Data Beware of fraudulent job offers using LCG's name. LCG will never request payment-related details or advancement of money during the application process. Legitimate communication will only come from lcginc.com or system@hirebridgemail.com emails, not free commercial services like Gmail or WhatsApp. If you receive suspicious emails asking for payment or personal information, contact us immediately at hr@lcginc.com. If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission.

• Lead the design and development of robust dbt Core models to transform raw data into trusted, analytics-ready datasets in Snowflake • Architect scalable and performant data models that align with business needs and support enterprise reporting, analytics, and AI initiatives • Collaborate across BI, analytics, and business teams to gather requirements and translate them into efficient ELT solutions • Implement data quality frameworks, documentation standards, and lineage tracking to ensure transparency and trust in our data ecosystem • Use Python to support automation, data validation, and performance monitoring across ELT pipelines • Monitor and optimize Snowflake query performance and cost efficiency • Guide and mentor other engineers, promoting skill development in dbt, CI/CD, and modern data architecture • Provide thought leadership on modern data transformation practices, helping to shape strategy, tooling, and best practices for the enterprise • Support data governance and metadata enrichment initiatives in alignment with enterprise data strategy