Job Classification: Technical Specialist 2
Hours: 100 hours
Interview Process: Phone/Skype Interviews
Will Close to Submissions on: 2/8/17 at 11:00 am
Requirement Description:
OFCC is seeking an individual that can be a part time Data Architecture consultant in an advisory role in the creation of an Enterprise Data Warehouse.
1. Data-related technologies, design architectures, and model data in a manner that is efficient, scalable, and supportable.
2. 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
3. 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.
4. Maintain cross referenced metadata on data sources, interfaces and systems of record and systems of reference if needed.
5. Advise the agency & team on data quality rules and identify appropriate mechanisms to execute and update results of data quality checks.
6. Recommend and bring data management best practices to stitch together disparate data and analytics requirements and reporting needs for the organization
7. Work with leadership to influence the direction of our data technology platform.
8. Establish & Document database process that currently extract the data from the existing system for reporting purposes.
9. 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.
Mandatory Requirements/Time:
(7-8 Years of experience)
1. Expert to advanced proficiency in data modeling for relational, dimensional and big data platforms
2. Strong knowledge of data modeling and ETL best practices and experience in Designing and implementing ETLs and data migrations.
3. Modeling data for modern systems and distributed application architectures.
4. Expertise with data modeling techniques (Star, Snowflake, etc.) as well as data warehousing & data mart principles and methodologies.
5. Experience in analyzing structured & unstructured data in relational, NoSQL, non-relational data stores including:
6. Key/Value pair, document stores, object databases, search indexes, MongoDB etc.,
7. Experience with reporting/analysis tools such as Micro-Strategy, Tableau, etc.
8. Professional working experience modeling data requirements based on complex business needs across multiple information domains.
9. Experience with resolving data anomalies and conducting data integration analysis.
10. Hands on experience with integration tools (DTS, SSIS, Data Stage, etc.)
11. Experience working in an agile or continuous improvement environment
12. Proficient with enterprise architecture and data architecture concepts.
13. Specific experience in metadata and master data management
14. Writing, troubleshooting and optimizing SQL queries.
