What are the responsibilities and job description for the W2 Data Engineer position at Inabia Software & Consulting Inc.?
Overview
Inabia is seeking an experienced Data Engineer with strong expertise across data engineering, database architecture, cloud platforms, and application architecture. This role is responsible for designing and implementing reliable, scalable, secure, and high-performance data solutions in close collaboration with application architects, cloud engineers, data scientists, and application development teams. The ideal candidate brings hands-on experience building scalable data pipelines and platforms, deep SQL and data modeling skills, working Python knowledge, and meaningful exposure to AI/ML and Generative AI technologies.
Responsibilities
- Design and define enterprise-level database architectures, standards, patterns, and best practices
- Evaluate and select relational, NoSQL, and cloud-native database technologies based on business and technical requirements
- Design scalable database solutions encompassing data modeling, availability, resiliency, backup/recovery, replication, and disaster recovery
- Provide platform expertise across PostgreSQL, MySQL, Oracle, SQL Server, MongoDB, or similar systems
- Design and support database solutions deployed on AWS, Azure, or GCP
- Lead or support on-premises-to-cloud database migrations and modernization initiatives
- Optimize database performance through query tuning, indexing, partitioning, and capacity planning
- Establish and enforce database security standards including encryption, access controls, auditing, data protection, and regulatory compliance
- Use Python for database automation, scripting, data processing, validation, and operational tasks
- Collaborate with AI/ML and GenAI teams, providing architectural guidance on embeddings, vector databases/search, and RAG patterns
- Create and maintain architecture diagrams, database standards documentation, and technical reference materials
- Provide technical leadership, conduct architecture reviews, support troubleshooting efforts, and mentor team members
Key Qualifications
- Strong experience in database architecture, engineering, or administration at enterprise scale
- Deep understanding of relational database concepts: SQL, data modeling, normalization, indexing, transactions, and performance optimization
- Hands-on experience with one or more major database platforms (PostgreSQL, Oracle, SQL Server, MySQL, MongoDB, or equivalent)
- Hands-on experience with AWS, Azure, or GCP managed database services
- Solid understanding of cloud architecture principles: scalability, high availability, security, monitoring, backup, and disaster recovery
- Demonstrated experience with database migration and modernization projects
- Basic to intermediate Python skills for scripting, automation, and data processing
- Experience with cloud-native and distributed database architectures, Infrastructure as Code (IaC), and DevOps/CI/CD practices
- Knowledge of database observability, monitoring, and automated operations
- Experience with data governance, security, privacy, and regulatory compliance requirements
- Proven track record supporting large-scale, high-volume, highly available enterprise systems
- Strong problem-solving, analytical, written communication, and documentation skills
Preferred Qualifications
- Familiarity with vector databases, embeddings, semantic search, large language models (LLMs), and Retrieval-Augmented Generation (RAG) patterns
- Basic understanding of AI/ML and Generative AI concepts as they relate to data platform design