Senior Data Analyst / Data Automation Consultant

Intracruit Solutions United State
Remote
Apply
AI Summary

Seeking a Senior Data Analyst / Data Automation Consultant for a large-scale server refresh program. This role focuses on improving and automating complex reporting workflows by integrating data sources, optimizing processes, and delivering scalable solutions. Requires strong SQL, Power BI, and ETL skills with a proactive approach to identifying and resolving inefficiencies.

Key Highlights
Automate complex reporting workflows and integrate multiple data sources.
Optimize data processes, improve data integrity, and build scalable reporting solutions.
Maintain and enhance Power BI dashboards and translate technical data into business insights.
Key Responsibilities
Learn and document current reporting workflows and dependencies.
Recreate existing reporting and data processes to ensure continuity.
Analyze current-state pain points, bottlenecks, and data quality issues.
Evaluate existing data architecture and workflows.
Identify opportunities to improve efficiency, reliability, and scalability.
Recommend better approaches for data collection, transformation, and reporting.
Improve data integrity across multiple systems and reporting sources.
Design and implement automation for recurring manual processes.
Develop scalable data pipelines and backend integrations.
Reduce reliance on manual spreadsheet-based workflows.
Support sustainable reporting and operational efficiencies.
Maintain and enhance Power BI dashboards used by leadership.
Build meaningful visualizations that clearly communicate trends, risks, and progress.
Translate technical data into business-focused insights and executive reporting.
Technical Skills Required
SQL SQL Server Power BI SSIS ETL Data Modeling Data Transformation Data Pipelines Excel
Benefits & Perks
100% Remote
Nice to Have
ServiceNow data/CMDB environments
SharePoint Lists
Microsoft Lists
Power Apps
Enterprise infrastructure, server environments, or IT operations reporting
Highly regulated or large enterprise environments

Job Description


Senior Data Analyst / Data Automation Consultant

100% Remote


Overview

We are seeking a highly analytical and technically skilled Senior Data Analyst / Data Automation Consultant to support a large-scale server refresh program. This role will focus on improving and automating complex reporting workflows by integrating multiple data sources, optimizing data processes, and delivering scalable reporting solutions.

The ideal candidate combines strong technical expertise with business acumen and can proactively identify inefficiencies, recommend improvements, and build sustainable automation solutions.

Key Responsibilities

Current-State Assessment & Process Understanding

  • Learn and document current reporting workflows and dependencies
  • Recreate existing reporting and data processes to ensure continuity
  • Analyze current-state pain points, bottlenecks, and data quality issues

Data Analysis & Process Optimization

  • Evaluate existing data architecture and workflows
  • Identify opportunities to improve efficiency, reliability, and scalability
  • Recommend better approaches for data collection, transformation, and reporting
  • Improve data integrity across multiple systems and reporting sources

Automation & Solution Development

  • Design and implement automation for recurring manual processes
  • Develop scalable data pipelines and backend integrations
  • Reduce reliance on manual spreadsheet-based workflows
  • Support sustainable reporting and operational efficiencies

Reporting & Visualization

  • Maintain and enhance Power BI dashboards used by leadership
  • Build meaningful visualizations that clearly communicate trends, risks, and progress
  • Translate technical data into business-focused insights and executive reporting

Required Skills & Experience

  • Strong experience with SQL / SQL Server
  • Experience with Power BI development and reporting
  • Experience with SSIS (SQL Server Integration Services) or similar ETL/data integration tools
  • Strong understanding of data modeling, data transformation, and data pipelines
  • Experience working with multiple enterprise data sources
  • Advanced Excel/data management experience
  • Experience automating manual reporting processes

Preferred Experience

  • Experience with ServiceNow data/CMDB environments
  • Familiarity with SharePoint Lists, Microsoft Lists, or Power Apps
  • Experience in enterprise infrastructure, server environments, or IT operations reporting
  • Experience working in highly regulated or large enterprise environments

Ideal Candidate Profile

We are looking for someone who:

  • Is highly analytical and naturally curious
  • Demonstrates strong root-cause analysis skills ( "Five Whys” mindset)
  • Thinks strategically and challenges inefficient processes
  • Can independently identify smarter, more sustainable solutions
  • Understands how to tell a compelling story with data for leadership audiences
  • Balances technical depth with business understanding


Similar Jobs

Explore other opportunities that match your interests

Visa Sponsorship Relocation Remote
Job Type Contract
Experience Level Mid-Senior level

HMG AMERICA LLC

United State
Visa Sponsorship Relocation Remote
Job Type Contract
Experience Level Mid-Senior level

MSR Technology Group

United State

Senior Data Science Expert

Data Science
2h ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

Mercor

United State

Subscribe our newsletter

New Things Will Always Update Regularly