Job Title: Technical Specialist 4 - Data Architecture & Analytics Consultant
Location: Remote
Candidate must report onsite on the first day in Columbus, OH 43215
Duration: Long-Term Contract
Position Overview
We are seeking a highly experienced Technical Specialist 4 (TS4) to support enterprise data architecture, analytics modernization, data integration, and scalable cloud-based data platform initiatives within a large enterprise environment.
The ideal candidate will bring strong expertise in enterprise data modeling, data governance, cloud analytics platforms, Salesforce technologies, Snowflake, Tableau, Azure, AWS S3, and enterprise integration solutions. This role will collaborate closely with architecture teams, database administrators, data engineers, business intelligence teams, and leadership stakeholders to deliver secure, scalable, and high-performing enterprise data solutions.
Key Responsibilities
Enterprise Data Architecture & Modeling
Design and maintain conceptual, logical, and physical data models supporting enterprise analytics and operational systems
Establish enterprise data modeling standards, reusable design patterns, and naming conventions
Contribute to enterprise data architecture modernization strategies and roadmap initiatives
Design scalable and interoperable enterprise data solutions aligned with governance standards
Provide architectural guidance for enterprise-wide data integration and analytics initiatives
Data Integration & Platform Engineering
Design, configure, and optimize enterprise data integration pipelines and workflows
Support integrations between enterprise systems and cloud-based data lake platforms
Support data cleansing, classification, curation, governance, and quality initiatives
Recommend best practices for data platform optimization, scalability, and performance
Participate in technical implementation, maintenance, optimization, and troubleshooting activities
Technical Leadership & Collaboration
Serve as a senior technical resource providing architecture guidance and engineering leadership
Collaborate with:
- Database Administrators
- Data Engineers
- Business Intelligence Teams
- IT Architecture Teams
- Business and Leadership Stakeholders
Review and evaluate enterprise solution designs and recommend architecture improvements
Mentor technical teams and promote best practices in enterprise data management and analytics
Analytics & Reporting Platforms
Support enterprise analytics and reporting solutions using Tableau and Snowflake
Design scalable enterprise reporting and operational analytics solutions
Support cloud storage and enterprise data lake integrations using AWS S3
Assist with analytics platform optimization and reporting modernization strategies
Required Qualifications
Minimum 5 years of experience with:
- Data Integration
- Data Cleansing
- Data Classification
- Data Modeling
5+ years of experience with Salesforce platforms
5+ years of experience with Microsoft technologies including Azure and Dynamics
Strong hands-on expertise with:
- Apex
- Lightning Web Components (LWC)
- Salesforce Flow
- Validation Rules
5+ years of experience with Snowflake
5+ years of experience with Tableau analytics integration
Experience with StreamSets data integration pipelines
Experience with AWS S3 storage environments
Strong understanding of enterprise data governance and scalable architecture practices
Preferred Skills
Enterprise Data Architecture
Data Governance & Data Quality
Cloud Data Platforms
Data Lake Integrations
Business Intelligence & Reporting
Data Curation & Classification
Enterprise Integration Architecture
Scalable Data Platform Design
Technical Leadership & Mentoring
Technical Skills
Salesforce
Apex
Lightning Web Components (LWC)
Salesforce Flow
Azure & Dynamics
Snowflake
Tableau
AWS S3
StreamSets
Data Modeling
Data Integration
Data Cleansing
Data Classification
Data Governance
Enterprise Data Architecture
Business Intelligence Platforms
Work Environment
Remote work environment
Microsoft Teams interviews
First-day onsite reporting required in Columbus, Ohio
FBI fingerprint/background check required
Additional Information
Ohio-based candidates preferred
Contractors must comply with enterprise security and equipment usage policies