Jonathan Shepard Email & Phone Number

Austin, TX, US

Dallas, Texas, US

-Delivered customized dashboards with KPIs for Board of Directors, C-suite, and equity partners. Custom-built requisite data sources in backend.-Interviewed and made hiring recommendations for new members of data analytics team.-Collaborated with product team to ingest new objects into data warehouse.

Dallas, Texas, US

• Led data analytics team, prioritizing tasks and ensuring that deliverables were completed correctly, and on time.
• Managed data modeling and architecture of entirety of end-to-end BI stack, including Mozart, Snowflake, Tableau Cloud.
• Prepared and analyzed high-level financial data for executive team, including C-suite and Board of Directors.
• Established and enforced standards for backend data sourcing (SQL) and Tableau dashboard development.
• Ensured that team deliverables were consistent with stakeholder requirements. Clarified and documented requirements as necessary.
• Provided mentoring and coaching to analytics team members.

Dallas, Texas, US

• Served as team lead, managing and delivering on incoming analytics requests end-to-end: collecting and clarifying requirements, assigning work to team members, developing custom transforms and reports, and QA'ing.
• Implemented full-scale data warehouse project rollout, including vendor selection, connector setup, data pipeline management, data transform development, and bug triage.
• Led customer segmentation analysis project; resulting data was used as key input in company valuation.
• Led team in successful rollout of agile project management; delivered over 180 completed tickets over the course of six months, including new dashboards, major projects, modification requests, ad hoc analyses, and bug.
• Improved operational efficiency and scalability to stakeholders by automating manual data management tasks.
• Served as data warehouse admin/manager and Tableau admin/account manager.

Austin, Texas, US

• Led and implemented cross-functional business process improvements across organization to optimize financial health and long-term scalability of technology partner program.
• Built out complex SQL queries to automate core business processes and answer ad hoc business questions.
• Generated comprehensive Tableau dashboards to monitor financial transactions and core KPIs acrossBigCommerce partner program. Presented findings to senior management.
• Spearheaded major revenue recoupment initiative across technology partner program portfolio, resulting inrecapture of over $1M to date. Authored audit findings, briefed senior leadership.
• Managed BigCommerce partner program commission payments and operationalized partner re-tiering project.
• Documented detailed requirements for Partner Experience Improvement Project.

Austin, Texas, US

- Coordinated cross-functional team response to metering issues, resulting in prompt issue resolution.- Analyzed billing and electrical metering data, manipulated raw data to produce Tableau dashboards for senior management team. Dashboards were subsequently used for project monitoring and task resolution.

Bellevue, US

• Identified causal pathway to enable clean data migration for data entities to be migrated to new client ERP system. Successfully mapped, extracted, cleaned, and transformed data from legacy systems to facilitate data.
• Worked with onsite client functional leads and remote technical consultants to test ERP functionality and ensure comprehensiveness of data migration.
• Successfully mapped hundreds of fields from legacy ERP system to destination ERP system.
• Ensured data quality and validation for several million records across dozens of data migration entities.
• Served as project manager for Global Data Synchronization Network project.

San Francisco, California, US

• Launched, configured, and actively managed hundreds of online ad campaigns on social media platforms. The campaigns brought thousands of new customers to the client company.
• Conducted campaign audits, analytics, and bid experiments to reduce expenditure on underperforming ad campaigns. Performed statistical analyses on campaign performance data, using findings to enhance campaign.

• Compiled a comprehensive research report on US aid and reconstruction projects in Iraq from 2003-2013. Data were collected from a diversity of information sources, reports, and contacts. Final report was provided to.
• Synthesized and organized geospatial data sets to create integrated project database, which was subsequently used to manage projects in ISIS-controlled zones.
• Designed first phase of research project to systematically examine the long-term effects of US-funded infrastructure projects in Iraq.

Washington, District Of Columbia, US

• Produced video content and other strategic communications products to promote USAID’s work in science and technology. Oversaw and directed contract with video production team. Video content was subsequently screened at.
• Managed design, award criteria, and outreach for agency-wide Science and Technology prize competition, which resulted in 86 prize entries from around the world. Prize winners were subsequently awarded additional.
• Created and managed social media portfolio.
• Served as primary liaison between technical scientific experts and public affairs officers for outreach and marketing campaigns.

Washington, District Of Columbia, US

• Provided ongoing technical expertise on project monitoring and evaluation to USAID field offices worldwide. Consultation allowed field staff to more effectively design, manage, and budget for project evaluations.
• Provided technical and operational liaison services between field staff and headquarters on project monitoring and evaluation. Provided policy guidance and technical expertise to field staff.
• Managed $125 million contract to provide evaluation services to USAID global field operations.
• Managed and oversaw provision of evaluation training to USAID staff, resulting in the training of over 500 staff from around the world.
• Organized and executed evidence summit on broad-based economic growth.
• Provided direct in-country technical assistance to USAID/Nepal and USAID/Iraq.

Washington, District Of Columbia, US

• Managed communications between overseas field mission and USAID/Washington
• Provided analytical and programmatic support to field mission
• Organized and participated in interagency working groups.

Washington, DC, US

• Produced interactive GIS maps to facilitate regional planning initiatives and strategically target programming. Used resulting geospatial maps to evaluate incoming grant proposals for eligibility and quality.
• Served as primary liaison to grantees to provide agency guidance on application processes.

Headed research team responsible for garnering, aggregating, and presenting comprehensive data on federal grant programs.

• Conducted comprehensive market analysis on the feasibility of exporting products to Latin America.
• Regularly liaised with congressional offices on matters of policy interest.

• Reviewed incoming draft manuscripts for quality and potential marketability.
• Edited unpublished manuscripts for translation into Japanese and publication on the Japanese market.

• Taught English to Japanese students of all ages.
• Collaborated with Japanese English teachers to produce original lesson plans.
• Planned and participated in a variety of international cultural exchange events.

Master Of Public Policy (Mpp), Public Policy

Certification, Data Science

Bachelor Of Arts (B.A), Policy Studies