Talent.com
SQL Server Data Warehouse Architect
SQL Server Data Warehouse ArchitectManTech International Corporation • Tampa, FL, United States
SQL Server Data Warehouse Architect

SQL Server Data Warehouse Architect

ManTech International Corporation • Tampa, FL, United States
1 day ago
Job type
  • Full-time
Job description

Description & Requirements

Elevate your career with MANTECH International Corporation! Join a dynamic team dedicated to national security through cutting-edge technology. Since 1968, MANTECH has led in delivering advanced solutions to government intelligence, the Department of Defense, and Federal Civilian sectors. Dive into innovation in Digital Transformation, Cybersecurity, IT, Data Analytics and Software Development. Your journey to impactful work and rapid growth starts now-be extraordinary at MANTECH!

  • This is for a future opportunity

MANTECH seeks a motivated, career and customer-oriented SQL Server Data Warehouse Architect to join our team. This is a remote role that may require occasional travel to Tampa, FL.

Responsibilities include but are not limited to :

  • Design, architect, and build the required structure to store and maintain financial and budgetary data.
  • Provide technical database design, administration, and maintenance functions necessary for the development of databases that will contain all Planning, Programming, Budgeting, and Execution (PPBE) data utilized by the enterprise.
  • Migrate data from Oracle data warehouse to a SQL Server based data warehouse. The required solution utilizes physical servers operating Windows 2022 operating system and SQL server, and virtual machines operating on Windows 2022 server operating system.
  • Configure and build the databases and data warehouses in Microsoft SQL Server. Data currently residing in an Oracle 12c relational database must be migrated to SQL Server.
  • Create Data Migration Plan and execute the plan to migrate budget data from 2017 to current, from Oracle into the SQL Server data warehouse
  • Provide support to other team members responsible for creating business intelligence dashboards and reports.
  • Data analysis, problem solving, investigation and creative thinking with large amounts of data supporting a variety of scenarios and work closely with the client to assist in managing data needs and supporting collection of data needed for various operational needs.
  • Minimum Qualifications :

  • Bachelor's degree in a relevant field such as Computer Science, Information Technology, Software Engineering, Data Science, or a related STEM discipline, or 8 years of related experience may be accepted in lieu of the degree.
  • 8 years of experience in data architecture or related roles, including experience with data modeling, database design, and data integration Proficiency in data modeling, database design, data warehousing, and ETL processes
  • Proven experience developing and maintaining data models and data dictionaries
  • Proven experience working with and implementing data quality checks to identify errors and address outdated business rules
  • Demonstrated proficiency with Microsoft SQL Server
  • Proven data warehouse and ETL experience, including data warehouse design
  • Proven experience with SQL Server Migration Assistant for Oracle (SSMA) or similar tool
  • Data migration experience with SQL Server Integration Services (SSIS)
  • CompTIA Security+ certification
  • Preferred Qualifications :

  • Oracle database experience
  • Experience with TIBCO EBX master data management
  • Experience converting OBIEE reports to Power BI.
  • Experience implementing Federal financial management systems such as OneStream (highly preferred), Hyperion, or other Corporate Performance Management platforms
  • Master's degree in business administration (MBA) or a related field.
  • Advanced certifications, such as those related to SQL Server, data warehouses, business intelligence, and Agile methodologies
  • Clearance Requirements :

  • Must have a current / active Top Secret security clearance and may be required to obtain a TS / SCI security clearance.
  • Physical Requirements :

  • Must be able to remain in a stationary position 50%
  • The person in this position frequently communicates with co-workers, management and customers, which may involve delivering presentations. Must be able to exchange accurate information in these situations
  • Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine and computer printer.
  • MANTECH International Corporation considers all qualified applicants for employment without regard to disability or veteran status or any other status protected under any federal, state, or local law or regulation.

    If you need a reasonable accommodation to apply for a position with MANTECH, please email us at careers@mantech.com and provide your name and contact information.

    Create a job alert for this search

    Data Warehouse Architect • Tampa, FL, United States

    Related jobs
    Sr Software Engineer (SQL / Java)

    Sr Software Engineer (SQL / Java)

    RIT Solutions, Inc. • Tampa, FL, United States
    Full-time
    Sr Software Engineer (SQL / Java).Medicare and Medicaid experience is a nice to have but skillset level is most important • •. Hibernate / JPA / MyBATIS (5-7 years).Show more
    Last updated: 30+ days ago • Promoted
    Treasury Data Solutions Analyst - AVP / C12

    Treasury Data Solutions Analyst - AVP / C12

    Citigroup Inc • Tampa, FL, United States
    Full-time
    The Liquidity Change and Data Management team within the Treasury organization works closely with stakeholders to define, drive and execute end-to-end process design and implementation efforts for ...Show more
    Last updated: 17 days ago • Promoted
    Azure Data Engineer / Azure Databricks Administrator

    Azure Data Engineer / Azure Databricks Administrator

    Diverse Lynx • Tampa, FL, United States
    Full-time
    Position : Azure Data Engineer / Azure Databricks Administrator.Type of Hire : - Long Term Contract.We are seeking a skilled Azure Data Engineer / Azure Databricks Administrator to join our data engine...Show more
    Last updated: 1 day ago • Promoted
    Siem Sour

    Siem Sour

    Purple Drive • Tampa, FL, United States
    Full-time
    At least 5+ years of experience in technology with emphasis on cyber security.At least 3+ years of experience in SIEM and SOAR products such as Splunk, Elastic, Datadog, Cribl, etc.At least 1+ year...Show more
    Last updated: 15 days ago • Promoted
    Lead Cloud Architect

    Lead Cloud Architect

    RIT Solutions, Inc. • Tampa, FL, United States
    Temporary
    Lead Cloud Architect - Healthcare Company.Must have hands on experience working with.Must have Lead Application Architect experience. Healthcare Tech experience is a big plus.Health Insurance experi...Show more
    Last updated: 30+ days ago • Promoted
    Test Data Architect

    Test Data Architect

    CData Software • Tampa, FL, United States
    Full-time
    Seeking for an experienced Senior Data Architect Advisor in healthcare leading the planning, development and execution of data and automation initiatives in Carelon Rx based on established roadmaps...Show more
    Last updated: 1 day ago • Promoted
    Sr Manager, SAP Master Data and Data Governance

    Sr Manager, SAP Master Data and Data Governance

    Refresco • Tampa, FL, US
    Full-time
    Make a Difference in YOUR Career! Our vision is both simple and ambitious : to put our drinks on every table.We are the leading global independent beverage solutions provider.We serve a broad range ...Show more
    Last updated: 1 hour ago • Promoted • New!
    Cloud Architect

    Cloud Architect

    Booz Allen Hamilton • Tampa, FL, United States
    Full-time +1
    Lead the design and implementation of secure, scalable cloud solutions for our logistics IT infrastructure.Optimize cloud environments to support logistics systems such as warehouse management, tra...Show more
    Last updated: 10 days ago • Promoted
    Oracle PL / SQL developer - Tampa / NJ / Dallas

    Oracle PL / SQL developer - Tampa / NJ / Dallas

    Staffing the Universe • Tampa, FL, United States
    Full-time
    Duration : 12 months (possible ext) Exp : 3-4+ (mid level).Preferable candidate location : Tampa / NJ / Dallas (in case clients call for onsite). Mandatory skills : Oracle PL / SQL, SQL, Unix shell scripting....Show more
    Last updated: 1 day ago • Promoted
    Senior Data Engineer

    Senior Data Engineer

    Toorak Capital Partners • Tampa, Florida, US
    Full-time
    Ready to make your application Please do read through the description at least once before clicking on Apply.Toorak Capital Partners is an integrated correspondent lending and table funding platfor...Show more
    Last updated: 5 days ago • Promoted
    Business Solution Architect

    Business Solution Architect

    GAC Solutions • Tampa, FL, US
    Full-time
    Proven success delivering large-scale functional, integration, migration and reporting cloud-based projects using agile methodologies. Insurance industry experience is required.Property casualty is ...Show more
    Last updated: 9 days ago • Promoted
    Lead Cloud Architect

    Lead Cloud Architect

    Confidential • Tampa, FL, United States
    Full-time
    A reputable company in the government contracting industry committed to excellence.Join our team as a Lead Cloud Architect, where you will play a vital role in shaping our cloud architecture and st...Show more
    Last updated: 30+ days ago • Promoted
    SQL Server DBA

    SQL Server DBA

    RIT Solutions, Inc. • Tampa, FL, United States
    Full-time
    Contract Duration : Initial contract 3-6 months, likely extension for the right person.Please note where they have the following and note the areas where they might be light).SQL Server DBA (mid to ...Show more
    Last updated: 1 day ago • Promoted
    Manager, Cloud Architect

    Manager, Cloud Architect

    KPMG • Tampa, FL, United States
    Full-time
    Known for being a great place to work and build a career, KPMG provides audit, tax and advisory services for organizations in today's most important industries. Our growth is driven by delivering re...Show more
    Last updated: 21 days ago • Promoted
    Cloud Architect

    Cloud Architect

    RIT Solutions, Inc. • Tampa, FL, United States
    Full-time
    Title- Cloud Integration Engineer.We are hiring an energetic, motivated, innovative individual to be a part of our team supporting Center for Medicare and Medicaid Services (CMS) in Baltimore, MD.T...Show more
    Last updated: 30+ days ago • Promoted
    Server

    Server

    Yeoman's TopGolf Swing Suite • Tampa, FL, United States
    Full-time
    Ready to quit your day job and jump into the restaurant industry with us? We're not your average restaurant, and we don't want your average Server, better known as a Vibe Setter.Are you ready to h...Show more
    Last updated: less than 1 hour ago • Promoted • New!
    Cloud Architect - VP

    Cloud Architect - VP

    MUFG • Tampa, FL, United States
    Full-time
    Do you want your voice heard and your actions to count?.Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), one of the world's leading financial groups. Across the globe, we're 150...Show more
    Last updated: 30+ days ago • Promoted
    USA_Analyst

    USA_Analyst

    Varite • Tampa, FL, United States
    Full-time
    At least 5+ years of experience in technology with emphasis on cyber security.At least 3+ years of experience in SIEM and SOAR products such as Splunk, Elastic, Datadog, Cribl, etc.At least 1+ year...Show more
    Last updated: 29 days ago • Promoted