We are seeking a Business Intelligence Data Warehouse Developer who will lead the architecture, technical design, evaluation and administration of existing and proposed data warehouse and business intelligence systems by providing system expertise including domain knowledge. Design, develop, and maintain the corporate data, cloud data warehouse and business intelligence solutions within the Associations. Monitor existing cloud data warehouses and perform system enhancements to ensure optimal performance to meet business requirements. Lead continuous improvement efforts by enhancing performance, providing increased functionality, and supporting business intelligence systems based on current and future business needs. Foster collaboration with business analysts, developers and product owners to ensure they are working towards the same vision and goals. Provide technical leadership, mentoring, and support to project team members.
Essential Duties & Responsibilities
- Meet with business teams to understand future business needs and help translate business requirements into the appropriate data models that integrate with the cloud data warehouse. Work collaboratively with business and technology stakeholders to establish, communicate, and maintain the cloud data warehouse architecture. Architect and assist in the design and development of ETL standards, policies, procedures, and metadata to ensure accuracy, consistency, integrity, and optimization of the information in the cloud data warehouse.
- Promote a highly collaborative team environment following the Agile methodology to assist developers in the successful accomplishment of strategic and divisional objectives. Take the necessary steps to ensure our customers’ needs are met to the maximum extent possible in an accurate and timely manner. Lead and perform coding efforts to provide a high level of data integrity, security, and availability for internal and external customers. Mentor, support and provide direction to less experienced teammates.
- Analyze future data warehouse requirements and develop long-term strategies for data warehousing and business intelligence usage while maintaining an effective and consolidated environment. Apply knowledge of Snowflake data warehouses to maintain consistent peak performance and proper secure access. Communicate with proposed changes and promote collaboration while providing guidance and contributing to the development of business intelligence projects. Facilitate the architecture of discussions and communications with the team to ensure the team understands the goals and objectives of each development stream and how they affect the system as a whole.
- Provide support on production systems and collaborate to define and correct defects. Identify and effectively resolve data warehouse performance concerns, capacity requirements, environment migrations, and other data warehouse enhancement opportunities. Work with business analysts and developers to develop adequate testing procedures for data warehouse enhancements and data corrections. Provide expertise regarding data movement and management tools to administer and maintain data confidentiality, integrity, and availability in all database environments.
- Maintain accepted best practices and standards regarding the development, security, and utilization of all business intelligence systems.
