Senior Consultant (REQ #75)

Definian • Chicago, IL

16d • Remote

About The Position

Definian helps organizations unleash the full potential of their data. Our expertise in data-led business transformation, data fundamentals and migration, risk management and data value realization helps companies maximize the value of their data, empowering them to achieve success across the entire data value chain. Having successfully completed thousands of projects since our founding in 1985, many of the world’s leading brands, technology companies, and system integrators rely on Definian to solve their most complex data challenges.
The Opportunity:
Job Title: Senior Consultant
Location: Chicago, IL - Option to work remotely from any location in the U.S.
Employment Type: Full-Time
What You'll Be Doing
Work directly with clients to understand their business needs, identify and define technical requirements, and become an expert with respect to their data.
Analyze data to gather insights, trends, transformation needs, and quality metrics.
Apply complex database methodology, data analysis, and reporting technologies.
Use data analysis tools such as PLSQL, Python, and Spark for development/programming.
Use cloud technology to create and maintain comprehensive documentation of data engineering processes, pipelines, and workflows.
Collaborate effectively with cross-functional teams, including data scientists and analysts, to understand their data needs and support data-related initiatives.
Build custom solutions for clients’ specific needs and guide them through large-scale technology transformations.
Deliver technology solutions to clients across industries, such as Manufacturing & Distribution, Education & Government, Consumer & Industrial Products, and Life Sciences & Healthcare. EOE
What You'll Bring to the Team
Must have Bachelor’s degree or foreign equivalent in Information Systems, Data Science, or a related field plus three (3) years of experience in the position offered, or as a Data Analyst, Business Analyst, or a related position. Alternatively, employer will accept a Master’s degree or foreign equivalent in Information Systems, Data Science, or a related field plus one (1) year of experience in the position offered, or as a Data Analyst, Business Analyst, or a related position.
Must have three (3) years (or one [1] year with a Master’s) of experience with all of the following:
Analyzing and managing structured data sets across diverse domains, with hands-on responsibility for both data transformation and reporting;
Writing complex queries and scripts using Python, R, or SQL, and validating data pipelines developed by engineering teams;
Creating interactive dashboards and advanced visualizations using Tableau, Power BI, or Looker, tailored for business and technical audiences;
Designing and maintaining cloud-based ETL workflows using Snowflake or Airflow;
Writing comprehensive documentation for client-facing data systems, including business logic mapping, schema design, and validation criteria;
Leading cross-functional collaboration across data engineers, product teams, and compliance stakeholders to deliver scalable, production-ready data solutions.
Definian has been named one of Built In's 2024 Best Places to Work across four categories: Chicago's Best Midsize Places to Work, Chicago's Best Places to Work, US Best Midsize Places to Work, and US Best Places to Work. Additionally, we have been recognized as one of the Best and Brightest Companies to Work For® in Chicago, as one of Crain’s Top 100 Best Places to Work in Chicago, and proudly made the 2021 Inc. 5000 list of America’s Fastest-Growing Private Companies. While we are relentlessly client-focused, we are proud to have our culture and company recognized by others.
Definian is an EEO Employer and provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Requirements

• Must have Bachelor’s degree or foreign equivalent in Information Systems, Data Science, or a related field plus three (3) years of experience in the position offered, or as a Data Analyst, Business Analyst, or a related position. Alternatively, employer will accept a Master’s degree or foreign equivalent in Information Systems, Data Science, or a related field plus one (1) year of experience in the position offered, or as a Data Analyst, Business Analyst, or a related position.
• Must have three (3) years (or one [1] year with a Master’s) of experience with all of the following: Analyzing and managing structured data sets across diverse domains, with hands-on responsibility for both data transformation and reporting;
• Writing complex queries and scripts using Python, R, or SQL, and validating data pipelines developed by engineering teams;
• Creating interactive dashboards and advanced visualizations using Tableau, Power BI, or Looker, tailored for business and technical audiences;
• Designing and maintaining cloud-based ETL workflows using Snowflake or Airflow;
• Writing comprehensive documentation for client-facing data systems, including business logic mapping, schema design, and validation criteria;
• Leading cross-functional collaboration across data engineers, product teams, and compliance stakeholders to deliver scalable, production-ready data solutions.

Responsibilities

• Work directly with clients to understand their business needs, identify and define technical requirements, and become an expert with respect to their data.
• Analyze data to gather insights, trends, transformation needs, and quality metrics.
• Apply complex database methodology, data analysis, and reporting technologies.
• Use data analysis tools such as PLSQL, Python, and Spark for development/programming.
• Use cloud technology to create and maintain comprehensive documentation of data engineering processes, pipelines, and workflows.
• Collaborate effectively with cross-functional teams, including data scientists and analysts, to understand their data needs and support data-related initiatives.
• Build custom solutions for clients’ specific needs and guide them through large-scale technology transformations.
• Deliver technology solutions to clients across industries, such as Manufacturing & Distribution, Education & Government, Consumer & Industrial Products, and Life Sciences & Healthcare.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level