Data Engineer

Job Description: Data Engineer

Camelot is looking for the best and the brightest to join our rapidly growing team.

Our work environment is very fast-paced and entrepreneurial. Camelot is looking for a talented, highly motivated individual with an analytical mind and a solid quantitative grounding to join our organization. You will work closely with data architects, other data engineers, data scientists, and business leads to build out new datasets for analytical functions. 

*No location restrictions on this role.  Camelot is headquartered in Dallas, Texas with remote employees across the country.

Role:

Do you see patterns everywhere you look? Do you have a passion for solving complex problems simply? Camelot’s data team is expanding and looking for a person with hands-on experience designing, building, and maintaining enterprise-class data analytics solutions supporting a wide range of end user requirements from simple reporting to ML. Camelot frequently participates in alpha/betas in the latest big data/cloud solutions that focus on marketing and media industry. Camelotians are “hands-on” in both establishing the strategic direction of our services and solutions but are then actually implementing the plan. 

What you'll do: 

• Take business requirements and produce data sets for efficient cross-business analysis
• Execute architected techniques and solutions for data collection, ingestion, management, aggregation and usage 
• Extreme focus on detail and data quality validation
• Deep interest in the data and analytics market with the ability to creative in solving data integration and delivery problems
• Design, deploy and integrate process-specific data models feeding a wide range of reporting/insights/activation data sets.
• Using tools like Alteryx, Tableau, DBT and platforms like Snowflake create innovative data solutions for media/marketing teams optimization processes

What we need (Position requirements): 

• Minimum 4-6 years of recent, progressive experience and demonstrable technical expertise in enterprise-class data analytics solutions and services. Including advanced skills in areas such as Data Modeling, Integration, Storage, Indexing, Security, Logging, Data Quality, Master Data Management, and Archiving.
• Minimum 2 years of recent experience in enterprise-class data analytics architecture, including enterprise and solution architecture assessment/definition, and significant depth in two or more data analytics solution architecture components (i.e., data management, data integration, information delivery, and/or advanced analytics)
• Experience designing logical and physical data models utilizing ERDs, data pipelines and workflow documentation
• Proficiency in all aspects of SQL (complex joins and aggregations, stored procedures, functions, triggers) (5 years).
• Experience with architecture and applications on or incorporating cloud infrastructure-, platform-, and/or software as a service (particularly data analytic solutions on Amazon AWS, Microsoft Azure, or other cloud platforms and service providers)
• Experience with Alteryx (Designer/Server) or similar, DBT, and cloud-based storage/databases/data-warehouses (Redshift, Snowflake, etc.) 

What we look for:

• Passion and dedication
• Desire to be the best
• Ability to work both independently and as part of a team
• Strong interpersonal communication skills - written and verbal
• Strong Quantitative Reasoning and Pattern Recognition ability
• Proven track record of problem-solving
• “Common sense” business approach (ability to balance real world with the theoretical)

What we offer you in our Benefits and Perks Programs:

• Camelot strives to create collaborative environments that are both inclusive and diverse, allowing for all Camelotians to share their unique talents.
• We endeavor to provide the tools and support for all Camelotians to help them excel at their professional growth and to continue learning in their area of expertise through self-elected programs and courses and certifications.
• We encourage and support a healthy lifestyle for all Camelotians, and to that end, we offer a competitive compensation package, which includes both mental and physical health programs. As part of our suite of health benefits, we provide employer-paid health coverage via Blue Cross Blue Shield for all full-time employees and offer competitive discounted dependent plans for employees to take advantage of.   Additionally, we offer employer paid dental coverage, life insurance, long-term disability insurance, and individual disability insurance (employees can also opt into the employer-sponsored dependent plans if desired.)
• Above our Health benefits, we also offer a 401(k)-matching programming at 10% for all Camelotians to take part in.
• We additionally offer free access to great tools and company-sponsored activities for all to take advantage of including Mindfulness sessions; yoga and virtual pilates classes; and many other discounts for health training and equipment.
• We are committed to inclusiveness, equity, and accessibility. We encourage all qualified candidates to apply.