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