- Entry level
- No Education
- Salary to negotiate
The Senior Consultant works closely with clients to define and deliver business intelligence and analytics solutions using Microsoft SQL Server, Power BI, and Microsoft Azure technologies. The Senior Consultant provides vision, direction, as well as hands-on technical expertise in designing and building solutions that unlock the value of data for our clients. The Senior Consultant works both independently and as part of a project team on a variety of solutions, such as data warehousing, business intelligence, data visualization, big data analytics, predictive analytics, and others.
Lead the development of data warehousing, reporting, business intelligence and analytics solutions
Apply knowledge of on-premises and cloud-based Microsoft technologies in the areas of database development, data warehousing, business intelligence, data visualization and analytics
Identify and strive to realize desired business outcomes from customer engagements
Manage successful completion of project initiatives on-time and within budget
Transfer knowledge to customers as part of the delivery of services and through classroom instruction
Mentor fellow consultants and interns
As the client's trusted advisor, identify and pursue additional opportunities to provide value
Seek new business opportunities with existing clients or within the general market
Provide pre-sales technical support, conduct demonstrations, and prepare technical aspects of proposals/statements of work
Communicate with clients about project status; handle both routine and complex customer concerns, involving Practice Lead or Project Manager as needed
Bachelor's Degree in computer science, information systems, business, mathematics, engineering or equivalent work experience
3+ years building data warehousing, business intelligence and analytics solutions using Microsoft technologies
3+ years with SQL Server with strong T-SQL development skills
3+ years using SSRS
1+ years using SSAS, with proficiency in MDX and DAX
1+ years using SSIS
Knowledge of dimensional modeling and database optimization techniques
Knowledge of ETL and report development best practices and optimization techniques
Experience with developing data and analytics solutions in Azure, using such technologies as Azure SQL Databases, Azure SQL Data Warehouse, Azure Data Lake, Azure Data Factory, Azure Stream Analytics, Azure HDInsight, Azure Machine Learning and others
Knowledge of SharePoint and related BI technologies (Excel Services, Power Query, Power View, SSRS)
Knowledge of C# or VB.NET
Work experience in a consultant capacity
Knowledge of Agile/SCRUM SDLC Methodologies
Certification: MCITP in Database Development or BI, MCSE for BI
What's the first thing that happens when one of the most successful physician groups in Orange County comes together with a global leader in health care? Opportunity. With Monarch HealthCare joining OptumCare and the UnitedHealth Group family of companies, people like you will find increasing levels of challenge, impact and professional success. With a vibrant network of hospitals and urgent care centers, we're changing health care for the better by improving access to affordable, high quality care, and working together to improve the patient experience. That takes passion, commitment, intense focus and the ability to contribute effectively in a highly collaborative team environment. Are you with us? Learn more about this exciting opportunity to do your life's best work.(sm)
Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.
UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.
Job Keywords: Senior IT Business Intelligence and Analyst, Irvine, CA, California, SQL, Analyst, Data Warehousing, T-SQL, SSRS, SSIS, SSAS, MDX, DAX
Senior IT Business Intelligence and Analyst - Irvine, CA
About the company
Our mission is to help people live healthier lives and to help make the health system work better for everyone.
A Fortune 6 company, we're focused on helping people live healthier lives while making the health system work better for everyone. Here, we seek to empower people with the information, guidance and tools to make personal health choices. We work harder and we aim higher. We expect more from ourselves and each other. And, at the end of the day, we’re doing a lot of good for more than 85 million people worldwide.
Our biggest point of differentiation is our people - and the collective talent, energy, intelligence and drive our force of 188,000 individuals around the world bring to our mission every single day. So, how do we do it? With our every action, interaction and intention that demonstrates the five fundamental values that guide everything we do: