Data Architect with Advanced BI Capabilities

2 days ago


Ellicott City, Maryland, United States Omm IT Solutions Full time

About the Position:

Omm IT Solutions is seeking an experienced Data Architect with advanced Business Intelligence (BI) capabilities to lead our technology initiatives. This is a hybrid position with 2 days onsite and 3 days remote.

Job Description:

  • We are looking for a highly skilled data architect to lead the development of complex enterprise applications, focusing on database design, architecture, and implementation. The ideal candidate will have experience in relational database management systems, including database design, stored procedures, views, triggers, functions, tables, indexes, data import and export processes, schema creation, data dictionaries, master and meta data management, and reporting.
  • The successful candidate will be responsible for setting standards and developing SQL programming and SQL objects, including stored procedures, views, triggers, functions, tables, indexes. They will also execute database solutions, ensuring stability, reliability, and performance, establishing best practices, and working with other developers in optimizing database and applications.
  • This role requires leadership in designing, developing, maintaining, administering, and supporting ongoing needs of enterprise business intelligence platforms, including dashboard development, data warehousing data model development, extract transform load (ETL) activities, and reporting and analytical development.
  • The ideal candidate will have experience incorporating best practices around data visualization and possess excellent visualization skills to convey customer data in an intuitive and visually compelling way.
  • They will work directly with business owners in the development of various reports and respond to ad hoc reporting requests. Leadership and guidance in user security management, software release management, end-user and technical issue troubleshooting, system software upgrade, and dashboard portal design are also required.
  • Responsibilities include developing business requirements and tools for process development, system enhancements, and continuous improvement. The candidate will work with groups of users to define needs and translate user requirements into system requirements.
  • Ensuring application and database meet business requirements by working with stakeholders and translating user requirements into system requirements is essential. Providing viable solutions and recommendations leveraging industry standards and best practices, taking into account current environment, disaster recovery, data integrity, and security, are key aspects of this role.
  • The ideal candidate will create high and low-level design documents for systems and applications and provide training and help to express and unify understanding of architecture.
  • Experience working with Agile Scrum development in a fast-paced, highly technical environment is necessary.

Requirements:

  • A minimum of 10 years of experience in complex enterprise application development, Microsoft Visual Studio development environment, Microsoft .Net development environment, application architecture, and object-oriented design.
  • Familiarity with ASP.NET or VB.Net, C#.Net with MVC Entity Framework, .NET Web services (ASP.NET Web Services, WCF, WPF), scripting languages (VB Script, Java Script), markup languages (HTML, DHTML, XML), and relational database management systems (RDBMS).
  • At least 5 years of experience working in Microsoft Business Intelligence Studio, Microsoft SQL Integration Services, creating and managing ETL packages using SSIS, Microsoft SQL Server Reporting Services, and advanced Microsoft SQL Server Reporting Services reporting development.
  • Possession of excellent visualization skills and experience incorporating best practices around data visualization.
  • Positive references from other K-12 school systems and/or government organizations.

Estimated Salary Range: $120,000 - $180,000 per year



  • Maryland City, Maryland, United States Oakland Consulting Group, Inc. Full time

    Job Title: Senior Power BI DeveloperAbout the Role:The Oakland Consulting Group, Inc. is seeking a skilled Senior Power BI Developer to design, develop, and maintain advanced data visualization solutions using Microsoft Power BI. This role involves creating complex reports and dashboards to provide actionable insights and support business decision-making.Key...


  • Maryland City, Maryland, United States Johns Hopkins Applied Physics Laboratory (APL) Full time

    Job Title: Senior Project ArchitectThe Johns Hopkins University Applied Physics Laboratory (APL) is seeking a talented Senior Project Architect to join our team. As a Senior Project Architect, you will play a crucial role in designing and constructing buildings that meet the needs of our nation's most critical defense, security, space, and science...


  • Ellicott City, Maryland, United States DCCA Full time

    Job SummaryWe are seeking a highly skilled Senior Java Software Engineer to join our team at DCCA. As a key member of our software development team, you will be responsible for designing and developing complex software systems using Java and related technologies.Key Responsibilities:Design and develop multi-tier, enterprise web-based solutions using Java EE,...


  • Ellicott City, Maryland, United States SonderMind Full time

    About SonderMindSonderMind is a leading mental health care platform that is revolutionizing therapy services. We are committed to delivering best-in-class care to all individuals by focusing on high-quality clinical outcomes and leveraging data to help people get better.Therapist OpportunitiesWe seek compassionate and highly skilled licensed mental health...


  • Ellicott City, Maryland, United States Resource Energy Corporation Full time

    Job SummaryResource Energy Corporation is seeking a highly skilled Energy Billing Specialist to support our clients with primary responsibility for tenant utility billing calculations. The role encompasses a detailed and analytically driven framework revolving around energy calculations and accounting.Key ResponsibilitiesPrepares client utility budgets and...


  • Maryland City, Maryland, United States Johns Hopkins Applied Physics Laboratory (APL) Full time

    Are you passionate about advancing the capabilities of optical communications and synchronization of distributed systems?We are seeking an engineer to contribute to projects in optical communications, precision synchronization, and control of advanced photonic systems for state-of-the-art applications.As a Photonic Systems Firmware Engineer at Johns Hopkins...


  • Ellicott City, Maryland, United States The Bob & Ronna Group Full time

    Marketing Department Support SpecialistFull-Time Career PositionKey Responsibilities:Support the Marketing Department in organizing various projects and monitoring marketing analytics techniques to gather important data.Complete daily administrative tasks to ensure the functionality and coordination of the department's activities.Assist in the organizing of...


  • Ellicott City, Maryland, United States DCCA Full time

    Medicaid Finance ExpertAt DCCA, we are seeking a highly skilled Medicaid Finance Expert to join our team. As a Medicaid Finance Expert, you will be responsible for working with Product Owners and Business Owners to define objectives, processes, policies, procedures, and rules related to the Medicaid and CHIP Financial (MACFin) system.Key...


  • Ellicott City, Maryland, United States Penn Foster Inc Full time

    About the Role:We are seeking a highly skilled Senior Designer to join our team at Blackpoint Cyber. As a Senior Designer, you will be responsible for developing and maintaining Blackpoint's brand identity, collaborating with the Creative Director to establish brand guidelines that represent our mission and values.Key Responsibilities:Use advanced skills in...


  • Ellicott City, Maryland, United States Howard County Public School System Full time

    Job SummaryWe are seeking a skilled Generator Maintenance Specialist to join our team at the Howard County Public School System. As a Generator Maintenance Specialist, you will be responsible for performing routine maintenance and repairs on our emergency generators to ensure they are operational and reliable in case of power failure.Key...


  • Maryland City, Maryland, United States The Swift Group Full time

    Job SummaryWe are seeking a highly skilled Principal Engineer to join our team at The Swift Group. This is a unique opportunity to lead complex technical projects and drive innovation in system engineering.Key ResponsibilitiesSystem Engineering Leadership: Provide technical direction for the development, engineering, and integration of complex...


  • Maryland City, Maryland, United States GliaCell Technologies LLC Full time

    GliaCell Technologies LLC is a cutting-edge software and system engineering company specializing in Enterprise and Cyber Security solutions. We pride ourselves on delivering stable and reliable software solutions using Agile Software Development principles, providing a quick turn-around using interactive applications and the integration of industry-standard...


  • Maryland City, Maryland, United States Johns Hopkins Applied Physics Laboratory (APL) Full time

    Job Title: Senior Radar/EO/IR System EngineerWe are seeking a highly skilled Senior Radar/EO/IR System Engineer to join our team at the Johns Hopkins Applied Physics Laboratory (APL). As a key member of our team, you will play a critical technical leadership role in fielding next-generation Navy Radar/EO/IR and Electronic Warfare systems and land-based...


  • Maryland City, Maryland, United States Johns Hopkins Applied Physics Laboratory Full time

    Job DescriptionWe are seeking an experienced engineer to help us design and develop concepts and algorithms that will solve complex sensor and source integration and data association challenges in networked sensor systems.Key ResponsibilitiesDesign, develop, and assess sensor and source integration and data association techniques for incorporation into...


  • Maryland City, Maryland, United States Johns Hopkins Applied Physics Laboratory (APL) Full time

    Job DescriptionWe are seeking a highly skilled Systems Engineering Modeling Project Lead to join our team at the Johns Hopkins Applied Physics Laboratory (APL). As a key member of our team, you will be responsible for leading the development and integration of sophisticated electro-optical/infrared (EO/IR) systems using model-based systems engineering (MBSE)...


  • Maryland City, Maryland, United States The Johns Hopkins University Applied Physics Laboratory Full time

    Electromagnetic Systems EngineerWe are seeking a highly skilled Electromagnetic Systems Engineer to join our team at The Johns Hopkins University Applied Physics Laboratory. As an Electromagnetic Systems Engineer, you will be responsible for developing and optimizing large-scale simulations of electromagnetic fields and radar systems. You will work closely...


  • Maryland City, Maryland, United States Capitol Technology University Full time

    Director of Marketing and CommunicationsCapitol Technology University seeks a highly skilled Director of Marketing and Communications to join our team. The successful candidate will be responsible for developing and implementing marketing and communications strategies to support the University's enrollment and advancement goals.Key...


  • Maryland City, Maryland, United States The Johns Hopkins University Applied Physics Laboratory Full time

    Job SummaryWe are seeking a highly skilled Systems Engineer to join our team at The Johns Hopkins University Applied Physics Laboratory (APL). As a Space Kill Chain Engineer, you will be responsible for designing and developing innovative systems to support the nation's space-based defense capabilities.Key Responsibilities:Conceive novel and effective threat...


  • Ocean City, Maryland, United States Oak View Group Full time

    Job Summary:Oak View Group is seeking a highly skilled Customer Service Representative to join our team. As a key member of our operations team, you will be responsible for ensuring the smooth operation of our concession stands, providing exceptional customer service, and maintaining accurate financial records.Key Responsibilities:Oversee the handling of...


  • Maryland City, Maryland, United States Johns Hopkins Applied Physics Laboratory (APL) Full time

    Job DescriptionWe are seeking a highly motivated and skilled Biomechanical Engineer to join our Human Performance and Biomechanics team at the Johns Hopkins University Applied Physics Laboratory (APL). As a key member of our team, you will be responsible for leading research efforts in biomechanics, developing advanced protection solutions for the...