Data Engineer/DBA

6 days ago


Huntingdon, PA, United States Century Support Services Full time

JOB TITLE: Data Engineer/DBA

DEPARTMENT: IT

REPORTING RELATIONSHIP: CIO

FLSA STATUS: Salary (Exempt)

Century is one of the nation's largest debt settlement companies, helping consumers resolve their unsecured debts. This is an exciting opportunity to join a high growth, evolving, proven, and successful organization. The company's culture has been built on caring for its clients and employees for over 20 years.

We value each of our team members and recognize that their wide array of perspectives and life experiences fuel our organization's strength. Our ongoing commitment to every member of our team has earned us several 'Best/Top Workplace' and 'growth' awards, and those recognitions inspire us to continually exceed expectations.

JOB SUMMARY:

We're seeking a critical role in Data Engineering to own the design/redesign and operation of our modern data pipelines. You will build and maintain scalable ingestion frameworks, (ETL) implement robust data quality/validation controls, and collaborate and partner closely with the analyst and application teams to deliver well-modeled, trustworthy datasets. Your work will directly support mission-critical reporting, analytics, and product features.

A successful candidate will be able to create a world class data environment enabling high-performance and deliverables.

DUTIES AND RESPONSIBILITIES

  • Data Engineering
  • Design, build, and maintain ETL/ELT pipelines using tools such as Airbyte, SQL Server Integration Services (SSIS), or cloud-native orchestration.
  • Develop and maintain scalable data ingestion frameworks for structured and unstructured data.
  • Implement robust data quality, validation, and monitoring checks across all pipelines.
  • Collaborate with analysts, data scientists, and business stakeholders to support data modeling and schema design that aligns with analytics and application needs.
  • Support the development of data warehouse architectures (star schemas, snowflake schemas, SCDs, CDC, etc.).
  • Database Development
    • Develop efficient, maintainable SQL (DDL/DML), stored procedures, functions, triggers, and views across multiple environments (dev, QA, prod).
    • Optimize complex queries for performance, scalability, and cost efficiency.
    • Implement indexing strategies, partitioning, and query-plan reviews to improve system performance.
    • Support application developers with database-driven features, including schema design, query optimization, and integrations.
    • Participate in code reviews, ensuring database changes follow best practices and governance standards.
  • Database Administration (DBA)
    • Manage and administer SQL Server, Snowflake, or other RDBMS environments.
    • Perform installation, configuration, upgrades, patches, and performance tuning.
    • Ensure database security, encryption, role-based access, and compliance with internal and regulatory standards.
    • Monitor database health and performance using tools such as SQL Server Profiler, Query Store, CloudWatch, New Relic, etc.
    • Implement and maintain backup and recovery strategies, high availability (HA), and disaster recovery (DR) solutions.
    • Troubleshoot incidents and provide on-call support for production issues.
  • Data Governance & Architecture
    • Establish and enforce data standards, naming conventions, documentation, version control, and deployment processes.
  • Support metadata management, data lineage, and data cataloging initiatives.
  • Contribute to capacity planning, storage management, and system scalability strategies.
KNOWLEDGE AND ESSENTIAL SKILLS
  • Excellent problem-solving abilities with strong attention to detail.
  • Ability to work cross-functionally with Engineering, Business Intelligence, Analytics, and Product teams.
  • Strong communication skills with the ability to translate technical concepts for non-technical stakeholders.
  • Self-driven, proactive, and capable of managing multiple priorities in fast-paced environments.
  • Experience supporting both operational databases and analytics data warehouses.
  • Understanding of data governance frameworks and compliance (SOC2, HIPAA, GDPR).
EDUCATION AND/OR WORK EXPERIENCE
  • Certifications in SQL and ETL tools are preferred.
  • 3-5+ years of experience in data engineering, database development, and/or database administration.
  • Strong proficiency with SQL (T-SQL, PL/pgSQL, or similar) and relational database design.
  • Experience administering and optimizing SQL Server, Snowflake, Azure, or similar platforms.
  • Hands-on experience with ETL/ELT development, data modeling, and pipeline orchestration tools.
  • Experience with version control (Git), CI/CD, and code-based database deployments.
  • Familiarity with cloud environments (AWS, Azure, or GCP).
  • Strong understanding of performance tuning, indexing, query plans, and workload optimization.
We love our employees
  • Competitive compensation package
  • Career development & growth opportunities through performance and career pathing
  • 100% Premiums paid on Basic Life insurance, AD&D, Short-Term Disability, and Long-Term Disability
  • Affordable Medical, Dental, and Vision coverage that begins on the first day of employment with generous contribution
  • Optional Supplemental Insurance for Life Insurance, Critical Illness, and Accident
  • Employee Recognition Programs - Standing Ovation, Voice of Support, and Time in Service Bonus
  • 401K plan with 100% matching up to 4% and immediately vested
  • No cost Employee Assistance Program and Travel Assistance
  • Generous PTO package that starts on day 1 and increases after 1st year
  • Commitment to employee communication through employee suggestions and engagement surveys
  • Experienced leadership team with decades of industry experience
  • Great team members who want you to succeed

  • USDA NRCS TN

    2 weeks ago


    Huntingdon, United States ELYON International Full time

    In partnership with the United States Department of Agriculture (USDA) Natural Resource Conservation Service (NRCS), ELYON International is recruiting for multiple (7) Engineering Technician (Civil) positions in the State of Tennessee. The ELYON Engineering Technician (Civil) will be an integral part of the NRCS Team and provide support for a variety of...


  • Huntingdon, United States Anglian Water Services Full time

    Circa £50,000 (dependent on skills & experience)Hybrid – base location Huntingdon, Peterborough or LincolnPermanent / Full-time / 37 hours per week (flexible working available)Make every drop of your potential count… join our Digital, Data & Technology teamAt Anglian Water, we’re transforming how we manage and optimise our operational technology...


  • Huntingdon, United States Granges AB Full time

    Gränges is a global leader in the rolling and recycling of aluminum, with a proud heritage of over 125 years located around the world. We are an aluminum company dedicated to creating lighter, smarter, and more sustainable aluminum products and solutions for the future. Our 3,500 employees across three continents are the foundation of our success. We are a...


  • Huntingdon, United States Granges AB Full time

    Gränges is a global leader in the rolling and recycling of aluminum, with a proud heritage of over 125 years located around the world. We are an aluminum company dedicated to creating lighter, smarter, and more sustainable aluminum products and solutions for the future. Our 3,500 employees across three continents are the foundation of our success. We are a...


  • Huntingdon Valley, PA, United States CARR & DUFF Full time

    Company Overview:Carr & Duff, LLC has been a leading electrical contractor in the Greater Philadelphia Tri-State Area and Mid Atlantic Region since 1958. With over 65 years of experience, C&D has earned a reputation for excellence in tackling complex electrical construction projects with a focus on safety, quality, and timeliness. We now offer services...