Data Warehouse Developer

» Data Warehouse Developer
Information Technology
in Tampa
, FL
Reference: 19-01893

Summary:

The Data Warehouse Developer will be responsible for designing, developing, and maintaining data warehouse and analytics architecture to meet an enterprise’s business analysis and reporting needs. The Data Warehouse Developer role involves designing, developing, and supporting new and current ETL processes employing industry standards and best practices for loading of the data from and into different source target systems. This position will report to the Business Intelligence Manager and work under BI umbrella and will be a key contributor to supporting current technology and potentially migrating current ETL processes to a different tool set.

The Data Warehouse Developer will collaborate with multiple departments gathering reporting requirements and identifying data sources from transactional systems and providing expertise in the capabilities of exporting and transforming the data through different staging patterns to the final data warehouse repository.  This position will provide expertise on the implementation of a semantic data layer and a business reporting layer to satisfy dashboards, complex analytical models and transactional reporting.

Job Responsibilities / Functions:

  • Consolidate and optimize available data warehouse infrastructure
  • Conceive analytics and business intelligence platform architecture for various departments within the organization
  • Help develop and support customer facing reporting, data visualizations, and analytics
  • Design and implement ETL procedures for intake of data from both internal and outside sources as well as ensure data is verified and quality is checked
  • Develop and maintain mapping logic to ETL data sets from the various transactional sources to the data warehouse model
  • Create semantic data layers for business intelligence reporting/dashboards/scorecards
  • Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization
  • Carry out monitoring, tuning, and database performance analysis
  • Perform the design and extension of data marts, meta data, and data models
  • Ensure all the data warehouse architecture codes are maintained in a version control system
  • Perform project planning and resource allocation to meet project milestones
  • Resources include teams of three to four data analysts
  • Provide support, maintenance, monitoring, troubleshooting, and resolution for data warehouse and database processes

Education:

  • Bachelor’s degree in Computer Science or related field

Experience: 

  • Five (5) to seven (7) years of technology or IT experience

Skills and Knowledge:

  • Experience in business intelligence and data warehousing design including staging source data, master data management and conformed dimensions and data stewardship
  • Experience in relational database concepts with a solid knowledge of Cognos 10, SQL and PL/SQL
  • Experience with ETL tools
  • Experience developing a semantic data layer for easy access of business users
  • Experience in designing and delivering cross-functional custom reporting solutions by managing technical teams
  • Excellent oral and written communication skills including the ability to communicate effectively with both technical and non-technical stakeholders
  • Comfortable with agile methodologies such as Agile
  • Experience working with disparate data sources residing in the cloud/on-prem and turning them into a unified solution
  • Ability to work in cross-functional teams and communicate with colleagues in both business and technical roles
  • Strong ability to interact, communicate, present and influence within multiple levels of the organization
  • Excellent communication skills, both written and verbal
  • Proven ability to meet tight deadlines, multi-task, and prioritize workload
  • A work ethic based on a strong desire to exceed expectations