Data Engineer Modeling & Profiling

SES Corporation
Chantilly, VA
Jan 22, 2022
Jan 24, 2022
Engineer, IT, QA Engineer
Full Time
Role Description:The data engineer designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. The Data steward will populate the data catalog meta data and managing standard business definitions. This includes identifying key business terms for resolution and standardized definition, ensuring compliance with naming conventions and naming standards, facilitating convergence for the correct definitions, associating business term definitions with their authoritative sources.The data engineer is responsible for collecting, collating, and triaging issues and problems with data.The successful candidate will: Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL). Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively. Assess new data sources and define how the new data fits into the existing data model. Examine the data available from an existing information source and collecting statistics or informative summaries about that data. Collect requirements to understand present and future data needs for the projectKey Responsibilities for Data Engineer:Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models.Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.Interpreting data, analyzing results using statistical techniques.Developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality.Acquiring data from primary or secondary data sources and maintaining databasesRequirementsMinimum Skills & Requirements:7 years of experienceBachelor's or master's degree in computer/data science technical or related experience.3+ years of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required. Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required. Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks).Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc) Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracyPreferred Skills:Mortgage analytics experience desiredExperience in the following sector(s): housing and mortgage finance, Federal credit programs, and government benefit programsBenefitsSES provides a competitive salary and the following benefits:MedicalDentalVisionAD&DSTDLTDCompany paid Life Insurance401k with employer contributionPaid Time Off