Company:
BeaconGov
Location: Annapolis
Closing Date: 06/08/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Education:
Bachelor's degree in computer science, or a related field (as determined by the Client)
Skills, Experience, & Capabilities:
Offeror shall propose resource(s) possessing the following preferred skills, experience, and capabilities:
Database and analytical skills.
Ability to query source data.
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.
Strong analytical, consultative, and communication skills; as well as the ability to make good judgments and work with both technical and business personnel.
Ability to:
Work productively and maintain effective working relationships with peers, end users, vendor development staff, and all levels of management and Judicial 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 databases and other SQL-based services.
Experience with:
BI best practices, relational structures, dimensional data modelling, structured query language (SQL) skills, data warehouse and reporting techniques.
Dimensional modelling, STAR schema design, Snow fake 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 ensure data quality and cleansing is verified.
Normalization process
Performing the design and extension of data marts, metadata, 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 modelling 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
Education:
Bachelor's degree in computer science, or a related field (as determined by the Client)
Skills, Experience, & Capabilities:
Offeror shall propose resource(s) possessing the following preferred skills, experience, and capabilities:
Database and analytical skills.
Ability to query source data.
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.
Strong analytical, consultative, and communication skills; as well as the ability to make good judgments and work with both technical and business personnel.
Ability to:
Work productively and maintain effective working relationships with peers, end users, vendor development staff, and all levels of management and Judicial 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 databases and other SQL-based services.
Experience with:
BI best practices, relational structures, dimensional data modelling, structured query language (SQL) skills, data warehouse and reporting techniques.
Dimensional modelling, STAR schema design, Snow fake 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 ensure data quality and cleansing is verified.
Normalization process
Performing the design and extension of data marts, metadata, 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 modelling 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