Search jobs > Kansas City, MO > It analyst

IT Data Analyst

Barkley
Kansas City, MO
Full-time

As a Barkley IT Data Analyst you will work closely with the operations team (Finance, HR, Project & Resource Management) to develop data infrastructure and insights.

You will be immersed into a full data lifecycle, requirements, design and analysis.This includes integrating various data sources of truth (HRIS, ERP, PM) into Snowflake Data Warehouse and implementing creative visualizations in PowerBI for stakeholders.

Responsibilities :

  • Utilize SQL, Python, Matillion and Snowflake to extract and analyze data from various sources.
  • Perform data transformation and cleansing to ensure accuracy and reliability.
  • Create insightful and comprehensive reports based on data analysis.
  • Develop interactive dashboards using Power BI for effective data visualization.
  • Collaborate with cross-functional teams to understand reporting requirements.
  • Continuously optimize and automate reporting processes for efficiency.
  • Stay updated on industry trends and best practices in data analytics.
  • Work closely with internal stakeholders to understand and implement business requirements and processes into presentable insights.
  • Collaborate with the IT Data Engineer on infrastructure, design, analysis and best practices.

Skill Requirements :

  • Proven experience in data analysis and report writing.
  • Proficiency in SQL, Python, Snowflake, DBT, and Power BI.
  • Strong analytical and problem-solving skills.
  • Ability to transform raw data into meaningful insights.
  • Experience in data visualization and dashboard creation.
  • Excellent communication and collaboration skills.
  • Detail-oriented with a focus on data accuracy and quality.

Preferred Qualifications :

  • Bachelor's degree or relevant certifications or experience (e.g., Data Science, Statistics, Computer Science, Data Engineering).
  • Previous experience in a similar role.
  • Familiarity with data warehousing concepts.
  • Deep understanding of Financial Concepts and Reporting
  • Experience with stakeholder dashboard & reporting design

Barkley's Commitment to Diversity & Inclusion

We believe being radically diverse and inclusive is the key to becoming one of the world's great creative idea companies.

By embracing everything that makes our partners who they are and what makes them unique to the world around them, we create the conditions and capacity to help creative, original thinking thrive.

  • Barkley is committed to Diversity, Equity, Inclusion and Belonging as part of our corporate strategic goals, supported by a formal DEI+B program, Employee Resource Groups, Director of Diversity leadership and agency commitment to The Brand Lab.
  • 30+ days ago
Related jobs
Promoted
Lockheed Martin
Pascagoula, Missouri

The incumbent will support the ATO with the presentation of data and metrics presented quarterly at the Ship Program Review (SPR). Using effective programs to display test program data and metrics in a professional deductible manner. Ability to develop and program databases, scripts, develop trackin...

PwC US Group LLP
Kansas City, Missouri
Remote

A Data Scientist collects domain context from stakeholders, defines hypothesis and prediction tasks, identifies and creates supporting data sources, conducts experiments with various algorithms to model prediction tasks, undertakes validation and tests of models to improve performance, produces pipe...

Maximus
Kansas City, Missouri

Description & Requirements Maximus Enterprise Services division is seeking a Medicaid Lead Analyst. The candidate must have a minimum of 5+ years (5-10 preferred) of provider business operations and/or implementation with Medicaid Enterprise Systems. Analyze existing systems, programs, policies...

Burns & McDonnell
Kansas City, Missouri

The Senior Business Analyst will play a key role in the Emerging Technology Office within the Information Technology (IT) department located onsite at Burns & McDonnell’s World Headquarters office in Kansas City, Missouri. This individual will be tasked with analyzing new technology options, doc...

Bally’s Dover Casino Resort
Kansas City, Missouri

Provide onsite and remote IT technical support for a diverse and complex technical environment covering many different IT methodologies. Duties, responsibilities, and activities may change at any time with or without notice. Bally’s Corporation is one of the world’s leading entertainment companies, ...

Federal Reserve System
Kansas City, Missouri

Assists with deploying data mining techniques to refine models that optimize decisions and improve scalable and reusable data mining solutions and capabilities that support the FedNow fraud program. As a member of the FedNow Fraud Protection team, you will participate in statistical and mathematical...

People Integra LLC
Kansas City, Missouri

As a Business Analyst, you will play a critical role in identifying business needs, analyzing processes, and implementing solutions that drive efficiency and support organizational goals. Required Skills : Business AnalysisAdditional Skills : Business Analyst. Position Overview:We are seeking a deta...

Lockton Companies
Kansas City, Missouri

Assist in the prospect pharmacy data collection process; analyze pharmacy claims data and provide detailed pricing and contract savings analysis. Perform quality control and data validation checks on the various client data sets. Integrate data from multiple data sets into relevant client reports. S...

Slalom
Kansas City, Missouri

You come from a background in data with experience in architecture, data modeling, data engineering, or data governance using all different types of databases. You know data and you know how businesses are using data to make an impact in the world. Python, SQL, AWS, GCP, Golang, Hadoop, Snowflake, R...

Wits Solutions Inc
Kansas City, Missouri

Provide systems analysis, problem solving support, and necessary programming support to provide efficient and effective use of administrative information systems in support of client's goals and objectives. This is why right from the beginning; our analysts and solution-builders work closely wi...