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 InformationAll your information will be kept confidential according to EEO guidelines.
Top Skills
What We Do
vTech solution Inc. is a Managed IT Services firm based out of Washington DC with a primary focus on Cloud Computing and Professional Services.
vTech was incorporated in January 2006 under the Commonwealth of Virginia as an IT Professional firm. vTech has experienced constant growth over the years and has developed various IT service capabilities by diversifying its service portfolio to IT Consulting, Enterprise Software Solutions, and Cloud Computing Services to provide complete IT Managed Service offerings.
Currently, we are one of the nation’s fastest-growing private companies and have been consecutively named in INC. 5000 list for the past five years.
Our focus is to enhance the level of success for our clients by efficiently offering the highest quality services. We use the most advanced IT technologies and practices to add value to our client services.
We specialized in core competencies which include Cloud solutions, Network Services, Security Solutions, Customized Application Services, System Integration, AI Tools, and Professional IT Services such as Project Management, Staff Augmentation, and IT Infrastructure Services.
vTech Solution's unwavering dedication to results defines our brand. Our time-tested management processes, quality control methods, and state-of-the-art work environment ensure that our clients' most complex projects are delivered on time, on budget, and message.
"vTech encourages and supports a healthy work-life balance for its employees. It offers a workplace where you can work with dignity and independence. vTech offers a competitive salary and comprehensive benefits package. We offer tuition and training expense reimbursement and a flexible work schedule."
