Data Architect

3 days ago

Annapolis, United States Tech Army, LLC Full time

ATTENTION: FOR US CITIZENS AND GC HOLDERS ONLY


Job Description:

  • Participation in all aspects of Data Warehouse (DW) and Extract, Transform, Load (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.
  • Collaborating with the platform administration team to design an ETL process to move data from the source system to the data warehouse, including:
  • Outlining the ETL process and setting the boundaries of data processing.
  • Providing system architecture for each element and the entire data pipeline.
  • Documenting system requirements, managing development, and facilitating necessary knowledge transfer.
  • Assisting in the development/implementation of ETL tools.
  • Conducting testing of the tools and data pipelines.


DW Schema:

  • Developing effective DW models 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.
  • Ensuring all work completed by the proposed resource(s) adheres to regulatory compliance standards to protect sensitive data.
  • Reporting as follows:
  • Weekly progress report on programs and projects.
  • Weekly report communicating project progress and status.
  • Weekly time reporting on JIS-provided forms.
  • Any additional reports as assigned by the supervising manager.


Skills & Experience:

The 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, XML, and SQL.
  • Knowledge of scripting languages, such as Python, and the ability to automate repetitive tasks in Azure.


Communication and Consulting Skills:

  • Strong analytical, consultative, and communication skills.
  • 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.
  • 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, SQL skills, data warehouse, and reporting techniques.
  • Dimensional modeling, STAR schema design, Snowflake schema design, slowly changing dimensions, and confirmed dimensions.
  • Designing and building BI solutions, 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; ensuring data quality and cleansing is verified.
  • Normalization process.
  • Designing and extending data marts, metadata, and data models.
  • Ensuring all data warehouse architecture codes are maintained in a version control system.
  • Advanced experience with SQL Server 2016 or above, 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 architecture to structure optimized data workflows.


Tools:

  • Power BI
  • Tableau
  • Azure Synapse
  • Azure Data Factory
  • Azure Blob Storage
  • Azure Databricks
  • Microsoft Fabric
  • One Lake

  • Data Architect

    2 weeks ago

    Annapolis, United States Tential Full time

    As the Data Architect, you hold a pivotal position responsible for nurturing the growth and success of our Data Practice leading client Data engagements through presales and delivery. This position entails driving presales activities, defining project architectures, and effectively communicating these plans to clients. As a leader within the team, you...

  • Data Architect

    2 days ago

    Annapolis, United States Edify Technologies Full time

    Job Title: Data Architects/EngineersJob Location: Annapolis, MDDuration: 12 MonthsAbout Edify Technologies: Transforming Businesses with Innovative Digital Solutions!Headquartered in Naperville, IL, we are a dynamic team with over two decades of industry expertise, dedicated to delivering robust business solutions, staff augmentation, and a comprehensive...

  • Data Architect

    6 days ago

    Annapolis, United States Edify Technologies Full time

    Job Title: Data Architects/Engineers Job Location: Annapolis, MD Duration: 12 MonthsAbout Edify Technologies: Transforming Businesses with Innovative Digital Solutions!Headquartered in Naperville, IL, we are a dynamic team with over two decades of industry expertise, dedicated to delivering robust business solutions, staff augmentation, and a comprehensive...

  • Data Architect

    5 days ago

    Annapolis, United States Edify Technologies Full time

    Job Title: Data Architects/Engineers Job Location: Annapolis, MD Duration: 12 MonthsAbout Edify Technologies: Transforming Businesses with Innovative Digital Solutions!Headquartered in Naperville, IL, we are a dynamic team with over two decades of industry expertise, dedicated to delivering robust business solutions, staff augmentation, and a comprehensive...

  • Data Architects/Engineers

    3 days ago

    Annapolis, United States Fedtec Full time

    Job DescriptionJob DescriptionFedTec Overview:FedTec is a Woman-Owned Small Business with headquarters in Reston, VA. However, FedTec is more than just a company we are a dedicated team of visionary individuals who understand the power of transformation. With our unwavering commitment to innovative technology and forward-focused methods, we empower...

  • Data Architect/Engineer

    7 days ago

    Annapolis, United States ASCENDING Full time

    Job DescriptionJob DescriptionOverviewThe Hybrid Data Architects/Engineers will provide Data Warehouse Architect/Engineer services to serveas the primary resource(s) responsible for designing and building a data warehouse solution and workingwith conventional data warehouse technologies to devise plans that support designing data warehousesolutions.Work...

  • Data Architect 3

    2 weeks ago

    Annapolis, Maryland, United States JASINT Consulting and Technologies, LLC Full time

    Job Title:Data Architect Level 3 Location(s): Annapolis Junction, Maryland Hours:Regular Full-Time Clearance Requirements This position requires a current and active TS/SCI with Poly at the time of application. What you will be doing:Defines policies, procedures, models and technologies that will be used to collect, organize, store and retrieve information...

  • Data Architect 3

    4 weeks ago

    Annapolis, United States JASINT Consulting and Technologies, LLC Full time

    Job Title: Data Architect Level 3 Location(s): Annapolis Junction, Maryland Hours: Regular Full-Time Clearance Requirements This position requires a current and active TS/SCI with Poly at the time of application. What you will be doing: Defines policies, procedures, models and technologies that will be used to collect, organize, store and retrieve...

  • Data Architect 3

    2 weeks ago

    Annapolis, United States JASINT Consulting and Technologies, LLC Full time

    Job Title: Data Architect Level 3 Location(s): Annapolis Junction, Maryland Hours: Regular Full-Time Clearance Requirements This position requires a current and active TS/SCI with Poly at the time of application. What you will be doing: Defines policies, procedures, models and technologies that will be used to collect, organize, store and retrieve...

  • Hybrid Data Architect/Engineer

    2 days ago

    Annapolis, United States DMI Full time

    About DMI DMI is a leading global provider of digital services working at the intersection of public and private sectors. With broad capabilities across IT managed services, cybersecurity, cloud migration and application development, DMI provides on-site and remote support to clients within governments, healthcare, financial services, transportation,...

  • Hybrid Data Architects/Engineers

    2 days ago

    Annapolis, United States International Software Systems, Inc. Full time

    Hybrid Data Architects /EngineersHybrid remote (2) days remote / (3) days in office Maryland Judiciary Information Systems, 189 Harry S TrumanParticipation 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...

  • Hybrid Data Architects/Engineers

    1 day ago

    Annapolis, United States International Software Systems, Inc. Full time

    Hybrid Data Architects /EngineersHybrid remote (2) days remote / (3) days in office Maryland Judiciary Information Systems, 189 Harry S TrumanParticipation 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...

  • Data Architect

    3 days ago

    Annapolis, United States Tech Army, LLC Full time

    ATTENTION: FOR US CITIZENS AND GC HOLDERS ONLY!!!Job Description:Participation in all aspects of Data Warehouse (DW) and Extract, Transform, Load (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...

  • Data Architect

    1 hour ago

    Annapolis, United States Elegant Enterprise-Wide Solutions, Inc. Full time

    Only LOCAL TO MARYLAND, or Willing to go for F2F Interview SKILLS, EXPERIENCE, & CAPABILITIESa. 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,...

  • Solution Architect

    1 week ago

    Annapolis, United States Pearson Full time

    As a Solution Architect, you'll be a part of our dynamic Professional Services team, crafting innovative solutions within the workforce/HR space. **A Day in the Life of a Solution Architect**: - **Morning Coffee with Clients**: Explore client needs, understand their tech stacks, and craft tailored solutions. - **Prototyping with Python / Workato**: Build...

  • Data Architect/Engineer

    20 hours ago

    Annapolis, United States SHLD, Inc. Full time

    Job DescriptionJob DescriptionThis position will be hybrid, with 3 days onsite in Annapolis, MD. Please only apply if you can commute 3 days to Annapolis.Responsibilities:1. Participation in all aspects of DW and ETL process design, creation, and specification for components.2. Providing the following services in coordination with technical, functional and...

  • Azure Data Architect

    2 days ago

    Annapolis, United States Volitiion IIT Full time

    Job DescriptionJob DescriptionEXPERIENCE, & 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...

  • Machine Learning SoC Architect

    4 weeks ago

    Annapolis, United States Meta Inc Full time

    Summary: Meta is seeking a Machine Learning SoC Architect to join its silicon team within the Infrastructure organization which is responsible for designing and operating all of Meta’s Data Centers. These Data Centers are the foundation upon which our rapidly scaling business operates, and upon which all of our services such as Facebook, Instagram,...

  • Splunk Architect

    3 weeks ago

    Annapolis, United States COMSO Full time

    About us: COMSO, Inc. is a powerhouse when it comes to empowering federal government stakeholders to fulfill their mission with confidence and efficiency. Our staff brings knowledgeable IT systems expertise, software development proficiency, innovative learning solutions for workforce development, and exceptional operations and production support. We were...

  • Senior JAVA Architect

    1 week ago

    Annapolis, United States West Advanced Technologies Full time

    Senior JAVA Architect Annapolis, MD 12+ months Mandatory Qualifications: Eight (8) years of experience in SDLC. Master's degree in computer science or a related field. Experience with: o Financial security and compliance for payment channels; o Developing payments facilitation ecosystem for web apps and standalones; o Both embedded web and...