Integration Associate/Data Analyst at ParsonsKellogg in Remote

Summary: ParsonsKellogg is seeking an Integration Associate/Data Analyst to join their team. In this role, you will collaborate with Project Managers and DevOps Engineers to deploy products to customers and perform data analysis and quality assurance within utility and billing systems. Responsibilities: - Collaborate effectively with end users, developers, and cross-functional teams to deliver high-quality integrations - Integrate third-party vendor database platforms (MySQL, SQL Server) into a Microsoft SQL Server–based data warehouse - Develop, modify, and optimize SQL scripts to support data integrations and transformations - Use GitHub (or similar version control tools) to maintain production-quality software builds - Work closely with Project Managers, integrators, and support staff to deploy Meter Data Management (MDM) software - Test web applications for performance, functionality, and regression to prepare for general software releases - Perform SQL Server database migrations to updated server environments and platforms - Troubleshoot integration issues and coordinate resolutions with internal and external stakeholders Required Qualifications: - Bachelor's degree in Business, Computer Science, or related field - Hands-on experience with Microsoft SQL Server, T-SQL, MySQL - Experience with regression testing of stored procedures, ETL processes, and applications - Proven software QA experience working with complex system integrations - Strong data analysis skills, including data profiling, validation, and reconciliation Preferred Qualifications: - 1 – 2 years experience in Software Development, or in the Utility Industry - MongoDB, SOAP-based web services, MultiSpeak Required Skills: Microsoft SQL Server, T-SQL, MySQL, Regression Testing, Stored Procedures, ETL Processes, Software Quality Assurance, System Integration, Data Analysis, Data Profiling, Data Validation, Data Reconciliation, GitHub Benefits: Medical, Dental, Vision, Paid time off, Employee Stock Ownership Plan (ESOP), 401(k), Life insurance, Flexible work schedules, Holidays