SQL Database Developer

2 days ago


Vienna, Virginia, United States DT Professional Services Full time
Job Summary

DT Professional Services is seeking a highly skilled SQL Developer to support the Office of Information Systems within the Drug Enforcement Administration (DEA). The successful candidate will have experience with Enterprise Data Warehouse (EDW) and cloud environment experience to support the DEA's SQL Server-based EDW.

Key Responsibilities
  • Assist the EDW Team in providing data warehouse information and systems transitioning to a cloud environment
  • Create and maintain database integrity and performance using scripts and/or VS Database Project
  • Develop and maintain data transformation services using Microsoft SSIS and other tools
  • Create SQL Scripts to deploy, enhance, and maintain databases
  • Maintain and add to an extensive set of SQL Server Integration Service (SSIS) packages for Extract, Transform, and Load (ETL) data
  • Support the review of database systems from non-Concorde applications in other DEA offices
  • Participate in daily Agile stand-up meetings and monthly planning sessions, sprint reviews, and retrospective sessions
  • Maintain, enhance, and create enterprise and application level SQL Server Report Service (SSRS) and other Business Intelligence (BI) tools
Requirements
  • A DoD issued Active Secret Clearance is required
  • 2+ years of Cloud environment experience (AWS or Microsoft Azure)
  • 8 years of experience in the design, development, and implementation of SQL Server databases
  • 2+ years of experience with SSIS packages for data manipulation and loading
  • 2+ years of experience with the SQL Server 2012 environment
  • Bachelor's degree in IT, Computer Engineering, or a related discipline
  • Excellent organizational and time management skills; ability to work independently and solve problems
  • Self-starter with the ability to identify what tasks need to be prioritized based on the impact(s) to the environment and team
  • Experience within an Agile development environment
  • Experience with Git and Python, and PowerShell
  • Experience with Azure DevOps Server
  • Experience with Power BI
Preferred Qualifications
  • Experience with multi-dimensional data models
  • Ability to create reports with a solid understanding of a variety of BI data tools
  • Experience with SSIS
  • Experience with data modeling programming and software development, including Python, R, or other high-level language used in statistical computing
  • Demonstrated ability and desire to learn new technologies
  • Knowledge of Kimball data warehouse methodology highly desired

The compensation range for this position is $140,000 - $170,000 annually.



  • Vienna, Virginia, United States Integral Services Company Full time

    Job Title: SQL Database AdministratorWe are seeking a highly skilled SQL Database Administrator to join our team at Integral Federal. As a key member of our team, you will be responsible for designing and configuring database architecture, performing monitoring and performance tuning, and providing ongoing database support in multiple-cluster production...


  • Vienna, Virginia, United States Shuvel Digital Full time

    Data Integration DeveloperWe are seeking a skilled Data Integration Developer to design and deploy ETL solutions in a data warehousing and BI environment.Key Responsibilities:Design and implement data integration solutions using SQL Server ETL toolsDevelop and maintain ETL processes to ensure data accuracy and integrityCollaborate with cross-functional teams...


  • Vienna, Virginia, United States General Dynamics Information Technology Full time

    Job DescriptionJob Title: Database Systems EngineerJob Summary:We are seeking a highly skilled Database Systems Engineer to join our team at General Dynamics Information Technology. As a Database Systems Engineer, you will be responsible for designing, implementing, and administering databases to support our clients' complex data processing needs.Key...


  • Vienna, Virginia, United States General Dynamics Information Technology Full time

    Job Description:As a Database Analyst Advisor at General Dynamics Information Technology, you will play a critical role in delivering transformative solutions to our clients' big-data obstacles. Your work will provide insights to help our clients turn data into action, advancing the mission and making a meaningful impact on their careers.Our team is seeking...


  • Vienna, Virginia, United States Leidos Full time

    About LeidosLeidos is a company that prioritizes investing in the growth and development of its employees, while also supporting mission-critical projects. We offer a range of benefits, including paid time off, flexible schedules, and career growth opportunities.Job SummaryWe are seeking a Software Developer to support a technical development program on one...


  • Vienna, Virginia, United States General Dynamics Information Technology Full time

    Job Summary:General Dynamics Information Technology (GDIT) is seeking a highly skilled Software Engineer Senior to join our team. As a Software Engineer Senior, you will be responsible for designing, developing, and testing software programs and applications. You will work closely with our team to deliver cutting-edge solutions to our clients.Key...


  • Vienna, Virginia, United States General Dynamics Information Technology Full time

    Job Title: Software Engineer SeniorDeliver cutting-edge solutions to complex problems as a Software Engineer Senior at General Dynamics Information Technology (GDIT). You will tailor innovative solutions to the unique requirements of our clients, prioritizing the end-user experience.Key Responsibilities:Design, develop, evaluate, plan, and test engineering...


  • Vienna, Virginia, United States RapidIT Full time

    Job Title:Mainframe Developer with Assembler ExpertiseLocation:Hybrid (Remote)Duration:Multiyear ContractDescription:We are seeking a highly skilled Mainframe Developer with expertise in Assembler to join our team at RapidIT. The ideal candidate will have recent experience with Assembler (6 years minimum) for System Z, as well as extensive experience using...


  • Vienna, Virginia, United States Apex Systems Full time

    {"title": "Financial Data Analyst", "content": "Financial Data AnalystAs a key member of our finance team, you will play a vital role in uncovering insights from financial data to inform business decisions. This position requires a strong foundation in MS Office, proficiency in SQL, and intermediate Excel skills. You will be responsible for analyzing data...


  • Vienna, Virginia, United States Shuvel Digital Full time

    Position Overview: Data Integration DeveloperWe are seeking a skilled Data Integration Developer to enhance our capabilities. This role is essential for those who excel in crafting and implementing ETL solutions within a data warehousing and business intelligence framework.Key Responsibilities:Design and implement robust data integration solutions tailored...


  • Vienna, Virginia, United States Shuvel Digital Full time

    Position Overview: Data Integration DeveloperWe are seeking a skilled Data Integration Developer to enhance our data management capabilities. This role focuses on the design and implementation of ETL solutions within a data warehousing and business intelligence framework.Key Responsibilities:Design and implement effective data integration solutions tailored...


  • Vienna, Virginia, United States EAI Technologies Full time

    Job OverviewEAI Technologies is seeking a highly skilled and experienced Senior Software Developer to join our team. As a key member of our software development team, you will be responsible for leading the design and development of dynamic Enterprise Web and Mobile applications for our clients.Key Responsibilities:Lead and work in a fast-paced, hands-on...


  • Vienna, Virginia, United States Apex Systems Full time

    Job SummaryWe are seeking a highly skilled Financial Data Analyst to join our team at Apex Systems. As a key member of our finance team, you will play a crucial role in interpreting financial data to provide actionable insights that drive business decisions.Key ResponsibilitiesFinancial Analysis: Conduct in-depth financial analyses using advanced MS Office...


  • Vienna, Virginia, United States Esri Full time

    Job Title: Enterprise Data EngineerAt Esri, we are seeking an experienced Enterprise Data Engineer to join our team. As a key member of our Professional Services division, you will work closely with customers and partners to design and implement enterprise database solutions that meet their business needs.Responsibilities:Design and implement enterprise...


  • Vienna, Virginia, United States Bitcoin Devs Company Full time

    About the RoleThe Senior Blockchain Developer will play a pivotal role in driving the development and maintenance of our blockchain-based custody solutions at Bitcoin Devs Company. This individual will be instrumental in designing, implementing, and enhancing secure and efficient custody systems leveraging blockchain and cryptocurrency technologies.Key...


  • Vienna, Virginia, United States Armedia LLC Full time

    Job Title: Principal Software EngineerArmedia LLC is seeking a highly skilled Principal Software Engineer to join our team. As a key member of our software development team, you will be responsible for designing, developing, and implementing complex software systems.Job SummaryWe are looking for a talented software engineer with a strong background in...


  • Vienna, Virginia, United States Bitcoin Devs Company Full time

    Role OverviewThe Senior Python Developer will play a pivotal role in our company's software development team. They will be responsible for designing, implementing, and maintaining various Python-based applications and integrating them with other technologies to deliver high-quality software solutions.Key ResponsibilitiesDrive technical decisions that...

  • Senior Data Engineer

    3 weeks ago


    Vienna, Virginia, United States General Dynamics Information Technology Full time

    About the RoleWe are seeking a highly skilled Senior Data Engineer to join our team at General Dynamics Information Technology. As a Senior Data Engineer, you will play a critical role in designing, developing, and maintaining large-scale data systems and infrastructure.Key ResponsibilitiesDesign and develop complex data flows and pipelines using...

  • Fullstack Developer

    1 week ago


    Vienna, Virginia, United States Velocity Ventures Full time

    Your Role at Velocity Ventures**Collaborate with Our Shop Agency**You will support the launch of our new shop in partnership with our shop agency, ensuring a seamless integration of our products and services.**Develop and Implement New Features**As a key member of our team, you will design and implement new features and functionalities for our shop agency,...


  • Vienna, Virginia, United States DirectViz Solutions, LLC Full time

    Job Description**About DirectViz Solutions, LLC**DirectViz Solutions, LLC (DVS) is a rapidly growing government contractor that provides strategic services to meet mission IT needs for government customers. We offer innovative information technology solutions to government clients through the expertise of our dedicated employees. As an employee-centric...