Data Engineer

NCQA is seeking a highly skilled Data Engineer with a strong background in MS-SQL and Business Intelligence (BI) tools. The ideal candidate will have extensive experience working with complex SQL queries, deciphering and optimizing legacy SQL code, and developing efficient data processes. Proven expertise in designing and building objects for data warehouses, datamarts and reporting solutions. Additionally, experience with BI tools such as Power BI and MicroStrategy is required to support reporting and visualization needs. The individual should be familiar with ADF2 cloud services. The individual must be able to work independently and in a group setting. This role is critical in ensuring the accuracy, performance, and usability of our data infrastructure.

Responsibilities

• Optimize database performance, indexing, and query execution plans.
• Design, develop, and maintain scalable data pipelines and ETL processes.
• Designs and builds database systems for high availability and quality.
• Enforces and documents database policies, procedures, and standards.
• 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.
• Analyze, interpret, and optimize legacy SQL code to improve performance and maintainability.
• Work closely with analysts and business stakeholders to ensure data accuracy and usability.
• Develop and maintain BI reports and dashboards using Power BI and other visualization tools.
• Performs tests and evaluations regularly to ensure data integrity, validity, consistency, security, privacy, and integrity
• Collaborate with other reporting, visualization, and analytics departments
• Collaborate with cross-functional teams to define data requirements and improve data architecture.
• Analyze business needs of customers and operations, analyze information systems, and propose data solutions
• Ensure data governance, security, and best practices are followed.
• Serve as change agent who motivates end users in adopting new methods of viewing and using data and interactive dashboards.

Requirements

• Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.
• 3+ years Strong proficiency in MS-SQL, including debugging, refactoring, and performance tuning. 
• Experience working with relational databases (e.g., SQL Server, PostgreSQL, MySQL). Expert SQL and scripting skills.
• Knowledge of ETL tools and ADF2 data pipeline frameworks.
• 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 required.

Compensation & Benefits:

• For new hires, this position pays in the range of $120K - $130K per year, depending on experience.
• This position is eligible for an annual incentive bonus, payable in accordance with policy.
• Click here for employee benefit information.

NCQA is committed to being an employer of choice and fostering an inclusive culture and workplace.

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 any and 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).