ETL/SQL Developer

4 weeks ago

Herndon, United States Idea Entity Full time

Idea Entity, a Microsoft Gold Partner, is a global change management consulting firm committed to delivering customer outcomes that change the way business is done. We are looking for an experienced ETL/SQL Developer who will assume a key role on our team.

This role will be operating on a hybrid schedule with three (3) telework days a week on-site out of our Herndon, Virginia office. Due to the nature of this role, US Citizenship/Green Card/Work Authorization is required and is not eligible for sponsorship.

The successful ETL/SQL Developer will set standards for operations, programming and security and will be responsible for developing, testing, improving, and maintaining new and existing databases to help users retrieve data effectively. The ETL/SQL Developer will integrate new systems with existing warehouse structure and refine system performance and functionality, as well as assist development team with data management, including data warehousing systems and concepts. Collaboration with administrators and clients is essential to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude.

Requirements

  • Analyzing and understanding business requirements of data structures.
  • Designing and maintaining RDBMS architecture as well as ensuring their optimal performance, availability, and security.
  • Optimizing RDBMS performance, including query tuning, indexing, and statics maintenance.
  • Creating complex parameterized scripts and queries for business intelligence reporting.
  • Programing and designing data extract, transform and load jobs using the open-source technologies.
  • Installing, configuring, maintaining, and upgrading ETL software, repositories, and pipelines.
  • Using ETL tools (Azure Data Factory), BI tools (Power BI), and OBIEE.
  • Writing optimized complex SQL queries for integration with other applications.
  • Developing, configuring, and deploying ETL packages/pipelines.
  • Implementing and enforcing database security measures, including access controls, encryption, auditing, and disaster recovery.
  • Effective partnership with development teams to design data management and governance protocols, manage the information lifecycle, design infrastructure, and data integration controls.
Qualifications
  • Minimum of four to seven (4-7) years of experience in relational databases in the areas of defining entities (physical/logical), dependencies, SQL queries, stored procedures, indexing, scheduled jobs, performance tuning with respect to queries/schema/etc., analyzing query execution plans, data management, including data warehousing systems and concepts, data transformation and integration techniques.
  • Minimum of four (4) years of experience in performing data extractions, data analysis and programming, to include writing advanced SQL Queries or creating programs.
  • Minimum of four (4) years of experience with Azure SQL.
  • Minimum of four (4) years hands on experience with Azure Data Factory and an understanding of ETL best practices.
  • At least three (3) years of experience using source code management software.
  • Prior experience working in an agile environment.
  • Bachelor's Degree preferably in a field related to data science, computer information systems. Can substitute education requirement for greater experience.
  • Must be able to work independently and as part of a development team on multiple overlapping projects.
  • Proven track record of successfully delivering large projects.
  • Exceptional communicator with both technical and non-technical audiences.
  • Strong interpersonal skills with ability to collaborate effectively in cross-functional teams.
  • Demonstrated ability to solve challenging technical problems with innovative solutions.
  • Security+ certification or ability to obtain within 6 months of hire.
Preferred Qualifications:
  • Azure SQL
  • Azure Data Factory
  • OBIEE
  • Microsoft Certifications
Benefits
  • Competitive Health Care Plan (Medical, Dental & Vision)
  • Health Savings Account (HSA)/Flexible Spending Account (FSA)
  • Retirement Plan (401K, IRA) with employer match
  • Paid Time Off (Vacation, Sick and Federal Holidays)
  • Paid Training & Development opportunities
  • Hybrid work environment

At Idea Entity, our culture is centered around diversity and inclusion where our employees are valued and empowered. We are an Equal Opportunity Employer and employment decisions are made without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, physical or mental disability, genetic factors, military/veteran status or other characteristics protected by law.

  • ETL/SQL Developer

    3 weeks ago

    Herndon, United States Idea Entity Full time

    Job DescriptionJob DescriptionIdea Entity, a Microsoft Gold Partner, is a global change management consulting firm committed to delivering customer outcomes that change the way business is done. We are looking for an experienced ETL/SQL Developer who will assume a key role on our team.This role will be operating on a hybrid schedule with three (3) telework...

  • ETL/SQL Developer

    6 days ago

    Herndon, United States Idea Entity Full time

    Idea Entity, a Microsoft Gold Partner, is a global change management consulting firm committed to delivering customer outcomes that change the way business is done. We are looking for an experienced ETL/SQL Developer who will assume a key role on our team. This role will be operating on a hybrid schedule with three (3) telework days a week on-site out of our...

  • SQL Server Administrator

    6 days ago

    Herndon, United States Oran Full time

    As a SQL Server Administrator/Developer at Oran Inc., you will play a pivotal role in managing and optimizing our database infrastructure while also developing and implementing efficient database solutions to meet the specialized requirements of our DOD projects. You will work closely with our defense clients to design, deploy, and maintain database systems...

  • ETL Engineer with Security Clearance

    4 weeks ago

    Herndon, United States Invex Technology Solutions, LLC Full time

    ETL Engineer Do you enjoy working with data? Transforming and enriching content so users can find what they're looking for? Working with modern design patterns including Serverless and Event Driven Architectures? Invex is looking for you to join our ETL team! You'll work with a small team of engineers building and maintaining data pipelines that help drive...

  • Software Developer

    4 weeks ago

    Herndon, United States TTG Solutions, Inc. Full time

    TTG Solutions Inc. has ongoing needs to support multiple technical contracts in the Northern Virginia area. Base Salary: $175k - $205k, base on experience.Retirement: 15% with 36-month initial vesting.PTO: 30 days annual total.Medical/Dental/Vision: company funded, cash incentives if you waive.3% to 5% annual bonuses.$100 monthly cell phone...

  • Business Objects Developer

    6 days ago

    Herndon, United States TalentRemedy Full time

    Job Description Our client is seeking a Business Objects Developer to join our team of qualified, diverse individuals. This position is hybrid, in Herndon, VA. The qualified applicant will become part of the Department of State (DOS) Consular Systems Modernization (CSM) Program, for the Bureau of Consular Affairs (CA). This initiative will modernize and...

  • Business Objects Developer

    10 hours ago

    Herndon, United States TalentRemedy Full time

    Job Description Our client is seeking a Business Objects Developer to join our team of qualified, diverse individuals. This position is hybrid, in Herndon, VA. The qualified applicant will become part of the Department of State (DOS) Consular Systems Modernization (CSM) Program, for the Bureau of Consular Affairs (CA). This initiative will modernize and...

  • Systems Engineer

    2 days ago

    Herndon, United States Janus Soft Inc Full time

    REQUIRED SKILLS AND DEMONSTRATED EXPERIENCE The candidate shall have the following required skills, certifications and demonstrated experience: •Demonstrated experience with Linux administration. •Demonstrated experience with scripting languages (Python preferred). •Demonstrated experience with Unified Modeling Language (UML) and SQL's such as Data...

  • Linux Engineer with Security Clearance

    4 weeks ago

    Herndon, United States Cornerstone Defense Full time

    Title: Linux Engineer Location: Herndon, VA *Clearance: *Active TS/SCI w/ Polygraph needed to apply * Company Overview: Cornerstone Defense is the Employer of Choice within the Intelligence, Defense, and Space communities of the U.S. Government. Realizing early on that our most prized assets are our employees, we continually focus our attention on improving...

  • Linux Engineer

    2 weeks ago

    Herndon, United States Cornerstone Defense Full time

    Title: Linux Engineer Location: Herndon, VA *Clearance: *Active TS/SCI w/ Polygraph needed to apply * Company Overview: Cornerstone Defense is the Employer of Choice within the Intelligence, Defense, and Space communities of the U.S. Government. Realizing early on that our most prized assets are our employees, we continually focus our attention on improving...

  • Jr Database Developer

    7 days ago

    Herndon, United States Gridiron IT Full time

    GridIron IT is seeking a Junior Database Developer on a remote basis. Must hold a minimum of an active Secret and the ability to obtain a TS clearance. RESPONSIBILITIES Technical members of our solutions teams require little guidance, but love to learn, collaborate, and problem solve. This position requires a junior level of experience, a passion for...

  • IT Application Developer III

    5 days ago

    Herndon, United States RIT Solutions, Inc. Full time

    Need LinkedIn with profile picture and strong connections and profile should be old not the newly created. Job Description: Solvas Application developer. 7+Years of experience in Solvas. Should be able to train new developers for Solvas products. Required Skills/Experience Previous experience with Solvas application Preferred Skills/Experience N/ ...

  • Business Intelligence Engineer, DCC Communities

    5 days ago

    Herndon, Virginia, United States Amazon Full time

    As a Business Intelligence / Data Engineer you will enable data-driven decision making within the Amazon Web Services Data Center Infrastructure Operations organization.The Infrastructure Operations Team is responsible for planning, implementing, monitoring and continuously improving the global Amazon Data Center infrastructure.The team supports all aspects...

  • Systems Engineer SQL

    4 weeks ago

    Herndon, United States BAE Systems Full time

    Job Description BAE Systems, a top-ten prime contractor to the U.S. Department of Defense, enables the U.S. government to transform data into intelligence and provides engineering, integration and sustainment support for critical military platforms and systems. Intelligence & Security provides services and products to the Department of Defense, the...

  • Applications Developer

    4 weeks ago

    Herndon, United States Cantada Full time

    Job DescriptionJob DescriptionFull Stack Developer (Data Scientist). Currently seeking a Full Stack web Application Developer in Herndon, VA to work on a suite of services that will supply users with tools to automate a wide range of enterprise-wide Information Management mission activities. The candidate will be part of a team of software developers and...

  • Developer I

    4 weeks ago

    Herndon, Virginia, United States Sky Solutions LLC Full time

    Developer I: Write, analyze, review & rewrite prog, etc. MS or foreign equiv in Comp Sci, MIS, Info Sys, IT, Comp Eng'g or rel field. 1yr exp as Software devp'r or any occu where req exp gained. 1yr software devel exp using Java, SQL, etc. See careers/current-openings/ for decrp'n and req'ts and apply. FT. Sky Solutions LLC 13921 Park Center Rd #100 Herndon...

  • Applications Developer

    2 hours ago

    Herndon, United States Convirgence Full time

    Applications Developer - SME HerndonMandatory Skills: Demonstrated experience with building web applications in the Java Spring framework. Demonstrated experience with building web applications using the Angular 2+ framework Demonstrated experience working in Linux (Bash) shell scripting Demonstrated experience with development and deployment of...

  • Senior Business Intelligence Engineer, DCC Communities

    3 weeks ago

    Herndon, United States Amazon Data Services, Inc. Full time

    As a Business Intelligence / Data Engineer you will enable data-driven decision making within the Amazon Web Services Data Center Infrastructure Operations organization.The Infrastructure Operations Team is responsible for planning, implementing, monitoring and continuously improving the global Amazon Data Center infrastructure. The team supports all aspects...

  • Entellitrak Developer

    4 weeks ago

    Herndon, United States Latitude, Inc. Full time

    Job DescriptionJob DescriptionGrowing government contractor looking to bring on an Entellitrak Developer. As an accomplished developer, you will be responsible for:Configure and customize the core application components including but not limited to forms, data objects, security, searches and workflows to support customer’s requirements.Apply Agile...

  • Applications Developer

    4 weeks ago

    Herndon, United States Convirgence Full time

    Applications Developer - SME Herndon Mandatory Skills: * Demonstrated experience with building web applications in the Java Spring framework. * Demonstrated experience with building web applications using the Angular 2+ framework * Demonstrated experience working in Linux (Bash) shell scripting * Demonstrated experience with development and deployment of...