Job Description

• Leads technical project team and responsibilities using project management standards and methodologies. Develops project management artifacts and documentation.
• Define, capture and document metadata and rules associated with ETL processes, Develop and test ETL processes
• Work with end users, business analysts, technical team, and developers to define the data requirements and data structure for BI solutions
• Makes recommendations to improve operational processes relative to efficiency and effectiveness; provides input and organizational context to major architectural designs to ensure consistency, maintainability and flexibility with respect to overall system.
• Utilizes data-mining skills and business knowledge to convert raw data into solutions that provide clear and concise insights into the health of the business
• Design and implement conceptual and logical models for the data warehouse or data mart (data structure, storage, and integration). Lead the database analysis, design, and build efforts.
• Designs, develops, implements, and supports highly complex BI applications of strategic or functional importance for an enterprise audience including: integration with data sources; highly automated data refresh processes; best-in-class data visualizations, dashboards, and reports that communicate critical insights to drive decision making; testing methodology and criteria to ensure data/information quality; delivery of training and demos to business users.

Required Experience

• 8+ years of experience in data warehouse/BI intelligence architecture, design and development. Significant experience as BI/DW architect on several BI/DW initiatives / projects.
• Experience in BI development using the Microsoft Power BI platform
• Excellent understanding of Microsoft Power platform (Power Apps, Power Automate, Power BI) and other Microsoft BI platforms (SSRS, SSAS, etc.)
• Experience with Microsoft Business Intelligence reporting and analytical tools (SSIS, SSAS, SSRS, and SQL Server). Knowledge of other commercial or Open Source tool sets is an asset (SAS, Tableau, etc…)
• Expert data modeler who can define transformed schemas and cubes for analytics use
• Extensive SQL programming skills and solid understanding of relational databases and data architectures in one or more vendor product: Oracle, SQL Server, PostgreSQL, RDS, Aurora, etc
• Self-starter who is able to take ownership and thrive in an independent environment and drive teams through technology change
• Strong experience with ETL tools such as SSIS and SAS, as well as familiarity with standard data extract, de-duping, cleansing, integration, and aggregation techniques and best practices
• Strong project management skills with high attention to detail on data and a strong focus on meeting deliverables with time limitations - must have ability to multitask and prioritize