Lead Business Intelligence Engineer - REMOTE

Naperville, Illinois

100% Remote

Full Time

$135k - $150k

We have partnered with a premier client to fill a full time employee -100% remote position. This is a great opportunity to expand your career and work with a well known company and look towards career growth.

Are you a Lead Business Intelligence engineer who is passionate about consulting with all levels of internal stakeholders? Are you incredible with the following technologies: SQL Server, SSIS, SSRS, SSAS, AWS (Lambda, S3, Redshift or Athena), Glue, Python, Data Modeling and most importantly, thrive in a team environment? Are you extremely collaborative and enjoy working with your teammates to impact positive change? Are you looking for your next career opportunity? This position may be for you.

Required Skills & Experience

  • AWS - Redshift or Athena (must have Lambda, Glue, and S3 knowledge)
  • SQL - Strong background with SSIS, SSAS, SSRS
  • Python - must be able to understand, review, and work with the business (coding is a STRONG plus)
  • Data Modeling
  • Glue
  • Looking more data engineering skills (rather than data modeling)
  • Must have 10+ years experience in IT - preferably in cloud architecture (AWS), developing with SQL, SSIS, SSAS, SSRS, PowerBI, Python
  • NOTE: Tech stack for this role, it will be focused more on AWS (S3, Redshift, Lambda, Microservices, DaaS, Python, PySpark, big data, DMS, etc..)
Desired Skills & Experience
  • Previous management / mentorship experience
  • Data Warehouse experience
  • Power BI
  • PL/SQL
  • C#
  • Supply Chain experience

What You Will Be Doing

  • Demonstrated ability to partner with internal product stakeholders to help define requirements and outcomes for data-focused initiatives
  • Ability to decompose large problems and execute smaller, manageable bodies of work to demonstrate continuous architecture delivery
  • Architecting and managing scalable data pipelines across on-premise and cloud data repositories
  • Create data flow diagrams, and document source to target mapping
  • Utilizing their business acumen, analytical mindset, and strong communication/people skills to extract business requirements and translating them into actionable tasks
  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning, aggregations etc.
  • Create user-facing dashboards that provide key insights at a glance for its specific audience
  • Recognize and adopt best practices and cost effective solutions in developing analytical insights on prem and in the cloud
  • Provide guidance and mentor junior team members
  • Keep current with Business Intelligence data trends and technological innovations
  • Execute on POC’s with new technologies, drive innovation, and new ideas

The Offer

  • Medical Insurance
  • Dental Benefits
  • Vision Benefits
  • Paid Time Off (PTO)

Applicants must be currently authorized to work in the US on a full-time basis now and in the future.

Posted by: Aaron Rontal

Specialization: Business Intelligence