What are the responsibilities and job description for the ETL Data Analyst position at Bloomberg Philanthropies?
About Bloomberg Philanthropies
Bloomberg Philanthropies works to create catalytic change across five areas of focus: arts and culture, education, the environment, government innovation, and public health. Our mission is to ensure better, longer lives for the greatest number of people. Our approach is rooted in Mike Bloomberg's unique experience and success across the field of business, government, and philanthropy.
Position Summary
Our Data & Reporting team supports all Bloomberg Philanthropies programs, initiatives, events and projects by upholding a standardized method of storing data and to provide this information accurately, comprehensively, and as frequently as requested. The team leads the development and implementation strategy of the central contacts database, built on the Salesforce platform and, to streamline processes, we are currently integrating our other platforms into Salesforce.
We are seeking to a hire a Data Analyst to join our team to focus on our contact data management, reconciliation and reporting. In this role you’ll work closely with the team to analyze and ensure data is input efficiently and accurately, build visualizations of the data through reports and dashboards, and manage user access.
Key responsibilities include:
- Bulk extraction, transformation and loading (ETL) of contact data
- Identify patterns and outliers within large datasets
- Reconcile large sets of irregularities in large datasets
- Development of reports and dashboards for our senior leaders
- Assist with coordination of business critical and sensitive reporting requests
- Provide project assistance and additional ad-hoc data management support for the department
Technical Qualifications:
- A Bachelor’s Degree is required, with a minimum of 3 years of experience in data management
- Advanced excel skills including fluency in pivot tables, VLOOKUP and/or XLOOKUP and data cleanup tools such as CONCAT, TEXTJOIN and Text to Columns
- Knowledge of Ungerboeck, Fluxx, Raiser’s Edge and/or Salesforce would be an advantage
- Experience with data visualization tools, such as Tableau, would be strongly preferred
Additional Requirements:
- Experience handling, manipulating, processing and verifying large sets of data with accuracy and integrity, ideally within a non-profit organization or political campaign
- Strong attention to detail and task follow-through
- Good project management skills for executing short term projects and reporting requests
- Proven history of solving complex data problems with a sharp eye for detail
- Curiosity and a passion for learning and applying knowledge
- Superb interpersonal skills with a comfort working across diverse teams and handling senior leaders
- An ability to handle your time efficiently and multi-task in a fast-paced environment
- Flexible, open, positive, and collaborative personality
Bloomberg Philanthropies is an equal opportunities employer, and we value diversity at our organization. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Compensation will be commensurate with experience and accomplishment.
