Data Solutions Architect (Roseville CA)

Date: Apr 18, 2024

Location:

Roseville, CA, US, 95747-6645 Any city, CA, US, 99999

Req ID: 24526

Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You’ll have an incredible opportunity to grow your career in a company that values work flexibility, learning, and career development. You’ll add to your technical credentials and certifications while enjoying a generous, flexible vacation policy and educational assistance. We also have comprehensive leadership and technical development academies to help build your skills and capabilities.

Summary

As a Data Solutions Architect (Roseville CA) at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges. Here are the details on this position.

Your role in our mission

Work with Business, Architects and System Analysts to fully understand the business requirements and translate them into Conceptual, Logical and Physical models.
Create and maintain, conceptual, logical and physical data models defining information requirements to meet end user needs.
Partner with development and QA teams to communicate the business rules, data models and ensure test cases target the quality and integrity of the data model.
Partner with DBAs to transform logical data models into physical database designs while optimizing the performance and maintainability of the physical database
Works closely with DBA on the DDLs creation, maintenance and optimization of the database.
Analytical ability and business acumen to collect multiple sources of data and draw conclusions.
Responsible for building solutions involving large data sets using SQL methodologies• Has strong analytical SQL experience working with dimensional modeling.
Deliver projects on-time and to specification with quality.

What we're looking for

7+ years of experience working with datasets with strong understanding on how data should be optimized within transactional , reporting and big data architectures
5+ years of experience in health care industry working with extensive amounts of healthcare data (claim and clinical sides) and major databases
2+ years of experience with Cloud strategy, architecture, migration and implementation using Azure / AWS / Hadoop
Expert knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases
Expert hands on experience on any data modelling tools like Erwin, ER studio.
Ability to apply mastery knowledge in one of the relational data base (DB2, MSSQL, Teradata, Oracle 8i/9i/10g/11i)

What you should expect in this role

Hybrid role 2 days in office, Roseville CA
Occasional evening and weekend work
Video cameras must be used during all interviews, as well as during the initial week of orientation.
This posting is intended for pipelining. We will accept applications on an ongoing basis

Put your passion to work at Gainwell. You’ll have the opportunity to grow your career in a company that values work flexibility, learning, and career development. All salaried, full-time candidates are eligible for our generous, flexible vacation policy, a 401(k) employer match, comprehensive health benefits, and educational assistance. We also have a variety of leadership and technical development academies to help build your skills and capabilities.

We believe nothing is impossible when you bring together people who care deeply about making healthcare work better for everyone. Build your career with Gainwell, an industry leader. You’ll be joining a company where collaboration, innovation, and inclusion fuel our growth. Learn more about Gainwell at our company website and visit our Careers site for all available job role openings.

Gainwell Technologies is committed to a diverse, equitable, and inclusive workplace. We are proud to be an Equal Opportunity Employer, where all qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical condition), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. We celebrate diversity and are dedicated to creating an inclusive environment for all employees.