RestonRecruiter Since 2001
the smart solution for Reston jobs

SQL Developer

Company: Incept Data Solutions, Inc.
Location: Reston
Posted on: February 23, 2021

Job Description:

SQL Developer (SSIS/SSAS)
Seeking a highly skilled SQL Developer to support a Fortune 500 technology company offering high-end solutions in systems engineering and integration. You'll be surrounded by a supportive working environment and people who'll recognize your potential and encourage you to flourish. You'll be challenged to always do your best and be rewarded for your hard work and contributions.
REMOTE (currently)US Citizens are encouraged to apply.
Responsibilities
-- Develop and improve solutions spanning data processing activities from the staging to star schemas and reporting view's / tables and finally into SSAS. -- Develop and improve Microsoft Analysis Services cubes (tabular and dimensional) -- Will be expected to mentor colleagues and be proactive in developing colleague skill sets to have a better understanding of Analysis Services. -- Experience with multi-dimensional SSAS OLAP Cubes. Proficient in MDX and DAX.-- Develop and improve solutions spanning data processing activities from the staging to star schemas and reporting view's / tables and finally into SSAS. -- Create and Modify SSIS packages. Create an ETL design and implementation checks in SSIS packages.-- Create data load mappings, import/export methods, Incremental /Full load data from Source systems to various targets.-- Automate data extractions, loads and consolidations (when applicable) using batches or PowerShell scripts. Tune and optimize ETL batch jobs for performance and throughput.-- Should be able to analyze and optimize SQL queries and provide tuning recommendations to SSIS jobs, time/CPU consuming queries if situation arises.-- Design and develop ETL (MSBI) code for efficient and scalable data transformations in the Enterprise Data Warehouse-- Extend and maintain the EDW/Mart data layers - Type I, II, III SCD dimensions and facts.-- Troubleshoot and resolve technical issues with data migration and transformation using MSSQL, SSIS, SSAS, SSRS.-- Conform to SSIS workflow and mapping standards so that development is done in a consistent manner across all development resources.Qualifications
-- Bachelor's Degree or equivalent experience in Computer Science-- Bachelor's degree-- Experience with MS SQL Server 2005/2008/2012/2016 including T-SQL/PL-SQL programming and scripting.-- 5+years' experience with MSBI and DW Modelling-- Experience in EDW design principles such as: requirements analysis, data mapping, transformations, SCD, Star Schema, snowflake schema and DW modelling. -- Knowledge on MS Power BI tool along with profound knowledge on query writing-- Strong systems skills especially in implementation, maintenance, enhancement, and documentation

Keywords: Incept Data Solutions, Inc., Reston , SQL Developer, IT / Software / Systems , Reston, Virginia

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Software Developer (US Citizenship Required)
Description: cFocus Software is seeking a Software Developer to support the NGA, located in Springfield, VA or Chantilly, VA. Remote work is available. br br Required Qualifications: br br ul li Bachelor's (more...)
Company: cFocus Software Incorporated
Location: Chantilly
Posted on: 02/26/2021

Back-End Software Engineer
Description: In an era of dynamic change in space, Aerospace is addressing a generation of complex challenges. We operate the only federally funded research and development center FFRDC committed exclusively to (more...)
Company: Aerospace Corporation
Location: Chantilly
Posted on: 02/26/2021

Database Engineer
Description: Description SAIC is a fortune 500 technology integration company providing premier solutions and services to solve our nation's most complex modernization and readiness challenges across the defense, (more...)
Company: SAIC
Location: Chantilly
Posted on: 02/26/2021


Senior Database Engineer
Description: Description SAIC is a fortune 500 technology integration company providing premier solutions and services to solve our nation's most complex modernization and readiness challenges across the defense, (more...)
Company: SAIC
Location: Chantilly
Posted on: 02/26/2021

Java Software Engineer
Description: TS/SCI FSP required br Java Engineer/Developer The candidate will design and develop applications in a web environment as well as modify existing general computer applications software programs.
Company: ACTION STAFFING, LLC
Location: Chantilly
Posted on: 02/26/2021

Assistant Professor of Software Engineering
Description: Job location: College at Wise Wise, VA Employment Type: Full-time Posted data: 2021-02-04 Req: R0021110 Assistant professors are untenured faculty who are on the tenure track. The probationary (more...)
Company: university of virginia
Location: Charlottesville
Posted on: 02/26/2021

VMware System Administrator
Description: BasicQualifications: ul li Active DoD Top Secret security clearance li DoD 8570 IAT II certification li VMware Certified Professional VCP certification li Experience with VMware vSphere and (more...)
Company: ApTask
Location: Chantilly
Posted on: 02/26/2021

Back-End Web Developer, Senior
Description: Job Number: R Back-End Web Developer, SeniorThe Challenge:Are you looking for an opportunity to not just develop software, but to help build a system that will solve complex and challenging business, (more...)
Company: Booz Allen Hamilton
Location: Chantilly
Posted on: 02/26/2021

Web Developer
Description: Description Job Description:Leidos is seeking a Web Developer for a position in the Chantilly, VA. This position requires an active TS/SCI with Polygraph in order to be considered. The Web Developer will (more...)
Company: Leidos
Location: Chantilly
Posted on: 02/26/2021

Software Engineer (All Levels) Experience Required
Description: C6ISR develops next generation solutions in the areas of undersea systems, cyber, unmanned vehicles, battle management, ISR, acoustic sensors and precision navigation. br For this Dev Ops Software (more...)
Company: Cinteot Inc.
Location: Chantilly
Posted on: 02/26/2021

Log In or Create An Account

Get the latest Virginia jobs by following @recnetVA on Twitter!

Reston RSS job feeds