> Markdown version of [/jobs/ext/448341-it-applications-analyst-python-sql-psc-windows-server](https://www.wearedevelopers.com/jobs/ext/448341-it-applications-analyst-python-sql-psc-windows-server). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # IT Applications Analyst (Python / SQL / PSC / Windows Server) - **Company:** Primary Talent Partners - **Location:** Charlotte, NC, United States - **Experience:** Expert - **Salary:** $135,200.0 - $156,000.0 - **Contract:** Temporary to permanent - **Skills:** Microsoft Windows, Application Programming Interfaces (APIs), Data Analysis, Application Layers, Software Applications, Application Performance Management, Application Services, User Authentication, Automation of Tests, Data Validation, Information Engineering, Data Integration, Data Mart, Data Transformation, Data Migration, Distributed Systems, Subnetting, Python (Programming Language), Log Analysis, Microsoft SQL Server, Windows Servers, Oracle (Applications), Performance Tuning, Query Optimization, Regression Testing, SQL Databases, Data Streaming, System Testing, Web Applications, Web Platforms, Web Services, SSL Certificate Management, Reliability of Systems, Backend, Data Layers, Integration Tests, Information Technology, Apache Kafka, Data Pipelines - **Published:** June 2, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=abb6940ffa3adcc2 ## About the Role Do you have experience in Windows support?, * Bachelor's degree in Computer Science, Engineering, or related field (or equivalent experience) * 8+ years of experience in IT application support, development, or data engineering roles Technical Skills Strong experience with: * Python development * Microsoft SQL Server * Windows Server administration * Web application configuration and support * Proven experience troubleshooting: * Distributed applications * Integration and synchronization issues * Experience with: * TLS / mTLS and certificate management * Service accounts (including secure configurations) * Testing tools such as qTest * Kafka configuration and troubleshooting Preferred Qualifications: * Experience with Progressive Web Applications (PWA) and sync-based architectures * Familiarity with NERC CIP or security compliance environments * Experience with field-based systems or disconnected/sync models * Experience working with vendors (e.g., Subnet) in support and troubleshooting scenarios Key Competencies: Strong end-to-end troubleshooting across: * Infrastructure (Windows Server) * Application layer * Security layer (certificates, auth) * Data layer (SQL/Kafka) * Ability to diagnose complex, multi-system failures (sync, auth, data) * Strong analytical and problem-solving skills * Effective communication with both technical teams and business stakeholders * Detail-oriented with strong focus on compliance, auditability, and system reliability ## Description We are seeking a highly skilled IT Applications Analyst to support two critical initiatives: Aspen Data Mart - focused on Python development, data integration, testing, and Kafka-based streaming CIP Local Password Tool (CLPT) - supporting a vendor solution (Power System Center - PSC) including a core application and Progressive Web Application (PWA) used by field personnel This role requires a strong blend of data engineering, application support, Windows server administration, and security troubleshooting. The ideal candidate will be capable of supporting complex, security-driven environments involving TLS/mTLS certificates, service accounts, and synchronized web-based applications, while also contributing to development and testing activities., Project 1: Aspen Data Mart (Data Engineering & Integration) * Develop and maintain Python-based data pipelines and applications * Support data transformation, validation, and analysis * Write and execute test scenarios (qTest) for data migration and validation * Configure and troubleshoot Kafka topics, producers, and consumers * Ensure reliability and performance of data flows and integrations * Project 2: CLPT / Power System Center (Application & Platform Support) * Provide operational and technical support for Power System Center (PSC): * PSC Central Core application (central system) * PSC Local used on field laptops * Troubleshoot complex application issues, including: * Sync failures between systems * Authentication and connectivity issues * Application performance and availability problems Application & Web Platform Support * Configure and support web-based applications across environments * Troubleshoot issues spanning: * Application layer * Web services/APIs * Client-side (field laptops / browser-based PWA) * Analyze logs, services, and data flows to identify root causes Windows Server & Infrastructure Administration * Administer and support Windows Server environments hosting PSC and related applications * Manage: * Application services * Scheduled jobs and background processes * Server performance and health monitoring * Support deployments, patching, and configuration updates Security & Identity (Critical Requirement) * Manage and troubleshoot certificate-based authentication, including: * TLS / mTLS configurations * Server and client certificate installation and renewal * Support service account (including gMSA) configurations * Diagnose and resolve security-related issues: * Authentication failures * Certificate trust/chain issues * Secure communication breakdowns * Ensure systems align with NERC CIP and enterprise security requirements Data & Database Management * Manage and support Oracle and SQL Server databases * Perform: + Query tuning and performance optimization + Data validation and troubleshooting + Support backend data flows for both Aspen and PSC systems Testing & Quality Assurance * Develop and execute qTest scenarios * Perform: + Functional testing + Integration testing + Regression testing * Validate both data accuracy and application behavior Business & Data Analysis * Work with business stakeholders to gather requirements and clarify issues * Conduct data analysis to support troubleshooting and decision-making * Translate business needs into technical solutions and improvements ## Related Videos - [Small, Secure, Interconnected: The next Internet Protocol](https://www.wearedevelopers.com/videos/100062-small-secure-interconnected-the-next-internet-protocol) - [Developing the Backend with Stefan Lingler, CTO at Shpock](https://www.wearedevelopers.com/videos/100360-developing-the-backend-with-stefan-lingler-cto-at-shpock) - [Security Pitfalls for Software Engineers](https://www.wearedevelopers.com/videos/726-security-pitfalls-for-software-engineers) - [Nest.js - TypeScript in the backend can also be clean](https://www.wearedevelopers.com/videos/1033-nest-js-typescript-in-the-backend-can-also-be-clean) - [Migrating half a million users to a new payment service provider](https://www.wearedevelopers.com/videos/730-migrating-half-a-million-users-to-a-new-payment-service-provider) - [Meet Your New BFF: Backend to Frontend without the Duct Tape](https://www.wearedevelopers.com/videos/682-meet-your-new-bff-backend-to-frontend-without-the-duct-tape) ## Related Articles - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools) - [Where To Find Software Engineering Jobs](https://www.wearedevelopers.com/magazine/396-where-to-find-software-engineering-jobs) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)