What are the responsibilities and job description for the Database Architect position at Y & L Consulting Inc.?
Job Details
We are seeking an experienced Database Architect for a hybrid contract in Austin, TX.
Responsibilities:
Designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. Must be able to design, develop and manipulate database management systems, data warehouses and multidimensional databases. Requires a depth and breadth of database knowledge that shall help with formal design of relational databases and provides insight into strategic data manipulation. Responsible for making sure an organization's strategic goals are optimized through the use of enterprise data standards. This frequently involves creating and maintaining a centralized registry of metadata. Has working knowledge of EIR Accessibility standards and assistive technologies. Ensures that all user interfaces for database administration and inputting, viewing, outputting data(via reports) are compliant with accessibility standards.
The Senior Data Architect & Analytics Lead will play a pivotal role in advancing the data infrastructure and analytics initiatives. This position is designed for a seasoned professional with in-depth expertise in data design and advanced analytics.
Responsibilities include designing and implementing robust data structures to support analytics projects, developing comprehensive database and table designs for optimized data storage and retrieval, and utilizing advanced analytics tools and techniques to extract insights that facilitate decision-making. The successful candidate will collaborate with cross-functional teams to ensure alignment of data strategies with organizational goals and provide thought leadership on data modeling and analytics best practices. The ideal applicant will have proven experience as a Data Architect or similar role, with a strong understanding of data modeling, database design, and data governance principles, alongside familiarity with analytics tools and frameworks. Excellent communication and collaboration skills are essential for effectively working across teams.
Minimum Qualifications:
- 10 years experience in data architecture, data modeling, and data warehousing on-prem and cloud technologies
- 10 years experience with business intelligence and big data solutions
- 10 years of Proven experience in leading and managing advanced analytics projects.
- 10 years experience with cloud platforms such as Azure, AWS, or Google Cloud Platform is required.
- 10 years experience in developing, deploying, and managing applications and data storage on these platforms
- Strong knowledge of data architecture principles and best practices.
- Proficiency in SQL and other database technologies.
- Knowledge of advanced analytics tools and strategies.
- Strong communication skills, with the ability to explain complex technical concepts to a non-technical audience.
- Ability to lead teams and manage complex projects.
- Proficiency in cloud infrastructure management, including understanding of cloud-based data storage options, cloud security considerations, and best practices for deploying applications in the cloud.
- 10 years experience developing and maintaining enterprise data models, data warehouses, and data lakes to support analytics and reporting.
- 10 years experience evaluating and integrating emerging technologies such as AI, machine learning, and big data analytics in healthcare.
- 10 years experience working closely with data engineers, developers, and analysts to ensure seamless data accessibility and usability.
- 10 years experience with ETL tools, data integration platforms, and APIs.
- 10 years experience with EHR integration, APIs, and real-time streaming.
- 10 years experience in architecting and designing ETL pipelines using Informatica tools.
- 10 years experience designing and modeling data for cloud-based data architecture solutions using Snowflake as the primary data platform.
Preferred Qualifications:
- Experience in implementing and deploying big data applications
- Hands-on expertise in Python and/or Java/Scala
- Experience with structured Enterprise Architecture practices, hybrid cloud deployments, and on-premise-to-cloud migration deployments and roadmaps
- Healthcare industry experience preferred
- Fundamental understanding of the Information Management principles, IT processes, SDLC, architecture and technologies adopted by an organization.
- Consulting and Facilitation Skills.
- Customer-focused ability to communicate across all levels of the organization.
- Proactive Leadership style; self-starter and strong attention to detail.
- The Open Group Architecture Framework (TOGAF), Cloud Solution Architecture on Azure, Amazon Web Services (AWS) and/or Google Cloud Platform (Google Cloud Platform) Certification
- Experience with healthcare data standards like FHIR, CCDA, and HL-7
What We Offer:
Sistema offers competitive pay and solid benefits, including medical, dental, and vision coverage. We keep things simple, focus on people, and prioritize long-term relationships with our clients and consultants.
Apply now if you re a clear communicator, problem solver, and ready to work hybrid in Austin, TX!