Sign upLog in
See more jobs

Data Engineer II

Servco Pacific Job Distro
  • Honolulu, Hawaii
    30+ days ago

    Job Description

    Servco's Data Engineers play a crucial role in ensuring the organization has the data it needs to make informed business decisions. This includes acquiring data from a variety of sources-internal systems as well as external APIs-and transforming, modeling, and curating it so it's reliable and usable for downstream analytics and reporting.

    This role requires a strong understanding of DataOps practices and the ability to operate in a cloud-first, code-first, agile environment. Data Engineers in this role are expected to work with technologies such as Databricks for data warehousing, data modeling, and orchestration, as well as Cloud Functions for serverless computing and automation. Data Engineers should be skilled coders with high proficiency in Python and SQL, capable of writing clean, efficient, well-documented code and troubleshooting issues across pipelines and platforms.

    Data Engineers will partner closely with Analytics Engineers, who focus on downstream activities that turn prepared data into actionable insights. This role is responsible for sourcing, preparing, and serving data in a way that enables those analytics workflows to operate confidently and at scale.

    This position is primarily on-site in Honolulu and is not a remote role. It allows up to one day per week working from home.

    QUALIFICATIONS:
    • Bachelors in Computer Science, Information, Data Science, Business Analytics or Information Management (not required but preferred)
    • 4-7 years of experience in the following areas, all in an individual contributor capacity:
    • Process Mining & Stakeholder Collaboration
      • Experience with process mining and collaborating with stakeholders to understand their needs and identify opportunities for process improvement.
    • Programming & Software Development Practices
      • Experience with Python programming, including libraries such as NumPy, Pandas, and Selenium, as well as testing and debugging using tools such as PyTest.
      • Experience with SQL programming, writing efficient queries and stored procedures.
      • Experience with version control systems such as Git (including merging and resolving conflicts) and containers such as Docker.
    • Data Engineering (Integration, Modeling & Warehousing)
      • Experience working with database integrations and designing systems that integrate data from multiple sources.
      • Experience designing and implementing logical and physical data models and applying data warehousing best practices such as dimensional modeling, star and snowflake schemas.
      • Experience creating and maintaining dbt documentation using Jinja templates.
      • Experience with day-to-day database administration, including backup and recovery, performance tuning, and security management.
    • Cloud, Infrastructure & Architecture
      • Experience working with cloud-based services, specifically Azure and Databricks.
      • Experience using Infrastructure as Code (IaC) tools such as Terraform.
      • Experience managing and maintaining analytics infrastructure, including data pipelines and storage systems, and supporting incident response procedures.
      • Experience designing and implementing systems using a microservices architecture.
    • Governance & Security
      • Experience implementing policies and procedures to ensure the availability, usability, integrity, and security of data throughout its lifecycle, including data lineage, data quality, data privacy, and compliance requirements.
    • Technical Documentation
      • Experience creating and maintaining technical documentation such as project plans, requirements, design documents, and test plans.

    Skills:
    • Process Mining
      • Ability to understand and document business processes, including identifying process inputs, outputs, and key stakeholders.
    • Programming (Python & SQL)
      • Ability to work with and integrate APIs and other external systems.
      • Ability to write efficient and optimized SQL queries and stored procedures.
    • Data Engineering (Orchestration, Modeling & Warehousing)
      • Experience designing and implementing scalable, reliable, and maintainable data pipelines.
      • Ability to identify and resolve data migration and integration issues, including data loss, corruption, and duplication.
      • Proficient in analyzing business requirements to determine database design and implement effective data models and transformations.
      • Ability to abstract data from its physical location and structure, allowing users to access and use the data without knowing where it resides or how it is stored.

    Numbers & Facts

    LocationHonolulu, Hawaii

    Skills

    • Application Programming Interface (API)unmatched
    • Automationunmatched
    • Best Practicesunmatched
    • Business Analysisunmatched
    • Business Processesunmatched
    • Channel Strategiesunmatched
    • Cloud Computingunmatched
    • Computer Programmingunmatched
    • Computer Scienceunmatched
    • Data Managementunmatched
    • Data Migrationunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Recoveryunmatched
    • Data Scienceunmatched
    • Data Storageunmatched
    • Data Warehousingunmatched
    • Database Administrationunmatched
    • Database Designunmatched
    • Debugging Toolsunmatched
    • Design Documentunmatched
    • Dimensional Modelingunmatched
    • Dockerunmatched
    • Documentationunmatched
    • Gitunmatched
    • Identify Issuesunmatched
    • Incident Responseunmatched
    • Information Scienceunmatched
    • Information/Data Security (InfoSec)unmatched
    • Microservicesunmatched
    • Microsoft Windows Azureunmatched
    • Multiplatform/Cross-Platformunmatched
    • Needs Assessmentunmatched
    • Performance Tuning/Optimizationunmatched
    • Policy Implementationunmatched
    • Procedure Implementationunmatched
    • Process Developmentunmatched
    • Process Improvementunmatched
    • Project Planningunmatched
    • Pytestunmatched
    • Python Programming/Scripting Languageunmatched
    • Query Optimizationunmatched
    • Regulatory Complianceunmatched
    • Requirements Managementunmatched
    • SQL (Structured Query Language)unmatched
    • Security Monitoringunmatched
    • Seleniumunmatched
    • Snowflake Schemaunmatched
    • Software Developmentunmatched
    • Software Engineeringunmatched
    • Source Code/Configuration Management (SCM)unmatched
    • Star Schemaunmatched
    • Stored Proceduresunmatched
    • System Integration (SI)unmatched
    • Technical Writingunmatched
    • Testingunmatched
    • Usability Engineeringunmatched
    • User Interface Designunmatched
    • Warehousingunmatched
    • Workflow Analysisunmatched
    • Writing Skillsunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder