• 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

We are changing FINANCE to finance CHANGE! At Climate First Bank, we’re redefining what banking can be. As a Florida Benefit Corporation and FDIC-insured commercial bank, we offer a full suite of personal and business services—including solar, residential, commercial, ESOP Banking, Structured Finance and SBA loans—all designed to power a better future. We’re proud to be a Certified B Corporation, a member of 1% for the Planet, and part of the Global Alliance for Banking on Values (GABV), reflecting our deep commitment to sustainability, transparency, and ethical banking. With branches in St. Petersburg, Winter Park, Mount Dora, and a growing digital presence, we’re proving that banking can be a force for good. We don’t just support environmental and social causes—we’re built on them. Under our Holding Company, Climate First Bancorp, we are also powered by OneEthos. OneEthos operates at the intersection of fintech and traditional banking to expand access to inclusive, values-driven financial services. Regulated by the Federal Reserve Bank, it equips Community Banks, Credit Unions, CDFIs, and Green Banks with ethical lending tools—especially in climate finance and solar lending. Join the Movement We’re seeking driven, mission-aligned individuals ready to make an impact. If you’re passionate about sustainability, thrive in a fast-paced, results driven environment, and want to be part of something bigger, you will feel right at home. Our team is one of goal-setters, go-getters, problem solvers, thought leaders, and changemakers. We celebrate wins, tackle challenges head-on, and push boundaries. Fueled by purpose, we thrive where perseverance and passion turn ambitious goals into reality. Thrive at Climate First Bank At Climate First Bank, we’re investing in your future. We offer a comprehensive, people-first benefits package that supports your health, finances, and work-life balance. Compensation — In addition to the base salary, this position may be eligible for an annual bonus, incentives and equity. Actual compensation is based on industry salary ranges, internal salary structures, experience, skills and other job-related factors. Health Coverage — 100% employer-paid for employees; employer contribution for dependents by Us - Medical, Dental & Vision Insurance - Health Savings Account (HSA) - Free Telemedicine access via Teladoc Financial Wellness & Wealth Building - 401(k) with 6% Employer Match — No Vesting Period. - Employee Stock Options - Exclusive Employee Banking Perks - 0% Financing for Employee Solar Loans - Employee Only Mortgage Product with exclusive interest rates and terms. - 0% Financing for Eligible Electric Vehicles (EVs) - Referral Incentives Generous Paid Time Off - 2–4 Weeks of Vacation based on officer level plus additional tenure-based time. - 64 Hours of Paid Sick Time for all full-time employees. Protection & Peace of Mind - Company-Paid Life Insurance - Short- & Long-Term Disability Insurance - Voluntary Life, Accident & Critical Illness Coverage - Employee Assistance Program (EAP) with free counseling, legal, and financial services. Now Hiring: Data Engineer We’re looking for a Data Engineer to lead the design, development, and optimization of enterprise data solutions. This role will be responsible for building robust data pipelines, integrating diverse data sources, and enabling advanced analytics and reporting across the organization. The ideal candidate will have deep expertise in Azure data services, building advanced SQL queries, and modern data engineering practices. What You’ll Contribute as a Data Engineer Data Architecture & Integration - Design and develop end-to-end data pipelines using Azure Data Factory (ADF), Azure Synapse, Databricks, Logic Apps, etc. - Build and optimize ETL/ELT workflows for structured/unstructured data from multiple sources. - Implement data models, data lakes, and data warehouses in Azure. - Use Azure Databricks for big data transformations & analytics. - Optimize SQL queries, stored procedures, & performance tuning in Azure SQL/SQL Server. - Integrate streaming & real-time data solutions using Event Hubs, Kafka, or Azure Stream Analytics. - Ensure data governance, security, & compliance (RBAC, encryption, monitoring, logging). Implement CI/CD pipelines for data solutions using Azure DevOps, Git, ARM Templates, or Terraform. Power BI Ownership and Optimization - Lead the architecture & administration of Power BI across the enterprise. - Design & implement scalable semantic models that unify data from disparate systems. - Author complex DAX measures & calculated columns to support dynamic reporting needs. - Optimize DAX queries for performance and scalability across large datasets. Champion Our Mission, Protect What Matters - Embody a commitment to environmental, social, and economic justice. - Partner with internal resources to ensure adherence & promotion of our commitment to sustainability practices & continued carbon neutrality. - Ensure compliance with all banking laws, rules, regulations, & prescribed policies/procedures/practices. - Remain vigilant regarding suspicious activity and report to necessary channel(s) when necessary. What You’ll Leverage in this Role: Experience & Education - Bachelor’s degree in Computer Science, Information Systems, Data Engineering, Finance, or related field. - 8+ years of overall IT experience with a focus on data engineering; banking or financial services industry a plus. - Strong expertise in Azure Data Factory, Azure Synapse Analytics, Azure SQL, and Azure Data Lake. - Hands-on experience with Azure Databricks (PySpark, Python, or Scala); proficiency in Python, Spark, or Scala for data transformations. - Strong knowledge of SQL, performance tuning, and query optimization. - Experience with big data platforms and distributed systems. Entrepreneurial Self-Starter Mentality - You take charge of your work product and take pride in delivering consistently great and measurable results. You solve problems efficiently, seek operational efficiencies and are an analytical thinker with a strong focus on data-driven decision making. A high-pace and high-expectation environment excites you and you can’t wait to push yourself to new professional heights in a company that rewards high performance. Master Communicator - Whether it’s in-person, on camera, phone, or chat — you communicate with confidence, precision, and professionalism. You listen deeply and respond thoughtfully and are able to engage efficiently and tactfully with stakeholders at all levels of the organization. Additionally, you masterfully build relationships and develop business with strong influencing and decision-making skills. Banking & Fintech Acumen- You are highly educated in financial products and services, applicable regulations and laws. You also possess strong overall business acumen and the ability to interpret financial reports and legal documents. Strong knowledge of unique industries and markets in conjunction with a broad knowledge of business banking products and services is required. Tech-Forward and Analytical Thinking - You learn new tools quickly, are excited by innovation and leverage technology to optimize your work product and streamline your creative process. Commitment to Being a Team Player - You lift others up, share ideas, and bring positive energy to everything you do. You know what it takes to operate as a part of a larger team and cherish opportunities to contribute to the big picture. You’re dependable, communicate clearly and always happy to lend a hand where needed. What to expect from your physical environment - Remote role within the United States; Eastern Standard Hours. - Occasional U.S. travel for company events or leadership sessions. - Sustained standing and sitting. - Frequent communication (speaking and listening) and use of PC, including typing or sustained attention to monitor. - Occasional lifting up to 20 lbs. Equal Opportunity Statement: At Climate First Bank we truly believe that our people are our strength and the diverse talents they bring to our workforce are directly linked to our success. Diversity and inclusion are at the core of our values and mission. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs. Equal Opportunity Employer/Disability/Veterans E-Verify Statement: This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9