This position is contingent upon award
The Data Engineer is an accomplished technical leader, proactive customer-focused advocate, a team player with substantial software engineering experience, preferably with some experience within the healthcare industry. The Data Engineer must have hands-on experience with enterprise level software development, integration and implementation. Big data experience is a plus. The ideal candidate will have an advanced understanding of ETL & ELT, data ingestion, data discovery & analysis, data cleansing, data transformation, data visualization, and SQL/data modeling. The candidate must demonstrate the ability to evaluate cutting edge technologies and overcome technical challenges in a fast paced environment. The Data Engineer will play a key role of migrating three enterprise applications into a consolidated application which leverages DevOps, cloud computing, and data lake / big data technologies.
The candidate will evaluate and recommend available DBMS products to meet user requirements. Determine file organization, indexing methods, and security procedures for specific user application. Commensurate experience and education. Develop data migration strategy and lead data migration efforts. Familiarity with Oracle data migrations.
•Architect, design, develop, implement, and maintain code, information architecture, and conceptual models to support data processing, and flows thru data lake
o Landing Zone - data ingestion of raw data or capture of streaming data
o Discovery Zone – evaluate data quality, transform raw data, and cleanse data
o Enterprise Zone – transform into data model for external consumption by reporting & self-service BI
•Develop data & metadata policies and procedures
•Review and evaluate database performance, risk and financial analysis feasibility studies
•Investigate and repair application defects regardless of component including platform, business logic, data process logic, or database (SQL and data modeling).
•All other duties as assigned or directed
•Bachelors of Science (or higher) in computer science or related field
•At least eight (8) years of systems/application analysis & design experience
•At least five (5) years of combined experience ETL (Talend, Informatica, or other ETL tool)
• Experience migrating data from Oracle to other database structures and products, preferred COTS/SaaS solution such as Salesforce
•Excellent knowledge of relational databases (PostgreSQL, Oracle, RDS) including SQL, stored procedures, data modeling
•Excellent knowledge of SQL, complex SQL tuning, and data warehouse best practices
•Preferred experience with delivering code using Continuous Integration and Continuous Delivery (CI/CD) best practices and DevOps
•Preferred experience with Salesforce, AWS or other cloud platforms.
•Preferred experience with Big Data (Cloudera) & Java integration
•U.S. citizen or legal right to work in the United States without sponsorship
•Location: Falls Church, VA