Senior BI and Data Warehouse Developer

As a Senior BI and DATA WAREHOUSE DEVELOPER, you will be tasked with designing, developing, staging, and implementing Data Warehouse Solutions. Provide leadership to the Data Warehousing professionals within the Business Intelligence Team and champion continuous improvement initiatives Design, develop, implement and maintain dashboards and reports using data warehouse technologies. Responsible for the full life-cycle of reports/dashboards from business engagement and requirement gathering to developing the data ingestion and maintenance, to the presentation thereof. Ensure that the data being brought into the data warehouse is managed, secure, accurate, clean, easily available, and complete. Assist the business in ensuring that data warehouse processes are running at an optimum capacity at all times. Responsibilities Maintain the business’s physical and logical data models, reflective of the current business environment. Provide technical assistance in the identification, evaluation and development of data warehousing systems and procedures. Define and promote the data warehouse design principles and best practice with regard to architecture and techniques. Design and support the table schemas and database for new and existing data sources for the business’s data warehouse. Create and support the ETL processes to facilitate the integration of data into the data warehouse through the use of SSIS and other technologies. Lead data-related technical projects for the business across platforms; participate in project planning and the analysis of the business’s data requirements and solutions. Bachelor’s Degree (Master’s preferred) in Computer Science, Data Science, Information Technology, Statistics, Information Systems or any other related field • Minimum 5 years working in a data warehousing role within a fast-paced and complex business environment • 4+ years writing T-SQL queries • Technologies: o Microsoft SQL Server (T-SQL, SSIS, SSAS) o Oracle PL/SQL Bachelor’s Degree (Master’s preferred) in Computer Science, Data Science, Information Technology, Statistics, Information Systems or any other related field • Minimum 5 years working in a data warehousing role within a fast-paced and complex business environment • 4+ years writing T-SQL queries • Technologies: o Microsoft SQL Server (T-SQL, SSIS, SSAS) o Oracle PL/SQL