$90K - $125K/yr
Full-time
Posted 27 days ago
Job description
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
Qualifications:
Supplemental Skills:
Education
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.
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.
Most Popular SQL Developer Job Categories
Ms Sql Developer
Sql Application Developer
Sql Programmer
T Sql Developer
Sql Database Developer
Sql Programmer Analyst
Sql Bi Developer
Sr Sql Developer
Sql Engineer
Senior Sql Developer
Other Helpful Pages Related To SQL and Python Developer
Python Programmer Salaries
Python Programmer Career Research
Frequently asked questions
Q: What skills or qualities help someone succeed as a SQL Developer?
A: To succeed as a SQL Developer, key technical skills include proficiency in SQL programming languages (e.g., T-SQL, PL/SQL), database management systems (e.g., MySQL, PostgreSQL, Microsoft SQL Server), and data modeling techniques. Additionally, strong analytical and problem-solving skills, as well as the ability to communicate complex technical concepts to non-technical stakeholders, are essential soft skills for this role. By combining these technical and soft skills, SQL Developers can effectively design, implement, and maintain databases, drive business insights, and contribute to the growth and success of their organization.
Q: What is the career path for a SQL Developer?
A: A SQL Developer's typical career progression involves starting as a Junior SQL Developer, where they focus on writing and optimizing database queries, and then advancing to a Senior SQL Developer role, where they lead database development projects and mentor junior team members. Along the way, they can develop skills in data modeling, database administration, and business intelligence tools, as well as opportunities to specialize in areas like data warehousing, ETL, or big data technologies. Long-term, SQL Developers can transition into leadership roles, such as Database Architect or Data Engineer, or pursue careers in related fields like data science, business analysis, or IT management.
