Data Systems Specialist
Apply NowCompany: ECS
Location: Arlington, VA 22204
Description:
ECS is seeking a Data Systems Specialist to work in our Arlington, VA office.
Develops and implements data pipelines using ETL tools such as Azure Data Factory and Oracle Data Integrator
Data Modeling
Serves as the SME for logical and physical data modeling in support of application and reporting projects
Works with agile teams including software developers, business intelligence developers, QA engineers, and business analysts to create, review, and implement logical and physical data models
Creates views and models of denormalized data for reporting systems
Reviews and optimizes queries, data models, and data security in existing systems
Creates synthetic data for testing purposes
Develops and implements data pipelines using ETL tools
Documents data assets
5+ years' experience designing, implementing, and optimizing data solutions for data integration in enterprise environments
5+ years' experience working in or supporting project teams
Knowledge of dimensional modeling and experience in creating logical and physical data models
Experience transforming logical business requirements into appropriate data pipeline solutions
Ability to analyze and evaluate Entity Relation Diagrams, data dictionaries, record layouts, and logic flow diagrams
Strong understanding of data warehousing principles including, dimensional modeling, slowly changing dimensions, and ETL best practices
Experience supporting and maintaining database systems and related architecture
Database performance analysis and tuning experience to identify bottlenecks, optimize queries, and ensure optimal data flows
Experience creating views and modeling of denormalized data for reporting systems
Proficiency in planning and deploying database changes across deployment environments
Experience with generating synthetic data that satisfies both data privacy and testing objectives
Strong knowledge of common database languages
Develops and implements data pipelines using ETL tools such as Azure Data Factory and Oracle Data Integrator
Data Modeling
Serves as the SME for logical and physical data modeling in support of application and reporting projects
Works with agile teams including software developers, business intelligence developers, QA engineers, and business analysts to create, review, and implement logical and physical data models
Creates views and models of denormalized data for reporting systems
Reviews and optimizes queries, data models, and data security in existing systems
Creates synthetic data for testing purposes
Develops and implements data pipelines using ETL tools
Documents data assets
5+ years' experience designing, implementing, and optimizing data solutions for data integration in enterprise environments
5+ years' experience working in or supporting project teams
Knowledge of dimensional modeling and experience in creating logical and physical data models
Experience transforming logical business requirements into appropriate data pipeline solutions
Ability to analyze and evaluate Entity Relation Diagrams, data dictionaries, record layouts, and logic flow diagrams
Strong understanding of data warehousing principles including, dimensional modeling, slowly changing dimensions, and ETL best practices
Experience supporting and maintaining database systems and related architecture
Database performance analysis and tuning experience to identify bottlenecks, optimize queries, and ensure optimal data flows
Experience creating views and modeling of denormalized data for reporting systems
Proficiency in planning and deploying database changes across deployment environments
Experience with generating synthetic data that satisfies both data privacy and testing objectives
Strong knowledge of common database languages