lead data architect

lead data architect.

• rochester , new york (remote)

• posted may 1, 2024

job details

summary

• $120,000 - $140,000 per year

• permanent

• bachelor degree

• category computer and mathematical occupations

• reference1050747

job details

job summary

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 experience preferred

• Epic Cogito Data Model(s) within 1 year required

• Denodo Architecture Training and Certification within 1 year required

qualifications

• Experience level: Experienced

• Minimum 7 years of experience

• Education: Bachelors (required)

skills

• Data WarehouseEqual Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group ~~~ Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact ~~~ offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).Applications accepted on ongoing basis until filled.