Lead Data Architect - Randstad USA
Rochester, NY 14642
About the Job
General Purpose
Architects, designs, develops, implements, and supports various components for the enterprise data warehouse and associated data sources. Leads efforts to build and maintain enterprise data systems, ensure high quality and integrity of data, and drive data initiatives that enable business objectives. Mentors staff, demonstrates best practices, and works on projects that support Business Intelligence and Data Warehousing functions as assigned.
Knowledge & Experience
- Bachelor's degree in a related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering and 7 years related experience required
- Or equivalent combination of education and experience
- Experience with data architecture patterns and distributed systems (e.g. Hadoop, Spark) required
- Extensive hands-on experience with data warehouses, ETL processes, and data modeling required
- Project experience with data warehouse design, dimensional data models and ETL technologies required
- Experience with service-oriented architecture and enterprise information integration preferred
- Experience with integrating data warehouses with business intelligence metadata tools preferred
- Analytical and problem-solving abilities required
- Ability to actively participate and collaborate on a team required
- Excellent written communication skills. Ability to translate functional business requirements into documented system requirements and designs required
- Knowledge of Data Warehousing/Business Intelligence lifecycles required
- In depth understanding and development experience using SQL, Pl/SQL and UNIX scripting languages with SQL based databases (Oracle, DB2 or SQL Server) and NoSQL databases required
- Knowledge of Health Care EHR systems and/or Health care industry data experience preferred
- Epic Cogito Data Model(s) within 1 year required
- Denodo Architecture Training and Certification within 1 year required
#LI-AC1
location: ROCHESTER, New York
job type: Permanent
salary: $120,000 - 140,000 per year
work hours: 8am to 4pm
education: Bachelors
responsibilities:
General Purpose
Architects, designs, develops, implements, and supports various components for the enterprise data warehouse and associated data sources. Leads efforts to build and maintain enterprise data systems, ensure high quality and integrity of data, and drive data initiatives that enable business objectives. Mentors staff, demonstrates best practices, and works on projects that support Business Intelligence and Data Warehousing functions as assigned.
Knowledge & Experience
- Bachelor's degree in a related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering and 7 years related experience required
- Or equivalent combination of education and experience
- Experience with data architecture patterns and distributed systems (e.g. Hadoop, Spark) required
- Extensive hands-on experience with data warehouses, ETL processes, and data modeling required
- Project experience with data warehouse design, dimensional data models and ETL technologies required
- Experience with service-oriented architecture and enterprise information integration preferred
- Experience with integrating data warehouses with business intelligence metadata tools preferred
- strong analytical and problem-solving abilities required
- Ability to actively participate and collaborate on a team required
- Excellent written communication skills. Ability to translate functional business requirements into documented system requirements and designs required
- Knowledge of Data Warehousing/Business Intelligence lifecycles required
- In depth understanding and development experience using SQL, Pl/SQL and UNIX scripting languages with SQL based databases (Oracle, DB2 or SQL Server) and NoSQL databases required
- Knowledge of Health Care EHR systems and/or Health care industry data experie