Director Data Development, eMerges.com (you must presently reside within 6o miles of Annapolis, no exceptions)
Advanced Entry to Mid-Level ETL Integrator/Alteryx Developer
What is eMerges.com?
Incorporated in 2000, eMerges.com directly compiles, standardizes, and supplies 250 million public records including registered voter list files, watercraft registrations, aircraft registrations, campaign contributor files, hunting and fishing license holders, carry concealed weapon holder permits, and pilot licenses. We supply the data for permitted or non-restricted uses, which may include but is not limited to campaigns, congressional franking, law enforcement, legislatures, identity authentication, and fraud prevention entities. See eMerges.com use cases on the web site.
With growing revenue, eMerges is hiring a skilled ETL engineer. You will not be joining a team. You will be eMerges Director of Data Development and collaborate directly with the founder. There is no hand-holding you will be an autonomous worker. You are expected to have a thorough understanding of data integration and be very data-driven. Helpful if you are interested in voting issues, politics or identity validation and fraud prevention. >>Bonus points for strong knowledge of local and federal elections and voting.
Work Setting - The circa 1870 brick walled English basement office is in Annapolis, MD one block from the State Capitol. You must live within 60 miles of Annapolis although this position can be eighty percent remote after your first 120 days. There may be no strict requirement to continue work from the office on a daily basis after your first 120 days.
Develop and integrate databases using Alteryx data analytics and strategies that optimize quality. Identify, analyze, and interpret trends or patterns in data sets. Locate and define new process improvement opportunities for basic ETL goals -
DeduplicatingAggregatingJoining multi-filesMergingFilteringEnriching with longitude and latitudeEnriching USPS CASS address standardizationEnrich with census appendsSplittingMigrating transformed data to AWSGenerating summary metrics
Proven working experience as an entry or mid level data integrator extracting and transforming delimited or fixed field source datasets and loading records to target fixed field data formats. No degree is required if you have proven aptitude in data science. Technical expertise regarding data models, database design development, data mining and segmentation techniques Adept at data transformation, queries, report writing and presenting findings on large 200 gb datasets not just little MS excel reports.
>>Bonus points for strong knowledge of local and federal elections and voting.
Start with these very basic initial ETL needs:
managing fixed field or delimited text filesjoining two or more files using uniquecomparing two files and appending data from file 1 to file 2date conversions to YYYYMMDD'camelback' and lower case conversionsremove numbers or letters in a stringtrim spaces off stringsusing string length for multiple functions such as discardaddress and name parsingconversion of number values to English words
Experience you should have includes any combination of two or more of:
ETL Data Integrator: 2 yearsAlteryx Data Manager: 2 yearJavelin Clover DX - 1 year is helpful for transition
Your home residence must be within 60 miles of Annapolis. But you will be 80-100% Remote after your first 120 days. Bonus, PTO. Flexible schedule Schedule: Monday to Friday or whatever works to get the job done. Job Type: Full-time, Part-time, Contract - Pay: $50.00 - $110.00 per hour