Location and Travel Details: Remote
The key responsibilities of the Data Engineer include:
- Work closely with data architects to ingest, integrate, and prepare database structures needed for reporting, analytics, and visualizations
- Develop and maintain ETL pipelines
- Translate existing transformations and business rules into new ETL code
- Involved in the ETL process and must be motivated to be collaborative with the team members to understand and implement data requirements
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.
Key skills for this position include:
- Experience with Azure Data Factory
- Expert in ETL development and pipeline builds
- Ability to translate business rules and functional transformation into code
- Exposure to a variety of database such as Teradata, Azure SQL, Oracle and Postgres
- Understanding of DDL, DML, DCL and stored procedures required
- Experience integrating data from a variety of data source types
- Understanding of optimal data strategies for data 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:
- Experience with Teradata BTEQ
- Database design, principles and best practices
- Data modeling, schema development, and data-centric documentation
- 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.