Data Analyst (Snowflake & PowerBI) - (USC/GC Only) Job at Infosoft, Inc., Irvine, CA

Z04yazZ0QUExUzN1a0lxdjdmY2R3cDlXVHc9PQ==
  • Infosoft, Inc.
  • Irvine, CA

Job Description

Job Title: Data Analyst (Snowflake & PowerBI) - (USC/GC Only)

Pay Rate: $56.00 to $69.67/HR

Duration: 12 months

Location: Irvine, CA (Onsite)

We are looking for a Senior Data Analyst to coordinate changes to computer databases, test, and implement the database, applying knowledge of database management systems, and visualize in Power BI the data as per team requirements.

Database Expertise :

  • Work with the PPM tool to support and identify tables for reporting. The analyst will update ingestion to include new tables, update the semantic model , and update reports as requested by stakeholders.
  • Design, develop, deploy, and manage ongoing improvement of the data warehouse , portals, and dashboards by partnering with stakeholders. Manage the complete data pipeline, from the data mart all the way through to end-user BI tools (e.g., data intake, validation, mining, modeling , visualization , and reporting )
  • Work with senior management, technical, and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage, and analysis strategies
  • Write and code logical and physical database descriptions and specify identifiers of the database to the management system, or direct others in coding descriptions
  • Design, implement, automate, and maintain large-scale enterprise data ETL processes
  • Modify existing databases and database management systems, and/or direct programmers and analysts to make changes
  • Test programs or databases, correct errors, and make necessary modifications

Analytical Expertise :

  • Identify, evaluate, cleanse, organize, and assess the value of disparate data sources. Identify data sources available and collect primary data where necessary.
  • Partner with the team to develop new analyses; collaborate with stakeholders through fact-based analyses, drive change, and develop solutions. Continually improve user experience for Business Intelligence reports and dashboards
  • Perform ad hoc analysis as assigned and actively identify new opportunities for value-added analytics.

Required Skills:

  • Dataflow Gen2/Snowflake
  • Star Schema Modeling
  • Power BI knowledge, including
  • RLS
  • Semantic modeling
  • Data retrieval from the PPM tool database using the ODt connector for full and incremental loads

Requirements :

  • A bachelor's degree in a technical field such as computer science, computer engineering, or a related field is required
  • 5-7 years of applicable experience required
  • Experience with database technologies
  • Knowledge of the ETL process
  • Knowledge of at least one scripting language
  • Strong written and oral communication skills
  • Strong troubleshooting and problem-solving skills
  • Demonstrated history of success
  • Desire to be working with data and helping businesses make better data-driven decisions

Job Tags

Similar Jobs

Weigel Broadcasting Co.

Sports Producer/ Multi-Media Journalist Job at Weigel Broadcasting Co.

 ...MyNet, Telemundo and Univision network affiliates, offering a mix of entertainment programing, local news and professional and college sports broadcasts. Weigel and its affiliate companies broadcast network and independent television stations serving New York, Los Angeles,... 

Havelock Wool

Customer Service Associate Job at Havelock Wool

 ...practices, and environmental benefits. Maintain accurate customer records using CRM and order management systems (e.g., Shopify, HubSpot). Identify recurring customer pain points and provide feedback to improve systems, products, and processes. Support internal... 

Primrose Schools

School Director Job at Primrose Schools

 ...POSITION SUMMARY The School Director at Primrose School is primarily responsible for driving enrollments and managing the overall operations of the school. As the School Director, your dedication to the success of our next generation will ensure we deliver on our mission... 

Snelling of Northern Colorado

Medical Credentialing Specialist Job at Snelling of Northern Colorado

 ...operations role! Bring your expertise to a mission-driven team where accuracy, service, and professionalism are everything. Medical Credentialing Specialist ~$28/hour ~ Fort Collins, CO (Hybrid 3 days in office)~ Temp-To-Hire Why consider this Medical... 

Hot Springs Health Program, Inc.

Home Health RN Case Manager Job at Hot Springs Health Program, Inc.

 ...The home health/hospice RN will case manage and provide skilled nursing services for patient visits. This will include coordination of home care services to patients, supervision of CNAs and PRN nurses in the home, and coordination of care between home care disciplines...