Databricks Engineer

Location and Travel Details: Dayton, Cincinnati, or Columbus preferred, Remote considered

Do you have what it takes? Are you driven to implement creative solutions that unravel complex and ever-changing challenges? We value passion, curiosity, and perseverance with an ability to communicate ideas and results to diverse audiences. We look for people who thrive in collaborative and independent assignments, have the aptitude to learn new data quickly, and who are willing to mentor junior team members.

Required skills for this position include:

• Strategic data architecture and data modeling with structured and unstructured databases
• Experience with DDL, DML, DCL and stored procedures with relational databases required, Postgres preferred
• Experience with Databricks and enterprise cloud databases
• Database design, principles and best practices
• Data modeling, schema development, and data-centric documentation
• Configuring Delta Lakes and Delta Tables, managing data ingest, access, and performance tuning
• Experience configuring workflows and jobs within Databricks. Experience with Apache Airflow is desired
• Ability to work closely with data architects to ingest, integrate, and prepare database structures needed for reporting, analytics, and visualizations
• Develop and maintain ETL pipeline
• Involved in the ETL process and must be motivated to be collaborative with the team members to understand and implement data requirements
• Experience with Cloud (AWS)
• Experience integrating data from a variety of sources
• Recommend and advise on optimal data strategies for ingestion, integration, and visualization
• Experience improving code performance and query optimization to meet demanding data analytics and visualization needs
• Outstanding problem-solving skills
• Excellent verbal and written communication skills and ability to interact professionally with a diverse group, executives, managers, and subject matter experts
• Minimum education: Bachelor's degree in Computer Science, Mathematics, or comparable academic discipline
• Minimum experience requirements: five years of experience required
• Must have or be willing to obtain Secret Clearance (this requires US Citizenship)
• Acceptable candidates must successfully pass a drug test and background screen

Desired Experience:

• Python
• Linux
• Knowledge of Air Force supply and logistics systems

A little more about us. At Illumination Works, we know data, and we should, we've been doing it since we started in 2006! We specialize in everything data from big data to data science, software engineering, data management, AR/IoT, and cloud development. Illumination Works is a trusted technology partner in user-centered digital transformation-delivering impactful business results to clients. We partner with customers to solve their unique technology and data challenges, and stay on top of modern technologies and advancements leveraging our Innovation Lab.

Why choose us?We invest in our employees in all aspects of their life and we value family. We offer market competitive salary, a generous PTO package, and comprehensive medical, dental, vision and life insurance plans. We also offer 401K, short/long-term disability insurance, a fun and engaging culture, and training opportunities to keep you up to speed on the latest technologies.

Illumination Works is committed to hiring and retaining a diverse workforce. We are an Equal Opportunity Employer, making decisions without regard to race, color, religion, sexual orientation, gender identity or national origin, age, veteran status, disability, or any other protected class. Acceptable candidates must successfully pass a drug test and background screen.