Performs validation on incoming data files, resolves data quality issues, and coordinates preventative corrective actions with the appropriate vendors or internal teams when errors are present.
Designs programmatic methods (automation) to ingest, clean, process, test, and serve data to the business. The BI Engineer designs and implements methods for improving data processing, accuracy, and reporting.
Investigates and diagrams data processes, identifies opportunities for improvement, recommends and engineers a solution within Azure (Data Factory – ETL Notebooks (Python & SQL) One Lake, and deployment pipeline semantic layer design).
Works closely with the business to understand informational needs, and to model consumption layer data.
Takes a continuous learner’s approach to maintaining industry knowledge and technical skillset.
Journals work assignments for the benefit of team knowledge management.
Upholds data governance by journaling all data asset information within Microsoft Purview (Azure).
Assists with executing and delivery of operational reporting as needed.