Error message
Warning: Undefined array key "gh_src" in Drupal\green_house_jobs\Forms\ApplyJobForm->buildForm() (line 28 of modules/custom/green_house_jobs/src/Forms/ApplyJobForm.php).
Drupal\green_house_jobs\Forms\ApplyJobForm->buildForm()
call_user_func_array() (Line: 536)
Drupal\Core\Form\FormBuilder->retrieveForm() (Line: 284)
Drupal\Core\Form\FormBuilder->buildForm() (Line: 224)
Drupal\Core\Form\FormBuilder->getForm() (Line: 27)
Drupal\green_house_jobs\Controller\JobDetailsController->getDetails()
call_user_func_array() (Line: 123)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 637)
Drupal\Core\Render\Renderer->executeInRenderContext() (Line: 121)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext() (Line: 97)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 181)
Symfony\Component\HttpKernel\HttpKernel->handleRaw() (Line: 76)
Symfony\Component\HttpKernel\HttpKernel->handle() (Line: 53)
Drupal\Core\StackMiddleware\Session->handle() (Line: 48)
Drupal\Core\StackMiddleware\KernelPreHandle->handle() (Line: 28)
Drupal\Core\StackMiddleware\ContentLength->handle() (Line: 201)
Drupal\page_cache\StackMiddleware\PageCache->fetch() (Line: 138)
Drupal\page_cache\StackMiddleware\PageCache->lookup() (Line: 87)
Drupal\page_cache\StackMiddleware\PageCache->handle() (Line: 206)
Drupal\cleantalk\EventSubscriber\BootSubscriber->handle() (Line: 48)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle() (Line: 51)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle() (Line: 36)
Drupal\Core\StackMiddleware\AjaxPageState->handle() (Line: 51)
Drupal\Core\StackMiddleware\StackedHttpKernel->handle() (Line: 741)
Drupal\Core\DrupalKernel->handle() (Line: 19)
Warning: Undefined array key "updated_at" in Drupal\green_house_jobs\Controller\JobDetailsController->getDetails() (line 38 of modules/custom/green_house_jobs/src/Controller/JobDetailsController.php).
Drupal\green_house_jobs\Controller\JobDetailsController->getDetails()
call_user_func_array() (Line: 123)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 637)
Drupal\Core\Render\Renderer->executeInRenderContext() (Line: 121)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext() (Line: 97)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 181)
Symfony\Component\HttpKernel\HttpKernel->handleRaw() (Line: 76)
Symfony\Component\HttpKernel\HttpKernel->handle() (Line: 53)
Drupal\Core\StackMiddleware\Session->handle() (Line: 48)
Drupal\Core\StackMiddleware\KernelPreHandle->handle() (Line: 28)
Drupal\Core\StackMiddleware\ContentLength->handle() (Line: 201)
Drupal\page_cache\StackMiddleware\PageCache->fetch() (Line: 138)
Drupal\page_cache\StackMiddleware\PageCache->lookup() (Line: 87)
Drupal\page_cache\StackMiddleware\PageCache->handle() (Line: 206)
Drupal\cleantalk\EventSubscriber\BootSubscriber->handle() (Line: 48)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle() (Line: 51)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle() (Line: 36)
Drupal\Core\StackMiddleware\AjaxPageState->handle() (Line: 51)
Drupal\Core\StackMiddleware\StackedHttpKernel->handle() (Line: 741)
Drupal\Core\DrupalKernel->handle() (Line: 19)
Deprecated function: DateTime::__construct(): Passing null to parameter #1 ($datetime) of type string is deprecated in Drupal\green_house_jobs\Controller\JobDetailsController->getDetails() (line 38 of modules/custom/green_house_jobs/src/Controller/JobDetailsController.php).
Drupal\green_house_jobs\Controller\JobDetailsController->getDetails()
call_user_func_array() (Line: 123)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 637)
Drupal\Core\Render\Renderer->executeInRenderContext() (Line: 121)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext() (Line: 97)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 181)
Symfony\Component\HttpKernel\HttpKernel->handleRaw() (Line: 76)
Symfony\Component\HttpKernel\HttpKernel->handle() (Line: 53)
Drupal\Core\StackMiddleware\Session->handle() (Line: 48)
Drupal\Core\StackMiddleware\KernelPreHandle->handle() (Line: 28)
Drupal\Core\StackMiddleware\ContentLength->handle() (Line: 201)
Drupal\page_cache\StackMiddleware\PageCache->fetch() (Line: 138)
Drupal\page_cache\StackMiddleware\PageCache->lookup() (Line: 87)
Drupal\page_cache\StackMiddleware\PageCache->handle() (Line: 206)
Drupal\cleantalk\EventSubscriber\BootSubscriber->handle() (Line: 48)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle() (Line: 51)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle() (Line: 36)
Drupal\Core\StackMiddleware\AjaxPageState->handle() (Line: 51)
Drupal\Core\StackMiddleware\StackedHttpKernel->handle() (Line: 741)
Drupal\Core\DrupalKernel->handle() (Line: 19)
Data WareHouse Engineer
The key to our success is simple; we deliver the highest quality, on time, with passion and commitment, and live every day by a set of great values. We've built a company that fosters long-term careers in an environment of continuous learning, with cutting-edge benefits, tools, and resources. In addition, certifications that endorse our company as a great place to work.
Responsibilities
- Design, build, and maintain scalable, high-performance data warehouse solutions using modern cloud and on-premise technologies.
- Develop, schedule, and monitor robust ETL/ELT pipelines using tools such as Airflow (orchestration) and dbt (data transformation).
- Optimize data models, queries, and storage strategies to improve performance, scalability, and system reliability.
- Implement and enforce data quality, validation, and governance standards to ensure accuracy, consistency, and compliance.
- Collaborate with data analysts, engineers, and business stakeholders to translate analytical requirements into efficient data solutions.
- Continuously enhance and automate data workflows by leveraging Airflow, dbt, and other modern frameworks to drive efficiency and continuous improvement.
Requirements
- 3+ years of experience designing, developing, and maintaining data warehouses and ETL/ELT workflows in production environments.
- Proficiency in SQL and strong experience with data modeling, schema design, and performance optimization.
- Proven hands-on experience with modern data engineering tools (e.g., Airflow, dbt) and AWS cloud-based data platforms (e.g., Snowflake, Redshift).
- Hands-on experience (on business projects) with programming languages such as Python, C/C++, or Java.
- Strong analytical and problem-solving skills, with the ability to work collaboratively across cross-functional teams in a fast-paced, data-driven environment.
- Must not have had any disciplinary actions regarding attendance, conduct, and/or performance in the past 90 days, and must not be approaching such action.
- Experience using Excel, Google Sheets, and Slack.
- AWS Cloud Practitioner or Engineer certificates.
- High-speed Wi-Fi connection.
- Ability to work US timezone shifts (e.g., EST, CST, MST, or PST).
#LI-REMOTE
About us
AssureSoft is a multinational software development and information technology company providing strategic consulting, technology services, and outsourcing business processes. We work to innovate and create quality software with motivated, passionate, and qualified teams that develop in an environment of professional, stable growth and continuous learning.
Inclusive Opportunities for Every Talent. At AssureSoft, we believe that true innovation is born from diversity—of ideas, experiences, and perspectives. That’s why our hiring practices are inclusive and reflect a firm commitment to equity and equal opportunity.
Here, every person—regardless of origin, gender, orientation, or beliefs—finds a space to grow, contribute, and be valued not only for their talent, but also for who they are.
What sets us apart
- Great Place To Work certification.
- A company with more than 15 years of experience.
- Work with world-class clients and long-term projects.
- English scholarships for an external institute.
- English classes with company teachers.
- State-of-the-art tools and resources.
- Certifications for your professional growth.
- Recreation and leisure activities.
- Compliance with the regulations and labor rights of your region.
Retention of your personal information: AssureSoft will retain your personal information for as long as necessary to fulfill the purposes for which it was collected or as necessary to comply with our legal obligations, resolve disputes, and maintain appropriate business records. Once the purpose has been fulfilled, your personal information will be retained and blocked due to the possibility of legal and governmental requirements, and until the status of limitations has run out.
Important Notice Regarding Personal Information: If you do not want your personal and professional information to be retained in our database, please send your request for data removal to info@assuresoft.com.
