Job Description :
Location: Austin, TX
Duration: 8-12 months
Process:
10 question “pre-test” (short, does not take too long)
Phone call or Skype with client (45 minutes)
ETL/SQL Developer
The position:
ETL Developer with a background in Data Warehousing to build out fully functional data pipelines and manage the data flow in and out their CRM platform. This is a CI/CD, highly scalable environment in AWS. This position will require both ETL experience and real-time data integration.
Responsibilities:
Extract, load and transform data from WeddingWire/XO and other sources to our DataWarehouse and datamarts for the consumption of our end users.
Design and develop solutions for integration between disparate systems which include cloud-based sources such as Salesforce and Exacttarget
Design and develop data models used for relational reporting tools such as Tableau, Birst, Domo, Qlik
Document data lineage and data model
Requirements:
?Programming experience and a demonstrated interest in statistical analysis, informatics, analytics, or business intelligence
?Minimum of 3+ years’ experience with SQL every day
?Hands-on experience with at least one of the following Databases (MYSQL, PostgreSQL, MSSQL, Redshift, Snowflake)
Scripting skills using shell, python or ruby, 3+ years
Experience with writing shell scripts, python, ruby or other language
Experience with at least one Business Intelligence tools such as Tableau, Birst, Domo, Qlik
Experience with at least one ETL tool such as Matillion, Talend, SSIS, Informatica
Excellent communication skills, both verbal and written.