Data Engineer/Analyst at Illumination Works LLC Hill Air Force Base, UT

Illumination Works LLC

Riverdale (UT)

Hybrid

USD 90,000 - 120,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Illumination Works is hiring a Data Analyst/Engineer to join our Hill Air Force Base team in Utah. The role blends hands-on data engineering with analytics, focusing on ETL automation via Azure Functions and Python, and governance of data feeds.

You will build and maintain big data pipelines using PySpark and Databricks, and support BI dashboards with Qlik and Plotly. Required: 3+ years in data analytics/engineering, Python/SQL, Azure Log Analytics, and a Bachelor’s degree in a related field.

Qualifications

  • 3+ years of experience as a Data Analyst/Engineer with Python, SQL and ETL
  • Existing Secret Clearance
  • Familiarity with Azure Functions and Azure Log Analytics or similar technologies
  • Strong analytical skills and ability to understand data in a business context
  • Excellent interpersonal skills
  • CompTIA Security+ certification or ability to acquire it
  • Minimum education: Bachelor’s degree in Computer Science, Data Science or Analytics, Applied Mathematics, Information Systems, Software Engineering, or comparable discipline

Responsibilities

  • Collaborate with the data team to automate ETL using Azure Functions and Python
  • Use Python scripting and data libraries (Pandas, SQLAlchemy, pyodbc) to optimize processing and analysis
  • Act as data steward governing inbound/outbound datafeeds with stakeholders
  • Leverage PySpark and Spark SQL in Databricks to architect and maintain big data ETL processes
  • Implement data lineage, logging, and auditability (Azure Log Analytics and Application Insights)
  • Operate within government version of Azure and adapt to its features
  • Maintain and develop BI dashboards with tools like Qlik and Plotly
  • Work independently and in a team, communicating results to diverse audiences
  • Bridge infrastructure, developer, and end-user needs to translate requirements into solutions

Skills

Python scripting
SQL
ETL processes
Analytical skills
Interpersonal skills

Education

Bachelor’s degree in Computer Science or related field

Tools

Azure Functions
Azure Log Analytics
Databricks
PySpark
Spark SQL
SQLAlchemy
pyodbc
Qlik
Plotly

Job description

Job Description Job Description Location and Travel Details: Hybrid Onsite 2-3 days a week at Hill Air Force Base (Ogden, UT) Illumination Works is looking for a Data Analyst/Engineer to join our dynamic team at Hill Air Force Base, Utah, where we specialize in innovative data solutions and analytics. We are committed to leveraging technology to enhance data processing and insights, contributing to our strategic goals and mission effectiveness. This role involves a blend of technical expertise and collaborative skills, working in a hybrid environment to optimize data processes and contribute to our data-driven objectives.

The key responsibilities include:
  • 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.

Key skills we look for include:
  • 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

About ILW

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

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.
Commitment to Non-Discrimination

All qualified applicants will receive consideration for employment without regard to disability, status as a protected veteran, or any other status protected by applicable federal, state, local, or international law.

Know Your Rights Poster E-Verify Participation Poster (uscis.gov)

Accommodations

If you are an individual with a disability and would like to request a reasonable workplace accommodation for any part of our employment process, please contact the Human Resources Staff by sending an email to ILW_HR@ilwllc.com. This option is reserved only for individuals who are requesting a reasonable workplace accommodation. It is not intended for other purposes or inquiries.

Notification for current or previously cleared professionals:

Official U.S. Government information appearing in the public domain shall not automatically be considered UNCLASSIFIED or approved for public release. ILW recognizes that information contained in resumes of current or previously cleared professionals may be sensitive, containing potentially proprietary and/or protected information. Protected Information is considered classified, in the process of a classification determination, or unclassified, but protected by statute. Therefore, all resumes should be approved for public release by a U.S. Government Official with Original Classification Authority, prior to posting the resume to ILW's applicant tracking system.

By submitting my resume, I understand that I am NOT authorized to upload content with Official U.S. Government information that is considered, sensitive, proprietary, or protected.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineering & Visualization Specialist
Data Engineering & Visualization Specialist

Illumination Works LLC. • Utah

Hybrid
USD 120,000 - 160,000
PTO
Health insurance
401K
+1
Data Services Developer
Data Services Developer

Illumination Works llc • United States

Remote
USD 90,000 - 120,000
Medical Insurance
Dental Insurance
Vision Insurance
+2
Data Scientist/ Data Engineer
Data Scientist/ Data Engineer

Illumination Works llc • United States

Remote
USD 120,000 - 180,000
Market salary
Generous PTO
401K
+2
Data Scientist
Data Scientist

Illumination Works LLC. • Idaho

Remote
USD 120,000 - 180,000
Information System Security Officer (ISSO)
Information System Security Officer (ISSO)

Illumination Works LLC. • United States

Remote
USD 110,000 - 160,000
Remote ISSO — RMF/ATO & Cloud Security Lead
Remote ISSO — RMF/ATO & Cloud Security Lead

Illumination Works LLC. • Idaho

Hybrid
USD 110,000 - 160,000
Data Scientist
Data Scientist

Illumination Works • United States

Hybrid
USD 90,000 - 120,000
Market competitive salary
Generous PTO package
Comprehensive medical, dental, and vision insurance
+2
Hybrid Data Engineer & Analyst (Azure, PySpark, ETL)
Hybrid Data Engineer & Analyst (Azure, PySpark, ETL)

Illumination Works LLC • Riverdale (UT)

Hybrid
USD 90,000 - 120,000
Senior Data Engineer (Clearance Required) - Remote US
Senior Data Engineer (Clearance Required) - Remote US

ICF • Reston (VA)

Remote
USD 140,000 - 180,000
Data Engineer
Data Engineer

L3Harris • Salt Lake City (UT)

On-site
USD 110,000 - 150,000