Digital-first government for the common good.
Senior Data Engineer
Location
United States
Posted
1 day ago
Salary
$130K - $140K / year
Seniority
Senior
Job Description
Senior Data Engineer
Ad Hoc LLC
• Senior Data Engineer serves as an experienced individual contributor within a team, with the expectation that you will continue to develop your leadership, technical guidance, and mentoring skills. • With minimal oversight from leadership, you will design, build, and optimize scalable data solutions that support business and customer needs while ensuring projects meet scope, schedule, and delivery commitments. • Contribute to the long-term data strategy of the program, influence architectural decisions, and collaborate closely with software engineers, product managers, analysts, architects, and stakeholders to deliver reliable, secure, and scalable data platforms. • Serve as the primary data engineering lead for initiatives and utilize strong leadership and communication skills to drive improvements in data engineering processes, platform reliability, and engineering best practices. • Evaluate and recommend multiple technical approaches to solve complex data engineering and architecture challenges. • Design, develop, maintain, and optimize scalable data pipelines supporting both batch and real-time processing. • Design and implement robust ETL/ELT workflows that transform raw data into reliable, consumable datasets. • Build and maintain scalable data models, data warehouses, and cloud-native data architectures. • Generate data architecture recommendations and successfully implement approved solutions. • Ensure data quality, integrity, governance, lineage, security, and observability across data platforms. • Optimize database performance, query execution, storage strategies, and overall system scalability. • Diagnose and resolve production issues while implementing long-term improvements to increase system reliability and performance. • Collaborate with cross-functional teams to translate business requirements into scalable technical solutions. • Present technical designs, architecture diagrams, and implementation strategies to clients, stakeholders, partners, and engineering teams. • Champion data engineering best practices, coding standards, automation, and operational excellence. • Mentor junior engineers through technical guidance, code reviews, design discussions, and knowledge sharing. • Lead small projects or serve as the technical lead for data engineering initiatives when needed. • Effectively communicate technical challenges, risks, and progress with engineering teams, leadership, clients, and stakeholders. • Participate in technical interviews and contribute to hiring decisions.
Job Requirements
- Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or a related technical discipline with 7+ years of professional experience.
- 7+ years of experience designing, building, and maintaining enterprise-scale data platforms and data pipelines.
- Strong proficiency in SQL with experience developing, optimizing, and troubleshooting complex queries and large datasets.
- Professional experience developing software and data solutions using Python, Java, Scala, or a comparable programming language.
- Experience designing, developing, and maintaining ETL/ELT pipelines for batch and real-time data processing.
- Experience working with cloud-based data platforms and services within AWS, Microsoft Azure, or Google Cloud Platform.
- Experience with modern cloud data platforms such as Snowflake, Databricks, Amazon Redshift, Google BigQuery, or Azure Synapse Analytics.
- Experience with relational database technologies such as PostgreSQL, SQL Server, Oracle, or MySQL, along with familiarity with NoSQL database solutions.
- Experience with distributed data processing frameworks such as Apache Spark or equivalent big data technologies.
- Strong understanding of data modeling, dimensional modeling, schema design, data warehousing, and database optimization.
- Experience implementing data quality, validation, governance, metadata management, and data lineage best practices.
- Experience working with structured, semi-structured, and unstructured data from multiple sources.
- Experience with version control systems such as Git and CI/CD practices supporting data engineering workflows.
- Understanding of data security, privacy, encryption, and access control principles.
- Experience monitoring, troubleshooting, and optimizing production data systems for scalability, availability, and performance.
- Experience working within Agile software development environments and collaborating across cross-functional engineering teams.
- Strong analytical, troubleshooting, and problem-solving skills with the ability to make sound technical decisions.
- Excellent written and verbal communication skills with the ability to explain technical concepts to both technical and non-technical audiences.
- Demonstrated ability to mentor junior engineers through code reviews, technical guidance, and knowledge sharing.
- Ability to obtain and maintain a U.S. Public Trust clearance.
Benefits
- Company-subsidized health, dental, and vision insurance
- Flexible PTO
- 401K with employer match
- Paid parental leave after one year of service
- Employee Assistance Program
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Streaming Data Engineer
Bright Vision TechnologiesBright Vision Technologies is a forward-thinking software development company dedicated to building innovative solutions that help businesses automate and optimize their operations. We leverage cutting-edge technologies to create scalable, secure, and user-friendly applications.
Role Description We are seeking an experienced Streaming Data Engineer to architect, deploy, and operate large-scale Apache Kafka and Confluent platform environments supporting mission-critical event-driven workloads. In this role you will own the Kafka platform end-to-end, including: - Cluster sizing - Configuration - Security - Automation - Observability - Developer enablement The ideal candidate will combine deep Kafka internals knowledge with strong DevOps and SRE practices, and will partner with application teams to deliver a reliable, performant, and developer-friendly streaming platform. You will work closely with cross-functional partners — product, design, engineering, operations, and business stakeholders — to translate ambiguous requirements into well-engineered solutions. You will be expected to raise the bar through: - Code review - Design review - Mentorship of more junior engineers The successful candidate brings strong engineering discipline, a clear communication style, and a track record of shipping meaningful work that holds up well in production. Qualifications - Bachelor’s degree in Computer Science, Engineering, or a related technical discipline. - Five or more years of experience operating Apache Kafka or Confluent Platform in production. - Deep, hands-on knowledge of Kafka internals (partitions, replication, ISRs, consumer groups). - Strong experience with Kafka security (SASL, mTLS, ACLs, RBAC). - Hands-on experience with Kafka Connect, Schema Registry, and either Kafka Streams or ksqlDB. - Experience with HA/DR strategies for Kafka. - Strong scripting skills in Python, Bash, or Go. - Hands-on experience with infrastructure-as-code (Terraform, Ansible). - Working knowledge of observability tooling for Kafka. - Excellent troubleshooting, communication, and documentation skills. Preferred Qualifications - Confluent Certified Administrator or Developer credentials. - Experience operating Kafka on Kubernetes (Strimzi, Confluent Operator). - Exposure to managed Kafka services (AWS MSK, Azure Event Hubs Kafka API). - Familiarity with stream processing frameworks (Flink, Spark Streaming). - Experience with data governance and lineage for streaming data. How to Apply Would you like to know more about this opportunity? For immediate consideration, please send your resume to [email protected] Equal Employment Opportunity (EEO) Statement Bright Vision Technologies (BV Teck) is committed to equal employment opportunity (EEO) for all employees and applicants without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, veteran status, or any other protected status as defined by applicable federal, state, or local laws. This commitment extends to all aspects of employment, including: - Recruitment - Hiring - Training - Compensation - Promotion - Transfer - Leaves of absence - Termination - Layoffs - Recall BV Teck expressly prohibits any form of workplace harassment or discrimination. Any improper interference with employees' ability to perform their job duties may result in disciplinary action up to and including termination of employment.
Lead Data Engineer – Microsoft Fabric
Blend360Optimizing business performance through people, data, tech & analytics
• Conduct comprehensive gap analysis and data mapping across 80+ ERP systems to identify integration challenges, data inconsistencies, and transformation requirements. • Design and develop standardized ETL pipelines and data transformation processes for migrating enterprise data into Microsoft Fabric. • Build robust data quality frameworks and validation rules to ensure data readiness for AI and analytics workloads. • Lead hands-on implementation of ETL standards and best practices, establishing repeatable patterns and automation scripts for multi-source integrations. • Develop and optimize data models that support seamless transformation from fragmented ERP sources into a unified, AI-ready data architecture. • Lead the pilot implementation phase, testing and refining standards against real ERP data before full-scale rollout. • Mentor and guide team members on ETL development, data transformation techniques, and Fabric-specific engineering practices. • Collaborate with stakeholders to document data lineage, transformation logic, and integration patterns for knowledge transfer and governance. • Troubleshoot data inconsistencies and implement corrective measures to maintain data integrity throughout the pipeline.
Lead Data Engineer – Microsoft Fabric
Blend360Optimizing business performance through people, data, tech & analytics
• Conduct comprehensive gap analysis and data mapping across 80+ ERP systems to identify integration challenges, data inconsistencies, and transformation requirements. • Design and develop standardized ETL pipelines and data transformation processes for migrating enterprise data into Microsoft Fabric. • Build robust data quality frameworks and validation rules to ensure data readiness for AI and analytics workloads. • Lead hands-on implementation of ETL standards and best practices, establishing repeatable patterns and automation scripts for multi-source integrations. • Develop and optimize data models that support seamless transformation from fragmented ERP sources into a unified, AI-ready data architecture. • Lead the pilot implementation phase, testing and refining standards against real ERP data before full-scale rollout. • Mentor and guide team members on ETL development, data transformation techniques, and Fabric-specific engineering practices. • Collaborate with stakeholders to document data lineage, transformation logic, and integration patterns for knowledge transfer and governance. • Troubleshoot data inconsistencies and implement corrective measures to maintain data integrity throughout the pipeline.
Lead Data Engineer – Microsoft Fabric
Blend360Optimizing business performance through people, data, tech & analytics
• Conduct comprehensive gap analysis and data mapping across 80+ ERP systems to identify integration challenges, data inconsistencies, and transformation requirements. • Design and develop standardized ETL pipelines and data transformation processes for migrating enterprise data into Microsoft Fabric. • Build robust data quality frameworks and validation rules to ensure data readiness for AI and analytics workloads. • Lead hands-on implementation of ETL standards and best practices, establishing repeatable patterns and automation scripts for multi-source integrations. • Develop and optimize data models that support seamless transformation from fragmented ERP sources into a unified, AI-ready data architecture. • Lead the pilot implementation phase, testing and refining standards against real ERP data before full-scale rollout. • Mentor and guide team members on ETL development, data transformation techniques, and Fabric-specific engineering practices. • Collaborate with stakeholders to document data lineage, transformation logic, and integration patterns for knowledge transfer and governance. • Troubleshoot data inconsistencies and implement corrective measures to maintain data integrity throughout the pipeline.

