Data Analyst/Engineer

Location: REMOTE

We are seeking a Data Analyst/Engineer who is passionate about delivering Data Analytics as a Service (DAaaS). In this role, you will bridge the gap between raw business requirements and technical data solutions. Working within the Azure ecosystem, Databricks, and the Microsoft stack, you will curate data, perform deep data exploration, prepare data for analytics, and deliver impactful Power BI visualizations. You will also act as a key consultative partner, translating functional customer needs into end-to-end data flows that ensure stakeholders have access to clean, reliable, and actionable insights.

Key Responsibilities

• Partner directly with functional customers to capture business needs., translating
• Serve as the bridge between technical teams and non-technical business leaders, ensuring alignment and clear delivery schedules
• Architect and maintain Power BI dashboards (and optional Tableau reports)
• Design and deploy custom business applications using Power Apps to streamline data collection, user inputs, and operational workflows
• Perform deep-dive exploratory data analysis using SQL and Python to identify trends and anomalies, ensuring data is fit for purpose
• Work within the Azure cloud environment (including platforms like ARES) to ensure secure, compliant, and optimized data hosting and processing
• Maintain rigorous data quality standards and technical documentation to ensure transparency and trust across all analytical products

Do you have what it takes?

We value consultants who are exceptional communicators, curious, persistent, and capable of articulating complex technical results to non-technical audiences. We look for experts who thrive in customer-facing roles, learn new business domains quickly, and enjoy mentoring junior analysts.

Required Skills and Experience

• 5+ years as a Data Analyst, Analytics Engineer, or Data Consultant
• Proven ability to work cross-functionally with functional customers, elicit requirements, and present complex findings clearly to diverse stakeholders
• Advanced proficiency in designing complex, high-performance dashboards, managing datasets, and publishing within the Power BI ecosystem
• Hands-on experience developing independent, functional business applications to solve data-entry or workflow challenges
• Hands-on experience building and managing automated data pipelines and performing analysis within the Databricks ecosystem
• Familiarity working within Azure cloud environments
• Hands-on experience with data marts, data warehouses, and medallion architecture
• Expert SQL skills for data transformation and Python for automating workflows and exploring large datasets
• Foundational knowledge of Generative AI and Large Language Models (LLMs), including how they can accelerate data analysis and automation tasks, as well as an understanding of their limitations, reliability, and responsible use
• Deep understanding of Delta Lake and cloud-based data warehousing concept
• Bachelor’s degree in a quantitative field
• Secret Clearance

Preferred Skills

• Hands-on experience with Tableau dashboard design and migration in addition to mandatory Power BI skills

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 www.ilwllc.com.

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.