Ledgent Technology ยท 1 day ago
Business Intelligence Analyst
San Diego, CA
Full-time
Onsite
Mid Level
$100K/yr - $130K/yrLedgent Technology is seeking a Business Intelligence Analyst to join their team. The role involves leveraging technical expertise in Power BI, SQL, and Python to create advanced dashboards and optimize data models for high-performance reporting.
Staffing & Recruiting
No H1B
U.S. Citizen OnlyHiring Manager
Gregory Williams
Responsibilities
Skilled in building advanced dashboards, crafting complex DAX formulas, leveraging Power Query (M language), optimizing data models, and ensuring high-performance reporting
Proficient in writing advanced queries, developing stored procedures, tuning performance, and designing relational databases (Azure SQL, SQL Server, or similar platforms)
Experienced in data manipulation, automation scripting, and API integration using libraries such as pandas, NumPy, and requests
Hands-on experience with Microsoft Fabric, Azure Synapse, or comparable large-scale data solutions
Ability to design and implement automated workflows and system integrations to streamline processes
Advanced capabilities including complex formulas, pivot tables, and integration with Power Query/Power Pivot for data analysis
Strong understanding of RESTful APIs and expertise in connecting and integrating systems programmatically
Familiar with Git/GitHub for managing code versions and enabling collaborative development
Qualification
Required
Must be a US Citizen or Green Card Holder as this is a direct hire
Must sit onsite in San Diego
Power BI: Skilled in building advanced dashboards, crafting complex DAX formulas, leveraging Power Query (M language), optimizing data models, and ensuring high-performance reporting
SQL: Proficient in writing advanced queries, developing stored procedures, tuning performance, and designing relational databases (Azure SQL, SQL Server, or similar platforms)
Python: Experienced in data manipulation, automation scripting, and API integration using libraries such as pandas, NumPy, and requests
Enterprise Data Platforms: Hands-on experience with Microsoft Fabric, Azure Synapse, or comparable large-scale data solutions
Power Automate: Ability to design and implement automated workflows and system integrations to streamline processes
Excel: Advanced capabilities including complex formulas, pivot tables, and integration with Power Query/Power Pivot for data analysis
APIs: Strong understanding of RESTful APIs and expertise in connecting and integrating systems programmatically
Version Control: Familiar with Git/GitHub for managing code versions and enabling collaborative development
Company
Ledgent Technology
Ledgent Technology, a business line of Roth Staffing Companies, utilizes proven processes and their robust professional network to place qualified technology professionals in contract, contract-to-hire, direct-hire roles and project teams throughout the US.
Founded in 1994
501-1000 employees
Funding
Current Stage
Late StageCompany data provided by crunchbase