Jobs
>
Herndon

    ETL/SQL Developer - Herndon, United States - Idea Entity

    Idea Entity
    Idea Entity Herndon, United States

    7 hours ago

    Idea Entity background
    Description

    Job Description

    Job Description

    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.

  • Idea Entity

    ETL/SQL Developer

    6 days ago

    Idea Entity Herndon, United States

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

  • ARFA Solutions, LLC

    Etl Developer

    4 days ago

    ARFA Solutions, LLC Ashburn, United States

    **Responsibilities**: · - Design, develop, and maintain scalable ETL processes using Snowflake, Azure Data Factory, and other technologies · - Collaborate with cross-functional teams to gather and analyze business requirements · - Perform data profiling and develop data quality r ...

  • Syms Strategic Group, LLC (SSG)

    ETL Developer

    4 days ago

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

    Job Description · Job DescriptionSyms 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 T ...

  • General Dynamics Information Technology

    ETL Developer

    2 weeks ago

    General Dynamics Information Technology Herndon, United States Paid Work

    Req ID: RQ171188 · Type of Requisition: Regular · Clearance Level Must Be Able to Obtain: Top Secret SCI + Polygraph · Public Trust/Other Required: None · Job Family: Software Development · Skills: · Data Transformation,ETL,ETL Tools · Experience: · 6 + years of related experienc ...

  • Syms Strategic Group, LLC (SSG)

    ETL Developer

    4 days ago

    Syms Strategic Group, LLC (SSG) Reston, United States

    Job Description · Job DescriptionSyms 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 T ...

  • Applied Memetics LLC

    SQL Developer

    4 days ago

    Applied Memetics LLC Arlington, United States

    : · The SQL Developer & Data Designer has considerable experience in designing, developing, and maintaining complex SQL code based on business requirements and new business processes. · **Requirements**: · **ESSENTIAL DUTIES AND RESPONSIBILITIES**: · The SQL Developer & Data Desi ...

  • All In Solutions

    SQL Developer

    4 days ago

    All In Solutions Arlington, United States

    **Responsibilities** · - Performing day to day querying and analysis using SQL queries and procedures, and script execution to enhance understanding of data within a consolidated data store. · * · Considering amorphous problem sets or functional requirements to determine path for ...

  • Fusion Technology LLC

    SQL/Informatica ETL Developer

    7 hours ago

    Fusion Technology LLC Washington, United States

    Job Description · Job DescriptionSQL/Informatica ETL Developer · Who is Fusion Technology? · Fusion Technology is a performance-driven HUBZone Small Business concern residing in the heart of the beautiful mountainsides of West Virginia, steps away from the Federal Bureau of Inves ...

  • Standard Technology (MD)

    sql etl engineer

    1 week ago

    Standard Technology (MD) Bethesda, United States

    Job Description · Job Description · SQL ETL Engineer (REMOTE) · We are seeking an experienced SQL ETL (Extract, Transform, Load) Engineer proficient in developing and maintaining ETL processes using SSIS (SQL Server Integration Services). · This is a challenging opportunity fo ...

  • Syms Strategic Group, LLC (SSG)

    ETL Developer

    4 days ago

    Syms Strategic Group, LLC (SSG) Chantilly, United States

    Job Description · Job DescriptionSyms 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 T ...

  • Insight Global

    ETL Developer

    1 week ago

    Insight Global Chantilly, United States

    Insight Global is looking for an experienced software developer with a background in ETL processes to support an intelligence customer in Chantilly. This individual will be using python to assist in the ETL process of structured and unstructured data coming in to our platform fro ...

  • Insight Global

    ETL Developer

    5 days ago

    Insight Global Chantilly, United States

    Job Description · Insight Global is looking for an experienced software developer with a background in ETL processes to support an intelligence customer in Chantilly. This individual will be using python to assist in the ETL process of structured and unstructured data coming in t ...

  • ManTech

    ETL Developer

    3 days ago

    ManTech Chantilly, United States

    Secure our Nation, Ignite your Future · Join the top Information Technology and Analytic professionals in the industry to make invaluable contributions to our national security on a daily basis. In this innovative, self-contained, Big Data environment, the ManTech team is respons ...

  • Leidos

    ETL Java Developer

    2 weeks ago

    Leidos Reston, United States

    Description · We have an IMMEDIATE NEED for a ETL Java Developer SME to provide Agile DevOps support to mission critical systems. As a ETL Java Developer on this program, you will have the opportunity to build strong systems, software, and cloud environments and provide operatio ...

  • ARFA Solutions, LLC

    ETL Developer

    4 days ago

    ARFA Solutions, LLC Ashburn, United States

    We are seeking an experienced ETL Developer to join our team. As an ETL Developer, you will be responsible for designing, developing, and implementing data extraction, transformation, and loading processes. You will work with Snowflake, Azure Data Factory, and other data tools to ...

  • Syms Strategic Group, LLC

    ETL Developer

    5 days ago

    Syms Strategic Group, LLC Ashburn, United States

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

  • ARFA Solutions, LLC

    ETL Developer

    3 days ago

    ARFA Solutions, LLC Ashburn, United States

    Job Description · Job DescriptionWe are seeking an experienced ETL Developer to join our team. As an ETL Developer, you will be responsible for designing, developing, and implementing data extraction, transformation, and loading processes. You will work with Snowflake, Azure Data ...

  • Syms Strategic Group, LLC (SSG)

    ETL Developer

    4 days ago

    Syms Strategic Group, LLC (SSG) Ashburn, United States

    Job Description · Job DescriptionSyms 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 T ...

  • Syms Strategic Group, LLC (SSG)

    Senior SQL Developer

    3 hours ago

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

    Syms Strategic Group (SSG) is seeking a talented Senior Structured Query Language (SQL) Developer · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: Public Trust (MBI) · Salary Range: $99 ...

  • Syms Strategic Group, LLC (SSG)

    Senior SQL Developer

    4 days ago

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

    Job Description · Job DescriptionSyms Strategic Group (SSG) is seeking a talented Senior Structured Query Language (SQL) Developer · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: Publ ...