Software Developer / Programmer 2 at First Tek, Inc. in Portland, OR

Job description

• API SoftDev2 JLSR 20260909 - CORA.docx
• Title & Level
• Software Developer 2
• Work Group Location
• Portland, OR
• Specialty
• Reports and Analytics Developer
• Offsite Work Eligibility*
• Routine Telework Eligible
• Organization
• JLSR
• Number of Days Onsite
• 1 days per Week
• Hours
• Full-Time, up to 40 hours
• This team meets onsite every Thursday for meetings.
• Overtime
• 5% anticipated
• On-Call
• No
• Travel
• Up to 5% for meetings
• FN Status
• NOT open to Foreign Nationals
• * Current telework, remote work and onsite support is based on BPA’s business needs and is subject to change or termination at any time.
• ** Assignments with the “Remote” Designation must reside in WA, OR, ID or MT. Case-by-case exceptions may apply only when in the best interest of BPA.
• Assignment
• This full-time contract assignment will support the Data Integration and Reporting (JLSR) organization within ***’s (BPA’s) IT department. This assignment involves contributing to the organizing, planning, and managing of a large, complex reporting environment, and performing project technical requirements, design, development and testing tasks similar to those performed by the rest of the development team.
• Organization
• Data Integration and Reporting provides reporting services, business intelligence, data warehousing, and data integration. The staff provides reports development and reporting services as well as the management and delivery of services supporting a BPA common information model through the implementation of data integration architectures such as data warehouses, data marts, and data migration/integration solutions.

Responsibilities

• Note: All official drafts, documents and recommendations, as listed below, must be reviewed, finalized and approved / accepted by appropriate BPA manager or other federal personnel with the authority to do so.
• Collaborate with technical team members and customers in order to translate user requirements from both internal and external BPA clients into functional capability. Confirm JLSR resources are available to provide representation to organizations within BPA.
• Perform project technical requirements; design, development, and testing tasks for fixed and analytic reports.
• Develop static and dynamic reports from a three-tier client-server application that uses a web server, application server, and SQL database engine architecture.
• Write scripts and modify Microsoft Visual Studio methodology templates to provide customization of check-in policies, custom reports, and repetitive testing.
• Create and modify existing reports and dashboards using the Power BI Desktop tool.
• Troubleshoot and communicate report interoperability problems in existing web-driven applications using SQL as the backend for data access.
• Develop customer focused BI analytics solutions.
• Develop presentation layers in concert with customer requirements and best practices and approaches.
• Act as a point of contact and oversee technical schedule segments to ensure project milestones are completed on time by escalating issues to the team lead and project manager if necessary.
• Provide issue resolution in coordination with the team lead and project manager.

Requirements

• Education & Corresponding Experience (required on matrix)
• Bachelor of Science in Information/Computer Technology or a related technical discipline is preferred.
• 3 years of Information Technology experience is required with a Bachelor’s degree in a specified degree..
• 5 years of Information Technology experience is required without a degree or an applicable degree..
• Required Technical Skills & Experience (required on matrix)
• Power BI Server and desktop tool
• Microsoft Visual Studio 2019, 2022 and SQL Server Data Tools (SSDT)
• Microsoft SQL Server 2016, 2022 or later
• SQL Reporting Services 2012, 2016, and 2022
• Scripting (VB scripting/Java Scripting, and Powershell)
• Report Design / Information/database Design Skills
• Microsoft Analysis Services 2008 – 2022
• Oracle Cloud infrastructure (EPM)
• Data Modeling/Dimensional Modeling/ER Diagrams
• Web design, content layout, ASP.NET
• HTML background
• SharePoint design experience
• SDS (System Design Specification)
• Software development coordination with clients and management
• Microsoft Certified Solution Developer (MCSD) for Microsoft.NET certification.

Skills

Required

• Power BI Server and desktop tool
• Microsoft SQL Server 2016, 2022 or later

Preferred

• Microsoft Analysis Services 2008 – 2022
• Oracle Cloud infrastructure (EPM)
• Web design, content layout, ASP.NET
• HTML background
• SharePoint design experience
• SDS (System Design Specification)