BI Application Developer

Zachary Piper Solutions is seeking a BI Application Developer to work in Huntsville, AL, Chantilly, VA, Quantico, VA or Washington, DC. This position has multiple openings, requiring work to be performed 100% onsite in one of the listed locations. The BI Application Developer will help to move a federal client's Data Warehouse from Oracle Enterprise Edition to the AWS cloud, offering a prime opportunity for those eager to improve their BI development expertise.

• Must have an Active Top Secret clearance*

Responsibilities of the BI Application Developer include:

• Collaborate with our AWS Solutions Architect and Data Warehouse Engineer to migrate the TIBCO WebFOCUS application from on-premises to AWS, modifying code and objects as necessary.

• Utilize Business Intelligence Client Server, Report Server, and Data Migrator for successful cloud transition tasks.

• Facilitate data connectivity and integration by creating TIBCO stored procedures and setting up adapter connections.

• Generate TIBCO reports in formats such as Excel, HTML, and PDF, manage master and access files, and schedule Reportcaster jobs.

• Engage with DB Visualizer for AWS Redshift data analysis, develop comprehensive design documentation, and adapt to the dynamic needs of an Agile work environment.

Qualifications for BI Application Developer include:

• Solid understanding of AWS services, architecture, and security best practices including IAM and KMS.

• Minimum of 6 years of experience in BI tools, specifically TIBCO WebFOCUS Client Server and Data Migrator, and at least 6 years in Report Server

• At least 6 years of hands-on experience with Aurora PostgreSQL or similar relational databases, as well as AWS Redshift.

• Proficiency in database programming and analysis tools, with a minimum of 6 years using DB Visualizer or similar software.

• Excellent communication, collaboration, and QA skills, with experience in Agile/SAFe environments and the ability to work with diverse teams and stakeholders.

Compensation for the BI Application Developer include:

• Salary: $150-160k

• Full Benefits: PTO, Paid Holidays, Cigna Medical, Dental, Vision, 401k, etc.

Keywords: on-site work, full-time position, cloud migration, object modifications, code implementation, cloud migration tasks, BI development, connection creation, TIBCO reporting, report editing, job scheduling, data analysis, system documentation, rapid development, security practices, multi-disciplinary team, stakeholder engagement, vendor coordination, team collaboration, technical communication, SQL scripting, secret security clearance, Amazon Web Services, data engineering, software development, process documentation, system knowledge preservation, fast-paced work environment, changing requirements, technical qualifications, SQL proficiency, serverless computing, complex SQL, data integration, software engineering, cloud services, database administration, systems architecture, information security, quality assurance processes, team dynamics, cross-functional collaboration, stakeholder management, strategic communication, advanced SQL, cloud technology, professional development, technical expertise, security clearance, federal projects, government contracting, Top Secret clearance, AWS Solutions Architect, Data Warehouse Engineer, TIBCO WebFOCUS, AWS Cloud, on-premises migration, Business Intelligence, Client Server, Report Server, Data Migrator, adapters, stored procedures, Excel reports, HTML reports, PDF reports, master files, access files, Reportcaster, DB Visualizer, AWS Redshift, design documentation, quality control, Agile environment, Huntsville AL, Chantilly VA, Washington DC, Quantico VA, Aurora PostgreSQL, relational database, Oracle, DB Programming, IAM, KMS, QA best practices, collaboration, business analysts, data scientists, subject matter experts, developers, Agile/SAFe, communication skills, serverless architecture, SQL queries

#LI-DT1 #LI-HYBRID #LI-DNI