Job Title: Senior Data Manager
Department: Information Technology
Reports To: Chief Technology Officer
FLSA Status: This is a full-time (40 hours per week) Exempt level position
Salary: $108,000.-$119,000
ABOUT CHILDREN’S COUNCIL:
For more than 50 years, Children’s Council has been the heart of child care and early education in San Francisco, advancing the belief that high-quality child care can transform lives and communities. Our more than 150 team members help families navigate their child care and preschool options and secure financial assistance to pay for it. We provide home-based child care businesses with the training and resources to succeed. Through a wide range of free programs and workshops, we support parents and caregivers as they build child development skills. As the city’s second-largest nonprofit contractor, with an annual budget of over $250 million, we are a major stakeholder in the child care system. We educate the public and advocate for increased investment in early education at the local and state level. If you are a child care champion, we want you on our team.
POSITION SUMMARY:
Children’s Council is looking for a self-motivated and enthusiastic senior level manager. This professional’s primary focus will be interpreting and analyzing data from a variety of sources to create dashboards, reports, extract trends, and turn data into information. They will define and manage data content and quality to ensure that the data collected and maintained meets our organization’s needs. The ideal candidate is organized, detail-orientated, and has a can-do attitude. The Senior Data Manager will report to the Chief Technology Officer.
This role is 100% remote but should be live locally to be available for in-office work/meetings as needed.
PRIMARY RESPONSIBILITIES:
- Takes strategic management role over data across the organization, champions data to key stakeholders
- Assist CTO with implementation of Data Strategy
- Responsible for creation, management, training, and administration of the data warehouse
- Creates and maintains integrations between the organization’s data warehouse and external REST APIs by utilizing platforms such as Azure Data Factory and Cloudingo.
- Manage and enhance integrations that transfer data directly into Salesforce utilizing ETL processes from the organization’s data warehouse, SQL databases and form tools such as FormAssembly.
- Utilize tools such as Cloudingo and Salesforce’s built-in duplicate management features to minimize the number of duplicate Salesforce contacts and related accounts.
- Work closely with other internal data team staff to clean and transfer historical data from spreadsheets into Salesforce using tools such as Dataloader, Cloudingo and the Salesforce Data Import Wizard.
- Serve as administrator and technical resource for Account Engagement, the organization’s email marketing tool.
- Supervise the organization’s Web/Database Administrator position and manage related work.
- Establishes requirements and assesses the quality of the data in our current databases
- Assisting in the maintenance and creation of a data catalog and data map.
- Creates and implements data standards, policies, procedures, and business rules
- Establishes data access security requirements
- Interprets data, analyze results using statistical techniques and provide ongoing reports from a variety of sources to create dashboards and other presentation materials and tools for key constituents
- Develops and implements databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
- Acquire data from primary and/or secondary data sources and maintain databases/data systems
- Filters and cleans data by reviewing computer reports, printouts, and performance indicators to locate and correct issues
- Serve as the organization’s Salesforce Administrator to include management of the Salesforce database and configuration. Will also work directly with any identified Salesforce consultants.
- Provides training and technical assistance with the design and management of collecting and reporting data (surveys). Also creates standards and procedures on how we create and conduct surveys.
- Independently analyze and summarize findings and present data in formats such as excel pivots, power point, reports, dashboards, grids, and tables along with any suggestions or recommendations
- Other data related duties as assigned.
REQUIRED QUALIFICATIONS:
- 3-5 years of hands-on experience involving quantitative data analysis and complex problem solving
- Bachelor’s in Mathematics, Economics, Computer Science, Information Management, Statistics, or related field
- Must be organized and extremely detail-oriented
- Excellent problem-solving, communication, and time management skills
- Technical expertise regarding data models, database design development, data mining and segmentation techniques
- Demonstrated ability to analyze statistical da