Please note that this position is
no longer available.
If you would like to be considered for similar opportunities now or in the future, feel free to apply and/or set up a notifier for yourself.
BI/Data Warehouse Architect
CA - Santa Ana
Opportunity Snapshot
Develop business intelligence (BI) solutions that will fight Medicaid fraud at the national level as you enable the recovery of literally billions of dollars back to the Federal government. Your twofold mission will be to design DW architecture on the conceptual, logical, business area, and application levels, and also to work directly with business and technical owners to help define the organization's view of data and BI solutions. Quick question for you - click here
We're cultivating a strong development team, so you'll learn on an ongoing basis from your seasoned peers. In addition, you'll be primed to open new doors of opportunity for your career as HMS is on the fast track to growth, meaning that small companies and state governments simply can't compete with the resources, compensation and career path that we can offer.
Since 1985 HMS has focused exclusively on the healthcare industry; we have partnered with more than 45 Medicaid agencies, other state health programs, and more than 50 government-sponsored healthcare plans to help them recover billions of dollars, and save billions more through cost avoidance. The driving force behind our success is our employees -- knowledgeable, innovative, and results-oriented professionals who provide unparalleled customer service.
The Essentials
Key responsibilities of this role include:
- Leading the development and implementation of data warehouses, data marts, and data stores including the ETL used to populate those databases. Quick question for you - click here
- Leading the development and implementation of normalized and dimensional data models (logical and physical) to support reporting and analytics. Quick question for you - click here
- Participating in the establishment of business performance metrics and measures to support key business objectives.
- Enforcing the change control process for the data architecture artifacts.
- Managing the data quality and metadata environments.
To be a good fit for this opportunity you will need:
- A Bachelor's degree in a related field; we also will consider non-degreed candidates with significant, relevant experience.
- 7 to 10 years of proven experience designing the architecture of Data Warehousing and BI solutions in a multi-terabyte environment.
- Solid understanding of and experience with ETL methodologies, business intelligence, and data warehouse principles, approaches, technologies, and architectures including concepts, designs, and usage of data warehouses, data marts, and operational data stores.
- Expert working knowledge of dimensional and relational modeling.
- Strong data analysis skills.
- Working knowledge of MS-SQL 2008+, MSAS, SSRS, SSIS and MDX.
- A proven track record of delivering high-quality solutions in an agile environment.
- Outstanding communication skills and a proven ability to interact effectively with people at all levels of the organization.
- Excellent problem solving skills and strong attention to detail.
Preferred, but not required:
- Experience designing and implementing data warehouse/BI solutions within the healthcare industry; working knowledge of healthcare business processes and KPIs is highly desirable
- Familiarity with.NET 4.0 and Crystal Reports.
- Strong process modeling experience.
- Experience developing and rolling out meta data management processes.
- Experience developing and rolling out data governance processes.
- SharePoint experience, as well as familiarity with Biz Talk is a plus.
What's in It for You
Broad impact -- this initiative is well defined, but you will quickly execute and "own" the project as you become a leading player, interacting with people and working with data from all areas of the organization. You'll be involved in a variety of projects, including ensuring robust ETL processes to handle data from multiple sources.
Autonomy and support -- while we'll look to you to achieve your goals with minimal supervision, the Development team has a strong sense of collaboration and a do-what-it-takes work ethic. We get our orders from the business owners, but it's up to us to come up with innovative solutions. We believe everyone has the right to voice their opinion and we foster a democratic decision-making process where you'll get to manage upwards and downwards in different situations.
Professional development -- this role isn't limited to one or two areas. Everyone contributes to a variety of challenges. We're software agnostic, choosing the right tool for the job, so we all learn from each other on an ongoing basis. One constant is that the pace is fast.
Work hard, play hard culture -- we're passionate about what we do and work long hours, but at the same time, we have a lot of fun together during and outside of work.
Career advancement -- we're hiring now with an eye on the future, looking for impact players who can grow with us. You will be well positioned to evolve your career along multiple directions, depending on your ambition and aptitude.
Excellent compensation -- in addition to a competitive salary and bonus potential, we offer a comprehensive benefits package that includes a 401(k) plan with generous employer match, flexible spending plans, and much more.
Keys to Success
Your technical expertise will be invaluable, of course, but you also will need a thorough understanding of the nuances of healthcare data and the role DW plays in achieving business goals. You'll showcase a collaborative approach to driving consensus among people who may have conflicting views. We'll also look to you to remain willing to "wear multiple hats" in our lean, agile environment. And finally, you'll take your work seriously, but not yourself as you keep a sense of humor handy and inject levity in stressful situations.
If this sounds like the right mix of challenge and opportunity for you, and you meet the minimum qualifications, we want to hear from you!
Who We Are
HMS Holdings Corp. (HMS) is the leader in coordination of benefits and program integrity services for government healthcare programs. The company's clients include health and human services programs in more than 40 states, over 90 Medicaid managed care plans, the Centers for Medicare and Medicaid Services (CMS), and Veterans Administration facilities. HMS helps ensure that healthcare claims are paid correctly and by the responsible party. As a result of the company's services, government healthcare programs recover over $1 billion annually, and avoid billions of dollars more in erroneous payments.
We take a proactive approach to growing our company, both organically and via mergers and acquisitions, to ensure we provide our clients with a broad offering of best-of-breed cost containment strategies to meet their financial and operational goals.
Opportunity Snapshot
Develop business intelligence (BI) solutions that will fight Medicaid fraud at the national level as you enable the recovery of literally billions of dollars back to the Federal government. Your twofold mission will be to design DW architecture on the conceptual, logical, business area, and application levels, and also to work directly with business and technical owners to help define the organization's view of data and BI solutions. Quick question for you - click here
We're cultivating a strong development team, so you'll learn on an ongoing basis from your seasoned peers. In addition, you'll be primed to open new doors of opportunity for your career as HMS is on the fast track to growth, meaning that small companies and state governments simply can't compete with the resources, compensation and career path that we can offer.
Since 1985 HMS has focused exclusively on the healthcare industry; we have partnered with more than 45 Medicaid agencies, other state health programs, and more than 50 government-sponsored healthcare plans to help them recover billions of dollars, and save billions more through cost avoidance. The driving force behind our success is our employees -- knowledgeable, innovative, and results-oriented professionals who provide unparalleled customer service.
The Essentials
Key responsibilities of this role include:
- Leading the development and implementation of data warehouses, data marts, and data stores including the ETL used to populate those databases. Quick question for you - click here
- Leading the development and implementation of normalized and dimensional data models (logical and physical) to support reporting and analytics. Quick question for you - click here
- Participating in the establishment of business performance metrics and measures to support key business objectives.
- Enforcing the change control process for the data architecture artifacts.
- Managing the data quality and metadata environments.
To be a good fit for this opportunity you will need:
- A Bachelor's degree in a related field; we also will consider non-degreed candidates with significant, relevant experience.
- 7 to 10 years of proven experience designing the architecture of Data Warehousing and BI solutions in a multi-terabyte environment.
- Solid understanding of and experience with ETL methodologies, business intelligence, and data warehouse principles, approaches, technologies, and architectures including concepts, designs, and usage of data warehouses, data marts, and operational data stores.
- Expert working knowledge of dimensional and relational modeling.
- Strong data analysis skills.
- Working knowledge of MS-SQL 2008+, MSAS, SSRS, SSIS and MDX.
- A proven track record of delivering high-quality solutions in an agile environment.
- Outstanding communication skills and a proven ability to interact effectively with people at all levels of the organization.
- Excellent problem solving skills and strong attention to detail.
Preferred, but not required:
- Experience designing and implementing data warehouse/BI solutions within the healthcare industry; working knowledge of healthcare business processes and KPIs is highly desirable
- Familiarity with.NET 4.0 and Crystal Reports.
- Strong process modeling experience.
- Experience developing and rolling out meta data management processes.
- Experience developing and rolling out data governance processes.
- SharePoint experience, as well as familiarity with Biz Talk is a plus.
What's in It for You
Broad impact -- this initiative is well defined, but you will quickly execute and "own" the project as you become a leading player, interacting with people and working with data from all areas of the organization. You'll be involved in a variety of projects, including ensuring robust ETL processes to handle data from multiple sources.
Autonomy and support -- while we'll look to you to achieve your goals with minimal supervision, the Development team has a strong sense of collaboration and a do-what-it-takes work ethic. We get our orders from the business owners, but it's up to us to come up with innovative solutions. We believe everyone has the right to voice their opinion and we foster a democratic decision-making process where you'll get to manage upwards and downwards in different situations.
Professional development -- this role isn't limited to one or two areas. Everyone contributes to a variety of challenges. We're software agnostic, choosing the right tool for the job, so we all learn from each other on an ongoing basis. One constant is that the pace is fast.
Work hard, play hard culture -- we're passionate about what we do and work long hours, but at the same time, we have a lot of fun together during and outside of work.
Career advancement -- we're hiring now with an eye on the future, looking for impact players who can grow with us. You will be well positioned to evolve your career along multiple directions, depending on your ambition and aptitude.
Excellent compensation -- in addition to a competitive salary and bonus potential, we offer a comprehensive benefits package that includes a 401(k) plan with generous employer match, flexible spending plans, and much more.
Keys to Success
Your technical expertise will be invaluable, of course, but you also will need a thorough understanding of the nuances of healthcare data and the role DW plays in achieving business goals. You'll showcase a collaborative approach to driving consensus among people who may have conflicting views. We'll also look to you to remain willing to "wear multiple hats" in our lean, agile environment. And finally, you'll take your work seriously, but not yourself as you keep a sense of humor handy and inject levity in stressful situations.
If this sounds like the right mix of challenge and opportunity for you, and you meet the minimum qualifications, we want to hear from you!
Who We Are
HMS Holdings Corp. (HMS) is the leader in coordination of benefits and program integrity services for government healthcare programs. The company's clients include health and human services programs in more than 40 states, over 90 Medicaid managed care plans, the Centers for Medicare and Medicaid Services (CMS), and Veterans Administration facilities. HMS helps ensure that healthcare claims are paid correctly and by the responsible party. As a result of the company's services, government healthcare programs recover over $1 billion annually, and avoid billions of dollars more in erroneous payments.
We take a proactive approach to growing our company, both organically and via mergers and acquisitions, to ensure we provide our clients with a broad offering of best-of-breed cost containment strategies to meet their financial and operational goals.
