For the given job description <<Role: Lead Data EngineerLocation: RemoteDuration: Long Term 8 to 10 years of experience working in data engineering, business intelligence or related field delivering large scale data platforms and services. Ideal candidate will have the following skills: A successful history of manipulating, processing and extracting value from large, disconnected datasets. Expertise in data modeling, data access and data storage techniques. The candidate should have foundational knowledge of dimensional modeling to build a data warehouse Strong experience building transformational logic using SQL on relational SQL and NoSQL databases. Skills using DBT framework for data transformation is plus Robust programming skills and strong experience with Python to ingest, transform and load the data Experience building and optimizing big data data pipelines, architectures and data sets using tools like Airflow. Experience with AWS cloud services: EC2, EMR, RDS, Redshift>> the resume: <<Career OverviewHighly accomplished Data Architect / Technical Lead with a verifiable track record of designing and implementing complex IT system and exceeding expectations. Practiced in clarifying business requirements, performing gap analysis between goals and existing procedures/skill sets, and designing process and system improvements to increase productivity and reducecosts. Extensive experience in data mapping, data migration, ETL, and data modeling for OLTP, OLAP, relational and dimensional models. Strong interpersonal skills, highly adept at diplomatically facilitating discussions and negotiations with stakeholders, developers and business leads . Recognized technical leadership skills, consistently delivercomplex, large-scale projects on time and within budget.
QualificationsAnalyticsBusiness IntelligenceManaging ScopeDatabase/Query Performance TuningStructured Query Language (SQL)
Education and TrainingManassas,VAExpected in––BS:Information Systems-GPA:➢ BS, in Information Systems, Strayer, Manassas, VA
Work ExperienceLumen Technologies-Integration Lead/ Data ArchitectNaples,FL,08/2014-04/2015Large Snack Food Company - DallasLarge Beverage Company - New YorkLed data integration effort to completion.Perform data integration troubleshooting with the clients ETL and batch teams.Wrote mapping and WSDL code based on client requirements.Monitored interface data loads using Accenture CAS Mat Tool and custom written SQL.Recommended performance improvements to client and Accenture architectsTexas State Agency - AustinInterfacing with client SMEs to document the as is environment in preparation for a new PBM vendorAnalyzing the organizations reports and interfaces that are needed to continue business continuityCreated and maintain System Inventory, User  Interaction and RICEFW documentationGathering and preparing documentation that was contributed to the RFP and will be used during the transition to a new vendor.Oil & Gas Company - ChicagoLed the creation and definition of the WEDS logical data architecture to support core data types: master data, transaction data, structured/unstructured data, digital documentsDeveloped strategies and options for data migration and data cleansingData Asset Strategy definition, Data Model Definition, Extraction and Transformation logicWrote custom functions and stored procedures to clean and transform dataAccenture Contractor Jobs-Technology ArchitectDenver,CO,05/2014-09/2014Led the technical information gathering effortCreate and demonstrated the importance of RICEFW documentationConducted meetings to discuss the data and process flow of internal and external systemsKey contributor in the evaluation of PBM vendors and their systemsAccenture Contractor Jobs-Data ArchitectSacramento,CA,11/2013-04/2014Led the creation and definition of the WEDS logical data architecture to support core data types: master data, transaction data, structured/unstructured data and digital options for data migration and data cleansing.Assisted with developing strategies for Management Information (MI) activities.Created a successful ETL proof of concept that extracted/transformed/loaded data and then linked the IDs from different systems into one universal ID.Wrote custom functions and stored procedures to clean and transform data.Technical liaison with vendor SMEs during the evaluation of different data applications and documents.Evaluated Smart Plant applications for use in the migration of structured and unstructured brownfield data.Developed strategies and options for data migration and data cleansingData Asset Strategy definition, Data Model Definition, Extraction and Transformation logicAssisted with developing strategies for Management Information (MI) activitiesCreated a successful ETL proof of concept that extracted/transformed/loaded data and then linked the IDs from different systems into one universal IDWrote custom functions and stored procedures to clean and transform dataTechnical liaison with vendor SMEs during the evaluation of different data applications and functionsArmed Forces Services Corporation-Data/Solutions ArchitectCity,STATE,11/2009-09/2013Data Architect and Team lead for a refactoring project.Responsible for leading the development of refactoring a Natural application to C# and from ADAbase to SQL Server.Implemented a process for configuration management within the company.Conducted peer reviews, estimation meeting and conducted testing cycles.Mentored junior developers in database practices and principles.Conducted data migration tasks as required by the company and projects.Moved all key infrastructure services within the company into a cloud infrastructure.Maintained the data integrity of the company's financial data used by Deltek.Created ETL scripts and processes as needed to support the companies' data request.Maintained the availability of all data driven systems.Supported project teams with data tasks.Used as a technical resource during proposals.Booz Allen Hamilton-Data ArchitectCity,STATE,01/2003-01/2009Created complex data models for DoD and government agencies.Worked with classified and unclassified data.Data lead for multiple development projects.Wrote, tested and optimize database scripts and procedures.Designed and implemented database designs used in the development of data driven web based applications.Interfaced with clients to gather reporting requirements.Sent to at-risk projects to win back client confidence.Designed and developed ETL processed for data migration tasks.Performed advance administration and troubleshooting of database engines.Worked with developers to design and optimize data access layers within the application code base.Provided technical feedback to upper management and support staff during proposals.
SkillsEtl, Extract, Transform, And Load, Data Migration, Database, Proposals, Clients, Access, Data Models, Dod, Engines, Web Based, Sql, Testing, C#, Change Management, Configuration Management, Data Integrity, Deltek, Estimation, Ms Sql Server, Natural, Solutions, Sql Server, Team Lead, Application Development, Bottling, Data Integration, Integration, Integrator, Issue Management, Mapping, Master Data Management, Mdm, Technical Product Marketing, Topo, Tpm, Architecture, Data Architecture, Data Cleansing, Data Model, Ids, Liaison, Stored Procedures, Transaction Data, Unstructured Data, Data Mapping, Data Quality, Data Structure, Data Warehousing, Database Analysis, Database Design, Dimensional Data, Federal Government, Microsoft Sql Server, Pricing, Security, Sql Server 2005, Documentation, Process Flow>>. The result is, 

Fit assessment: Good Fit