Data Engineer/Analyst

• Collaborate with the data team to automate the Extract, Transform, Load (ETL) process using Azure Functions and Python
• Utilize Python scripting and core data libraries (e.g. Pandas, SQLAlchemy, pyodbc) to optimize data processing and analysis
• Act as data steward by governing and accounting for inbound and outbound datafeeds, coordinating with interorganizational stakeholders
• Leverage PySpark and Spark SQL in Databricks to architect and maintain big data ETL processes
• Implement data lineage, logging, and auditability preferably with exposure to Azure Log Analytics and Application Insights
• Operate within the government version of Azure, adapting to its specific features and requirements
• Maintain and develop BI dashboards with tools like Qlik and Plotly
• Work effectively both independently and as part of a team, demonstrating strong collaborative skills
• Proactively seek to understand the underlying data and the business logic it supports, contributing to informed data analysis and decision-making
• Navigate cross-functional collaboration, bridging infrastructure, developer, and end-user needs to translate requirements into technical solutions

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.

• Must have existing Secret Clearance
• 3+ years of experience as a Data Analyst/Engineer, with a focus on Python scripting, SQL and ETL processes
• Familiarity with Azure Functions and Azure Log Analytics, or similar technologies
• Strong analytical skills and a keen interest in understanding data in a business context
• Excellent interpersonal skills
• Existing CompTIA Security+ certification or ability to acquire
• Minimum education: Bachelor’s degree in Computer Science, Data Science or Analytics, Applied Mathematics, Information Systems, Software Engineering, or comparable academic discipline
• Acceptable candidates must successfully pass a drug test and background screen

Pulled from the full job description

• 401(k)
• Health insurance
• Paid time off
• Vision insurance
• Dental insurance
• Life insurance
• Disability insurance, 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.

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, data engineering, software engineering, and cloud design. We are 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. Check out our website to learn more at www.ilwllc.com.