Business Intelligence Developer

Description

Location: Rockville, MD  (Required to be onsite Tuesdays, Wednesdays, and Thursdays and as needed/requested)

Company Description:

ASG is a Minority- and Woman-Owned, Physician-Owned small business with over 15 years of experience in federal government contracting. We deliver a wide range of technology services, including software development, mobile apps, AI/ML, analytics, data science, big data, DevSecOps, digital transformation, cloud, and cybersecurity. ASG is CMMI Level 3 certified and holds ISO 9001:2015, 20000-1:2018, and 27001:2022 certifications.

Job Description:

The National Institute of Mental Health (NIMH) leads the nation’s efforts to advance mental health through research, training, and public education focused on the prevention, diagnosis, and treatment of mental illness. NIMH conducts and supports scientific research across biological, behavioral, clinical, and social domains, and disseminates findings to improve mental health outcomes and services.

Business Intelligence Developers design, develop, and maintain data analysis and reporting solutions for NIMH, translating business requirements into dashboards, reports, and visual presentations. This role involves analyzing data from multiple sources, creating ETL processes, developing dashboards for target audiences, and providing technical recommendations. Strong skills in BI platforms (especially Power BI), relational and dimensional databases, stored procedures, and clear communication are essential, along with the ability to produce technical documentation and implement best practices.

What You Will Do: 

• Designs and develops NIMH-wide data analysis and reporting solutions. 
• Reviews and analyzes data from multiple internal and external sources. 
• Develops and maintains complex ETL processes using Pentaho ETL. 
• Designs and creates multiple dashboards that display selected data for specific audiences. 
• Researches and evaluates technical solutions and provides recommendations for given requirements. 
• Creates and maintains technical documentation. 
• Assists with the establishment and creation of standard processes and procedures for Business Intelligence industry best practices. 
• Translates business and/or functional requirements into dashboards, reports, or visual presentations. 
• Act as Technical Lead on projects and assist with project artifacts. 
• Other duties as assigned. 

Requirements

What We Need:

• Bachelor’s degree from an accredited college or university.
• Minimum of 6+ years of relevant, applicable professional experience. 
• Senior Developer with expertise in designing and developing business intelligence capabilities across a variety of disciplines. 
• Clear and concise communication skills, both written and verbal. 
• Experience in presenting analysis results in Microsoft PowerPoint presentations to meeting participants and upper management. 
• Demonstrated experience with PowerBI and ServiceNow Reporting. 
• Experience with ETL.
• Experience with stored procedure writing. 
• Experience with relational databases. 
• Experience with dimensional databases. 
• Experience with GitHub. 
• Exceptional analytical skills. 
• Exceptional critical thinking skills. 

Clearance Requirement:

• Ability to obtain Public Trust

Even Better:

• Experience supporting NIH/NIMH programs. 
• Experience with Python is a plus. 
• Experience in Qlik Sense, Erwin, Pentaho, and Toad is a plus. ? 
• Experience with Business Analysis is a plus. 
• Power BI Certification: Microsoft Certified Data Analyst Associate 

Additional Information:

At ASG, we value diversity and always treat all employees and job applicants based on merit, qualifications, competence, and talent. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or status as a protected veteran.

Applicants in need of special assistance or accommodation during the interview process or in accessing our website may contact us by sending an email to careers@a2-g.com. We will treat your request as confidentially as possible. In your email, please include your name and preferred method of contact, and we will respond as soon as possible.

Perks:

At ASG, we want you to be well and thrive. Our benefits package includes:

• Healthcare Benefits
• Life
• Disability
• Paid Time Off
• 401k Matching
• Employee Referral Bonus
• Education Assistance
• Learning and Development resources
• EOE, including Disability/Veterans