Role: Data Architect
Location = Onsite. Annapolis, MD
Visa- Any
References = 3, from project/work completed in the resume- must
Other = Proof of education and certifications- must
Skills - Database and analytical skills.
- Knowledge and experience with ETL tools, Visual Studio, and transmitting and reconstructing Extensible Markup Language (XML) and Structured Query Language (SQL).
- Knowledge of scripting languages, such as Python, and the ability to automate repetitive tasks in Azure.
- Ability to:
- Work productively and maintain effective working relationships with peers, end users, vendor development staff, and all levels of management and personnel.
- Critically think and problem solve,
- Provide excellent communication and mentoring needs,
- Quickly evaluate, learn and prototype new technologies.
- Write optimized SQL queries and manage databases, as Azure data analysts frequently interact with Azure SQL database and other SQL-based services.
Experience - BI best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques.
- Dimensional modeling, STAR schema design, Snowflake schema design, slowly changing dimensions, confirmed dimensions.
- 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.
- Designing and implementing database models, schemes, and databases to support efficient data storage, retrieval, and analysis.
- Monitoring and optimizing data systems, data lifecycle, and infrastructure to ensure performance, scalability, and integrity.
- Designing and implementing ETL procedures for intake of data from multiple source systems; as well as ensuring data quality and cleansing is verified.
- Normalization process
- Performing the design and extension of data marts, meta data, and data models.
- Ensuring all data warehouse architecture codes are maintained in a version control system.
- Advanced experience with technologies such as SQL Server 2016 or above, as well as with Azure data factory, SSIS and stored procedures
- Advanced experience developing codes, testing for quality assurance, administering RDBMS.
- High proficiency in dimensional modeling techniques and their applications
- Azure s architecture in order to structure optimized data workflows.
- The following tools:
- Power BI
- Tableau
- Azure Synapse
- Azure Data Factory
- Azure Blob Storage
- Azure Databricks
- Microsoft Fabric
- One Lake