TixelJobs
N
nanvia Indeed

Data Engineer

REMOTEPosted 8mo ago
Data EngineerMid LevelFull-time#python

About the Role

GENERAL STATEMENT OF JOB

At Stancil Services, our Data Engineer is at the core of how we power smarter decisions across the organization. This role is responsible for designing, building, and maintaining the backend data infrastructure that fuels our growing Data & Analytics team.

This role is responsible for building and maintaining the backend data infrastructure that powers the Data & Analytics team at Stancil Services. This is a purely technical, backendfocused role with no involvement in report development or business intelligence delivery. The Data Engineer owns everything from the source system connection to the cleaned, structured dataset sitting in the warehouse. What happens with that data after it lands is handled by others on the team.

Working within a modern cloud-based data stack, the Data Engineer ensures that raw data from across the business is collected, transformed, and stored in a reliable, organized, and well-documented state. This role is built for someone who prefers working close to the data infrastructure layer, values precision and systematic thinking, and wants to grow into more advanced data engineering, automation, and eventually data science or machine learning capabilities over time.

SUPERVISORY RESPONSIBILITIES

None

ESSENTIAL JOB FUNCTIONS

  • Design, build, and maintain data pipelines using Fivetran and Snowflake to ingest, transform, and load data from business systems including Sage Intacct, Bolt by ECI, Pipedrive, and the Piece-Pay Management System.
  • Develop and maintain data models and transformation logic within Snowflake that produce clean, reliable, and well-structured datasets ready for downstream use by other team members.
  • Monitor pipeline health on an ongoing basis, identify data quality issues before they surface to end users, and implement timely, well-tested fixes.
  • Manage Snowflake environment performance including query optimization, storage organization, and cost monitoring to ensure the warehouse runs efficiently as data volumes grow.
  • Support the integration of new data sources as the company expands into new markets and adds new business applications, working closely with the Director to evaluate and implement connections.
  • Develop Python scripts and automation to improve the efficiency, reliability, and repeatability of data processes across the pipeline infrastructure.
  • Document all pipelines, data models, transformation logic, and warehouse schemas in Confluence so that every process is clearly understood, repeatable, and not dependent on a single person's knowledge.
  • Participate in daily standups, project planning, and backlog management within Jira following the team's Agile-based workflow, keeping tasks current and status transparent at all times.
  • Collaborate with the Data Analyst during project intake to understand what data is needed at the source and model level, ensuring backend structures are built correctly before any downstream work begins.
  • Research and evaluate emerging tools, frameworks, and practices in data engineering that could improve team capabilities and present recommendations to the Manager when appropriate.
  • Other related duties as assigned

EDUCATION, EXPERIENCE AND TRAINING

Required:

  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a closely related technical field. A Master's degree in Computer Science or a related discipline may substitute for a portion of the experience requirements.
  • Minimum of 1 year of hands-on experience with data pipelines, SQL-based data transformation, or cloud data warehousing in a professional or advanced academic project setting.
  • Demonstrated proficiency in SQL including writing complex queries, joins, aggregations, window functions, and performance-aware query design. • Working knowledge of Python for data processing, scripting, and pipeline automation tasks.
  • Foundational understanding of cloud data warehouse concepts and architecture, with exposure to Snowflake or similar cloud-based data warehouse like BigQuery, or Redshift.
  • Strong attention to detail and a systematic, methodical approach to building and validating data processes.

Preferred:

  • Direct hands-on experience with Snowflake as a cloud data warehouse platform.
  • Experience with ELT/ETL data integration tools such as Fivetran, Airbyte, or similar platforms.
  • Exposure to dbt (data build tool) or similar SQL-based data transformation frameworks.
  • Experience working in an Agile or sprint-based team environment using project tracking tools such as Jira.
  • Coursework, personal projects, or professional exposure to machine learning, AI/ML pipelines, or data science is a plus and aligns with future growth opportunities within this role.
  • Familiarity with API integrations and connecting non-standard data sources to a centralized warehouse environment.

STANDARDS OF PERFORMANCE

  • Takes full ownership of the data pipeline and warehouse infrastructure, treating accuracy and reliability as non-negotiable because downstream business decisions depend on the integrity of the data this role produces.
  • Proactively monitors pipelines and data quality rather than waiting for issues to be reported and communicates problems clearly and promptly when they arise.
  • Keeps Jira tasks updated consistently so the Manager and teammates have an accurate, real-time view of what is in progress, what is blocked, and what has been completed.
  • Maintains thorough documentation in Confluence for every pipeline, model, and process built, ensuring nothing critical lives only in one person's head.
  • Asks clarifying questions early in any project to ensure backend work is aligned with the actual business need before significant development begins, avoiding costly rework.
  • Tests and validates all work rigorously before marking it complete, understanding that a broken pipeline or bad data model can have downstream impacts across the business.
  • Pursues continuous learning in data engineering technologies and practices and brings relevant findings back to the team in a practical, actionable way.
  • Maintains the same level of communication, availability, and output quality on remote workdays as on in-office days, managing hybrid work responsibly and professionally.

WORKING ENVIRONMENT AND CONDITIONS

  • This position can operate under a hybrid work arrangement. The employee is expected to report to the Concord, NC office on scheduled office days and may work remotely on designated remote days as coordinated with and approved by the manager.
  • Work is primarily performed in a professional office or home office environment. The remote work environment must support reliable internet connectivity and be free from distractions that would compromise work quality or availability.
  • This is a sedentary role. The employee regularly works at a computer for extended periods throughout the workday.
  • Standard business hours apply. Occasional extended hours may be necessary during high-priority pipeline incidents, system outages, or critical project deadlines.
  • Reasonable accommodations will be made to enable qualified individuals with disabilities to perform the essential functions of the job.

TOOLS AND EQUIPMENT

  • Company-issued laptop computer and peripheral equipment (monitor, keyboard, mouse) for use in both the office and remote work environments.
  • Snowflake: Primary cloud data warehouse platform used for data storage, transformation, modeling, and query execution.
  • Fivetran: Data integration and pipeline platform used to ingest and replicate data from business source systems into Snowflake.
  • Python: Primary scripting and automation language for pipeline development, data processing, and workflow automation.
  • SQL: Core language for all data transformation, modeling, and querying work within the Snowflake environment.
  • Jira: Project and task management platform used for sprint planning, backlog management, and daily workflow tracking.
  • Confluence: Team documentation and knowledge base platform used to document pipelines, schemas, processes, and technical decisions.
  • Microsoft 365 Suite: Including Outlook, Teams, SharePoint, and Excel for daily communication, file management, and team collaboration.
  • Standard office equipment including phone and video conferencing tools for daily standups, team meetings, and stakeholder communication.

Note: As in any Job Description, this description, including the list of essential functions, is not exhaustive and may be supplemented, as conditions require. The Company reserves the right to modify the quality or quantity standards for this position based on changes in specifications, manufacturing, or other conditions.

Stancil Services provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

Share