Opening Req Statement:    GDIT MAINES contract has a requirement for an experienced Software Developer/Data Engineer to join our ITS-EPA IV Managed Application, Infrastructure, Networking, Enterprise, and Security Services (MAINES) Contract in support of the Environmental Protection Agency.  This position supports the EPA’s Business Intelligence and Analytics Center (BIAC) and its Business Automation Platform (BAP) powered by Salesforce.
Job Description:
    Researches, designs, develops, tests, and/or modifies enterprise-wide systems and/or applications software. 
Major Duties and Responsibilities:
    •    Hands on experience leading data warehousing and analytics projects 
•    Excellent SQL and strong hands-on data warehousing design, tuning and ETL process development on Prem and in Cloud. 
•    The design, development, testing and support of new capabilities and ongoing changes within the various application data marts 
•    Collaborate with other IT specialists to rapidly develop and deliver solutions that meet changing business needs.  
•    Perform all necessary discovery and fact finding to fully understand business problems and opportunities and execute all assignments with limited supervision 
•    Effectively communicate development and production issues to the project team, applicable vendors and/or the manager in a timely manner 
•    Work with data owners to document data mappings and transformations to support effective downstream analytics and alerts 
•    Research and stay abreast of technology trends and IT best practices, with a focus on continuous learning.  
•    Develop test data as necessary to support testing 
•    Make recommendations and advise on data refresh, optimization of data, data storage, and data integration among two or more systems 
•    Attend various meetings as Subject Matter Expert for ETL 
•    Understanding of Business Intelligence Reporting and dashboard development 
•    Knowledge of Salesforce data integration 
•    Monitoring daily workflows for errors and performance. Debugging issues, analyzing data flow logic, and correcting defects 
•    Working knowledge of Unix and Shell scripting 
Qualifications:
    Required Qualifications: 
•    Bachelor’s Degree in Computer Science or related technical discipline with 5+ years' experience, or a Master’s Degree in Computer Application and 3+ years' experience 
•    Demonstrated experience using Informatica PowerCenter v10, PL/SQL, SQL, Oracle 11g/12c/18c/19c, XML, JSON, Java, web services, Git, JIRA, Linux (Red Hat)  
•    Salesforce Administration & Development  
•    Experience working in the no/low code declarative environment 
•    Experience with Apex, Visualforce
•    Experience with GearSet and assisting with deployments of discrete applications into shared multi-tenant environment 
•    Hands-on experience with Oracle Relational Database Management System. An understanding of how to design and develop an Oracle DataMart/data warehouse 
•    Demonstrated experience working with and transforming XML, JSON, or CSV 
•    Demonstrated experiencing working with and or authoring XML and JSON Schemas. Excellent communication skills, the ability to be proactive in communication (email, chat, phone) 
•    Knowledge of Salesforce for data integration 
•    Ability to work East Coast business hours 
•    Must be able to obtain and retain a Public Trust  
•    Must be able to work independently 
•    Must be able to work 100% remotely 
 
Additional Preferred qualifications but not required: 
•    Experience developing in an Agile environment, including Scrum and user stories 
•    Demonstrated experience participating in Agile development teams. 5+ years of experience in IT platform implementation in a technical role, designing data base and date warehouse environments, analyzing production deployments, recommendations to optimize performance, and ETL development using Informatica  
•    Experience with Business Intelligence and reporting 
•    Oracle Application Express (Apex) 
•    Oracle Analytics Server (formerly OBIEE) 
•    Experience with other technologies, such as Java, Python, .NET, Node.js, Salesforce, and Oracle APEX 
 
Soft Skills: 
•    Excellent written and verbal communication 
•    Comfortable interfacing with client and their customers, including technical & nontechnical audiences 
o    Translate complex technical specs and terms into business language 
o    Understand business requirements and translate into technical specifications 
•    Capable of Designing, Developing, and Demonstrating solutions