Senior Data Engineer

Lucid is a software company delivering the power of human answers on a massive scale. We built Fulcrum, the first global marketplace for market research sample (that means human beings who answer questions), and introduced programmatic buying and selling to the market research industry. We also created Federated Sample, a full-service sample provider that, using our proprietary technology, empowers our clients to do world-class market research.

The Senior Data Engineer will join our Engineering team in New Orleans, and work closely with our Business Intelligence and Corporate Business Operations teams. You have extensive experience designing schemas, report generation and turning data in to business value. You know SQL inside and out. Looking to expand your skill set to include Cassandra, Amazon Redshift, Apache Kafka, Apache Spark, and any other helpful tool you may discover. This is the opportunity you’ve been looking for.

* Collaborate with business units to translate challenges and opportunities into data warehousing/ETL and Stream Processing projects * Analyze source systems including internal systems and API integrations * Design and implement ETL systems to source data into Data Warehouse and OLAP DBs * Perform SQL query performance tuning * Aid in creation of dimensionally modeled data warehouse * Maintain, update, and create new SSIS packages * Build out self-service BI applications including Power BI * Create and maintain reporting environment to support client-facing reports embedded in custom applications

**Qualifications** * 3+ years of experience in development with a focus on ETL and data warehousing * Strong knowledge of dimensional data modeling/star schema * Strong knowledge of SQL including the ability to analyze execution plan for performance tuning * Ability to identify and implement new tools as projects dictate * Experience creating views and stored procedures for supporting various reporting applications * Experience with source control systems including Github * Continual learner, always looking for a new and better way to solve a problem **Preferred Qualifications** * AWS experience with Redshift, EMR, and Elasticsearch * Experience with NoSQL data sources including Cassandra * Experience with SQL Server 2014, In-Memory tables, DAX, MDX and Power BI * Experience with Apache Spark * Experience creating Data Lakes