PowerBI Database Engineer

SAIC; Washington (District of Columbia); On-site; USD 110,000 - 170,000; Full time

Job summary

SAIC in Washington, DC is seeking a Power BI Database Engineer to design and deploy BI solutions, fuse data from multiple sources, and deliver real and near real-time reports for decision makers.

You will build data models, write advanced SQL, and leverage Power BI, SharePoint, and Excel to provide insightful dashboards for the DREN program. On-site role in DC with security clearance required.

Qualifications

• Bachelor's degree or 5+ years experience in BI or data engineering.
• Active Secret clearance; US Citizenship required.
• Strong SQL, API, Power BI, data modeling skills.
• Experience with Power BI DAX and KPI scorecards.
• Agile environment experience.

Responsibilities

• Design and deploy BI reports and dashboards in Power BI.
• Develop data models and data integration from multiple sources.
• Create and optimize DAX measures and KPI scorecards.
• Collaborate with cross-functional teams to translate requirements.
• Ensure real-time or near real-time reporting for decision makers.

Skills

Power BI

SQL

Data modeling

DAX calculations

REST APIs

JavaScript / C++

Agile methodology

Dashboard design

Education

Bachelor's degree in a related field

Tools

SharePoint

Excel

Job description

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