Data Quality Analyst at MMC in Philadelphia, Pennsylvania

Job Description:

Graham Company, a division of Marsh & McLennan Agency, is an insurance brokerage and consulting firm committed to creating a healthy, safe, and prosperous tomorrow.


We value empathy, discipline, integrity, courage, and tenacity - and we are seeking candidates who share those values to join our team.


The Data Quality Analyst is responsible for ensuring the accuracy, integrity, and reliability of our data assets across various platforms. In this role, you will ensure ongoing monitoring of all datasets, partner with the data team to optimize data accessibility, and alert the business when unexpected changes or deviations occur. You will collaborate with cross-functional teams to identify data issues, implement solutions, and support data governance initiatives. You will also assist in the design, development, and implementation of a master data management strategy in collaboration with senior leadership in IT.



JOB FUNCTIONS & RESPONSIBILITIES:

• Ensure that the data entered into our systems by teams, colleagues, and technologies in our organization is accurate and accessible.


• Optimize data accessibility and oversee ongoing monitoring, maintenance, and data integrity across systems.


• Evaluate data from multiple sources and datasets to ensure accuracy before and after its entrance into a common data model or tool.


• Develop efficient ETL/ELT monitoring processes to track integrated data into target databases, applications, or files.


• Track, troubleshoot, and report on data issues with technology, tools and services, and generate alerts to stakeholders.


• Troubleshoot data issues on our primary dashboarding tools - Qlik and Power BI.


• Consult with internal teams to determine their data is properly displaying and accessible and solve problems when they arise.


• Document the scope of work in all stages of integration, noting customizations, routing rules, data mapping, etc.


• Assist in the design, development, and implementation of a master data management strategy.


• Work on complex assignments requiring judgment and initiative in resolving problems and making recommendations.


• Stay up to date on industry trends in data visualization tools and technologies

JOB SPECIFICATIONS:

• Experience working with API services related to data integrations.


• Experience with data and database technologies such as SQL (data analysis, data prep, ETL, ELT, etc.).


• Database skills, including writing stored procedures, functions, triggers, and data modeling.


• Experience interpreting and integrating data from structured and unstructured formats: flat files, XML, EDI, JSON, EXCEL.


• Expertise in investigating, vetting, and forming recommendations and perspective on data that may strengthen Graham's ability to visualize and report.


• Good report-writing skills. Analytical and problem-solving abilities.


• Ability to perform tasks independently.


• Professional demeanor.


• Proficient in Graham standard computer applications.


• Regular and predictable attendance in accordance with the limitations and reporting procedures established by The Graham Company from time to time.


• Employees are required to be fit-for-duty which includes not being under the influence of drugs and/or alcohol. This includes any drugs that might impact an employee's ability to safely perform their job.

We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. Marsh & McLennan Agency offers competitive salaries and comprehensive benefits and programs including health and welfare, tuition assistance, 401K, employee assistance program, domestic partnership benefits, career mobility, employee network groups, volunteer opportunities, and other programs. For more information about our company, please visit us at: http://marshmma.com/careers. Apply Now