Data Administration Specialist

Provide Data Administration analysis, design, support, and implementation in the areas of enterprise data standards, governance, reference data architecture, and Global Reference Tables (GRTs). Perform logical and physical data modeling activities, including database schema design across PostgreSQL, SQL Server, DB2, and Oracle using tools such as Erwin (V12.5.2 and later) and Hackolade. Develop, test, and maintain software supporting Data Administration infrastructure and tools using .NET, .NET Core, C#, Blazor, JavaScript, HTML, and CSS. Modernize legacy Visual Basic for Applications (VBA) code and Excel macros by reading, interpreting, and migrating existing logic into maintainable C# .NET Core solutions. Conduct data analysis, data profiling, and quality assessments to identify issues, improvement opportunities, and recommendations across enterprise datasets. Apply modern system design principles including Domain-Driven Design (DDD), Event-Driven Architecture, and Service-Oriented Architecture to align Data Administration solutions with SSA s IT Framework. Write and optimize LINQ and SQL queries to improve application performance and database efficiency. Support batch processing in distributed computing environments, including job orchestration and workflow development. Provide DevOps support leveraging Azure DevOps and CI/CD pipelines to enable efficient build, release, and deployment workflows. Support identity and access management capabilities including OpenID Connect and related authentication standards as implemented within SSA s systems. Apply Test-Driven Development (TDD) practices throughout the software development lifecycle, leveraging automated testing frameworks such as Selenium where applicable. Provide recommendations on Open File Formats including JSON, XML, Avro, Kafka, and MongoDB, and on code metadata schemas. Conduct requirements elicitation, analysis, and technical writing for planning, design, and project documentation. Communicate and collaborate with stakeholders across SSA components in a blended analyst and developer capacity, moving fluidly between analysis, design, development, and communication responsibilities.

Bachelor s degree in Computer Science, Information Systems, Data Management, or related technical field; Associate s degree with 7+ years of relevant experience may substitute for the bachelor s degree requirement. Minimum 7 years of relevant experience in data administration, software development, or enterprise data management. Demonstrated experience with logical and physical data modeling using Erwin (V12.5.2 and later) and Hackolade. Strong experience with database schema design and development across PostgreSQL, SQL Server, DB2, and Oracle. Strong experience with C#, .NET, .NET Core, Blazor, JavaScript, HTML, and CSS. Demonstrated experience modernizing and migrating legacy VBA and Excel macro code to C# .NET Core. Experience writing and optimizing LINQ and SQL queries for performance. Experience applying Domain-Driven Design, Event-Driven Architecture, and Service-Oriented Architecture principles. Experience with Azure DevOps and CI/CD pipeline development. Experience with batch processing in distributed computing environments. Experience with identity and access management standards including OpenID Connect. Experience applying Test-Driven Development (TDD) practices; familiarity with Selenium or similar automated testing frameworks preferred. Familiarity with Open File Formats including JSON, XML, Avro, Kafka, and MongoDB. Experience with web server management and configuration in enterprise environments. Experience with Microsoft Office Suite (including advanced Excel), Visio, Confluence, and SharePoint. Strong technical writing, problem-solving, and analytical skills with the ability to translate business needs into technical solutions. Strong interpersonal and communication skills, both written and verbal, with the ability to develop executive-level communications and presentations.