Data Architect (Tableau, MS-SQL, Oracle)

Emagine IT - Fairfax, VA (30+ days ago)3.8

Company Overview

Emagine IT is an information technology consulting services company that specializes in delivering technology solutions to meet the needs of clients. Our reputation reflects the high quality of the talented Emagine IT team and the consultants working for our clients. Our mission is to understand and meet the needs of both our clients and consultants by delivering quality, value-added solutions. Our solutions are designed and managed to not only reduce costs, but to improve business processes, accelerate response time, improve services to end users, and give our clients a competitive edge, now and into the future. As business systems integrators, we will align our clients’ business processes and information systems to enable them to access the right information at the right time, empowering them to achieve their desired business results and create enterprise value.

Duties & Responsibilities

Work with business, process teams, and leaders, to understand their business information requirements and to classify, organize, make available and govern the data needed to meet those requirements
Support the development of integrated data models and artifacts identifying as-is, planned, and to-be mission data and supporting metadata.
Facilitate data modeling sessions, ranging from information gathering to model validation.
Review and employ database schemas to document Physical Data Models and develop LDMs, and dictionaries.
Support the development of integrated data models and artifacts identifying as-is, planned, and to-be mission data and supporting metadata.
Develop and employ guidelines, standards, Standard Operating Procedures (SOPs), and recommended practices for maintaining and developing data models and data dictionaries.
Employ data modeling tools and associated graphical methods to depict and analyze current and proposed conceptual, logical, and physical data schema.
Provide subject matter expertise to the customer’s organization in the application of data management principles, standards, procedures, and tools
Advise management relative to data warehouses, metadata, and common data collections
Prepare and maintain database documentation and standards
Prepare documentation for technical architecture review and acquisition of development and execution environment components
Identify and provide documentation and recommendations for the acceptance or mitigation of any issues and risks associated with requirements, proposed systems, solutions, development, designs, plans and timelines.
Identify and provide documentation that provides all necessary detail regarding the impact of the technical architecture; design and development to other existing systems; and if the impact increases the risk or has a negative impact to the other systems, provide mitigation strategy recommendations.
Work closely with Government technical architecture staff and independently lead the identification and resolution of issues/problems within the technical infrastructure.
Identify development iterations, focus team development of prototypes and sample code that can be used by developers.
Provide knowledgeable solutions to resolve complex internal and external issues that can impact the success of the project.
Interact with technologists, management, project management, developers, and other technical leads throughout the period of performance.
Planning technical architecture, design and development of applications and data storage for complex systems, software and system development methodologies such as SCRUM, AGILE, and Waterfall, Hardware, COTS and open source analysis and selection; and bridging the business aspects and the technical aspects of delivering complex systems including the ability to productively interact with resistant and/or change adverse stakeholders.
Design multi-domain MDM solution using Informatica MDM multi-domain and PowerCenter COTS tools in a client/server and/or service-oriented architecture (SOA) environment, including understanding of technical architecture, MDM architecture style, network design, application development, middleware, servers and storage, database management, and operations.

10+ years of experience
Data Migration and ETL experience from legacy to next generation systems
Technical expertise to include: Oracle, Microsoft SQL Server, MySQL, Agile, DevOps & Tableau
Expertise or Knowledge of Extensible Markup Language (XML) editors
Expertise or Knowledge of SOA Technologies
Data modeling, including reverse and forward engineering.
Knowledge of database design principles
Possession of excellent oral and written communication skills
Experience with information architecture concepts (Common Information Model/Canonical Data Model, Enterprise Information Management, Metadata Management, Data Governance, and Master Data Management).
Experience with data modeling, data mapping, data profiling, and data quality
Self-starter, well organized, extremely detail-oriented and an assertive team player, willing to take ownership of responsibilities, and possess a high level of positive energy and drive
Excellent time management and organizational skills
Ability to manage multiple priorities, work well under pressure and effectively handle concurrent demands to prioritize responsibilities
AAP/EEO Statement

Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status.

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.