"Alerted.org

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:

1. 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.

2. Design and develop interactive dashboards and reports to visualize data in a user-friendly manner using Tableau and PowerBI.

3. Analyze data sets to identify trends, patterns, and insights relevant to business objectives using Python libraries such as Pandas, NumPy, Scikit-learn.

4. Write and optimize SQL queries to retrieve data efficiently using Microsoft SQL Server ensuring optimal performance of BI solutions.

5. 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.

6. Identify and resolve issues related to data quality, integrity, and performance in BI solutions using advanced Excel.

7. 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 [email protected].

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