Rand Technology ยท 1 day ago
BI and Data Developer
Irvine,CA,US
Full-time
Hybrid
Mid Level
3+ years expRand Technology is a company focused on delivering innovative technology solutions, and they are seeking a BI and Data Developer to transform data into actionable insights. This role involves designing, developing, and maintaining business intelligence solutions, collaborating with stakeholders to understand reporting needs, and ensuring data accuracy and security.
ElectronicsInformation TechnologyManufacturingSemiconductor
Responsibilities
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
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
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
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
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
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
Qualification
Required
Bachelor's degree in Business Analytics, Data Science, Computer Science, Information Systems, Management Information Systems, or related field
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
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
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
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
Company
Rand Technology
Rand Technology is a leading independent distributor of semiconductors and electronic components to the technology manufacturing industry.
201-500 employees
H1B Sponsorship
Rand Technology has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (6)
2024 (6)
2023 (12)
2022 (4)
2021 (1)
2020 (2)
Funding
Current Stage
Growth StageLeadership Team
Andrea Klein
Founder and CEO
Recent News
Company data provided by crunchbase