ETL/SQL Developer

3 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

    1 month 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

    4 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 Developer

    3 days ago

    Herndon, United States Syms Strategic Group, LLC (SSG) Full time

    **Syms Strategic Group (SSG) **is seeking a talented **Extract, Transform, and Load (ETL) Developer** **Department**:Veterans Affairs **Location**:On-site, Washington, DC **Type**:Full Time **Min. Experience**:Experienced **Security Clearance Level**:Public Trust (MBI) **Salary Range**:$75,995 - $89,000 **Military Veterans are highly encouraged to...

  • ETL Engineer with Security Clearance

    1 month 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...

  • Database Developer

    6 hours ago

    Herndon, United States Raytheon Technologies Full time

    Date Posted: 2024-03-07 Country: United States of America Location: VA531: 13900 Lincoln Park Dr, Herndon 13900 Lincoln Park Drive Suite 220, Herndon, VA, 20171 USA Position Role Type: Onsite You have been redirected to RTX's career page as we have recently transitioned from RTX to become a standalone company, which provides us with greater autonomy and...

  • Software Developer

    1 month 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...

  • Expert Cloud Developer

    5 days ago

    Herndon, United States The Swift Group Full time

    Job DescriptionJob DescriptionThe Swift Group is looking for an Expert Cloud Developer to work on an Agile team and develop code to build a mission critical data lake using serverless architecture. This position is located in Herndon, Va.Required Qualifications: 10+ years of relevant work experienceExperience with Availability Zones (AZ) and knowledge of the...

  • Business Objects Developer

    2 weeks 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

    2 weeks 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

    5 days ago

    Herndon, United States Cinteot Inc. Full time

    Business Objects Developer Cinteot is seeking a Business Objects Developer to join our team of qualified, diverse individuals. This position will be located in Herndon, VA with some remote work possible. The qualified applicant will become part of Cinteot's Department of State (DOS) Consular Systems Modernization (CSM) Program, for the Bureau of Consular...

  • Business Objects Developer

    3 days ago

    Herndon, United States Twenty Bridge Staffing Full time

    Description Our client is seeking a Business Objects Developer to join their team of qualified, diverse individuals. This position will be located in Herndon, VA, with some remote work possible. The qualified applicant will become part of the client's Department of State (DOS) Consular Systems Modernization (CSM) Program, for the Bureau of Consular Affairs...

  • Business Objects Developer

    4 days ago

    Herndon, United States Twenty Bridge Staffing Full time

    DescriptionOur client is seeking a Business Objects Developer to join their team of qualified, diverse individuals. This position will be located in Herndon, VA, with some remote work possible. The qualified applicant will become part of the client's Department of State (DOS) Consular Systems Modernization (CSM) Program, for the Bureau of Consular Affairs...

  • Business Objects Developer

    8 hours ago

    Herndon, United States Twenty Bridge Staffing Full time

    Job DescriptionJob DescriptionTwenty Bridge is seeking a Business Objects Developer to join our client's team of qualified, diverse individuals. This position will be located in Herndon, VA with some remote work possible.  Duties and Responsibilities:Manage, Maintain and Administer SAP BusinessObjects Env. including user and group management,...

  • Systems Engineer

    2 weeks 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

    1 month 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

    4 days ago

    Herndon, United States Cornerstone Defense Full time

    Location: Herndon, VirginiaType: ContractJob #3010 Title: Linux EngineerLocation: 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,...

  • Data Analyst

    4 weeks ago

    Herndon, United States Purple Drive Solution Full time

    Job Title : Data Analyst Relevant Experience (in Yrs) 8+ years Technical/Functional Skills Must have advanced proficiency working with data analysis languages (Python, R, SQL) Experience with Redshift and Aurora Databases Must have deep understanding of how data works and acts Advanced analytical and troubleshooting capabilities Knowledge on...

  • Data Analyst

    2 weeks ago

    Herndon, United States ApTask Full time

    Relevant Experience (in Yrs.) 8+ yearsTechnical/Functional SkillsMust have advanced proficiency working with data analysis languages (Python, R, SQL)Experience with Redshift and Aurora DatabasesMust have deep understanding of how data works and actsAdvanced analytical and troubleshooting capabilitiesKnowledge on reporting capabilities and delving into any...

  • Linux Engineer

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

  • Senior Data Engineer

    2 days ago

    Herndon, United States SOSi Full time

    OverviewSOSi is seeking a Senior Data Engineer to assist the MLOps Team in creating, maintaining, and automating workflows leveraging cutting-edge technologies and supporting a government customer in Huntsville, Alabama. This role will be responsible for delivering automation to key national security missions interacting with petabyte-scale data using...