Easy Dynamics

Mid Systems / Data Architect

US-VA-McLean
1 month ago
ID
2017-1079
# of Openings
2
Category
Information Technology
Education
Associates Degree or higher is required

Position Summary

Easy Dynamics is looking for a Mid Systems / Data Architect to support a Federal Agency Enterprise Architecture (EA) environment and the implementation and maintenance of data modeling and business intelligence capabilities, including but not limited to: business intelligence and analytics; extract, transform, load (ETL) business logic; data warehouse technology; and various databases and servers.  Specific responsibilities include:

  • Designing, implementing, and maintaining a denormalized data model for online analytical processing
  • Interacting with business users to elicit requirements to design, build, and maintain a comprehensive set of fact/measure and dimensions tables
  • Designing, implementing, and maintaining a data dictionary.
  • Designing, implementing, and maintaining COTS business intelligence suite to include creation of custom reports, dashboards, and content requested by business users
  • Designing, implementing, and maintaining an operational data store and enterprise data warehouse)
  • Designing, implementing, and maintaining ETL workflow, business logic, metadata management, and change data capture functions from inactive datacenter production database to operational data store to enterprise data warehouse

Basic Qualifications

Candidates must have experience with the following:

  • Associate's Degree in a relevant field and/or 3-8 years of relevant experience
  • Experience denormalizing a 3rd normalized formed database to a denormalized star schema with facts and dimensions
  • Experience with metadata management, data modeling, and ETL tools
  • Ability to gather requirements from the business and translate them into a data model
  • Experience developing design specifications and metadata documentation
  • Experience analyzing data content, scrubbing data, and translating data via rules from one database to another
  • Experience with data warehouse tools and techniques (ETL tools, modeling, metadata management, star schemas, etc.)
  • Experience using Erwin Data Modeler creating data models.
  • Experience using COTS for designing and developing business Intelligence analytics/reporting solutions such as reports, maps, charts, KPIs, etc.
  • Experience creating and managing enterprise data warehouse solutions
  • Experience with accepted industry best practices in all of the above areas
  • Ability to work with DBAs to achieve best possible desired results

​US Citizenship required

 

Additional Qualifications

  • Master's degree or equivalent plus three (3) years related experience, or Bachelor's degree plus seven (7) years related experience
  • Certified Data Management Professional (CDMP) certificate OR eight (8) years of job related experience to include at least five (5) years of database administration, data management, data warehouse management, and/or data architecture experience
  • Five (5) years of job related experience in development of data models and information flows, modeling and constructing operation data stores, dimensional data modeling and data warehousing, and metadata management

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed