Data Architects/Engineers

1 week ago

Annapolis, United States Omm IT Solutions Full time
Job Description
Please Note: This is a Hybrid Position with two days remote and 3 days onsite.About the Position:

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.

Candidate shall be responsible for the following:

  • 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 Client 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 Client, 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 Client provided forms, and
  • Any additional reports as assigned by the supervising manager.
Key Required Tools/Skills:
  • Power BI
  • Tableau
  • Azure Synapse
  • Azure Data Factory
  • Azure Blob Storage
  • Azure Databricks
  • Microsoft Fabric
  • One Lake
Requirements

Basic Qualifications and Skills:

Candidate should be possessing the following preferred skills, experience, and capabilities:
  • Bachelor's degree with at least 5 years of experience
  • 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.

  • Data Architect for Complex Systems

    6 days ago

    Annapolis, Maryland, United States Data Computer Corp of America Full time

    DCCA, a veteran-owned IT business, is seeking an experienced Data Architect to direct the development of complex systems. With over 40 years of experience in providing innovative solutions to government agencies and commercial enterprises, we pride ourselves on a culture built on integrity and inclusivity.The successful candidate will have a Bachelor's...

  • Senior Data Architect

    7 days ago

    Annapolis, Maryland, United States Omm IT Solutions Full time

    Job OverviewOmm IT Solutions seeks a highly skilled Data Architect/Engineer to join our team. The ideal candidate will have experience designing and implementing data warehouse solutions using conventional technologies.About the PositionThe Hybrid Data Architect/Engineer will serve as the primary resource responsible for designing and building a data...

  • Lead Data Streaming Architect

    6 days ago

    Annapolis, Maryland, United States Confluent Full time

    About ConfluentWe're a pioneering company in the data streaming space, dedicated to empowering organizations to harness the power of continuously flowing data. Our mission is to create a new category within data infrastructure that enables every organization to create experiences and utilize the power of data in profound ways.At Confluent, our purpose drives...

  • AWS Cloud Software Engineer

    7 days ago

    Annapolis Junction, Maryland, United States Reflexive Concepts Full time

    Job Title: AWS Cloud Software EngineerJob Description:Reflexive Concepts is seeking a skilled Sr. AWS Cloud Software Engineer to fill a critical role in our team.Key Responsibilities:* Design and implement data flow and analytic services using AWS Cloud Services* Develop and deploy applications using Docker, Spring/WebFlux framework, and Java, Maven, JFrog,...

  • Senior Data Model Architect

    6 days ago

    Annapolis Junction, Maryland, United States Acclaim Technical Services Full time

    Job Summary: We are seeking a highly skilled Data Model Development Lead to join our team at Acclaim Technical Services.About the Role: As a Data Model Development Lead, you will be responsible for defining and governing data models, setting standards for how data is represented in databases, and identifying requirements through multiple stakeholder...

  • Data Architect

    7 days ago

    Annapolis Junction, Maryland, United States Parsons Company Full time

    About the RoleWe are seeking a highly skilled Data Architect to join our team at Parsons. In this role, you will serve as a consultant to the business unit in long-range planning, focusing on new or projected areas of technological research and advancements.Key ResponsibilitiesEnhance existing systems and modernize legacy systems to a state-of-the-art level...

  • Senior Software Engineer

    2 days ago

    Annapolis, United States Tyler Technologies Full time

    We are looking for a remarkable Senior Software Engineer to join us! We've built a team of not just the best engineers, but some really awesome humans as well. This team builds cloud software (platform + apps + ecosystem) to accelerate the flow of government data into the hands of citizens, developers, businesses and researchers. With our Data & Insights...

  • Senior Database Architect

    6 days ago

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

    Job Title: Senior Database ArchitectLocation: Annapolis Junction, MDJob Type: Full-timeAbout Us: JASINT Consulting and Technologies, LLC is seeking a skilled Senior Database Architect to join our team.About the Role: We are looking for an experienced Senior Database Architect to provide guidance and assistance in the analysis, design, implementation, and...

  • System Architect for Data Integration and Automation

    2 days ago

    Annapolis Junction, Maryland, United States Belay Technologies Full time

    About the Company", Belay Technologies is a leading provider of systems automation and full-stack development solutions. Our team of experts specializes in delivering cutting-edge technology and engineering services to the DoD and commercial clients.", "Job Summary", We are seeking a highly skilled System Engineer (L2 or L3 SPLUNK Architect) to join our...

  • Strategic Data Architect

    2 days ago

    Annapolis Junction, Maryland, United States Booz Allen Hamilton Full time

    About the RoleWe're seeking a talented Software and Data Engineer to join our Strategic Innovation team at Booz Allen Hamilton. This is an exciting opportunity to leverage your expertise in software and data engineering to drive innovation and make a real-world impact on national security.As a Software and Data Engineer, you will be responsible for designing...

  • Senior Security IT Architect for Enterprise Trust

    6 days ago

    Annapolis, Maryland, United States Trustmark Full time

    Enterprise Trust Senior Security IT ArchitectAt Trustmark, we strive to improve wellbeing – for everyone. Our mission is grounded in a belief in equality and born from our caring culture. This culture can only be realized by building trust. Trust established by ensuring associates feel respected, valued, and heard.We are seeking an experienced Senior...

  • Data Engineer

    1 week ago

    Annapolis, United States Base2 Solutions Full time

    Base-2 Solutions is seeking a Mid-Level Data Engineer. Job Description As a data engineer/integrator on the program your role entails collaborating closely with a team of developers to fulfill data integration requirements. This involves writing and maintaining code using an Extract-Transform-Load (ETL) Platform to ensure data is transformed into suitable...

  • Highly Skilled Systems Architect

    6 days ago

    Annapolis, Maryland, United States Orbis Operations Full time

    Orbis Operations is a leading provider of innovative solutions to government agencies, and we are currently seeking a highly skilled Systems Architect to join our team in Annapolis Junction, MD. Estimated Salary: $120,000 - $200,000 per year.About the RoleThe successful candidate will be responsible for designing, developing, and maintaining complex...

  • Sr. Solutions Architect

    2 weeks ago

    Annapolis Junction, United States ManTech Full time

    Become an integral part of a diverse team while working at an Industry Leading Organization, where our employees come first. At ManTech International Corporation, you’ll help protect our national security while working on innovative projects that offer opportunities for advancement. Currently, ManTech is seeking a motivated, career and customer-oriented...

  • Senior Solutions Architect Manager

    4 weeks ago

    Annapolis, United States Capital One Full time

    Are you ready to join a leading technology-driven company? Capital One is dedicated to delivering exceptional products and experiences for our customers. We are looking for a talented Solutions Architect Manager to lead our innovative team in Card Tech. In this exciting role, you will play a key part in designing and implementing cutting-edge solutions for...

  • Chief Software Architect

    7 days ago

    Annapolis Junction, Maryland, United States GliaCell Technologies Full time

    GliaCell Technologies, a leading provider of software and system engineering solutions, is seeking an experienced Chief Software Architect to join their team. This role offers a unique opportunity to work on high-profile government contracts and contribute to the development of critical mission-related software and systems.As a Chief Software Architect at...

  • Data Engineering Advocate

    2 weeks ago

    Annapolis, Maryland, United States Pathway Full time

    About PathwayPathway is a deeptech start-up founded in 2020. Our primary offering is an ultra-performant Data Processing Framework with a Python API, distributed Rust engine, and capabilities for data source integration & transformation at scale.We provide a single-machine version on a free-to-use license.Data use cases revolve around event-stream data (IoT)...

  • Senior IT Architect, Security

    4 weeks ago

    Annapolis, United States Trustmark Full time

    Trustmark Senior IT Architect, Security Annapolis, Maryland Apply NowTrustmark’s mission is to improve wellbeing – for everyone. It is a mission grounded in a belief in equality and born from our caring culture. It is a culture we can only realize by building trust. Trust established by ensuring associates feel respected, valued and heard. At Trustmark,...

  • Cloud Security Systems Architect

    6 days ago

    Annapolis, Maryland, United States SilverEdge Full time

    Job Description:This position is open for a highly skilled Cloud Security Systems Architect to join our team at SilverEdge Government Solutions. The successful candidate will be responsible for coordinating efforts with personnel supporting other products and daily tasks may include requirements analysis, engineering and design in an agile environment.About...

  • Senior Network Architect

    1 week ago

    Annapolis Junction, United States ManTech Full time

    Become an integral part of a diverse team while working at an Industry Leading Organization, where our employees come first. At ManTech International Corporation, you’ll help protect our national security while working on innovative projects that offer opportunities for advancement. Currently, ManTech is seeking a motivated, career and customer-oriented...