Home   >   Careers   >   Opening


Data Architect

LOCATION: Canonsburg, PA
<p><strong>Overview:</strong> &nbsp;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. The Data Architect assists in the development and maintenance of data structures, transfer and processing of data.</p> <p><strong>Duties and Responsibilities:</strong></p> <ul> <li>Meeting with business users &amp; stake holders to capture and analyze requirements for data supporting transactional, analytics and reporting needs;</li> <li>Responsible for data modeling, system/data analysis, design and development for Applications, data marts &amp; semantic layer to support analytics and reporting needs;</li> <li>Build conceptual/logical/physical data models using concepts like star-schema modeling, snowflake schema modeling, fact and dimension tables;</li> <li>Develop ETL processes and assist other ETL developers in populating the data from the transactional system to the data marts to for easy analytics &amp; reporting;</li> <li>Implement slowly changing dimensions as well as transaction, accumulating snapshot, and periodic snapshot fact tables;</li> <li>Assess technological options and design offerings supporting scalable, high-performance, and highly available environments;</li> <li>Create and maintain documentation deliverables including, but not limited to process models, architecture diagrams, data models, data flow diagrams, &nbsp;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;</li> <li>Ensure teams follow best practices regarding coding standards, code reviews, and testing (including unit, integration, and system test);</li> <li>Partner with Engineers and architects to ensure developed solutions adhere to established best patterns and our architectural target state;</li> <li>Develop principles, strategies and frameworks on data governance and data management.</li> <li>Maintain compliance with Inovalon’s policies, procedures and mission statement;</li> <li>Adhere to all confidentiality and HIPAA requirements as outlined within Inovalon’s Operating Policies and Procedures in all ways and at all times with respect to any aspect of the data handled or services rendered in the undertaking of the position; and</li> <li>Fulfill those responsibilities and/or duties that may be reasonably provided by Inovalon for the purpose of achieving operational and financial success of the Company.</li> <li>Strong background in Data Modeling, Data Management, PL/SQL, ETL Processes and Database Performance Practices</li> <li>Experience working with Microservices and commercial cloud data platforms.</li> <li>Experience with Oracle, PostgreSQL and Snowflake is preferred.</li> </ul> <p><strong>Job Requirements:</strong></p> <ul> <li>At least 2 years of experience with Health Plan data models;</li> </ul> <ul> <li>6+ years of overall experience in IT. Experience with databases in Commercial cloud (GCP, Azure), Oracle, PostgreSQL and Snowflake is preferred.</li> </ul> <ul> <li>4+ years of experience in logical &amp; physical modeling (designing dimensional data models/facts/slowly changing dimensions from scratch);</li> <li>4+ years’ experience in data warehouse design/maintenance;</li> <li>2+ years’ experience with Informatica IICS;</li> <li>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);</li> <li>Technical proficiency with good interpersonal, problem solving and documentation skills;</li> <li>Ability to work both independently and in a team environment;</li> <li>Ability to work under tight deadline and fast paced environment;</li> <li>Experience working on an Agile SCRUM team is a plus.</li> <li>Working knowledge of Continuous Integration/Continuous Deployment and DevOps principles&nbsp;</li> </ul> <p><strong>Education:</strong></p> <ul> <li>Bachelor’s degree in computer science, engineering, statistics, related field (or equivalent experience); and</li> <li>Master's preferred.</li> </ul> <p><strong>Physical Demands and Work Environment:</strong></p> <ul> <li>Sedentary work ( i.e. sitting for long periods of time) Exerting up to 10 pounds of force occasionally and/or negligible amount of force;</li> <li>Frequently or constantly to lift, carry push, pull or otherwise move objects and repetitive motions;</li> <li>Subject to inside environmental conditions; and</li> <li>Travel for this position will include less than 5% locally usually for training purposes.</li> </ul> <p>&nbsp;</p> <p>CHJ21</p> <p>&nbsp;</p><div class="content-conclusion"><p><em>By embracing diversity, equity and inclusion we enhance our work environment and drive business success. Inovalon strives to reflect the diversity of the communities where we operate and of our clients and everyone whom we serve. We endeavor to create a culture of inclusion in which our associates feel empowered to bring their full, authentic selves to work and pursue their professional goals in an equitable setting. We understand that by fostering this type of culture, and welcoming different perspectives, we generate innovation and growth.</em></p> <p><em>Inovalon is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirement.</em></p> <p><em>The Company maintains a drug free work environment for all of its associates, which includes employees, contractors and vendors. It is unlawful for associates to manufacture, sell, distribute, dispense, possess or use any controlled substance or marijuana in the workplace and doing so will result in disciplinary action, up to and including termination of employment or the contracted relationship.</em></p> <div><em>Consistent with Inovalon’s safety protocols, the company will require a vaccination attestation for fully office-based and hybrid (office/remote) positions. Positions designated as fully remote are exempt from the attestation requirement unless and until such time as an in-office presence is required.</em></div> <p>&nbsp;</p></div>

Apply for this Position

© 2021 Inovalon. All rights reserved.