Powershell

Powershell Data Jobs

6 jobs found

10d ago

TSOE Tools & Analytics Engineer

AEP Service Corporation New Albany, OH

New Albany, OH

10d ago

$84k - $110k/yr Full time .NET Analytics Analytics Engineer

Apply Now

Job Description

Work onsite in New Albany, OH (or other listed location), supporting Transmission System Operations Engineering by building and improving the tools and data systems used for transmission facility ratings, configuration management, transmission modeling, and regulatory compliance.

AEP Service Corporation is hiring an entry level Tools & Analytics Engineer role focused on technical support and software/data development. You will help engineering and operations teams turn complex transmission data into reliable reports, dashboards, and automation that improve visibility and data integrity across TSOE-owned applications and datasets.

What you’ll do

Provide technical support for TSOE-owned applications, databases, reports, dashboards, and automation used by Transmission Engineering, Operations, Ratings & Configuration, and Configuration Management.
Develop, maintain, and enhance software applications, scripts, APIs, reports, and integrations supporting transmission modeling, facility ratings, engineering workflows, and business processes.
Create and support SQL, Oracle, and other database queries to analyze engineering, operational, and compliance-related data and deliver actionable insights.
Design and maintain Power BI dashboards, performance metrics, and reporting solutions to improve visibility into Transmission operations, Configuration Management activities, FAC-008 compliance, and engineering performance.
Support TPS, ODMS, facility ratings processes, and related transmission modeling tools by validating data quality, identifying discrepancies, and coordinating corrective actions.
Review outage requests, asset changes, engineering records, and system data to identify potential impacts to transmission models, facility ratings, and systems of record.
Perform root cause analysis for data quality issues, model discrepancies, reporting inaccuracies, and process failures to improve data integrity.
Collaborate with engineering, operations, IT, vendors, and external stakeholders to define requirements, implement enhancements, and support modernization of TSOE applications and data systems.
Apply subject matter expertise related to transmission system modeling, facility ratings, MLSEs, electrical asset data, Configuration Management, and applicable NERC and industry standards.
Identify and implement opportunities to automate manual processes, improve engineering efficiency, reduce compliance risk, and increase the accuracy and accessibility of transmission system data.

What you bring

Entry level position requiring a Bachelor’s degree in engineering from an ABET-accredited program.
Fundamentals of Engineering exam: encouraged and preferred in preparation for future licensing as a Professional Engineer (PE).
Typically, Engineer Associate SG6 aligns with entry level for new graduates; Engineer SG7 typically includes two or more years of related engineering experience. Master’s degree from an ABET-accredited program may be considered for entry at this level.
Individuals with a Bachelor’s in Engineering Technology can satisfy the degree requirement if they obtain a certified PE license.
Transmission system modeling knowledge: TPS, ODMS, PSSE, and bus/branch concepts.
Facility Ratings and FAC-008 knowledge and understanding of NERC compliance.
SQL and Oracle database experience.
Power BI development experience.
Programming experience with Python, .NET, PowerShell, or other languages.
API and system integration experience; data analytics and business intelligence.
Understanding of transmission assets: stations, transmission lines, relays, and ratings methodology.
Schedule flexibility is required, including work outside standard business hours (nights, weekends, and holidays).
Onsite role reporting to New Albany, OH, or Corpus Christi, TX.
Education alternate: Bachelor’s degree in engineering (non-ABET) plus a Master’s degree or PhD in engineering from a university with an ABET-accredited Bachelor’s program. VP or above may waive the requirement for a non-ABET program.

Tools you’ll use

SQL, Oracle, Power BI, Python, .NET, PowerShell, API, TPS, ODMS, PSSE, MLSEs, FAC-008

Compensation & work location

Location: Onsite in New Albany, OH 43054 (also reporting to a listed site location in Corpus Christi, TX)
Salary: $84,000 - $110,000 per year
Compensation grade: SP20-006
Compensation range provided: $74,551.00 - $109,543.00

Posting end date: 10-23-2026

View full job page →

1mo ago

Data Analyst

CloudHQ LLC Ashburn, VA

Ashburn, VA

1mo ago Closed

Full time Analytics Business Analytics Business Intelligence

This position is no longer accepting applications (closed Oct 25, 2026).

Job Description

The Data Analyst at CloudHQ LLC will collect, validate, analyze, and visualize data from multiple systems to support reporting and decision-making across operations and leadership. The role focuses on defining trusted metrics, automating recurring outputs, and communicating actionable recommendations.

Location and Work Model

Ashburn, VA (hybrid). Work is performed in an office or hybrid environment based on business needs.

Responsibilities

Collaborate with Operations, Development, Finance, IT, OT, and other teams to define reporting and data requirements.
Extract, transform, and analyze data using SQL, Excel, Power Query, and approved analytics tools.
Develop and maintain Power BI dashboards, scorecards, and recurring reports.
Analyze trends, variances, risks, and performance drivers, then recommend practical actions.
Support data center analysis across capacity, energy, incidents, maintenance, assets, projects, budgets, vendors, and service performance.
Validate data, resolve discrepancies, document assumptions, and implement quality checks.
Maintain business metrics, data dictionaries, calculation logic, and reporting procedures.
Automate recurring data preparation and reporting to reduce manual effort.
Communicate findings clearly to technical, operational, and leadership audiences.
Follow CloudHQ security, privacy, access control, and data-handling requirements.
Support analytics projects, testing, process improvements, and new reporting capabilities.

Required Qualifications

Bachelor’s degree in data analytics, statistics, computer science, information systems, business, engineering, finance, or a related field; equivalent experience will be considered.
3 to 5 years of experience in data analysis, business intelligence, reporting, or a related role.
Intermediate to advanced SQL skills, including joins, aggregations, common table expressions, and data validation.
Hands-on experience with Power BI/Tableau, data modeling, Power Query, and DAX.
Advanced Excel skills, including formulas, pivot tables, charts, and data transformation.
Ability to clean and reconcile data from multiple systems and explain findings to nontechnical stakeholders.
Experience gathering requirements, documenting business logic, and managing multiple priorities independently.
Strong written, verbal, and presentation skills, with attention to accuracy.

Preferred Qualifications

Experience with data center, facilities, energy, construction, infrastructure, or other mission-critical operational data.
Experience with Azure data services, Microsoft Fabric, data warehouses, APIs, ETL/ELT workflows, or other cloud analytics platforms.
Working knowledge of Python, R, PowerShell, or another language used for analysis and automation.
Familiarity with forecasting, anomaly detection, or predictive analytics.
Experience with BMS, EPMS, DCIM, CMMS, asset management, service management, finance, or project management data.
Understanding of data governance, role-based access, change control, and ISO 27001 or SOC practices.
Microsoft Power BI or Tableau Data Analyst certification or a comparable credential.

Technologies

SQL, Excel, Power Query, Power BI, Tableau, DAX, PowerShell
Power BI/Tableau

Core Competencies

Analytical thinking and structured problem-solving
Data quality and attention to detail
Business partnership and requirements gathering
Clear data storytelling and visualization
Accountability, integrity, and sound judgment
Process improvement and an automation mindset
Teamwork, adaptability, and knowledge sharing

Success Measures

Deliver accurate, timely, and decision-ready reporting.
Increase stakeholder adoption and trust in dashboards and defined metrics.
Reduce manual reporting effort through repeatable automation.
Improve data completeness, consistency, traceability, and documentation.
Translate analysis into measurable operational or business improvements.

Working Conditions

Office or hybrid environment based on business needs.
Occasional travel to CloudHQ data center campuses.
Limited after-hours support for critical reporting deadlines or operational events.
Compliance with confidentiality, information security, and site access requirements.

View full job page →

1mo ago

Site Reliability Data Engineer

Leidos San Diego, CA

San Diego, CA

1mo ago Closed

$87k - $157k/yr Full time Ansible Business Intelligence Cloud Infrastructure

This position is no longer accepting applications (closed Sep 30, 2026).

Job Description

Leidos is seeking a Site Reliability Data Engineer to support the SMIT program for the Navy. The role focuses on building and operating secure enterprise data solutions and automated testing frameworks that validate resilience, performance, and failure scenarios across hybrid cloud and on-prem environments, while meeting service level objectives (SLOs).

Responsibilities

Design, develop, test, deploy, and maintain scalable ETL/ELT pipelines that collect, transform, validate, and deliver structured and unstructured data from enterprise systems, applications, APIs, logs, files, and databases.
Build and optimize data models, schemas, tables, views, and curated datasets to support analytics, business intelligence, operational reporting, and downstream application requirements.
Develop data-processing solutions using SQL, Python, and other approved technologies, applying reusable engineering patterns, source control, peer review, and documented release practices.
Integrate cloud and on-premises data platforms while supporting secure data movement, interoperability, availability, retention, and performance across hybrid enterprise environments.
Implement automated data-quality checks, reconciliation controls, monitoring, alerting, and exception handling to detect incomplete, inaccurate, duplicated, delayed, or failed data flows.
Troubleshoot pipeline failures, data discrepancies, performance degradation, access issues, and integration defects, performing root-cause analysis and implementing corrective and preventive actions.
Coordinate with analysts, business intelligence developers, data owners, system administrators, and mission stakeholders to define data requirements, source-to-target mappings, transformation rules, service expectations, and acceptance criteria.
Apply data governance, security, privacy, least-privilege access, auditability, and records-retention requirements across the data lifecycle in coordination with cybersecurity and compliance teams.
Support platform upgrades, data migrations, modernization initiatives, capacity planning, and performance tuning while minimizing disruption to production services.
Create and maintain technical documentation, including architecture diagrams, data dictionaries, lineage documentation, interface specifications, runbooks, standard operating procedures, and troubleshooting guides.
Participate in Agile planning, backlog refinement, technical reviews, demonstrations, incident response, and after-hours support activities when required to sustain mission-critical services.
Develop and execute tests focused on system resilience, performance underload, and failure scenarios.
Work with other Site Reliability Engineers and development teams to create automated testing frameworks that simulate real-world conditions and validate system behavior under normal and stress conditions, ensuring services are resilient and meet established SLOs.
Support the operations and maintenance of the enterprise network.

Requirements

B.S Degree and 4–8 years of prior relevant experience, or Masters with 2–6 years of prior relevant experience in data engineering, computer science, information systems, software engineering, mathematics, or a related technical discipline, with at least four years of relevant experience. Additional directly related experience may be considered in place of a degree.
U.S. citizen with an active DoD Secret Security Clearance.
Ability to possess and maintain an IAT Level II certification that satisfies applicable DoD cybersecurity workforce requirements.
Location requirement: located in (or able to work onsite at Navy Base as required) either San Diego, California, the Hampton Roads, Virginia area, or Jacksonville, FL.
At least three years of hands-on experience developing, operating, or supporting production data pipelines, data integrations, data warehouses, data lakes, or comparable enterprise data solutions.
Demonstrated proficiency with SQL and at least one general-purpose scripting or programming language, such as Python, for data extraction, transformation, validation, automation, and troubleshooting.
Experience with ETL/ELT, relational data structures, data modeling, schema design, source-to-target mapping, data quality, metadata, and lifecycle management.
Experience integrating data from multiple source types including relational databases, APIs, flat files, application data, system logs, or message-based interfaces.
Working knowledge of cloud and on-premises infrastructure concepts related to authentication and authorization, network connectivity, encryption, secure file transfer, and service accounts as they relate to data engineering.
Experience diagnosing production data issues, analyzing logs and metrics, resolving failed jobs or performance problems, and documenting root cause and corrective action.
Ability to work independently and collaboratively in a high-tempo operational environment, manage competing priorities, communicate technical information clearly, and produce complete technical documentation.
Working knowledge of PowerShell, Python, and Ansible, with practical familiarity using large language models (LLMs) and AI-enabled tools.

Technologies

SQL
Python
PowerShell
Ansible
LLMs, AI-enabled tools
ETL, ELT
Agile/DevOps

Benefits

Competitive compensation
Health and Wellness programs
Income Protection
Paid Leave
Retirement

Nice to Have

Business intelligence experience, including development or support of dashboards, reports, semantic models, key performance indicators, and self-service analytics solutions; experience with Microsoft Power BI (and associated DAX knowledge) is highly desirable.
Microsoft Certified: Azure Administrator Associate (AZ-104) certification.
Hands-on experience with Azure data and analytics services such as Azure Data Factory, Azure SQL, Azure Storage, Synapse Analytics, Databricks, or comparable cloud data platforms.
Familiarity with Security Technical Implementation Guides (STIGs), the Risk Management Framework (RMF), vulnerability management processes, system hardening, security controls, and applicable compliance frameworks.
Experience using automation, configuration-management, source-control, or continuous integration and delivery tools such as Ansible, Jenkins, and Bitbucket.
Experience designing or supporting data solutions in classified, DoD, federal government, or other highly regulated environments.
Experience with modern data-platform concepts including data lakes, lake houses, dimensional modeling, streaming or event-driven data, distributed processing, or containerized workloads.
Experience implementing data cataloging, lineage, master or reference data, role-based access controls, audit logging, backup and recovery, and disaster-recovery practices.
Relevant technical certifications in Azure, data engineering, database administration, analytics, cloud architecture, or security.
Strong customer engagement, requirements analysis, technical presentation, mentoring, and cross-functional collaboration skills.
Experience with graph databases (e.g., Neo4j) and query languages such as Cypher, including modeling entities and relationships as a property graph.
Familiarity with knowledge graphs, ontologies, or semantic data models and controlled vocabularies.
Experience with entity resolution / record linkage and reconciling conflicting values across multiple authoritative sources into a single trusted record.

Location and Salary

Location: San Diego, CA (onsite)
Salary: USD 87,100 - 157,450 per year
Minimum Experience: 3 years

View full job page →

2mo ago

Software/Data Engineer

Peraton Laurel, MD

Laurel, MD

2mo ago Closed

$176k - $282k/yr Full time Backend Developer Aws Solutions Architect Azure Solutions Architect

This position is no longer accepting applications (closed Sep 19, 2026).

Job Description

Peraton is seeking a Software/Data Engineer to support an enterprise-wide engineering contract for its Cyber Mission business unit in the Intelligence Community.

Responsibilities

Develop, maintain, and enhance complex and diverse software systems based on documented requirements
Review and test software components to confirm adherence to design requirements
Document software test results
Apply software development and software design methodologies appropriate to the environment
Provide input to software components of system design, including use of COTS/GOTS instead of new development
Analyze system performance standards to develop software solutions
Confer with users and system engineers
Analyze usage and work processes
Investigate problem areas and support resolution efforts
Support one of the largest enterprise-wide engineering contracts within the Intelligence Community

Requirements

Bachelor's degree in Engineering, Computer Science, Mathematics, or related field from an accredited college or university plus 19 years of demonstrated experience in Software Engineering
OR Master's degree in Engineering, Computer Science, Mathematics, or related field plus 17 years of Software Engineering experience
OR PhD in Engineering, Computer Science, Mathematics, or related field plus 14 years of Software Engineering experience
OR 20 years of Software Engineering experience with a High School Diploma or GED
Experience designing, deploying, and managing cloud infrastructure using OpenStack and other comparable platforms
Strong background in Linux and Python
Understanding of IT management and operations
Active TS/SCI clearance with polygraph required

Technologies

OpenStack
Linux
Python
PowerShell
AWS Certified Solutions Architect
Microsoft Certified: Azure Solutions Architect

Individual Capabilities / Experience Desired

Excellent oral, written, organizational, and communications skills
Broad experience in system engineering disciplines
Software development and Develop Operations experience
Experience using network automation tools
Familiarity with cloud security and operations
PowerShell familiarity
Certifications such as AWS Certified Solutions Architect or Microsoft Certified: Azure Solutions Architect are a plus

Compensation

Target salary range: $176,000 - $282,000 per year

Benefits

Heavily subsidized employee benefits coverage for you and your dependents
25 days of PTO accrued annually up to a generous PTO cap
Eligible to participate in an attractive bonus plan
Medical, dental, and vision
Life and health savings account
Short/long term disability
EAP
Parental leave
401(k)
Paid time off (PTO) for vacation
Company paid holidays

Application Process

Estimated application period: 30 days from the job posting date
During application review, you may be required to participate in an on-camera interview
Participate in a process to verify your identity

EEO

Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law

Location: Laurel, MD (onsite) | Business Unit: Cyber Mission | Work Location Mentioned: Fort Meade, Maryland

View full job page →

2mo ago

Data Engineer

Vaco by Highspring Nashville, TN

Nashville, TN

2mo ago Closed

$58+/hr Contract Bigquery Cloud Data Warehouse Cloud Platform

This position is no longer accepting applications (closed Sep 10, 2026).

Job Description

Vaco by Highspring is hiring a Data Engineer for a 12-month contract in Brentwood, TN (hybrid). This role focuses on building ETL/ELT pipelines, supporting data warehouse solutions, governing data products, and improving data quality to enable reporting, automation, analytics, and AI-driven use cases.

Responsibilities

Build and maintain ETL/ELT processes and production data pipelines
Develop and support data warehouse solutions and curated datasets
Integrate data from multiple source systems
Prepare data for reporting, analytics, automation, applications, and AI-driven use cases
Perform data acquisition, cleansing, parsing, transformation, validation, and reconciliation
Support data governance activities, including lineage, documentation, testing, and change management
Create and maintain data models aligned with business and reporting needs
Monitor and improve data quality across platforms and processes
Collaborate with technical and business teams to gather requirements and deliver data solutions
Create and maintain technical documentation and data standards

Requirements

Experience building and supporting ETL/ELT processes and data pipelines
Hands-on experience with Teradata Protocol Transport (TPT)
Hands-on experience with SSIS
Hands-on experience with Python
Hands-on experience with PowerShell
Hands-on experience with cloud-based data services
Experience with data acquisition, cleansing, parsing, transformation, validation, and reconciliation
Experience integrating data from multiple source systems
Experience preparing data for reporting, analytics, automation, applications, and AI-related initiatives
Strong understanding of data warehousing concepts, data structures, and data modeling
Experience building curated datasets and governed data products
Experience with one or more database platforms, including: Google BigQuery, Teradata Vantage, Oracle, Microsoft SQL Server, or other enterprise DBMS platforms
Experience with data analysis and data visualization
Strong understanding of data quality, governance, lineage, documentation, testing, and change management practices
Strong SQL skills
Ability to communicate technical concepts with both technical and non-technical audiences

Preferred Qualifications

Experience with Google Cloud Platform (GCP)
Experience with Python
Experience with Microsoft SQL Server
Experience with Teradata
Experience with business intelligence and reporting platforms

Technologies

Teradata Protocol Transport (TPT)
SSIS
Python
PowerShell
Cloud-based data services
Google BigQuery
Teradata Vantage
Oracle
Microsoft SQL Server
SQL

Contract Details

Location: Nashville, TN (hybrid). Job type: Contract. Duration: 12-month contract. Compensation: USD 58 per hourly.

View full job page →

2mo ago

Data Analyst

Software Technology Inc Charlottesville, VA

Charlottesville, VA

2mo ago Closed

Contract Analyst Analytics Azure Platform

This position is no longer accepting applications (closed Aug 27, 2026).

Job Description

Contract Data Analyst position in Charlottesville, VA focusing on SSRS reporting, SQL data migration support, and BI dashboards, with initial on-site work and potential remote options.

Responsibilities

Design and tailor SSRS reports using configuration team mockups to modify standard vendor reports.
Analyze, clean, and load SQL data to support migration projects.
Develop Business Intelligence reports and dashboards.
Support ETL processes to cleanse and load data to on-premises and cloud databases, including SQL Server scripting and querying, and BI report creation.
Collaborate with ACIT team members, department stakeholders, vendors, and partners to design, develop and implement reporting, integration, and data analytics solutions.

Requirements

Proven expertise in designing, developing, and deploying SSRS reports.
Proficiency with SQL Server.
Strong SQL querying skills for relational databases.
Experience with complex queries, joins, subqueries, and data manipulation.
Ability to perform data analysis, data profiling, SQL coding and query tuning, data modeling, and data validation.
Capability to partner with internal stakeholders to develop reports or address data access and visualization needs.
Experience in data modeling with solid data management skills.

Technologies

SSRS
SQL Server
Power BI
Azure data warehousing solutions
Azure ETL processes and tools
Microsoft Fabric
Python
PowerShell

Benefits

Free parking on site at facilities.

Location

Charlottesville, VA 22902

Duration

12+ Months

Description

Data Analyst duties include creating and customizing SSRS reports, processing and loading SQL data for a migration project, and building BI reports and dashboards. Initial interviews may be virtual, with the possibility of an in-person interview. The selected candidate must be able to work on site for the first full week (5 days) and on-site at least one day per week thereafter.

Day to Day Responsibilities

Initial workload prioritizes SSRS report creation using mockups to tailor standard vendor reports.
Work on ETL processes to clean and load data to on-premises and cloud databases, along with SQL Server scripting and BI report creation.
Collaborate with ACIT team members, stakeholders, vendors, and partners to design and implement reporting, integration, and data analytics solutions.

Experience

4-6 years

On-site Schedule

1-2 days on site per week

Required Skills

Expertise in designing, developing, and deploying SSRS reports.
Proficiency with SQL Server.
Strong SQL querying skills for relational databases.
Experience with complex queries, joins, subqueries, and data manipulation.
Data analysis, profiling, SQL coding, query tuning, data modeling, and data validation.
Ability to work with internal stakeholders to develop reports or address data access and visualization needs.
Experience in data modeling with strong data management skills.

Desired Skills/Experience

Power BI report development
Azure data warehousing solutions
Azure ETL processes and tools
Microsoft Fabric
Proficiency in scripting languages such as Python or PowerShell for automation and data manipulation

View full job page →

Powershell Data Jobs

TSOE Tools & Analytics Engineer

Data Analyst

Site Reliability Data Engineer

Software/Data Engineer

Data Engineer

Data Analyst

Get Powershell Data Jobs alerts