Application and Business Intelligence Developer, Consultants
Washington, DC

Job Description

Job title: Application and Business Intelligence Developer, Consultants

Department: Technology Integration

Based in Washington DC (US based remote will be considered)

Reports to the Senior Application Development Manager

Who we are

We're Population Services International (PSI), the world's leading non-profit social marketing organization. We work to make it easier for people in the developing world to be healthy by providing access to products and services that range from mosquito nets to HIV testing.

There are over 7,000 "PSI'ers" around the world. It's a diverse group of entrepreneurs and professionals with an unusually wide range of backgrounds - from the medical industry to the music business - all with unique skills we bring to the job.

The IT Operations group of the Technology Integration department solves problems and finds new opportunities to support PSI's mission around the world. We provide expertise, guidance and support for enterprise applications, network infrastructure, business intelligence and software development. We're physically located in Washington, DC, but we work all over the globe. We contribute to the PSI mission by making sure our colleagues have access to the information, tools, and support they need wherever they may be.

What are we looking for

We're seeking 2 consultant developers for a 6-month contract with likely extension as project pipeline is dynamic and growing. We are looking to establish long term relationships with consultants who possess skill sets that match our current development framework.

Project A: QuickBooks Data Extraction Application Enhancements (C#.NET)

We have a custom developed Windows ETL application that extracts data from dozens of QuickBooks Enterprise installations, performs extensive live validation of the data based on pre-defined rules that are stored in a remote central SQL database, transforms data based on pre-defined mapping rules, and then saves the data into csv files in a remote central application server. The application is built with C#.NET and include both client and server components.

This project is to enhance the application to extract additional data points, add new features, address some performance issues and make other improvements.

Responsibilities:

* Quickly familiarize yourself with the existing codebase
* Assess existing architecture for performance, scalability, and stability and suggest improvements
* Work with business owners and subject matter experts to understand requirements, translate them into technical requirements and calculate the level of effort
* Design, develop, test, and deploy new features based on existing codebase
* Communicate status with stakeholders
* Develop and update technical documentation and tutorials
* Support and maintain the application in production

Requirements:

* 5 years of professional software development experience
* Expert on C#, .NET, Windows Services, WCF, T-SQL, QuickBooks SDK, ASP.NET, SSIS, IIS, LINQ, Visual Studio
* Experience with QuickBooks Enterprise, QuickBooks Pro, Azure Storage, Azure DevOps Git
* A solid understanding of good software development processes and experience with Scrum/Agile development methodologies
* Ability to master existing codebase
* Strong communication skills

Nice-to-Haves:

* Experience with SSAS Tabular, Power BI
* Experience with SharePoint, SharePoint REST API
* Experience with PHP, JavaScript, CSS
* Experience working with a global NGO

Project B: New SSAS Tabular Data Models and Power BI Reports

This project is to build a few data models in SSAS Tabular and produce Power BI reports to support our business analytics and operation management. The data sources will be from various systems that require different ETL methods.

Responsibilities:

* Work with system admins and business process owners to understand the various data sources and business logics for ETL
* Work with business users to understand reporting requirements
* Provide estimates of the level of effort based on user requirements
* Develop the ETL processes and build data warehouses
* Build tabular data models with SSAS
* Monitor and improve data model performance
* Set up reliable automatic data refreshing
* Produce Power BI dashboards and reports
* Configure row level security for Power BI reports
* Set up enterprise gateway for Power BI Service
* Develop technical documentation
* Support and maintain the products

Requirements:

* 5 years of professional business intelligence development experience
* 3 years of Power BI development experience
* Expert on T-SQL, Data Warehouse, SSAS Tabular, SSIS, Power BI, Excel
* Experience with Azure DevOps Git
* Experience with data ETL through web REST API
* A solid understanding of good software development processes and experience with Scrum/Agile development methodologies
* Strong communication skills

Nice-to-Haves:

* Experience with Power BI Embedded
* Experience with Azure Analysis Services
* Experience working with a global NGO

Project C: Enhancements and Supports of Existing Applications

We have multiple custom developed PHP web applications and SharePoint based JavaScript applications that need enhancements and support. We also have a few smaller applications that use a range of other programming languages including Node.js, Perl, VBA, etc. that require lower level of maintenance efforts. We are looking for a consultant that can provide long term support and maintenance of all these products.

Responsibilities:

* Quickly familiarize yourself with the existing codebase
* Assess existing architecture for performance, scalability and stability and suggest improvements
* Work with business owners and subject matter experts to understand the requirements, translate them into technical requirements and calculate the level of efforts
* Design, develop, test, deploy required new features based on existing codebase
* Communicate with all stakeholders on the development progress
* Develop and update technical documentation and tutorials
* Support and maintain the application in production

Requirements:

* 5 years of professional software development experience
* Expert on PHP, T-SQL, JavaScript, jQuery, CSS, SharePoint, SharePoint REST API, Excel, HTML5
* A solid understanding of good software development processes and experience with Scrum/Agile development methodologies
* Ability to dive into and master existing codebase in a limited timeframe
* Strong communication skills

Nice-To-Haves:

* Experience with Node.js, Perl, VBA, PowerShell
* Experience with SharePoint, Power Apps, Microsoft Flow

Please send CVs to tyao@psi.org