Senior Operations Data Architect

The Senior Operations Data Architect is responsible for building, managing, and supporting data warehouse and data-marts to support NCQA's data needs. As a Senior Operations Data Architect, you will:

• Build and maintain data models, related processes in data collection and reporting programs.
• Work with system leads on database design and fine-tuning.
• Review and enhance data structure. Extend and enhance data warehouse.
• Produce and maintain documentation related to data and data process.
• Support data governance activities.
• Work with others to create and maintain policies and establish protocols related to data management.
• Maintain current industry knowledge on the trends of technology in general as related to data warehouses, data-mart and reporting solutions.

Primary Responsibilities:

• Analyze business needs of customers and operations, analyze information systems, and propose data solutions
• Designs and builds database systems for high availability and quality
• Enforces and documents database policies, procedures, and standards
• Performs tests and evaluations regularly to ensure data integrity, validity, consistency, security, privacy, and integrity
• Monitors database performance, implement changes and apply new patches and versions when required
• Work effectively with data related to different business processes, products, and services
• Create supporting documentation for design and solution specifications
• Partner with developers in embedding data interfaces into different information systems
• Remediate data-related issues during testing with QA and UAT teams
• Collaborate with other reporting, visualization, and analytics departments
• Communicate effectively with various stakeholders (business vs technical, associate vs leadership, staff vs customer)
• Support training, creating user manuals, and providing post-production warranty
• Serve as change agent who motivates end users in adopting new methods of viewing and using data and interactive dashboards
• Provide production support to customers and operations staff encountering issues with reports, dashboards, and data visualizations
• Discovers opportunities to enhance information through data acquisition and integrations
• Perform root cause analysis, and identifying opportunities for improving the different data interfaces in use by operations
• Creating and maintaining a 'playbook' to troubleshoot commonly occurring problems
• Serving as a lead for departmental projects and process improvement initiatives involving data
• Assist in developing strategic roadmaps for key data systems and contribute to project planning
• Assist in creating business cases including forecasting effort (cost) and risk vs. return analysis for data solutions
• Assist with special projects

Requirements:

• Bachelor's Degree in computer science, Information System, Engineering, or equivalent professional experience.
• 3+ years experience implementing data solutions in Microsoft SQL Server
• 2+ years working with Visio and other software for documenting data, process related to data and data flow.
• A solid Software Development background with strong, full SDLC, software development methodology knowledge and experience. Experience developing data warehouse applications using an Agile methodology preferred.
• Expert SQL and scripting skills.
• Strong communication skills, both verbal and written.
• Ability to innovate, prioritize and multi-task. Technical aptitude and problem solving skills, cooperative approach.
• Data modeling / diagram skills.

NCQA is committed to Diversity, Equity, and Inclusion. We are an Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.

NCQA is a drug free workplace. NCQA recruits, hires, trains, and promotes individuals, and administers all personnel actions, without regard to race, color, religion, national origin, age, sex, pregnancy, citizenship, familial status, disability status, veteran status, genetic information, or other protected statuses under applicable state and federal laws.

NCQA will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c).