312 Business Intelligence Developer jobs in Washington, DC
Scroll to load more...
Senior Business Intelligence Developer
Spry Methods
Senior Business Intelligence Developer
This job is still taking applications, but it's been up a while.
About the job
Spry Methods supports federal agencies with IT services, specializing in database management and operations for law enforcement and scientific organizations; this role in Quantico VA involves on-premises and cloud database support.
Requirements
- 6+ years of experience
- Strong TSQL query skills
- Knowledge of database security
- Experience with SQL Server and AWS
- US citizenship and Top-Secret clearance
Qualifications
- Bachelor’s degree in CS or IT
- Excellent problem-solving skills
- Ability to work independently
- Effective communication skills
- Experience with database maintenance
Full job description
Are you ready to play crucial role in supporting cutting-edge technology for federal law enforcement and scientific organizations with IT services and support for hardware, IT systems, applications, and operational technologies that support mission critical operations?
Spry Methods is seeking a Senior Business Intelligence Developer (SQL Server / Power BI) to support a strategic laboratory program for our DOJ FBI customer. The ideal candidate has experience as a Business Intelligence Developer, SQL Developer, or Power BI Developer with strong Microsoft SQL Server database administration skills.
What Your Day-To-Day Looks Like (Position Responsibilities):
· Understanding of PowerBI dashboards and how to configure those datasets to leverage SQL queries and views.
- Must have experience developing Power BI DAX expressions for reporting and data analysis
- Develop and support reporting and ETL solutions using SSRS, SSIS, and Power BI.
- Develop, maintain, and enhance Power BI dashboards, reports, and semantic datasets to support enterprise reporting and analytics.
- Develop Power BI DAX measures, calculated columns, and data models to deliver business intelligence solutions.
- Connect SQL Server data sources to Power BI using optimized SQL queries, stored procedures, and views.
- Experience developing or supporting ETL processes, data integration, and enterprise reporting solutions.
· Design, write, optimize, and maintain complex TSQL queries, stored procedures, views, and database scrips to support business applications and reporting needs.
· Manage and monitor the performance of TSQL databases, seeking improvements through performance and query tuning
· Create, manage, and continually improve TSQL Server maintenance plans through monitoring of queries, indexes, and TSQL statistics
· Create, manage, maintain, and improve backup, restore, and replication schedules driven by end user events and processes
· When required, manage and monitor the performance of cloud-based databases within AWS.
· Support the deployment of new databases and schema objects as needed in the on-premises and cloud environment.
· Monitor and maintain databases to ensure stability and optimal performance.
· Ensure that databases are secure and adhere to industry standards.
· Analyze and troubleshoot database issues and take necessary actions to resolve them.
· Generate reports to measure database performance, utilization, and growth.
· Plan and implement database activities including upgrades and patching.
What You Need to Succeed (Minimum Requirements):
· US citizenship with active Top-Secret clearance
· 4 + years of experience. In absence of years of experience, certifications or past work may be used to show the level of experience needed to perform at this level.
· Bachelor’s degree in computer science, Information Technology, or a related field, or additional 3 years of experience.
· Strong proficiency in TSQL query writing, query tuning, and performance optimization
· Strong understanding of database architecture and design.
· Knowledge of database security and access controls.
· Advanced knowledge of TSQL and database query languages.
· Expertise in troubleshooting, performance tuning, and query optimization.
· Excellent communication, problem-solving, and organizational skills.
· Ability to work independently and as part of a team.
· Experience monitoring, performing updates, upgrades, testing, and other associated preventative maintenance and support functions related to Database Platforms
Ideally, You Also Have (Preferred Qualifications):
· Prior federal government experience supporting scientific organizations or law enforcement communities
· Experience in assessment, evaluation, and migration of on-premises databases to a cloud environment
· Experience in assessment, evaluation, and documentation of client environment, infrastructure, process, operations
· Experience with Data Warehousing and Analytic capabilities and solutions
Ask Duey about this jobDuey AI may make mistakes. Please double-check key information.