? Analyzes business requirements and translates them into data models with the EDW framework.? Develops and deploy reports, dashboards, and ad-hoc queries using Microsoft Power BI and other similar tools.? Designs intuitive and interactive visualizations to present complex data in a clear and actionable manner.? Participates in the development of ETL processes. Ensures data integrity and accuracy through validation and data cleansing processes.? Develops and maintains data models, data governanc... more details
Analyst 1, EDW
Job LocationsUS-CA-Irvine
Job ID
2024-8393
Overview
Under general direction, plays a critical role in the organization's data management and reporting initiatives. Responsible for designing, developing and maintaining data models within the EDW as well as creating insightful reports and dashboards to support data-driven decision-making across the organization. Ensures the accuracy and completeness of data in the data warehouse, providing technical guidance and support to other super users within the business units.
Pay starts at $31.73/hr
Responsibilities
? Analyzes business requirements and translates them into data models with the EDW framework. ? Develops and deploy reports, dashboards, and ad-hoc queries using Microsoft Power BI and other similar tools. ? Designs intuitive and interactive visualizations to present complex data in a clear and actionable manner. ? Participates in the development of ETL processes. Ensures data integrity and accuracy through validation and data cleansing processes. ? Develops and maintains data models, data governance policies and procedures. ? Participates in the development of data governance and enforcement of those policies and best practices. ? Collaborates with business stakeholders to understand their reporting requirements. Collaborate with IT teams to align data solutions with business objectives. ? Performs other duties as assigned.
Qualifications
EDUCATION: ? Bachelor's degree in Business Administration, Information Systems or related field
EXPERIENCE: ? 2+ years of experience in data warehousing and business intelligence report writing ? Experience in a healthcare environment or non-profit preferred. ? Experience with Microsoft Power BI. ? Microsoft Azure experience desirable. ? Demonstrated experience in requirements gathering methodologies.
KNOWLEDGE, SKILLS, ABILITIES: ? Experience with report development using Microsoft Power BI ? Experience with ETL tools and process ? Experience sourcing, modeling and analyzing both structured and unstructured data using tools like SQL and other industry data modeling tools. ? Understanding of data warehousing and business intelligence, with experience in designing, developing, and maintaining enterprise data warehouses. ? Strong communication skills. ? Understanding of data governance policies and procedures. ? Demonstrated proficiency in Microsoft Office Applications. ? Able to interpret and implement policies, procedures, and regulations. ? Able to consistently demonstrate good judgment and decision-making skills. ? Ability to maintain customer service orientation and professionalism in all interactions. ? Ability to exercise discretion, demonstrate good judgement, and maintain a high level of confidentiality to handle sensitive and confidential situations and documentation. ? Ability to travel locally; maintain driving record in compliance with Transportation Safety Standards; maintain auto insurance and vehicle registration.
PHYSICAL REQUIREMENTS IN ACCORDANCE WITH ADA: ? Carrying/Lifting: Occasional / 0-30 lbs. ? Standing: Occasional / Up to 3 hours per day ? Sitting: Constant / Up to 8 hours per day ? Walking: Frequent / Up to 5 hours per day ? Travel:Locally ? Repetitive Motion/Activity:Keyboard activity, telephone use, writing ? Visual Acuity: Ability to view computer monitor and read newsprint ? Environmental Exposure: None
Job Abstracts is an independent Job Search Engine. Job Abstracts is not an agent or representative and is not endorsed, sponsored or affiliated with any employer. Job Abstracts uses proprietary technology to keep the availability and accuracy of its job listings and their details. All trademarks, service marks, logos, domain names, and job descriptions are the property of their respective holder. Job Abstracts does not have its members apply for a job on the jobabstracts.com website. Additionally, Job Abstracts may provide a list of third-party job listings that may not be affiliated with any employer. Please make sure you understand and agree to the website's Terms & Conditions and Privacy Policies you are applying on as they may differ from ours and are not in our control.
We would like to take a second to Welcome You to Job Abstracts, the nation’s largest Pure Job Board. With over 3.1 million job listings from 15,000+ Companies & Organizations, we help job searchers find careers that match their interests. As an anonymous user, you have probably discovered how easy our system is to use. However, you have just scratched the surface of what we can offer.
We encourage you to Register so you can use our most powerful features: searching with multiple terms, setting up multiple locations, establishing favorite companies, and accessing your search history. If you find a job you like, you can apply directly for it, and then, keep notes on it. We will also keep a lookout for jobs that match your search terms and email you when we find something you may like.
You can register for free and the system is free to use. If you like our system so far, click on Register and unlock the power required by serious job searchers.
Any time you conduct a search, the system shows you job matches, ranked by their Relevance Score (RS).
The score is calculated by a proprietary algorithm that uses Intelligent Machine Learning.
The Relevance Score tells you how well the job opportunity matches your search term or terms.
When not logged in, the system is limited to one search term. Scores for single term matches are usually lower.
When you register, log in, and set up multiple terms prioritized by importance, the jobs found for you will receive a much higher Relevance Score.