BI Developer, Analytics

Lensa; Chicago (IL); On-site; USD 94,000; Full time

Job summary

A dynamic digital agency in Chicago is seeking a BI Developer to design, develop, and analyze data solutions. The ideal candidate will possess a Master's in a relevant field and have proficiency in Python, SQL, and Tableau. This full-time role involves collaborating with stakeholders to meet business objectives and drive innovation in BI practices.

Benefits

Medical coverage

Dental and vision insurance

401K plan

Flexible time off

Tuition reimbursement

Qualifications

• Master's degree plus 2 years experience.
• Experience with SQL, Tableau, and Python required.
• Proficiency in data modeling and ETL processes.

Responsibilities

• Design and develop BI solutions and dashboards.
• Analyze data sets for business insights.
• Collaborate with stakeholders to deliver BI solutions.

Skills

Data Analysis

SQL Optimization

Data Visualization

Python Programming

ETL Processes

Team Collaboration

Education

Master’s degree in Computer Science or related field

Tools

Python

Tableau

PowerBI

SQL Server

Job description

1 week ago Be among the first 25 applicants

Lensa is the leading career site for job seekers at every stage of their career. Our client, Publicis Groupe, is seeking professionals in Chicago, IL. Apply via Lensa today!

Company Description

At Publicis Collective, we know tomorrow’s challenges won’t be solved by today’s solutions. It’s why we support our teams with the resources and tools they need to continue redefining the future of marketing. It’s also why clients rely on us to lead the way in connecting media, data, technology, and teams by what matters most – business outcomes.

Publicis Collective’s consultative practitioners are catalysts for business growth and innovation, we’re more than media experts. We are an incubator for high-performing talent and a launchpad for ideas that push the boundaries of what’s possible.

As part of the global Publicis Media network, we’re backed by the power, scale, and benefits of Publicis Groupe, one of the largest and most celebrated marketing and communications platforms on the planet.

How are we different? There are three core values at the center of our approach that help us stay ahead – curious, open, and driven.

Curious - A deep curiosity compels us to go beyond the brief to deliver exceptional outcomes.

Open - We value diverse perspectives and new ways of working.

Driven - We are ambitious, rigorous, self-disciplined, and resilient in our pursuit of excellence.

If you're a collaborative and enterprising practitioner with a passion for media and a desire to make a real impact, we want to hear from you.

Let's shape the future together.

Overview

Employer: VNC Communications, Inc. dba Performics

Job Title: BI Developer, Analytics

Job Requisition: 6630.6529.6

Job Location: 35 West Wacker Drive, Chicago, IL 60601. Required to work from Company Office (Chicago, IL) certain days per week. Telecommuting allowed for balance of week.

Job Type: Full Time

Rate of Pay: $93,974 per year

Actual compensation within the range will be dependent upon, but not limited to, the individual's skills, experience, qualifications, location, and applicable employment laws.

Responsibilities

Duties: Design and develop solutions to complex applications problems, system administration issues, or network concerns. Involved in building and preparing data sets that involve extract, transform, and load processes from various sources, transform it into a usable format and load it into data warehouses or BI platforms. Design and develop interactive dashboards and reports to visualize data in a user-friendly manner. Analyze data sets to identify trends, patterns and insights relevant to business objectives. Create and maintain data models to structure and organize data for efficient analysis and reporting. Write and optimize SQL queries to retrieve data efficiently from databases, ensuring optimal performance of BI solutions. Collaborate with stakeholders, including business users, data analysts and other teams to understand data requirements and deliver BI solutions that meet business needs. Identify and resolve issues related to data quality, integrity and performance in BI solutions. Document data sources, data definitions, ETL processes and BI solutions to ensure clarity and maintainability. Perform test and validate BI solutions to ensure accuracy, reliability and adherence to business requirements. Emerge BI technologies, best practices and industry trends to continuously improve BI solutions and processes.

Qualifications

Requirements: Employer will accept a Master’s degree in Computer Science, Information Systems, Engineering or related field and two years of experience in the job offered or two years of experience in any occupation in which the required experience was gained. Position also requires one year of experience in each of the following:

• Build and maintain Extract, Transform, Load (ETL) processes to extract data from various sources transform it into a usable format, and load it into data warehouses using Python and Jupiter Notebook.
• Design and develop interactive dashboards and reports to visualize data in a user-friendly manner using Tableau and PowerBI.
• Analyze data sets to identify trends, patterns, and insights relevant to business objectives using Python libraries such as Pandas, NumPy, Scikit-learn.
• Write and optimize SQL queries to retrieve data efficiently using Microsoft SQL Server ensuring optimal performance of BI solutions.
• Communicate with business users, stakeholders, other teams, to understand data requirements and deliver BI solutions that meet business needs using MS teams, Python, SQL, Tableau.
• Identify and resolve issues related to data quality, integrity, and performance in BI solutions using advanced Excel.
• Proficient in developing and implementing data models for new and existing databases to support business processes and applications.
  
  

Required to work from Company Office (Chicago, IL) certain days per week. Telecommuting allowed for balance of week.

Additional Information

Our Publicis Groupe motto “Viva La Différence” means we’re better together, and we believe that our differences make us stronger. It means we honor and celebrate all identities, across all facets of intersectionality, and it underpins all that we do as an organization. We are focused on fostering belonging and creating equitable & inclusive experiences for all talent.

Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off.

If you require accommodation or assistance with the application or onboarding process specifically, please contact [e-mail].

All your information will be kept confidential according to EEO guidelines.

Seniority level

• Seniority level

  Entry level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Lensa by 2x

Get notified about new Business Intelligence Developer jobs in Chicago, IL.

Chicago, IL $149,760.00-$216,320.00 4 weeks ago

Chicago, IL $61,500.00-$162,500.00 1 week ago

Chicago, IL $61,500.00-$162,500.00 1 month ago

Chicago, IL $61,500.00-$162,500.00 1 month ago

Business / Data Analyst (Assistant Vice President)

SENIOR BUSINESS APPLICATION PROGRAMMER ANALYST

VP, Senior Commercial Business Intelligence Analyst

Chicago, IL $95,000.00-$105,000.00 3 days ago

Business Analyst/Enterprise Data Management

Oak Brook, IL $97,700.00-$184,175.00 2 weeks ago

Information Management Analyst, Data Enablement

Chicago, IL $90,000.00-$120,000.00 6 days ago

Senior Analyst, Data Integrity Procure to Pay

Deerfield, IL $79,300.00-$127,000.00 3 days ago

Sr. Data Analyst (W2 ONLY) - Contract - Hybrid - Chicago, IL

Business Analyst with Knowledge in Financial Data Exchange - FDX /DDA API .

Human Resources Information Systems HRIS Data Analyst II

Chicago, IL $95,000.00-$100,000.00 5 days ago

Tax Data Analyst - Business Tax Advisory - Quant Services - Manager - Multiple Positions - 1599377

Temporary Business Analyst – Data & Process Optimization (Financial Services)

Chicago, IL $132,500.00-$302,400.00 1 week ago

Business Intelligence Developer (BI Developer)

Chicago, IL $100,000.00-$130,000.00 20 hours ago

Chicago, IL $110,000.00-$120,000.00 1 hour ago

Chicago, IL $104,832.00-$142,272.00 4 weeks ago

Chicago, IL $100,000.00-$130,000.00 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.