PowerBI Database Engineer

SAIC has an excellent opportunity for a PowerBi Database Engineer to support the Defense Research and Engineering Network (DREN) program to provide effective and insightful reports using Power BI, SharePoint, Excel and other tools, build systems that merge data from disparate sources into consumable dashboards for the customer, and deliver real and near real-time reports and information for key decision making. This role is onsite in Washington, D.C.

JOB DESCRIPTION:

- Design and deploy reporting tool using provided software capabilities to fuse and present information from various systems through API calls or other authorized data transfer means
- Design, develop and deploy business intelligence solutions using PowerBI and other tools such as SQL and SharePoint
- Advanced SQL query writing and design skills including stored procedures, functions, views, tables, and relationships
- Determine business requirements within BI context and design a data model to transform raw data into meaningful insights
- Convert business requirements into technical specifications and implement them through reports that support decision-making
- Craft and execute queries based on requests for data
- Establish relationships between data sources and develop tabular and multi multidimensional data models to present information in customer consumable format
- Experience with integration tools and data modeling technology

Education Requirements:

- Bachelor’s and five (5)+ years of experience; additional six (6) years of experience accepted in lieu of degree.

Clearance Requirements:

- Must possess an active Secret security clearance; US Citizenship required.

Required Skills:

- Experience scripting web applications in Javascript or C++ language
- Experience developing application programming interfaces (API)
- Experience working with PowerBi tools, development, and administration
- Experience developing data presentation
- Experience with SQL (complex joins, math, aggregations, etc.)
- Building Analysis Services reporting models
- Developing visual reports, dashboards and KPI scorecards using Power BI desktop
- Connecting to data sources, importing data and transforming data for Business Intelligence
- 3+ year experience in an Agile organization with a formal Agile methodology is strongly preferred
- Demonstrated ability to construct custom calculations through Power BI DAX
- Certified Power BI / Power Platform certifications are strongly preferred.
- Strong understanding and ability to transform and integrate new and existing data sets
- Demonstrated knowledge of statistical applications
- Proven ability to effectively lead and collaborate in a dynamic, fast paced, team oriented environment, with competing priorities
- Ability to solve a variety of complex problems in the absence of technical guidelines and where creative thinking is required
- Experience working with and within virtual or physically dispersed teams preferred.
- Good understanding of REST and Web API’s.
- Experience working with Power Platform applications (Apps, Automate, BI, Pages, etc.) preferred.
- Ability to translate the functional requirements into technical work packages / data models.
- Certified Power BI / Power Platform certifications are strongly preferred.

Required Certifications:

- Must have one (1) of the following certifications Network+ CE, Security+ CE, CySA+, OR CASP+ CE