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.
All your information will be kept confidential according to EEO guidelines.
Job details are sourced from the employer's original posting.
Open job postingAbout the company
vTech can help you avoid the daunting task of writing and posting job offers, shifting through resumes and laboring through the lengthy interview process. Our Staffing solutions will allow you to elude those tasks and place topnotch, high-caliber professionals in the position you need to fill. We use our expertise, knowledge, and global resources to deliver top-quality candidates and tailor our IT and Non-IT recruitment services to your needs. This allows us to deliver the required results in a timely manner that meets your schedule at a substantially reduced cost. We pride ourselves for having one of the fastest growth rate and also the lowest turnover rates in the industry just 2.5 percent annually . We focus on the training and retaining qualified professionals with high personal and work ethics. With the help of our extensive database of internal candidates and CATS applicants tracking system, we can provide quality resources within the limited time frame. We have also successfully placed hundreds of candidates in the areas related to Information Technology, Engineering, professional, Scientific & Clinical, etc. for both our commercial and government clients. Source: A recruiter sources candidates from various sources; the search starts from our proprietary database. Using advanced sourcing methods like social media, professional networking media, internal, and 3rd party job boards, we identify qualified candidates. Validate: A recruiter validates the candidates’ experience and skill sets against our client’s position. Initial Screening: Based on the position and the client’s work culture, the recruiter uses initial screening questions to determine the most suitable candidates. Submit: the recruiter will submit to the technical team qualified candidates who have passed the initial screening. Technical Screening: The technical team then prepares a matrix of the particular requirements and required experience for the position and using a list of questions and the results, re-validates the candidates’ technical skills. Background Check: Administrative personnel will provide a detailed background check, as required, per client agreement. On board: On successfully completing the above steps, the candidates are welcomed on board and assisted to ensure a smooth integration at the client’s location.