# Data Architect — vTech Solution

- Location: Columbus, OH
- Posted: Feb 28, 2017
- Status: open (checked Nov 19, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/vtechsolution1/109568415
- Employer record: https://visajobs.io/company/vtech-solution.md

## Sponsorship history
- Tier: Employer history only
- Occupation (SOC): Database Architects (15-1243)
- Employer's certified LCAs for this occupation in OH, FY2024–FY2026: 0
- …in the whole US: 0
- With this exact title: 0
- Median DOL prevailing wage, level I / II: $80k / $105k

## Description
Job Description
Position Details:
Job Title: Data Architect
Location: Columbus, OH 43215
Duration: 12+ months (Strong possibility for an extension)
Requirement Description:
Ohio Facilities Construction Commission is looking for someone to Drive the technical architecture design in creating an Enterprise Data Warehouse for the Commission.
Roles & Responsibilities:
· Data-related technologies, design architectures, and model data in a manner that is efficient, scalable, and supportable for a data warehouse.
· Creating a tiered enterprise data management architecture using a combination of relational, dimensional and flat data models, depending on business context, type of data and use cases
· With the given data sources available, create the necessary data mapping and transformation rules and assist the technical team in staging the data for advanced reports/analytics & other needs.
· Maintain cross referenced metadata on data sources, interfaces and systems of record and systems of reference if needed.
· Ensure data quality rules are enforced and identify appropriate mechanisms to execute and update results of data quality checks.
· Recommend and bring data management best practices to stitch together disparate data and analytics requirements and reporting needs for the organization
· Work with leadership to influence the direction of our data technology platform.
· Establish & document database process that currently extracts the data from the existing system for reporting purposes.
· Help set the development of policies, standards and guidelines that direct the selection, development, implementation and use of Data/ETL/BI solutions within the enterprise.
· Prepare and present report on analyses, findings and project progress to management.
Mandatory Requirements/Time:
· Expert in data architecture concepts that support an Enterprise Data Warehouse
· Advanced proficiency in data modeling for dimensional and big data platforms
· Expert in ETL best practices and experience in designing and implementing ETLs and data migrations
· Strong skills in modeling data for modern systems and distributed application architectures
· Expertise with data modeling techniques (i.e., Star, Snowflake, etc.) as well as data warehousing & data mart principles and methodologies.
· Experience in analyzing structured & unstructured data in relational, NoSQL, non-relational data stores
· Experience with reporting/analysis/analytics tools such as SSRS, Power BI, Micro Strategy, Tableau, etc.
· In-depth experience modeling data requirements based on complex business needs across multiple information domains.
· Experience with resolving data anomalies and conducting data integration analysis
· Hands on experience with integration tools (DTS, SSIS, Data Stage, etc.)
· Experience working in an agile or continuous improvement environment
· Specific experience in metadata and master data management
· Writing, troubleshooting and optimizing SQL queries.
Additional Information
All your information will be kept confidential according to EEO guidelines.

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
