The TS4 will make technical decisions affecting configuration and implementation of data analytics environments, data platforms, integration systems, and environment-specific data storage solutions. The position will collaborate with IT Architecture staff, the Agency CIO, and IT Managers to design data solutions aligned with agency business needs, enterprise standards, and long-term architectural direction. The TS4 will assist in evaluating solution designs, contributing to business case analysis, and recommending IT architecture improvements.
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:
Salesforce platforms
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
Required/Desired SkillsSkill | Required /Desired | Amount | of Experience | Candidate years of exp | Last used year | |
Experience with Salesforce platforms | Required | 5 | Years | |||
Experience with Microsoft Environments including Azure and Dynamics | Required | 5 | Years | |||
Demonstrated hands-on experience with Salesforce platform capabilities including Apex, Lightning Web Components, Salesforce Flow, validation rules | Required | 5 | Years | |||
Experience with Snowflake data platform | Required | 5 | Years | |||
Experience with Tableau analytics integration | Required | 5 | Years |
| No. | Question | Answer |
|---|---|---|
| Question1 | Do you understand, and will abide by, the provision in your subcontract with OST that it is PROHIBITED for government equipment to be taken or used outside of the United States by your contractors? The consequences of this occurring can and will result in repercussions to you, the prime vendor, regardless if the candidate works for a sub-vendor of yours. It will also result in immediate termination of the contractor and make them ineligible for rehire in the program. | |
| Question2 | Is your candidate able to report to E Broad Street, 13th Floor Columbus, Ohio for their 1st day? | |
| Question3 | DODD prefers candidates based in Ohio, in case contractors are required to work on-site in the future. Where is your candidate currently located? | |
| Question4 | Selected candidate will be required to complete an FBI Fingerprint check. Does your candidate accept? |