Annapolis, United States | Posted on 07/05/2024
Job Location: Available to work Hybrid, Annapolis, MD. (3 Days/Week On-Site)
Note: Need 12+ Years of Experience, Need local candidates, In person interview required.
Job Description:
Summary:
- The AOC is seeking proposals from prospective Offerors for two (2) Hybrid Data Architects/Engineers. The Hybrid Data Architects/Engineers will provide Data Warehouse Architect/Engineer services to serve as the primary resource(s) responsible for designing and building a data warehouse solution and working with conventional data warehouse technologies to devise plans that support designing data warehouse solutions in alignment with the Maryland Judiciary’s initiatives.
Roles and Responsibilities:
- Participation in all aspects of DW and ETL process design, creation, and specification for components.
- Providing the following services in coordination with technical, functional and management representatives from JIS and the AOC.
- Source Data Model to DW Logical Design ERD:
- Understanding the general structure of the MDEC data and star schema models currently in use by JIS, and any related data sources identified as a result of initial planning and assessments.
- Collaboration with platform administration team, design an ETL process to move data from the source system to the data warehouse, including, but not limited to, the following:
- Outlining the ETL process, setting the borders of data processing.
- Providing system architecture for each element and the whole data pipeline.
- Documenting the requirements of the system, manage its development and facilitate necessary knowledge transfer.
- Assisting in the actual development/implementation of ETL tools.
- Conducting testing of the tools and data pipelines.
- DW Schema:
- Developing effective DW model(s) representing the data entities of the logical design based on functional analytic, reporting and bulk data requirements.
- DW Physical Design:
- Collaborating with platform administration to assist their efforts in creating a DW Physical design including technical considerations for data quality and operational efficiency.
- Collaborating with business and technology stakeholders to ensure data warehouse architecture development and utilization.
- All work completed by the proposed resource(s) shall be completed within regulatory compliance standards to protect sensitive data.
- Reporting as follows:
- Weekly progress report on programs and project.
- Weekly report communicating project progress and status.
- Weekly time reporting on JIS provided forms.
- Any additional reports as assigned by the supervising manager.
Requirements
Skills
Required / Desired
Experience
Database and analytical skills.
Required
-
Ability to query source data.
Required
-
Knowledge and experience with ETL tools, Visual Studio, and transmitting and reconstructing Extensible Markup Language (XML) and Structured Query Language (SQL).
Required
-
Knowledge of scripting languages, such as Python, and the ability to automate repetitive tasks in Azure.
Required
-
Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel.
Required
-
Work productively and maintain effective working relationships with peers, end users, vendor development staff, and all levels of management and Judicial personnel.
Required
-
Critically think and problem solve.
Required
-
Provide excellent communication and mentoring needs.
Required
-
Quickly evaluate, learn, and prototype new technologies.
Required
-
Write optimized SQL queries and manage databases, as Azure data analysts frequently interact with Azure SQL database and other SQL-based services.
Required
-
BI best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques.
Required
-
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.
Required
-
Designing and implementing database models, schemes, and databases to support efficient data storage, retrieval, and analysis.
Required
-
Monitoring and optimizing data systems, data lifecycle, and infrastructure to ensure performance, scalability, and integrity.
Required
-
Designing and implementing ETL procedures for intake of data from multiple source systems; as well as ensure data quality and cleansing is verified.
Required
-
Performing the design and extension of data marts, meta data, and data models.
Required
-
Ensuring all data warehouse architecture codes are maintained in a version control system.
Required
-
Advanced experience with technologies such as SQL Server 2016 or above, as well as with Azure data factory, SSIS and stored procedures.
Required
-
Advanced experience developing codes, testing for quality assurance, administering RDBMS.
Required
-
High proficiency in dimensional modeling techniques and their applications.
Required
-
Azure’s architecture to structure optimized data workflows.
Required
-
The following tools: Power BI, Tableau, Azure Synapse, Azure Data Factory, Azure Blob Storage, Azure Databricks, Microsoft Fabric, One Lake.