Senior Data Warehouse Developer

Stelle nicht auf LinkedIn

🕒 vor 27 Tagen

🗽 New York – Remote

🗽 New York – Remote

💵 $86.482 - $129.723 / Jahr

⏰ Vollzeit

🟠 Senior

🚰 Dateningenieur

Jetzt Bewerben

Ähnliche Remote-Jobs finden

E-Mail-Benachrichtigung für neue Jobs einrichten

📊 Überprüfen Sie Ihre Lebenslauf-Bewertung für diese Stelle

Verbessern Sie Ihre Chancen auf ein Vorstellungsgespräch, indem Sie Ihre Lebenslauf-Bewertung vor der Bewerbung überprüfen.

Lebenslauf hochladen

UR Ventures

WebsiteLinkedInAlle Stellen

11 - 50 Mitarbeiter

📚 Bildung

🤝 B2B

🔬 Wissenschaft

Education • B2B • Science

UR Ventures ist der Innovations- und Kommerzialisierungsarm der University of Rochester, der sich darauf konzentriert, Forschung und akademisches Unternehmertum voranzutreiben. Es verbindet die Fakultät und Forscher der Universität mit Industriepartnern, um die Entwicklung neuer Technologien und Unternehmen zu erleichtern, die positive Auswirkungen auf die Gesellschaft haben können. UR Ventures fördert Zusammenarbeit, Kreativität und Wissensaustausch und trägt so zur Mission der Universität bei, die Welt stets zu verbessern.

Beschreibung

• Architecting, designing, developing, implementing and supporting various components for the enterprise data warehouse and associated data sources. • Works independently and provides support for reporting projects, as well as process and architectural recommendations. • Mentoring staff, demonstrating best practices, planning for business continuity and sustainability and working on projects that support Business Intelligence and Data Warehousing functions as assigned. • Works with the user community and reporting team to understand business data and data transformation requirements. • Converts those requirements to functional/technical specifications for database and integration design. • Manages requests and/or components of larger projects with appropriate documentation and status reports. • Architects data integration and transformation processes across on premise and cloud data sources. • Provides leadership and is a subject matter expert depending on area of focus. • Designs and develops data integration and transformation processes across on-premises and cloud data sources using enterprise tools such as Informatica, Denodo, SQL Server, SSIS, Oracle Data Integrator, and Boomi AtomSphere, selected based on environment and requirements. • Develops data models and database designs that leverage their knowledge of data warehouse modeling best practices. • Collaborates with other team members using scrum processes or other project management disciplines depending on area of focus. • Follows best practices for change and code management. • Provides supporting technical documentation that is written, organized and maintained. • Participates in ongoing stabilization, support and maintenance. • Provides on call support as needed for business continuity and operations. • Attends webinars, reads case studies and white papers, and participates in opportunities to further refine skills and stay apprised on functional area topics.

🎯 Anforderungen

• Bachelor's degree in a related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering required • 5 years of related experience required • Equivalent combination of education and experience required. • Multiple project experience with Data Warehousing ETL technologies and overall knowledge of Data Warehousing/Business Intelligence lifecycles required. • Experience with dimensional data models required • Experience with OMOP data model preferred • Experience with integrating data warehouses with business intelligence metadata tools preferred • Experience with service oriented architecture and enterprise information integration preferred • Experience with the Denodo Virtualization Platform preferred • Experience with Informatica IDMC, MDM preferred • Experience with MS SQL Server 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 • Understanding of data warehouse and agile software development processes required • In depth understanding and development experience using SQL, Pl/SQL and UNIX scripting languages with SQL based databases (Oracle, DB2 or SQL Server) required • Proficiency in developing data transformation packages/stored procedures required