Senior Data/ETL Developer
Location
United States
Posted
2 days ago
Salary
$120K - $143K / year
No structured requirement data.
Job Description
- Developing data interactions through dynamic, stored procedure, and automated applications of SQL
- Evolving existing data architecture into a more modern and optimized design, most likely some version of a data lake.
- Working with developers and solutions architects to fulfill user stories on functional needs of both traditional web application deployment and Government Cloud application.
- Addressing emergent issues and resolving data and/or database issues
- Assisting or leading the developer of data related components across the ETL spectrum including in future states with active engage of securely controlled AI elements
- Performance, Resilience, and Extendibility optimization.
- DB Management (SQL & NoSQL): Practical understanding of SQL (especially MS SQL Server) and NoSQL at the administrative and traditional ‘ilities’ level (usability, supportability, extendibility, sustainability, resilience and optimizability) as well as data modeling, query optimization, and migration:
- Data Management & Governance: Comprehensive knowledge of data management principles, ontology, data governance frameworks (e.g., DAMA-DMBOK), and best practices for non-Cloud and Cloud supporting databases Experience implementing or supporting data governance programs, including defining data policies, standards, models, interfaces and procedures
- Understanding of the key DoD and Industry data standards, policies, and practices
- Data Quality Enhancement: Continuously refine data related storage, query, and interfacing elements to prompt data hygiene, overall data quality, and identify/mitigation data conflicts within the larger data ecosystem
- Expert knowledge of relational database concepts and highly proficient in SQL, with extensive experience optimizing queries, stored procedure and data API development
- Data Solution Development & Architecture: Designing and implementing complex, scalable, and secure solutions tailored to customer needs. This includes continued evolution and new development within the broader framework of well-integrated data components:
- Thought and creation of solution components for scalable data use including transaction optimization, load balance, precompute, data warehousing, data lake solutions, and cloud migration strategies
- Leading or contributing to the design and implementation of data architectures including zero trust interfaces to external data repositories
- Develop and implement a comprehensive data architecture that aligns with the organization's goals and supports business intelligence and analytics initiatives
- Develop architecture strategy based on modern data architectures like Data Products, Data Mesh, Data Fabric and Domain Driven Design
- Design data models (canonical, conceptual and logical data models and data flow. charts) for operational and analytical systems, ensuring consistency and scalability
- Ability to advise senior management and technical teams benefits, risks, and impacts of various data architecture and changes. Including but not limited to changes to data center infrastructure/policy, changes to overall data architecture, and data access interfaces.
- Data Integration/ELT: Demonstrated capability and proven ability to apply concepts and principles of building and scaling Extract, Load, Transform (ELT) pipelines. Experience overseeing or managing projects involving data pipeline orchestration, data quality management, and performance optimization.
- Data Science/AI & Data Standards: Understanding of how data standards impact data science, information availability, data hygiene and AI/ML initiatives:
- Experience contributing to or managing projects that apply data standards in data preparation, feature engineering, model training, validation, and AI/ML workflows is a plus
- User Story decomposition into technical solution components
- Agile Test-Driven Development
- DoD Data management and integration
- Non-disruptive transformation of complex legacy database collections
- Experience working with multi-disciplinary solutions teams
- Database/Data Entity containerization
- Evolutionary ETL
- Legacy Systems migration
- Coordination with and optimization for hosted database infrastructure
- Health, dental, and vision insurance
- 401(k) retirement plan with company match
- Life insurance
- Long-term/Short-term disability insurance (LTD/STD)
- Employee Stock Ownership Plan (ESOP)
- Vacation, Sick and Holiday leave
- Parental leave
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
The SQL Developer will primarily be responsible for MS SSIS, SSRS, and SSAS development, along with stored procedure, view, and index creation, and SQL Server instance management and performance tuning. Duties also involve working with end users on analytic tools and collaborating with development groups on database schema and maintenance.
We are seeking a highly skilled Power BI Data Engineer who combines deep technical expertise in data engineering with exceptional data visualization abilities. This hands-on role requires someone who can architect robust data solutions while creating compelling, insight-driven da...
3 Key Consulting is hiring an Associate Engineer, Drug Product Manufacturing Data Analysis for a consulting engagement with our direct client, a leading global biopharmaceutical company. Remote but preferably someone who is located near Thousand Oaks or Cambridge sites for occasi...
As a Data Engineer, you will help us build our information system, which is used by our staff globally. The RISE mission is to accelerate the internet for the Philippines—we do this by focusing on the overall customer experience, providing excellent internet services and creati...