SQL Server Data Warehouse ArchitectManTech International Corporation • Tampa, FL, United States

SQL Server Data Warehouse Architect

ManTech International Corporation • Tampa, FL, United States

3 days 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

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: 20 days ago • Promoted

Database Administrators

Mercor • Tampa, Florida, US

Remote

Temporary

Role Overview • • Mercor is collaborating with a leading AI organization to identify experienced Database Administrators for a high-priority training and evaluation project.Freelancers will be tasked...Show more

Last updated: 20 hours ago • Promoted • New!

Data Agency - Apps Dev Tech Lead Analyst - C13 - TAMPA

Citi • Tampa, Florida, United States

Full-time

C13 Applications Development Technology Lead Analyst.Applications Development Technology Lead Analyst (Senior Java developer and team lead) responsible for building out the firm’s strategic referen...Show more

Last updated: 30+ days ago • Promoted

Data Engineer

Gandiva Insights • Tampa, Florida, USA

Full-time +1

Design and develop BI solutions.Gather user requirements develop technical and functional requirements produce reporting solutions and document the design and development process metadata and busin...Show more

Last updated: 20 days ago • Promoted

System Architect

CAE • Tampa, Florida, USA

Full-time

Our vision is to be the worldwide partner of choice in defense and security civil aviation and healthcare by revolutionizing our customers training and critical operations with digitally immersive ...Show more

Last updated: 25 days ago • Promoted

Snowflake Consultant

GTN Technical Staffing • Tampa, Florida, USA

Full-time

What we are looking for are technical experts that can validate / tweak our initial design decisions and then help us to initiate the implementations. Below are some key areas we are looking for assis...Show more

Last updated: 24 days ago • Promoted

Database Architects (Professional, Scientific, and Technical Services)

Mercor • Tampa, Florida, US

Remote

Full-time

Mercor is recruiting • •Database Architects who work in the Professional, Scientific, and Technical Services • • as independent contractors working on a research project • •for one of the world’s top A...Show more

Last updated: 20 hours ago • Promoted • New!

HP Nonstop DBA – Database Engineer

TekWissen LLC • Tampa, Florida, USA

Full-time +1

TekWissen is a global workforce management provider headquartered in Ann Arbor Michigan that offers strategic talent solutions to our clients world-wide. Our client is an American multinational info...Show more

Last updated: 21 days ago • Promoted

Starburst Senior Developer

Programmers.io • Tampa, Florida, USA

Full-time

We are only looking for profiles who can relocate to Tampa FL or local to Tampa.We are seeking a highly skilled and hands-on Data Engineer to join our offshore team. The ideal candidate will have ex...Show more

Last updated: 21 days ago • Promoted

Server Administrator II

CAE • Tampa, Florida, USA

Full-time

Our vision is to be the worldwide partner of choice in defense and security and civil aviation by revolutionizing our customers training and critical operations with digitally immersive solutions t...Show more

Last updated: 14 days ago • Promoted

Banquet Server

Straz Center for the Performing Arts • Tampa, Florida, USA

Part-time

Be a Star at the Straz Center for the Performing Arts!.The Banquet Server is responsible for serving food and beverages to Center patrons. Located in downtown Tampa the Straz offers flexible hours e...Show more

Last updated: 2 days ago • Promoted

Database Administrators (Professional, Scientific, and Technical Services)

Mercor • Tampa, Florida, US

Remote

Full-time

Mercor is recruiting • •Database Administrators who work in the Professional, Scientific, and Technical Services Sector • • as independent contractors working on a research project • •for one of the wo...Show more

Last updated: 20 hours ago • Promoted • New!

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: 11 days ago • Promoted

Senior Database Developer

SSG • Tampa, Florida, USA

Full-time

Military Veterans are highly encouraged to apply!.Essential Duties and Responsibilities.Establish database management systems standards requirements guidelines and quality assurance for database de...Show more

Last updated: 19 days ago • Promoted

Data Engineer

Akaasa Technologies • Tampa, Florida, USA

Full-time

Hillsborough County Sherrif Office.Its better to think of this job as more Date Engineer and some Data Analyst.Major focus is designing and implementing data pipelines for structured and unstructur...Show more

Last updated: 21 days ago • Promoted

Experience Architect

Ohm Systems • Tampa, Florida, USA

Full-time

An Experience Architect is a professional who designs plans and builds the overall architecture of a users experience with a product or service focusing on a seamless and intuitive journey across a...Show more

Last updated: 1 day ago • Promoted

Airtable Tooling Expert (Internal)

Mercor • Tampa, Florida, US

Remote

Full-time

Role Overview • • Mercor is looking for an Airtable tooling expert who can design, maintain, and optimize internal project workflows. This is an internal project where you will build scalable Airtable...Show more

Last updated: 20 hours ago • Promoted • New!

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: 30+ days ago • Promoted