Senior Data Warehouse Developer

Role Overview

• 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.

Requirements

• 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

Tech Stack

• Cloud
• ETL
• Informatica
• MS SQL Server
• Oracle
• SQL
• SSIS
• Unix