SQL and Python Developer

IntelliDyne Jobs for Veterans; Washington (District of Columbia); On-site; USD 90,000 - 125,000; Full time

Job summary

IntelliDyne Jobs for Veterans in Washington, DC seeks a seasoned SQL Cognos Developer to design, develop, and implement SQL-based solutions in Cognos and Oracle environments. You will analyze requirements, build BI reports, and support production needs with Python scripting and ad hoc queries.

The role requires 5+ years in mid- to senior-level BI and data warehousing, strong SQL/PL-SQL, and experience with Cognos, OLAP, ETL, and data modeling; U.S. security clearance is required.

Qualifications

• 5+ years in a senior/open systems Oracle environment
• Minimum 5 years SQL and PL/SQL with 5 years of Python scripting
• Familiarity with OLAP modeling
• Familiarity with ETL (Extraction, Transformation and Loading)
• Strong understanding of relational structures, data modeling, SQL, data warehouse and reporting techniques
• Hands-on experience using SQL with Oracle
• Strong analytical and quality control experience for data accuracy
• Ability to work in a collaborative team on fast-paced projects
• Must have MBI Security Clearance

Responsibilities

• Perform complex analysis, design, programming, and modification of query programs inside Cognos and other applications
• Write SQL and PL/SQL and develop Python programs; test before client introduction
• Provide agile production support for application changes and ad hoc reporting
• Provide technical and analytical support
• Develop ad hoc SQL reports inside BI tools like Cognos and Crystal Reports
• Translate requirements into BI solutions using Python to query and analyze data
• Perform data modeling, BI app specs, performance tuning, and deployment support
• Analyze BI function requirements and estimate effort for reports development
• Provide QA/QC analysis of standard and ad hoc reports

Skills

SQL

PL/SQL

Python

OLAP

ETL

Data Modeling

Oracle

Quality Assurance

Team Collaboration

MBI Security Clearance

Education

Bachelor's degree in Computer Science or related field

Tools

Cognos

Crystal Reports

Business Objects Enterprise XI

Job description

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

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

As set forth in IntelliDyne Jobs for Veterans’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.