ETL/SQL Developer

2 weeks ago

Herndon, United States Idea Entity Full time
Job DescriptionJob 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.

  • ETL/SQL Developer

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

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

  • ETL/SQL Developer

    3 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

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

  • SQL Server Administrator

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

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

  • Linux Engineer

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

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

  • Jr Database Developer

    3 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

    1 day 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/ ...

  • Software Engineer

    1 week ago

    Herndon, United States VAZ CONSULTING CORPORATION Full time

    Job Description Job Description We are looking for a software engineer to accelerate the timely, reliable, and secure delivery of open source data, information, and insights. You will be responsible for application development support to maintain and enhance an existing social media data exploitation platform. You will work within an existing team...

  • Business Intelligence Engineer, DCC Communities

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

  • Full Stack Developer

    4 weeks ago

    Herndon, United States Two Six Technologies Full time

    At Two Six Technologies, we build, deploy, and implement innovative products that solve the world’s most complex challenges today. Through unrivaled collaboration and unwavering trust, we push the boundaries of what’s possible to empower our team and support our customers in building a safer global future.Trusted Concepts, a division of Two Six...

  • Applications Developer

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

  • Java Developer

    2 weeks ago

    Herndon, United States Gridiron IT Full time

    GridIron IT is seeking a Senior Software Developer on a remote basis. Must hold a minimum of an active Secret and the ability to obtain a TS clearance. The Developer will support the DoD enterprise Military Housing system. This complex system of 28 web-based modules is used by over 10,000 active users to meet the housing needs of over 2.5 million service...

  • Developer I

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

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