Position: Technical Specialist 4(TS4)
Location: Columbus, OHย
Visa: Any Visa except CPT, TN and GC (PP number is mandatory to fetch I94)
Interviewย Type: ย webcam interviewย
This role will serve as a significant contributor to the Agencyโs data modeling and data architecture practices, including:
โข Designing and maintaining conceptual, logical, and physical data models supporting enterprise analytics and operational systems
โข Establishing and promoting data modeling standards, naming conventions, and design patterns
โข Contributing to the development and evolution of the Agencyโs enterprise data architecture roadmap
โข Supporting domain-driven and scalable data design approaches aligned with enterprise data platforms and data governance objectives
โข Providing architectural guidance to ensure data solutions are reusable, interoperable, and aligned with enterprise integration strategies
The TS4 will recommend technical strategy by defining tasks and leading technical discussions related to design, implementation, operation, optimization, and ongoing maintenance of data systems. The position will work closely with Enterprise partners to determine and configure integrations between agency systems and enterprise data lake, data quality, and data curation platforms.
It is critical that this position possess at least five (5) years of proven experience related to data integration, data cleansing, data classification, and data modeling. The TS4 will provide technical leadership and guidance to DODDโs Data Management team by designing and implementing best-practice solutions for integrating agency and enterprise data platform environments.
Expected technologies and environments include, but are not limited to:
โข Microsoft Environments including Azure and Dynamics
โข StreamSets data integration pipelines
โข AWS S3 storage environments
โข Snowflake data platform
โข Tableau analytics integration
โข Microsoft SQL Server systems
The TS4 will operate as part of a collaborative team consisting of Database Administrators, Data Engineers, and Business Intelligence professionals, while serving as a senior technical resource influencing architectural direction, data standards, and engineering best practices across the Agency
Skills
Required / Desired
Requiredย Amount of Experience in years
Experience with Salesforce platforms
Required
5
Experience with Microsoft Environments including Azure and Dynamics
Required
5
Demonstrated hands-on experience with Salesforce platform capabilities including Apex, Lightning Web Components, Salesforce Flow, validation rules
Required
5
Experience with Snowflake data platform
Required
5
Experience with Tableau analytics integration
Required
5