Data Architect

Skills, Experience, & Capabilities


a. Database and analytical skills.


b. Ability to query source data.


c. Knowledge and experience with ETL tools, Visual Studio, and transmitting and


reconstructing Extensible Markup Language (XML) and Structured Query Language (SQL).


d. Knowledge of scripting languages, such as Python, and the ability to automate repetitive


tasks in Azure.
e. Strong analytical, consultative, and communication skills; as well as the ability to make good


judgment and work with both technical and business personnel.

f. Ability to:


(1) Work productively and maintain effective working relationships with peers, end


users, vendor development staff, and all levels of management and Judicial


personnel.


(2) Critically think and problem solve,


(3) Provide excellent communication and mentoring needs,


(4) Quickly evaluate, learn and prototype new technologies.


(5) Write optimized SQL queries and manage databases, as Azure data analysts


frequently interact with Azure SQL database and other SQL-based services.

g. Experience with:


(1) BI best practices, relational structures, dimensional data modeling, structured query


language (SQL) skills, data warehouse and reporting techniques.


(2) Dimensional modelling, STAR schema design, Snow flake schema design, slowly


changing dimensions, confirmed dimensions.


(3) Designing and building BI solutions by monitoring and tuning queries and data


loads, addressing user questions concerning data integrity, data mapping, monitoring


performance and communicating functional and technical issues.


(4) Designing and implementing database models, schemes, and databases to support


efficient data storage, retrieval, and analysis.


(5) Monitoring and optimizing data systems, data lifecycle, and infrastructure to ensure


performance, scalability, and integrity.


(6) Designing and implementing ETL procedures for intake of data from multiple


source systems; as well as ensure data quality and cleansing is verified.


(7) Normalization process


(8) Performing the design and extension of data marts, meta data, and data models.


(9) Ensuring all data warehouse architecture codes are maintained in a version control


system.


(10) Advanced experience with technologies such as SQL Server 2016 or above, as well


as with Azure data factory, SSIS and stored procedures


(11) Advanced experience developing codes, testing for quality assurance, administering


RDBMS.


(12) High proficiency in dimensional modelling techniques and their applications


(13) Azure's architecture to structure optimized data workflows.


(14) The following tools:


i Power BI


ii Tableau


iii Azure Synapse


iv Azure Data Factory


v Azure Blob Storage


vi Azure Databricks


vii Microsoft Fabric


viii One Lake