Database Architect-Transportation Data Collection-Remote
Quality Counts (QC) is seeking a Database Architect to design and evolve data platforms and data lakes. Here, you will drive strategy beyond database maintenance, shape the future of our data ecosystem, both contributing and collaborating with a team that leads innovation and industry advancement in the niche field of transportation data collection! Database Architect – Transportation Data – Duties:
- Design and evolve QC’s cloud-native data lake and analytical data platform, supporting large-scale transportation datasets across ingestion, storage, transformation, QA, analytics, and downstream publishing.
- Own the data architecture end-to-end
- Perform overall data lake architecture (raw → curated → analytics → publishing layers)
- Deploy data modeling strategies for time-series, geospatial, and high-volume event data
- Implement storage format decisions (row vs columnar, partitioning strategies, versioning)
- Employ data governance patterns (schemas, metadata, lineage, lifecycle management)
- Identify performance and cost tradeoffs across analytical and operational workloads
- Oversee long-term evolution of the platform as data volume and use cases grow
- Partner closely with application, analytics, and DevOps teams to ensure the platform is scalable, governed, observable, and extensible over time.
Database Architect – Transportation Data – Requirements:
- 5+ years of professional (non-academic) experience in database engineering or related roles
- Bachelor’s degree in computer science, information systems, or adjacent field of study
- Experience designing analytical data platforms or data lakes (not just application databases)
- Experience with columnar and analytical storage formats (e.g., Parquet, ORC, Iceberg, Delta Lake)
- Experience with data partitioning, versioning, and lifecycle management at scale
- Strong SQL skills and experience with relational databases (PostgreSQL, MySQL, SQL Server)
- Experience with NoSQL databases and modern data stores
- Experience with cloud database platforms (AWS RDS/Aurora, or similar)
- Experience with performance tuning, indexing, and query optimization
- Experience with backup, replication, and disaster recovery strategies
- Experience building or supporting ETL/ELT data pipelines
- Familiarity with data cataloging, metadata management, or schema evolution strategies
- Ability to work independently and collaboratively in a fast-paced environment
- Values feedback and collaboration
Database Architect – Transportation Data – Optional but recommended:
- Experience with geospatial data (PostGIS, spatial indexing, map-based analytics)
- Experience supporting analytics tools (Athena, BigQuery, Redshift, Snowflake, etc.)
- Event-driven or serverless data pipelines
- Experience designing systems that must coexist with legacy platforms
Database Architect – Transportation Data – Benefits:
- Remote position
- Health, Dental, Vision, and Life Insurance Package(s)
- Paid Time Off & Volunteer Time Off
- 401K with Employer Contribution (effective one year after employment)
- Employee ownership opportunity after committed service
- Work within a highly connected, curated team of talented technical/development professionals
Database Architect – Transportation Data – Salary: $115,000-$125,000 + annual performance bonuses Compensation details: 115000-125000 Yearly Salary PI1648ee3495ad-25401-39777547 Remote Skills: Amazon Relational Database Service (RDS), Cataloguing, Cloud Computing, Computer Science, Cost Analysis, Data Analysis, Data Collection, Data Lake, Data Management, Data Modeling, Data Partitioning, Data Sets, Database Administration, Database Architecture, Database Design, Database Extract Transform and Load (ETL), Database Programming, Database Technology, DevOps, Disaster Recovery, Ecosystems, Information Technology & Information Systems, Metadata, NoSQL, Operational Audit, Performance Tuning/Optimization, Quality Assurance, Quality Control, Query Optimization, Replication and Remote Mirroring, Spatial Data, Trade-Off Analysis, Use Cases About the Company: Quality Counts LLC Apply tot his job Apply To this Job