POSITION SUMMARY

The BI and Data Specialist is responsible for transforming data into actionable insights that drive strategic business decisions. This role designs, develops, and maintains business intelligence solutions, reports, and dashboards while ensuring data accuracy, accessibility, and security. The specialist collaborates with stakeholders across the organization to understand reporting needs and deliver data-driven solutions that support operational excellence and business growth.

KEY RESPONSIBILITIES

Business Intelligence Development

• Design, develop, and maintain interactive dashboards and reports using BI tools (Power BI, Tableau, etc.)
• Create data visualizations that effectively communicate complex information to various audiences
• Build and optimize SQL queries for data extraction and analysis
• Develop automated reporting solutions to streamline business processes
• Implement self-service BI capabilities for end users
• Maintain and enhance existing BI infrastructure and reporting library

Data Analysis & Insights

• Analyze business data to identify trends, patterns, and opportunities
• Conduct ad-hoc analysis to support strategic initiatives and decision-making
• Perform root cause analysis on business performance issues
• Develop key performance indicators (KPIs) and metrics aligned with business objectives
• Provide data-driven recommendations to improve business outcomes
• Create executive-level presentations and analytical reports

Data Management

• Design and implement data models, schemas, and warehouse structures
• Ensure data quality, accuracy, and consistency across systems
• Develop and maintain ETL (Extract, Transform, Load) processes
• Create and document data dictionaries and metadata
• Implement data governance standards and best practices
• Monitor data integrity and resolve data quality issues

Stakeholder Collaboration

• Partner with business leaders to understand reporting and analytics requirements
• Translate business needs into technical specifications and BI solutions
• Conduct requirements gathering sessions with department stakeholders
• Provide training and support to end users on BI tools and reports
• Present findings and insights to leadership and cross-functional teams
• Serve as a trusted advisor on data and analytics matters

System Integration & Optimization

• Integrate data from multiple sources including ERP, CRM, and operational systems
• Connect and consolidate data from Paylocity, accounting systems, and other platforms
• Optimize database queries and report performance
• Implement data security and access controls
• Maintain connections to cloud and on-premises data sources
• Support system upgrades and migrations

Technical Documentation

• Document BI solutions, data models, and technical processes
• Create user guides and training materials for BI tools
• Maintain inventory of reports, dashboards, and data assets
• Document data lineage and transformation logic
• Develop and maintain BI standards and procedures

REQUIRED QUALIFICATIONS

Education

• Bachelor's degree in Business Analytics, Data Science, Computer Science, Information Systems, Management Information Systems, or related field
• Master's degree or relevant certifications preferred

Experience

• 3-5 years of experience in business intelligence, data analysis, or related field
• Proven experience developing dashboards and reports in Power BI, Tableau, or similar BI platforms
• Strong background in SQL and database management
• Experience with data warehousing concepts and practices
• Track record of delivering BI solutions that drive business value

Technical Skills

• Expert proficiency in BI tools (Power BI, Tableau, QlikView, or similar)
• Advanced SQL skills for complex queries and database management
• Experience with data modeling and dimensional design
• Proficiency in ETL tools and processes (SSIS, Azure Data Factory, Informatica, etc.)
• Strong Excel skills including pivot tables, formulas, and data analysis features
• Knowledge of database systems (SQL Server, Oracle, MySQL, etc.)
• Familiarity with data visualization best practices
• Experience with programming languages (Python, R, DAX, M) a plus

Core Competencies

• Strong analytical and critical thinking abilities
• Excellent problem-solving and troubleshooting skills
• Outstanding attention to detail and data accuracy
• Effective communication skills with technical and non-technical audiences
• Ability to translate complex data into clear, actionable insights
• Project management and organizational capabilities
• Collaborative mindset with customer service orientation
• Self-motivated with ability to work independently
• Adaptability and continuous learning mindset

PREFERRED QUALIFICATIONS

• Experience in technology distribution, manufacturing, or telecommunications industry
• Knowledge of business processes (sales, finance, operations, supply chain, HR)
• Experience with cloud data platforms (Azure, AWS, Google Cloud)
• Familiarity with Paylocity or other HRIS/HCM systems
• Experience with ERP systems and data integration
• Certifications in Power BI, Tableau, or other BI platforms
• Knowledge of statistical analysis and predictive modeling
• Experience with agile development methodologies
• Understanding of data governance and compliance requirements (GDPR, CCPA)
• Background in financial analysis or sales analytics

KEY PERFORMANCE INDICATORS

• Quality and accuracy of reports and dashboards
• User adoption and satisfaction with BI solutions
• Timeliness of report delivery and analysis
• Impact of insights on business decisions and outcomes
• Data quality and integrity metrics
• System performance and optimization improvements

PHYSICAL REQUIREMENTS

• Primarily sedentary office work with extensive computer use
• Ability to use standard office equipment and technology
• May require occasional meetings and collaborative sessions
• Minimal travel required (less than 10%)
• Flexible work hours to support business needs and system maintenance

Work Environment

• Professional office setting
• Hybrid or remote work options may be available
• Collaborative environment with cross-functional teams
• Fast-paced, data-driven culture

EQUAL OPPORTUNITY EMPLOYER

Rand Technology, LLC is an equal opportunity employer and values diversity in the workplace. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.