James Harrold

Experience

• 

  University of Nebraska - Lincoln Housing Office

  Jun 2009 - May 2010

  Resident Assistant

  My primary duty as an RA is to be an on-site assistant to the residents of my floor. My purpose is to be available to answer questions, provide directions, give informal advice, and mediate conflicts. I am directed to develop good interpersonal relationships with those on my floor who willingly reciprocate my efforts and simply make a continual effort to keep those residents who prefer their privacy informed of goings-on on the floor. Two of my most important duties are weekly floor events and bi-weekly All-Hall events. Floor events are social events I arrange with as many of my residents as can attend to get everyone together, with an eye towards building a stronger floor community. All-Hall events are larger, collaborative events in which I participate with a team of RAs to bring together as many residents as possible in our dormitory complex in order to promote inter-floor social interaction. We are given a firm budget of 100 dollars and an edict that each All-Hall must be unique.My final duties include monitoring the hall for safety, enforcing housing rules, checking to make sure no resident is going through any major personal or educational difficulties without being offered help, and doing a full twelve duty nights in which I and another RA walk through all the halls at least twice in a night, interact with residents, check for damages, and keep an eye out for any violations of dorm rules. As an RA, I am considered the first resource for any resident on my floor with any difficulties. (Supervisor: Carmen Binder. Phone: 402-472-5346) Show less

• 

  Project Vote Smart

  May 2011 - Jan 2012

  VoteEasy Research Intern

  - Researched the public statements, voting records, and other information on members of Congress to determine their stances on various issues.- Heavy Excel use for keeping track of research on hundreds of candidates.

• 

  University of Nebraska Medical Center

  Feb 2012 - Sept 2012

  Health Survey Caller

  - Called Nebraskans across the state and persuaded them to participate in a public health study.- Collected and entered information on a wide range of health behaviors used by the DHHS to track health trends in Nebraska.

• 

  Project Vote Smart

  Sept 2012 - Mar 2014

  Researcher and Office Manager

  - Conducted political research, tracking candidates for office and elections as well as researching policies and court decisions.- Provided training and leadership for teams of research interns, tracking their KPIs and providing regular feedback on progress.- Coordinated internship recruitment and management, HR policy, staff recruitment and hiring.- Tracked office spending, payroll, and managed an API-based data sharing program developed internally and used by third-party partners.

• 

  NationBuilder

  Jul 2014 - Jan 2018

  Data Services Engineer

  - Working with myriad datasets, from statewide electoral files to intensely local datasets and shapefiles, many different kinds of mailing, financial, CRM, and membership data.- Data integrity and repair work using Ruby, Trifacta, and SQL/Postgres.- Implemented custom solutions to customer issues via Ruby on Rails platform fixes.- Worked on a team that built an ETL pipeline for a database of over 200 million records, constantly updated from dozens of diverse sources, using custom data standards developed for our customer's needs.- Managed data acquisition, extraction, and transformation for this database, using a mix of Excel wizardry, Ruby/Python automated tasks, and ETL pipeline software to standardize and load data.- Statistically driven and research-based data integrity assurance for customer assets.- Building and testing statistical analyses of electoral events for product development.- Worked as the intermediary between sales representatives and software engineers to help onboard or assist customers with large, complex product implementations that pushed our application's limits and helped us implement product improvements to meet customers' needs. Show less

• 

  California Special Districts Association

  Feb 2018 - Jun 2021

  Database and Online Communities Coordinator

  - Generating iMIS IQAs and SQL queries to identify bad data and poor practices among staff for data entry and iMIS use. The IQA tool is iMIS's point-and-click query builder that runs on SQL.- Reviewing tables/views in SQL Server and making sure various pieces of automation are fulfilling their intended purposes. We have had multiple consultants from different technology partnersmaking database changes needed for our third-party services to operate; investigating and documenting this work and implementing occasional tweaks for better performance are part of my duties.- I have written pages and pages of documentation capturing the specifics of my job (which did not exist before I was hired) so that a future hire will be able to hit the ground running- Working with leadership on managing projects and defining success for new metrics, new data-based products, and database changes/upgrades.- Educating coworkers and new hires on standard procedures and best practices for working with the database.- Keeping myself up to date on our CRM's updates and product improvements as they are rolled out.- Continuing to improve my SQL skills through problem-solving and database maintenance.- I have generated dozens of reports and specialized dashboards covering email analytics, data integrity metrics, membership metrics, team and project KPIs, etc.- Developed custom ETL processes using Excel wizardry, SQL and Python to merge data from third-party sources into our database in order to help CSDA enhance our targeted marketing and communication efforts. Show less

• 

  Covered California

  Jul 2021 - now

  Data Process Management Lead

  I help my team build, deploy, and maintain data delivery services/pipelines. We serve many different departments who exist within a complex hybrid database environment (Snowflake/AWS SQL Server/SAS/a wilderness of Excel documents). My team is responsible for understanding, documenting, automating, and maintaining our customers' business processes, from ETLs to data analysis and report design.Tools my team uses:- Azure DevOps for tracking work, hosting our Git repository, and storing our documentation- AWS-hosted SQL Server environment with hundreds of tables, stored procedures, views, and jobs.- SQL Server Integration Services for getting things from point A to point B with whatever transformation is required along the way.- Mulesoft to slowly phase out SSIS in favor of a solution that fits our needs better and leverages the advanced API capabilities of platforms like Salesforce that we use heavily.- Python for pre-processing and phasing out C# solutions.- Snowflake to slowly phase out our SQL Server and meet the needs of our data-hungry data science teams.- Tableau for all report delivery and the steady replacement of years of Excel cruft.- Miro, to visualize data flows and other complex concepts.- Most importantly, lots of meetings and communications to manage our relationships with customers. Show less