Data Architect
Zelis - Bedminster, NJ
Employment Type : Full-Time
Zelis is a healthcare and financial technology growth company and market-leading provider of claims cost management and payments optimization solutions to price, pay and explain healthcare claims. Zelis delivers integrated network analytics, network solutions, payment integrity, electronic payments and claims communications for payers, healthcare providers and consumers in the medical, dental and workers' compensation markets nationwide. Zelis is backed by Parthenon Capital Partners and Bain Capital.
POSITION OVERVIEW:Assist Business Intelligence Office team in the Architecture and Management of Zelis’ Data Warehouse assets and serve as the primary Data Architect for all related projects and tasks. The Zelis Data Architect will communicate and work collaboratively with internal application developers, database administrators and project stakeholders for project work, supporting existing data needs and contribute to resolution of major incidents. As a Data Architect, you’ll be a key member of a dynamic team of IT professionals responsible for the design and implementation of databases for Business Intelligence and Data Analytics. In this role, you will develop the strategies for Data Warehouse implementations, as well as, the acquisition and manipulation of data by optimizing SQL queries. Additionally, you will provide solutions for accessing data for analytical purposes by researching, assessing, and utilizing a myriad of tools to enable reporting and data analysis functions.
KEY RESPONSIBILITIES:- Create data models and define the structure and attributes of data elements.
- Develop data warehouse schemas and data marts derived from various internal and external data sources that support reporting requirements for business partners.
- Participate in requirements gathering sessions to interpret business needs from conceptual models into logical and physical data models.
- Assist in the creation of data models and data record layouts to facilitate integration and data exchange with external partners, vendors and regulatory agencies’ applications and systems.
- Spearhead the introduction and adoption of new technologies as they apply to data warehousing architecture and methodologies.
- Develop and deploy data warehouse and business intelligence solutions including Tabular Models and cloud-based architecture that include design considerations for reporting and ETL processing.
- Assist team members in reviewing and optimizing SQL queries used in enterprise applications and systems.
- Support database administrators in troubleshooting performance issues and assist in optimizing database performance.
- Work directly with business units to provide analytical support and report creation, with the goal of developing solutions to empower end-users to gain insight into their business.
- Responsible for documenting databases, processes and design configurations.
- Manage essential projects within planned timelines.
- Provide second-tier DevOps support to help resolve database related system outages.
- Follows established HIPAA, Compliance & Security policies
EDUCATION AND PROFESSIONAL EXPERIENCE:- Bachelor’s degree in Computer Science, Information Systems, or another four-year degree with significant IS experience or equivalent experience
- 7+ years of experience delivering Data Warehouse solutions
- 7+ years in Microsoft technology – SQL Server, SSIS, SSAS
- 4+ years in relational and multi-dimensional data modeling
Proficient In:- Logical and Physical Data Modeling
- Data Modeling Tools: Erwin and/or Toad
- Software Development Fundamentals
- Software Design
- SQL Programming
- Relational Database Concepts
- Data Warehouse Concepts
- Dimensional Data Modeling and Notation
- Microsoft SQL Server
- Microsoft SSIS
- Microsoft Tabular Models and SSAS Cubes
- Microsoft Team Foundation Server
- Data Warehouse Technologies: Azure Synapse Analytics and/or Snowflake
- Microsoft Power BI (Preferred)
- Agile development methods (Preferred)
- Jira (Preferred)
INTERPERSONAL AND PROFESSIONAL SKILLS:- Advanced Analytical Skills – Uses sound and logical judgment to identify and analyze complex, multi-dimensional problems and drive test planning and test execution decisions.
- Teamwork/Collaboration – Develops and leverages collaborative relationships to facilitate the accomplishment of work goals. Collaborates at all levels of the organization. Willingness to help others, as needed, to make the team and each deployment successful.
- Communication – Communicates accurately and effectively in both oral and written form. Practices active listening. Expresses thoughts and ideas with confidence and respects opposing views
- Managing Work – Ability to self-direct and multitask in a fast-paced, ever-changing environment. Identifies task importance; adjusts priorities as appropriate. Prepares and manages schedule to ensure goals are met. Takes prompt action to accomplish objectives.
- Technical/Professional Learning – Keeps up with current developments and trends in the field. Demonstrates strong desire to advance in the field and apply newly acquired knowledge in role.
- Living the Vision and Values – Keeps the company’s vision and values at the forefront of decision-making and action.
“We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.”