SQL and Python Developer
IntelliDyneWashington, District of Columbia, United States · Posted 1 month agoDescription
SQL and Python Developer
Location: Washington, DC
Classification: Exempt
Position Summary
The position of SQL Cognos Developer is for an IT professional that has 5+ years’ experience in a mid-career-level position supporting the design, development and implementation of SQL-based solutions in a Cognos and Oracle environment. This position requires proficiency in SQL, PL/SQL, and Python scripting. The individual in this position will perform some complex analysis, design, programming, and modifying programs for customer applications. The SQL Developer will be responsible for finalizing forms, procedures and other documentation needed for the maintenance and configuration of application programs like Cognos as well as providing production support of applications and ad hoc reporting needs. The candidate should have an in-depth knowledge of relational databases, OLAP, and data access/front-end tools such as SQL, PL/SQL, and Excel. The goal of this position is to work with our federal government customer to understand trends and then report those trends based on data analytics.
Primary Responsibilities
- Perform complex analysis, design, programming, and modification of query programs inside of various customer applications, but especially Cognos.
- Write SQL and PL/SQL scripting and develop Python programs; which are always tested and debugged before introduction to the client.
- Provide agile production support for application changes and ad hoc reporting requirements
- Provide technical and analytical support
- Work strategically in a high-performance team that develops ad hoc SQL reports inside of business intelligence tools like Cognos, and Crystal Reports
- Translate high-level requirements from the customer into effective BI solutions by using Python scripting to query and analyze data that explains business problems.
- Perform technical tasks such as data modeling, BI application specification performance tuning and deployment support
- Perform requirements analysis of BI functions and determination of level of effort for reports development
- Provide quality assurance and quality control analysis of “Standard” and “Ad hoc” reports
Qualifications:
- 5 or more years’ experience in senior level position supporting open systems Oracle environments
- Minimum 5 years SQL and PL/SQL experience plus 5 years of developing natural language Python scripts
- Familiarity in OLAP Modeling
- Familiarity with ETL (Extraction, Transformation and Loading)
- Good understanding of relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques
- Strong hands-on experience using SQL with a relational DBMS such as Oracle
- Strong analytical and quality control experience providing accurate data
- Ability to work in a collaborative team environment on fast-paced dynamic projects
- Must have MBI Security Clearance
Supplemental Skills:
- Experience with business intelligence tools; particularly with Cognos, Crystal Reports, and Business Objects Enterprise XI
- Experience installing, configuring, governing, troubleshooting and tuning Cognos is a plus
Education
- Bachelor’s degree in Computer Science or related field
Work Environment
This role may support internal business applications, client-facing systems, secure enterprise environments, and analytics-driven web applications. The developer should be comfortable working with cross-functional teams and adapting to evolving technical and business requirements.
Compensation: $90k to $125k
About Us
IntelliDyne, LLC empowers government organizations through the delivery of quality, mission-aligned services and innovative, people-first IT solutions. IntelliDyne has earned the designation of a Top Workplace by providing an inclusive and supportive environment where employees have a voice and are challenged to provide innovative solutions to our clients of national, state, and local importance.
For individuals with disabilities who would like to request an accommodation, please contact staffing@intellidyne-llc.com or 703-575-9715.
Similar jobs
Est. 107,500 USD
SQL and Python Developer Location: Washington, DC Classification: Exempt Position Summary The position of SQL Cognos Developer is for an IT professional that has 5+ years’ experience in a mid-career-level position suppor…
Est. 124,000 USD
Python Web Application Developer Location: Tyson Corner, VA (Hybrid) Classification: Exempt Position Summary We are seeking a mid-level Web Application Developer with strong Python experience and hands-on experience buil…
Est. 124,000 USD
Python Web Application Developer Location: Tyson Corner, VA (Hybrid) Classification: Exempt Position Summary We are seeking a mid-level Web Application Developer with strong Python experience and hands-on experience buil…
Est. 112,500 USD
Database Developer Job #1082 Clearance: Active Public Trust in DHS or a component of DHS Hybrid role, in Ashburn, VA 1-2 days per week What You'll Be Doing: The Database Developer will work with a team of database develo…
Est. 130,000 USD
Senior Database Developer Job #1081 Clearance: Active Public Trust in DHS or a component of DHS Hybrid role, in Ashburn, VA 1-2 days per week What You'll Be Doing: The Senior Database Developer will work with a team of d…
Est. 120,000 USD
This job requires active TS/SCI clearance with a CI Polygraph. Please apply only if you have an active TS/SCI clearance with a CI Polygraph. SQL Database Administrator – Senior Position / LCAT: SQL Database Administrator…
Est. 172,500 USD
Responsibilities include, but are not limited to: Leads the designing, developing, documenting, testing, debugging and maintenance of hardware or software based CNO capabilities. Ensure effective communication coordinati…
Est. 114,000 USD
CTEC is a leading technology firm that provides modernization, digital transformation, and application development services to the U.S. Federal Government. Headquartered in McLean, VA, CTEC has over 300 team members work…
Est. 140,000 USD
Senior Data Scientist - Databricks Genie & AI Analytics #1087 Clearance: U.S. Citizenship is required. Current CBP/DHS clearance highly preferred. High-Level Project Summary: Dev Technology is seeking a highly skille…
Est. 150,420 USD
We are seeking a Senior Python Developer to join our team. Working at NT Concepts means that you are part of an innovative, agile company dedicated to solving the most critical challenges in National Security. We’re look…
Est. 140,000 USD
Three Sisters Federal is part of the Seneca Nation Group (SNG) portfolio of companies. SNG is Seneca Holdings' federal government contracting business that meets mission-critical needs of federal civilian, defense, and i…
Est. 124,000 USD
Data Visualization Engineer Job #1098 Clearance: U.S. Citizenship is required. Active Public Trust in DHS or a component of DHS highly preferred What You'll Be Doing: You will be working with an established team to creat…
Est. 124,000 USD
Electrosoft Services, LLC is an award-winning company that provides comprehensive technology-based solutions and services to federal customers. While cybersecurity is our specialty, we also focus on ICAM, Zero Trust, dig…
Est. 130,000 USD
ServiceNow Developer Location: Washington, DC (onsite) Clearance: Active Secret (TS Preferred) Type: Exempt About This Role A ServiceNow Developer is needed to support a mission‑focused federal program in Washington, DC.…
Est. 130,000 USD
ServiceNow Developer Location: Washington, DC (onsite) Clearance: Active Secret (TS Preferred) Type: Exempt About This Role A ServiceNow Developer is needed to support a mission‑focused federal program in Washington, DC.…
Est. 124,000 USD
Electrosoft Services, LLC is an award-winning company that provides comprehensive technology-based solutions and services to federal customers. While cybersecurity is our specialty, we also focus on ICAM, Zero Trust, dig…
Est. 144,000 USD
CTEC is a leading technology firm that provides modernization, digital transformation, and application development services to the U.S. Federal Government. Headquartered in McLean, VA, CTEC has over 300 team members work…
Est. 118,000 USD
🔒 Clearance & Citizenship Requirements This position requires U.S. Citizenship and an active TS/SCI security clearance with Full Scope Polygraph. Candidates who do not currently hold these credentials will not be co…
Est. 124,000 USD
CTEC is a leading technology firm that provides modernization, digital transformation, and application development services to the U.S. Federal Government. Headquartered in McLean, VA, CTEC has over 300 team members work…
Est. 145,000 USD
Electrosoft Services, LLC is an award-winning company that provides comprehensive technology-based solutions and services to federal customers. While cybersecurity is our specialty, we also focus on ICAM, Zero Trust, dig…
Est. 200,000 USD
Job Description Seeking a Lead Data Engineer / Mission Data Pipeline to serve as a Subject Matter Expert (SME). You will work directly with government, technical, and industry stakeholders design, implement, and sustain…
Est. 160,000 USD
Assertive Professionals is seeking a Data Scientist supporting our National Security customer in Colorado Springs, CO. This is a proposed position, we are offering a salary of $160,000 with a $2,000 sign-on bonus, or rei…
Est. 135,000 USD
T-Rex is looking for a talented CNO Developer to work on a program in the Hanover, Maryland area in support of the Intelligence Community. Responsibilities: This Position Is An Onsite Role In this role, you will contribu…
Est. 124,000 USD
CTEC is a leading technology firm that provides modernization, digital transformation, and application development services to the U.S. Federal Government. Headquartered in McLean, VA, CTEC has over 300 team members work…
Est. 156,000 USD
Empower, Innovate, Impact! At Team A-TEK, we EMPOWER people to drive INNOVATION that IMPACTS mission! A-TEK operates at the intersection of mission and innovation by applying our deep domain expertise across the federal…
Est. 105,000 USD
Dexis is a dynamic professional services firm dedicated to partnering with government and community leaders both in the U.S. and internationally to achieve critical social outcomes in a rapidly changing world. At Dexis,…
Est. 135,000 USD
Technical Project Manager #1102 US Citizenship Required, Must be able to obtain Public Trust clearance This is a hybrid position with 3 days per week required onsite in Tysons Corner, Virginia. Seeking a dynamic, hands-o…
Est. 130,000 USD
All hired employees are expected to have experience with Microsoft Copilot and / or an approved equivalent AI solution.Description: Data Systems Analysts, Inc. (DSA) is seeking a Data Analytics Developer to join a high-p…
Est. 124,000 USD
CTEC is a leading technology firm that provides modernization, digital transformation, and application development services to the U.S. Federal Government. Headquartered in McLean, VA, CTEC has over 300 team members work…
Est. 225,000 USD
T-Rex is looking for a talented CNO Developer 3 to work on a program in the Hanover, Maryland area in support of the Intelligence Community. Responsibilities: This Position Is An Onsite Role Responsibilities include, but…