Back to all jobs
Centurion Consulting Group Logo

Centurion Consulting Group

We are hiring 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 client’s initiatives.

Scope of Work

  • 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.
      • Creating a logical warehouse data design.
      • 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, and
    • Any additional reports as assigned by the supervising manager.

Skills & Experience

  • 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 judgment 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 database and other SQL-based services.
    • Experience with:
      • BI best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques.
      • Dimensional modeling, 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, 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

Place of Performance

  • Work shall be performed in a hybrid setting each week, Monday through Friday, as follows:
    • Two (2) days remote at a suitable off-site location
    • Three (3) days on site in Annapolis, MD 21401.

Schedule

  • Work to be performed during normal operating hours, Monday through Friday, 8:00AM to 4:30PM Eastern Standard Time (EDT).
  • The Project Manager or Department/Senior Manager must approve work prior to or after normal operation hours, not to exceed 2,040 hours per year.
  • Depending upon project requirements, candidate must be able to work a flexible schedule to include evenings, nights, weekends, and holidays. Candidate must be available to provide on-call operational support as required outside business hours.
  • A two (2) to four (4) week training period will be provided to acclimate the successful resource(s) in the methods, processes, equipment, and software used by the program

Position Details:

Clearance: N/A

US Citizenship or Authorization to work in US required

Travel: < 10% (CONUS)

Centurion Consulting Group, LLC is an Equal Opportunity Employer EOE M/F/D/V

No third parties or subcontractors

REF: JOB-4815