Data Analyst/Engineer

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., * 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.

Do you have experience in Tableau?, Do you have a Bachelor’s degree?, * 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

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.