Senior SQL/Power BI Report Developer

Aver, Llc; Washington, Northern (District of Columbia, KY); Hybrid; USD 110,000 - 150,000; Full time

Job summary

AVER, LLC in Washington DC seeks a Senior SQL/Power BI Report Developer to lead BI reporting, data visualization, and analytics. Work focuses on data management, dashboards, and performance tuning within a government-facing BI environment.

You will design and deliver robust reports, dashboards, and data models, collaborating with data teams to ensure data quality and timely insights for decision-makers. Hybrid work in DC with security clearance requirements.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• 8+ years of technical and data analysis experience.
• Experience designing, optimizing, and performance tuning SQL and PL/SQL and dashboards in Power BI.
• Ability to present BI solutions with clear visuals to management.

Responsibilities

• Interpret ambiguous requests and drive progress with minimal guidance.
• Develop 2-4 reports weekly with validated data.
• Work with SSRS or Report Builder with parameters, security, and cascading parameters.
• Communicate updates and roadblocks clearly to the team.
• Enhance data retrieval speed and analytics in dashboards.
• Provide BI administration, data integration, security, and data quality oversight.
• Maintain BI platform administration and environment management.

Skills

SQL Development

Power BI Admin

BI Dashboards

Data Visualization

ETL

Education

Bachelor's degree in Computer Science or Information Systems

Tools

SSRS

Report Builder

SQL

PL/SQL

Data Modeling

Data Warehousing

Job description

AVER is a fast-growing SDVOSB that has achieved significant revenue growth over the past 5 plus years with much of our work focused on Data Analytics, Mission Support, IT Modernization and Biometrics. AVER is seeking a Senior SQL/Power BI Report Developerwith in-depth knowledge and experience across business intelligence data insight, reporting support, dashboard functionality, high level analytics and overall administration of the platform. This role is technically focused on data management and BI efforts encompassing administration, data conversion, data-marts and data consumption. Clients are looking for looking for advances in data retrieval speed, innovative data analytics and new concepts of data visualizations within dashboards to open up new opportunities for data management. Be part of a collaborative leadership team who values AVER’s mission, focus, and culture to deliver exceptional client service with great people and transformative technology solutions to enable Government mission success.

Responsibilities Include:

• Interpret more ambiguous requests and make effective decisions and progress forward
• Takes initiative in situations without very structured guidance or direction
• Work with SSRS or Report Builder with parameters, row level security, cascading parameters, differences between tables and lists, & SQL data modeling
• Develop 2-4 reports a week fully completed with data validated
• Communicate clear updates/roadblocks/issue
• Comfortable with SQL and improving experience
• Develop requirements from a project's inception to its conclusion for a particular IT subject matter area (i.e., simple to complex systems)
• Assist other project members with analysis and evaluation and with the preparation of recommendations for system improvements, optimization, development, and/or maintenance efforts in the following specialties: information systems architecture; networking; telecommunications; automation; communications protocols; risk management/electronic analysis; software life-cycle management; software development methodologies; modeling and simulation; disaster recovery; and requirements management
• Provide analytics that enables optimal decision making and business knowledge to the organization’s user community
• Provide technical oversight in delivering BI best practices, data integration, security and data quality
• Provide administration and management of the BI platform from infrastructure implementation to daily BI administration of the environment
• Operation and maintenance of BI reports and dashboards with various level of complexity
• Provide knowledge of BI capabilities and trends to identify opportunities to insert BI solutions
• Overall administration, configuration, security, and maintenance
• Provide strategies for alternate drill-down capabilities, partitioning and custom views
• Develop data models when appropriate using the appropriate modeling tools

Education Requirements:

• Bachelor’s degree in Computer Science, Information Systems, or equivalent/related field

Experience Requirements:

• 8+ years of technical and data analysis experience
• Experience with designing, optimizing, and performance tuning SQL and PL/SQL (preferred) as well as understanding the ETL process to develop, design, create, troubleshoot, and maintain informative reports, visualizations and dashboards in Power BI
• Advanced hands-on dashboard and report creation, over 5+ BI resources in the course of a 5-year period
• Knowledge of data management, Power BI administration, data conversion, data-marts, data consumption
• Experience with data analysis, predictive analytics, and modeling with intelligent dashboards
• Must have skills to present BI solutions with easy-to-understand visualizations and be able to communicate complicated data analytic concepts to various levels of management
• Ability to work with the data integration team to ensure key data metrics are accurate, complete and reliable to support various BI solutions
• Experience supporting data marts
• Development of advanced BI dashboards utilizing the established BI tools
• Development of data visualizations and information graphics utilizing established data visualization tools

Desired Requirements:

• Provide BI administration, security, system utilization and performance tuning, issue troubleshooting, system utilization and performance monitoring, plan and test for system patches and upgrades
• Report and Dashboard migration throughout all environments

Location:

• Washington, DC
• HYBRID, 2 days a week in office

Security Requirements:

• Ability to obtain and maintain government clearance (Public Trust)
• This role supports a government agency which requires U.S. citizenship

About Us:

AVER, LLC is a Data & Digital Transformation company that delivers exceptional client service with great people and transformative technology solutions to enable Government mission success. We provide customers with specialized technical skills and deep subject matter expertise focused on Homeland Security, Biometrics, Law Enforcement and Healthcare domains to meet the complex mission challenges today and tomorrow. We are a verified Service-Disabled Veteran-Owned Small Business (SDVOSB) that strives to provide a customer-centric experience building trusted partnerships with our clients and people.

AVER is an Equal Opportunity Employer/Veterans/Disabled