Baltimore, MD, 21217, USA
4 days ago
Data Analyst
Development and Alumni Relations (DAR) supports Johns Hopkins’ focus on research, teaching and patient care, and its role as a national and global leader in higher education. We create and foster enduring relationships that result in advocacy and philanthropic support for Johns Hopkins University & Medicine—strengthening the institution through partnerships with donors, alumni, volunteer leaders, faculty, students, staff, and patients. Johns Hopkins University supports a flexible work model which includes four different work modalities. This role has a modified hybrid work arrangement with an onsite presence of 2 days per week. The manager will confirm the team’s core onsite days where the majority/all team members will work in the office. Employees who travel on university business can count those days towards their onsite days. Reporting to the Associate Director of Data Quality, the Data Quality Analyst performs a variety of data processing, review, and maintenance activity to support development efforts for the Johns Hopkins Institutions. Additionally, the data quality analyst researches and reports on the status of critical data related to institutional donors and other constituents, and completes tasks related to development data quality initiatives. **Key responsibilities:** _Mass Data Processing Activities (30%):_ + Oversees compliance of data flows against data quality standards. + Evaluates incoming constituent biographic and demographic data against existing system data and manually merges data onto existing constituent records if determined to be a match or creates a new constituent record to store data if new to database. + Resolves data discrepancies on incoming data to maintain quality and validity. + Observes trends in imported data discrepancies or technical system errors and flags for supervisor review and possible refinement of source data and integration algorithms. + Monitors various data sources and reports to prioritize and expedite incorporation into the database. + Conducts mass data loads by reformatting customer provided data to match database structure. + Documents and reports to the Associate Director on status of data processing projects/goals. _Data Quality Maintenance (30%):_ + Initiates and responds to inquiries (oral and written) from divisional staff, business offices, and other institutional parties regarding biographic and demographic data edits, additions, and deletions. + Observes patterns in requests from divisional staff, business offices, and other institutional parties and alerts manager and/or suggests root cause analyses, customer communications, ticket request forms adjustments, and any other changes to streamline meeting the business needs. + Creates and maintains biographical, contact, employment/organizational relationship data for constituents, as well as other supporting data through filing, retrieval, retention, storage, compilation, coding, updating, and purging. + Completes any activity required to support the development data quality goals and initiatives. + Maintain reports that detail progress of targeted maintenance activities and projects. _Measurement and Analysis (25%):_ + Monitors reports and metrics of established data quality and customer data requests and reports on status to supervisor. + Observes trends in data and make recommendations to Associate Director, Data Quality. + Creates reports as needed to analyze scope of observed data quality issues. + Maintains and builds data quality dashboards in CRM to meet business needs of DAR. + Uses various software applications and databases to assemble, manipulate and/or format data and/or reports. _Knowledge Management (10%):_ + Aids in developing policy and procedure documentation for various data quality operations. + Creates templates for customers to provide data updates to streamline system import. + Refines customer facing webpages and request forms within DAR to support awareness of data quality efforts and streamline addressing of data quality concerns. _Additional Position Requirements (5%):_ + Supervises staff and/or operations (work delegation/assignment) in manager’s absence. + Acts as user acceptance test participant in the enhancement of Development software products. + Assists immediate supervisor in cross-training and new employee orientation within the area. + Other duties as assigned. **Minimum Qualifications** + Bachelor's degree. + Three years of related experience. + Additional education may substitute for experience to the extent permitted by the JHU equivalency formula. **Preferred Qualifications** + One year of experience preferred in collecting and analyzing data, preparing reports, identifying and solving problems. + Proficiency in the Microsoft Office Suite (including Word, Excel). + Knowledge of database structures and ability to use multiple information systems and software. + Experience working in a CRM database (Salesforce preferred). + Familiarity with SOQL. + Strong oral and written communication skills. + Demonstrated analytic, planning, and organizational skills. + Attention to detail and ability to manage multiple projects or responsibilities. + Ability to transform raw data into meaningful information for business and analysis purposes. + Ability to work with limited supervision and make decisions within established procedures. Classified Title: Data Analyst Job Posting Title (Working Title): Data Analyst Role/Level/Range: ATP/03/PB Starting Salary Range: Minimum: $46,200 - Maximum: $80,799 (targeted salary: $65,000; commensurate with experience) Employee group: Full Time Schedule: Monday-Friday, 8:30-5:00pm FLSA Status: Exempt Location: JH at Keswick Department name: 10001639-Data Administration Personnel area: University Administration The listed salary range represents the minimum and maximum Johns Hopkins University offers for this position, based on a good faith estimate at the time of posting. Actual compensation will vary depending on factors such as location, skills, experience, market conditions, education, and internal equity. Not all candidates will qualify for the highest salary in the range. Johns Hopkins provides a comprehensive benefits package supporting health, career, and retirement. Learn more: https://hr.jhu.edu/benefits-worklife/. Equal Opportunity Employer All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. EEO is the Law https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf
Confirm your E-mail: Send Email