Easy Dynamics

Senior Systems / Data Architect

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

Position Summary

Easy Dynamics is looking for a Senior 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 5-15 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

  • Bachelor's degree or equivalent plus nine (9) years related experience, or Master'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​

See less

Options

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