Rose International · 20 hours ago
Senior Data Analyst
Oakland, CA
Full-time
Hybrid
Mid, Senior Level
$46/hr - $51/hr
3+ years expRose International is a company in the utility industry, seeking a Senior Data Analyst to support Smart Meter Programs. The role involves extracting data, developing insights, and responding to ad hoc data requests while collaborating with various professionals to deliver business solutions and optimize processes.
Human ResourcesInformation TechnologyOutsourcingProject ManagementStaffing Agency
Responsibilities
Manage, monitor, and optimize ETL processes, primarily using SQL Server Integration Services (SSIS)
Create complex automated data routines and processes for reporting and data delivery ensuring accurate data manipulation and data cleansing
Anticipate client concerns and questions, and provide proactive, timely and professional client-focused communications
Provide timely and professional responses to client inquiries or escalate as appropriate
Analysis of current processes and recommendations for process improvements
Maintain and enhance existing Power BI reports and dashboards for various business units
Review, update, and organize data solution documents for knowledge sharing and compliance
Collaborate with stakeholders to understand requirements, translate them into technical solutions, and communicate results effectively
Assist in database administration, performance tuning, and troubleshooting complex SQL queries
Support data integrity, data quality, and data governance initiatives
Qualification
Required
At least 3 years' hands-on experience with relational databases (SQL Server preferred)
Advanced proficiency in T-SQL, including complex queries
High School Diploma or equivalent
Hands-on experience with SQL Server such as creating SSIS packages
Ability to do root cause analysis
Cross-functional translation skills – The ability to explain a technical failure to a non-technical stakeholder
Experience with data cleaning
Experience with PowerBI
Experience with PowerAutomate
Experience with Power App
Experience with Python
Preferred
Bachelor's Degree in Computer Science/Information Systems, Business, Engineering or other related field or equivalent work experience
Company
Rose International
Rose International is provider of Workforce Solutions and Information Technology Solutions .
5001-10000 employees
H1B Sponsorship
Rose International 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
2024 (3)
2023 (2)
2022 (2)
2021 (5)
2020 (9)
Funding
Current Stage
Late StageLeadership Team
Eric Token
Chief Revenue Officer (CRO)
Sue Bhatia
Founder and Chairwoman
Recent News
Company data provided by crunchbase