Business Intelligence Specialist Senior (SOCOM)

Paylocity; Northern (KY); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Paylocity is seeking a skilled BI professional to develop enterprise BI service offerings and value propositions. You will collaborate with end users to identify data management needs and deliver real-time dashboards and insights.

Responsibilities include maintaining data warehouses, ensuring data quality, and enabling ad-hoc analysis with tools like Power BI, SSRS, Cognos, and Qlik, while mentoring users and supporting BI adoption.

Qualifications

• Active Top Secret clearance with SCI eligibility.
• Master’s degree in computer science or related area (can substitute for 12 years of experience and BS degree).
• Expert using common BI tools including Power BI, SSRS, IBM Cognos, Qlik.
• Prefer experience in R/Python, Jupyter Lab, Git, Visual Studio.
• Understanding of Knowledge, Information and Data Management.
• Must have high-level written and verbal communication skills.

Responsibilities

• Develop new enterprise BI service offerings, content creation, and value propositions.
• Collaborate with end users to identify needs for improved data management and delivery.
• Maintain an operational data store and enterprise data warehouse using BI best practices.

Skills

Power BI

SQL

Data modeling

BI requirements gathering

Communication

Education

Master’s degree in computer science or related area

BS degree in related field

Tools

SQL Server Reporting Services

IBM Cognos

Qlik

Tableau

Sisense

SAP Crystal Reports

Jupyter Lab

Git

Visual Studio

Job description

Description

• Develop new enterprise business intelligence (BI) service offerings, content creation, and value propositions to support and improve Government business processes.
• Collaborate with end users to identify needs and opportunities for improved data management and delivery.
• Provide ongoing development and maintenance of an operational data store and enterprise data warehouse using BI best practices, relational structures, dimensional data modeling, structured query language skills, data warehouse and reporting techniques.
• Improve data quality to improve data accuracy, viability and value.
• Support ongoing development and maintenance of a BI architecture that enables fact-based decision making and ad-hoc analysis and insight generation.
• Provide interactive real-time dashboards and key performance indicators using Microsoft Power BI, SQL Server Reporting Services, IBM Cognos, Qlik, or newly identified BI tools
• Provide end-user support and encourage user adoption. Act as Tier 1 support for end-users of BI tools. Train end-users on basic functionality. Direct users to training material and available resources.
• Under general direction, responsible for converting business requirements and high-level data collection needs into well-specified analyses, reporting and visualizations.
• Gathers BI requirements, design solutions and works with developers on their delivery.
• Utilizes selected platforms – including SQL Server, Microsoft Dynamics CRM, Power BI, along with SSRS, to successfully deploy business intelligence solutions to satisfy information requirements.

Requirements

Required:

• Must have an active Top Secret security clearance (Must be clearable to SCI)
• Master’s degree in computer science or related area (can substitute for 12 years of experience and BS degree).
• Expert using common BI tools including Microsoft Apps especially Power BI, SQL Server Reporting Services, IBM Cognos, Qlik.
• Prefer experience in R/Python, Standard Data Packages, Jupyter Lab, Git, Visual Studio
• Understanding of Knowledge, Information and Data Management.
• Must have high-level written and verbal communication skills

Preferred but not Required:

• Experience with tools such as Tableau, Sisense, and SAP Crystal Reports