Data Architect
Bowie, MD

Job Description

Overview

The Data Architect will be responsible for working with business users, SMEs, peer developers and other analysts to deliver high quality data models, architectural designs and ETL processes to populate dimension/non-dimensional structures supporting analytics and reporting needs of the organization.

Responsibilities

* Meeting with business users & stake holders to capture and analyze requirements for data supporting analytics, forecasting and reporting needs;
* Responsible for data modeling, data analysis, design & development for data marts and development of semantic layers to support analytics & reporting needs;
* Build conceptual/logical/physical data models using concepts like star-schema modeling, snowflake schema modeling, fact and dimension tables;
* Develop ETL (SSIS) processes and assist other ETL developers in populating the data from the transactional system to the data marts to support for easy analytics & reporting;
* Implement slowly changing dimensions as well as transaction, accumulating snapshot, and periodic snapshot fact tables;
* Create and maintain documentation deliverables including, but not limited to process models, architecture diagrams, data models, data flow diagrams, metadata, glossaries, data dictionary, entity relationship diagrams, data mapping documents, BUS matrix and other data design artifacts that define technical data specifications and transformation rules;
* Ensure development team follow best practices regarding coding standards, code reviews, and testing (including unit, integration, and system test); and
* Develop principles, strategies and frameworks on data governance and data management.

Qualifications

* 6+ years of overall experience in IT. Experience with databases & SQL server will be preferred;
* 6+ years of experience with T-SQL/ advanced T-SQL;
* 4+ years of experience in logical & physical modeling (designing dimensional data models/facts/slowly changing dimensions from scratch);
* 4+ years' experience in data warehouse design/maintenance;
* 4+ years' experience with Microsoft SSIS for ETL;
* Good understanding of the Kimball lifecycle;
* Strong working knowledge of data modeling, data warehousing, metadata management, database design and development, ETL processes, semantic layer development and preferably visualization tools (e.g. Tableau or SSRS or Power BI);
* Technical proficiency with good interpersonal, problem solving and documentation skills;
* Ability to work both independently and in a team environment;
* Ability to work under tight deadline and fast paced environment;
* Experience with SSAS, SSRS and MDX queries is a plus;
* Experience working on an Agile SCRUM team is a plus; and
* Experience with Health Plan data models is a plus.

Education

* Bachelor's degree in computer science, engineering, statistics, related field (or equivalent experience); and
* Master's preferred.

Inovalon provides equal employment opportunities (EEO) to all employees and applicants for employment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, or protected veteran status and will not be discriminated against on the basis of disability.