BI Engineering Lead/Architect in Naperville, IL at Prestige Staffing

Date Posted: 4/29/2021

Job Snapshot

Job Description

JobID: 29983

Primary Responsibilities

As a BI Engineering Lead, you will have the opportunity to make a significant impact on the success and growth utilizing your business acumen, analytic mindset, and strong communication/people skills to extract business requirements, establish data pipelines, and create user-facing dashboards and applications.

You will also be responsible for the design of the data warehouse data/information architecture, which maps to the data warehouse architecture and balances the need for access against security and performance requirements.

This position provides strategic enterprise data technical vision (3-5 years out) while directing immediate tactical data architecture initiatives. Additionally, the position will ensure the overall quality of technology data implementations across multiple domains, including data management, data integration, data quality, data reporting, and data analytics supporting multiple business units, development and operations managers, and their teams.

Essential Functions

  • Owns the Solution Architecture and ensures best practices and internal processes are followed when solutions are designed and implemented
  • Architecting analytics solutions for usage at scale by utilizing distributed computing as needed
  • Ability to work on multiple projects and tasks with overlapping time frames and facilitate construction of 90 day forecast
  • Collaborate with cross-functional teams for effective management of the DW/BI environment.
  • Identify data sources, provide data flow diagrams, and document source to target mapping and process.
  • Design and develop SQL for large complex ETL jobs and conduct related database maintenance
  • Propose innovative SQL Server Analysis Services tabular models for solving ambiguous business problems
  • Develop data models and data pipelines in AWS cloud environment leveraging data lake and Redshift
  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning, aggregations etc.
  • Design, develop, and maintain intuitive, scalable reports, dashboards, and metrics using Microsoft reporting platform
  • Recognize and adopt best practices in developing analytical insights including data integrity, analysis, test design, validation, and documentation.
  • Proactively promotes data quality and security through recommended approaches and practices
  • Lead and coordinate implementation activities
  • 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

Minimum Requirements, Qualifications, Additional Skills, Aptitude

Supervisory Responsibility

This position has the opportunity to manage employees from entry to mid-level product professionals. Teams are responsible for prioritizing, designing and delivering features for software products in an agile development environment. This includes but is not limited to roles such as product owners, business analysts, data modelers, data scientists, and BI engineers.

Job Requirements:

  • You hold a Bachelors and/or Masters degree from an accredited university in one of the following disciplines: Computer Science, Information Systems, Operations Research, Mathematics, Statistics, or related technical field.
  • 10+ years of direct experience using databases, including Oracle, MySQL, or SQL Server
  • 10+ years hands-on experience developing with SQL, PL/SQL, SSIS, SSAS (Tabular), PowerBI
  • Ability and experience in leading teams
  • Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
  • Strong experience with business intelligence and data warehousing design principles and industry best practices including multi-dimensional modelling (star schemas, snowflakes, de-normalized models, handling “slow-changing” dimensions)
  • Cloud architecture experience, preferably in AWS (Azure or Google will also be considered)
  • You recognize the value of wearing multiple hats but also know how to play to your strengths and collaborate with your team.
  • Expert knowledge on T-SQL / DAX
  • You are articulate and concise
  • You are proactive and resourceful with a drive to match

Preferred Qualifications:

  • Knowledge of modern development techniques: Agile (Scrum, Kanban)
  • Experience with automation using but not limited to Java, C#, Python, Pyspark
  • You have an intrinsic curiosity for tinkering with data products.
  • You recognize the importance of data storytelling.
  • You think AI & machine learning is pretty neat.