Data Warehouse Programming Specialist jobs in Arlington, VA

Company Description

• ProSidian is a Management and Operations Consulting Services Firm focusing on providing value to clients through tailored solutions based on industry-leading practices. ProSidian services focus on the broad spectrum of Enterprise Service Solutions for Risk Management | Compliance | Business Process | IT Effectiveness | Engineering | Environmental | Sustainability | and Human Capital. We help forward-thinking clients solve problems and improve operations.
• Launched by former Big 4 Management Consultants; our multidisciplinary teams bring together the talents of nearly 190 professionals globally to complete a wide variety of engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies.  Our solution-centric services are deployed across the enterprise, target drivers of economic profit (growth, margin, and efficiency), and are aligned at the intersections of assets, processes, policies, and people delivering value.
• ProSidian clients represent a broad spectrum of industries including but not limited to Aerospace And Telecommunications | Consumer Products, Services, And Retail | Development And Sustainability | DOD/Military | Energy, Resources, & Industrials | Financial Services | Government & Public Services | Information Technology, Media, And Telecommunications | Life Sciences & Health Care | Manufacturing And Operations | Nuclear and Environmental | Professional Services |, etc.  Learn More About ProSidian Consulting at www.ProSidian.com.

Job Description

• Provide The Center for Food Safety and Applied Nutrition (CFSAN) IT System Lifecycle Development and Management Support Services on behalf of the Food and Drug Association (FDA). The FDA is seeking Small Business (SB) sources to determine the availability and capability of small business manufacturers or small businesses capable of IT System Lifecycle Development and Management Support Services.
• The FDA | CFSAN is in need of project management services. The Single Award Blanket Purchase Agreement (BPA) will be awarded by the FDA contracting manager.  The Center for Food Safety and Applied Nutrition (CFSAN) is the branch of the United States Food and Drug Administration that regulates food, dietary supplements, cosmetics, drugs, biologics, medical devices, and radiological products. 
• The scope of this contract is to provide the full range of technical and management services necessary to develop, maintain, and enhance CFSAN systems. The general requirements include providing Custom Computer Programming Services (NAICS 541511) to the FDA and CFSAN; and to maintain, support, and evolve code, scripts, views, triggers, jobs, designs, documentation, reports, and templates. 
• There is also a need to establish an ordering vehicle that develops and maintains existing and future Computer to Plate (CTP) systems, which will process structured and unstructured data. The FDA expects between 2-5 new applications/systems to be added to the BPA per year over the duration of this contract. The ProSidian Engagement Team shall provide training services to CFSAN stakeholders for existing applications, application changes, or newly-developed applications.  CFSAN will issue individual Task Orders for the Contractor to provide IT Lifecycle Support for the CFSAN IT portfolio of systems as needed. Representative tasks to be performed. 

THE BLANKET PURCHASE AGREEMENT IS DIVIDED INTO THE FOLLOWING (9) TASK AREAS: 

• Task 1: Project Management:  Task Order level project management to establish control, management, monitoring and notification mechanisms to ensure the individual task orders stay on track to meet the important milestones and performance measures within the awarded task. | DOCUMENTATION:  The Contractor shall use FDA supplied templates which will be provided on each individual Task Order as applicable. If an FDA template does not exist, the Contractor may be tasked with drafting a template for approval by the COR.
• Task 2: O&M and DME Architecture Support Services:  The Contractor shall provide the full range of architecture support services in order to formulate the integrated, end-to-end automated systems that provide enhanced IT capabilities necessary to support CFSAN business and mission processes. The goal is a stable evolutionary progression from an organization’s current state to its envisioned future state by identifying tools and technologies that work together to satisfy the needs or changing business needs of the CFSAN users.
• Task 3: Development, Modernization, and Major Enhancement: The Contractor shall provide the complete range of system development lifecycle support services necessary to develop and enhance CFSAN IT systems and tools as well as their external interfaces to FDA Enterprise and Center Systems and applications. Tasks may encompass the complete lifecycle of activities required for database, application and tool development including, but not limited to requirements elicitation, analysis and validation; system design; code generation; testing; deployment; and documentation.  The Contractor shall also develop, support and evolve designs, customizations and process automation such as interfaces, templates, scripts, workflows, interfaces to permit reviewer access to analytics/tools, and reports. Deliverable products shall be validated and tested to ensure that they meet applicable/specified standards, policy, business requirements.
• Task 4: Systems Integration and Engineering Services:  The Contractor shall support CFSAN with integration services. The Contractor shall focus on the development and deployment of integrated information systems that reflect the introduction of a Service Oriented Architecture (SOA) orientation and, moreover, places an emphasis on the recommended acquisition and re-use of existing components—be they FDA components, HHS components, or components acquired from any other source. 
• Task 5: Data Migration and Management Support:  The Contractor shall provide data management support for activities related to the development and execution of data architectures, data policies, practices, and procedures that properly manage the full data lifecycle needs of CFSAN. Task #6 - Operations and Maintenance (O&M) and Support Services
• Task 6: Operations and Maintenance (O&M) and Support Services:  The Contractor shall provide the complete range of operations and maintenance support services necessary to maintain CFSAN IT systems. The Contractor shall be responsible for maintaining the “lights on” availability, reliability, and security of the CFSAN IT portfolio through the full range of O&M services. The Contractor shall maintain, support, and evolve code, scripts, views, triggers, jobs, designs, documentation, reports, and templates. The Contractor shall analyze and report on the impact of infrastructure, software upgrades, capacity, and all changes to the technical environment. These day-to-day operations, maintenance, and help desk support ensures that the systems perform their intended functions.
• Task 7: System and Data Disposition:  The Contractor shall identify, recommend and implement the retirement and consolidation of systems, components, technologies, tools and data when they meet the appropriate disposition stage of the lifecycle as defined in the EPLC. 
• Task 8: Training Support for O&M and DME:  The Contractor shall provide training services to CFSAN stakeholders for existing applications, application changes, or newly developed applications. The Contractor shall assess the level of capability of the users and the need for training. The Contractor shall prepare a training plan, the training materials, and arrange and conduct training sessions. The training plan and materials shall be provided to the COR for review and approval prior to training.
• Task 9: Transition Activities:  The Contractor shall provide the transition-in and transition-out of activities to develop, operate, and manage the CFSAN IT portfolio. It is the responsibility of both the incoming Contractor and outgoing Contractor to ensure a smooth transition, with minimal disruption to services and support for users. The purpose of the transition is to transfer expert knowledge, data, and artifacts that are used to support applications from the incumbent Contractor to the successor Contractor efficiently.

*** Enterprise Performance Lifecycle (EPLC) Agile Methodology:  The Food and Drug Administration maintains a project management methodology framework that incorporates best government and commercial practices through a consistent and repeatable process, and provides a standard structure for planning, managing and overseeing IT projects over their entire life cycle.  The HHS Enterprise Performance Life Cycle (EPLC) framework provides that methodology for HHS OPDIVs including FDA.

Qualifications

TEAM PROSIDIAN PERSONNEL SHALL HAVE EXPERIENCE IN THE FOLLOWING:

• Expertise and experience in designing, developing, implementing, communicating, administering and evaluating human resources programs, with emphasis in compensation and classification in large (i.e., over 4,000 employees) geographically dispersed organizations with a technical, multi-faceted mission of national scope.
• Demonstrated successful experience in designing and implementing innovative private and public sector compensation and pay for performance programs, and/or expertise in a unionized environment.
• Experience in job analysis and evaluation, with expertise in making accurate Fair Labor Standards Act (FLSA) exemption determinations, and demonstrated ability to successfully defend those decisions to employees, management, and/or outside parties.
• Expertise in state-of-the art compensation, pay for performance, and awards programs, with the ability to tailor such programs to a public-sector regulatory/operational organization.
• Knowledge of existing laws and regulations pertaining to the federal compensation, classification, performance, and recognition programs, and to the federal financial regulatory agencies.  

DATABASE MANAGEMENT SPECIALIST – KEY PERSONNEL QUALIFICATIONS

• Provides highly technical expertise in the use of DBMS. Evaluates and recommends available DBMS products to support validated user requirements. Defines file organization, indexing methods, and security procedures for specific user applications. Administers, maintains, develops, and implements policies and procedures for ensuring the security and integrity of the customer databases. Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues. Develops and administers large-scale Database Management Systems (DBMS). Participates in the design and development of DBMS at the highest level, and in defining the core system and subsystems. Directs the entire software development process, from the establishment and definition of requirements to implementation, acceptance, and maintenance. Provides technical and administrative direction for personnel performing software development tasks, including the review of work products for correctness, adherence to the design concept and to user standards, and for progress in accordance with schedules. Prepares milestone status reports and deliveries/presentations on the system concept to colleagues, subordinates and end user representatives. Provides daily supervision and technical direction to staff to ensure program deadlines are met. Provides technical guidance to systems and applications programmers. Directs and participates in the conceptual system design and specification. Reviews computer database information software support systems and data requirements, as well as communication and response needs, and recommends operating systems and languages to support them. Develops test plans and test data for operating systems and support software. Assists with the design and documentation of data requirements, system test and implementation plans, and system demonstrations. May supervise more junior Database Administrators

Additional Information

As a condition of employment, all employees are required to fulfill all requirements of the roles for which they are employed; establish, manage, pursue, and fulfill annual goals and objectives with Documented Goals for each of the firm's Eight ProSidian Global Competencies [1 - Personal Effectiveness | 2 - Continuous Learning | 3 - Leadership | 4 - Client Service | 5 - Business Management | 6 - Business Development | 7 - Technical Expertise | 8 - Innovation & Knowledge Sharing (Thought Leadership)]; and to support all business development and other efforts on behalf of ProSidian Consulting.

CORE COMPETENCIES

• Teamwork – ability to foster teamwork collaboratively as a participant and effectively as a team leader
• Leadership – the ability to guide and lead colleagues on projects and initiatives
• Business Acumen – understanding and insight into how organizations perform, including business processes, data, systems, and people
• Communication – ability to effectively communicate to stakeholders of all levels orally and in writing
• Motivation – persistent in pursuit of quality and optimal client and company solutions
• Agility – ability to quickly understand and transition between different projects, concepts, initiatives, or workstreams
• Judgment – exercises prudence and insight in the decision-making process while being mindful of other stakeholders and long-term ramifications
• Organization – the ability to manage projects and actions and prioritize tasks

------------ ------------ ------------

OTHER REQUIREMENTS

• Business Tools – understanding and proficiency with business tools and technology, including Microsoft Office. The ideal candidate is advanced with Excel, Access, Outlook, PowerPoint, and Word, and proficient with Adobe Acrobat, data analytic tools, and Visio with the ability to quickly learn other tools as necessary.
• Business Tools – understanding and proficiency with business tools and technology, including Microsoft Office. The ideal candidate is advanced with Excel, Access, Outlook, PowerPoint, and Word, and proficient with Adobe Acrobat, data analytic tools, and Visio with the ability to quickly learn other tools as necessary.
• Commitment - to work with smart, interesting people with diverse backgrounds to solve the most significant challenges across private, public, and social sectors
• Curiosity – the ideal candidate exhibits an inquisitive nature and the ability to question the status quo among a community of people they enjoy and teams that work well together
• Humility – exhibits grace in success and failure while doing meaningful work where skills have impact and make a difference
• Willingness - to constantly learn, share, and grow and to view the world as their classroom

------------ ------------ ------------

BENEFITS AND HIGHLIGHTS

ProSidian Employee Benefits and Highlights: Your good health and well-being are important to ProSidian Consulting. At ProSidian, we invest in our employees to help them stay healthy and achieve work-life balance. That's why we are also pleased to offer the Employee Benefits Program, designed to promote your health and personal welfare. Our growing list of benefits currently includes the following for Full-Time Employees:

• Competitive Compensation: The pay range begins in the competitive ranges with Group Health Benefits, Pre-tax Employee Benefits, and Performance Incentives. The Company contributes a fixed dollar amount each month towards the Plan you elect for medical and dental benefits. Contributions are deducted on a pre-tax basis.
• Group Medical Health Insurance Benefits: ProSidian partners with BC/BS to offer a range of medical plans, including high-deductible health plans or PPOs. ||| Group Dental Health Insurance Benefits: ProSidian dental carriers - Delta, Aetna, Guardian, and MetLife.
• Group Vision Health Insurance Benefits: ProSidian offers high/low vision plans through 2 carriers: Aetna and VSP.
• 401(k) Retirement Savings Plan: 401(k) Retirement Savings Plans help you save for your retirement for eligible employees. A range of investment options is available with a personal financial planner to assist you. The Plan is a pre-tax Safe Harbor 401(k) Retirement Savings Plan with a company match.
• Vacation and Paid Time-Off (PTO) Benefits: Eligible employees use PTO for vacation, a doctor's appointment, or any number of events in your life. Currently, these benefits include Vacation/Sick days – 2 weeks/3 days | Holidays - 10 ProSidian and Government Days are given.
• Pre-Tax Payment Programs: Pre-Tax Payment Programs currently exist in the form of a Premium Only Plan (POP). These Plans offer a full Flexible Spending Account (FSA) Plan and a tax benefit for eligible employees.
• Purchasing Discounts & Savings Plans: We want you to achieve financial success. Therefore, we offer a Purchasing Discounts & Savings Plan through The Corporate Perks Benefit Program. This provides special discounts for eligible employees on products and services you buy daily.
• Security Clearance: Due to the nature of our consulting engagements, there are Security Clearance requirements for Engagement Teams handling sensitive Engagements in the Federal Marketplace. A Security Clearance is a valued asset in your professional portfolio and adds to your credentials.
• ProSidian Employee & Contractor Referral Bonus Program: ProSidian Consulting will pay up to 5k for all referrals employed for 90 days for candidates submitted through our Referral Program.
• Performance Incentives: Due to the nature of our consulting engagements, there are performance incentives associated with each new client that each employee works to pursue and support.
• Flexible Spending Account: FSAs help you pay for eligible out-of-pocket health care and dependent daycare expenses on a pre-tax basis. You determine your projected costs for the Plan Year and then elect to set aside a portion of each paycheck into your FSA.
• Supplemental Life/Accidental Death and Dismemberment Insurance: If you want extra protection for yourself and your eligible dependents, you have the option to elect supplemental life insurance. D&D covers death or dismemberment from an accident only.
• Short- and Long-Term Disability Insurance: Disability insurance plans are designed to provide income protection while you recover from a disability.

----------- ------------ ------------

ADDITIONAL INFORMATION - See Below Instructions On The Best Way To Apply

ProSidian Consulting is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, creed, religion, national origin, sex, sexual orientation, gender identity and expression, age, disability, or Vietnam era, or another eligible veteran status, or any other protected factor. All your information will be kept confidential according to EEO guidelines.

ProSidian Consulting has pledged to the Hiring Our Heroes Program of the U.S. Chamber of Commerce Foundation and the "I Hire Military" Initiative of The North Carolina Military Business Center (NCMBC) for the State of North Carolina. All applicants are encouraged to apply regardless of Veteran Status.

Furthermore, we believe in "HONOR ABOVE ALL"  - success while doing things the right way. The pride comes out of the challenge; the reward is excellence in the work.

For Easy Application, Use Our Career Site Located On Http://Www.ProSidian.Com/ Or Send Your Resume's, Bios, And Salary Expectation / Rates To To Careers @ ProSidian.Com & Recruiter @ ProSidian.Com

ONLY CANDIDATES WITH THE REQUIRED CRITERIA ARE CONSIDERED.

Be sure to place the job reference code in the subject line of your email.  Be sure to include your name, address, telephone number, total compensation package, employment history, and educational credentials.

Risk Management | Compliance | Business Processes | IT Effectiveness | Engineering | Environmental | Sustainability | Human Capital