About the job
SummaryBy Outscal
ConcertAI seeks a Technical Architect with 8+ years of experience in data warehousing, BI, and AWS/Azure. Must have expertise in DWH/ETL solutions, data modeling, SQL, Python, and PySpark. Experience with Healthcare data and HIPAA is a plus.
About the job
Job Requirements
Company Overview
ConcertAI’s mission is to accelerate insights, advance research, and improve patient outcomes in oncology and across life sciences. ConcertAI’s leading real-world evidence, AI technology and software-as-a-service solutions support healthcare decision-making across clinical research & development through commercialization. Top biopharma sponsors, clinical research organizations, healthcare providers and institutions rely on ConcertAI’s evidence-generation and digital transformation capabilities to advance precision medicine and medical innovation.
ConcertAI has emerged as one of the fastest growing AI health tech companies backed by industry-leading private equity companies: SymphonyAI Group, Declaration Partners, Maverick Ventures, and Alliance Bernstein PCI.
Role Summary
Technical Architect with a strong background in Data Warehousing, Business Intelligence, and expertise in AWS & Azure cloud platforms. He will be responsible for developing our next-generation products with robust & scalable system-designs and architectures. Will play a critical role in shaping the data strategy, architecture, and technology roadmap to support the organization's data-driven product lines. The ideal candidate will serve as the technical point person for these solutions, working closely with customers, product managers, data scientists, and development teams, applying innovative methods.
Responsibilities
- Architecture & Design: Lead the design and development of scalable, high-performance data warehousing and BI solutions on AWS/Azure, encompassing data modeling, data integration, and ETL processes.
- Define and implement BI reporting standards and visualization best practices to deliver intuitive and impactful dashboards and reports to end-users.
- Create end-to-end BI architectures that encompass data modeling, data warehousing, data marts, and reporting layers, ensuring scalability and performance.
- Demonstrated proficiency in architecting solutions on AWS/Azure, utilizing services such as Amazon Redshift, AWS Glue, AWS Data Pipeline, S3, Lambda, ADF, ADLS, AAS and others to build efficient and cost-effective data architectures.
- Optimize data processing and query performance for large-scale data sets, identifying and resolving bottlenecks and ensuring high availability of the data warehousing infrastructure.
- Collaborate with business stakeholders and data analysts to understand business requirements and drive the data strategy, ensuring that the data architecture aligns with the overall business goals.
- Provide technical leadership, mentorship, and guidance to data engineering and BI teams, fostering a culture of innovation and excellence.
- Evaluate and select appropriate tech stack and make recommendations for integration methods & business impact. Hands-on PoC.
- Innovation and Best Practices: Stay abreast of the latest advancements in data warehousing, BI, and cloud technologies across AWS and Azure, and apply this knowledge to drive continuous improvement (GenAI).
- Manage multiple projects simultaneously, ensuring successful project delivery within defined timeline & budget.
- Effectively communicate complex technical concepts to non-technical stakeholders, including senior management, to gain support for data-driven initiatives.
- Optimize cloud resource usage and cost efficiency across both AWS and Azure environments while maintaining high performance and availability.
Requirements
Work Experience
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Minimum of 8 years of hands-on experience with data/ system integration/ analytics/ software life cycle as a Technical Architect in a product development environment.
- Proven Experience in conceiving/designing/ architecting/developing data & BI platforms using multi-cloud solutions (AWS and Azure).
- Proficient in designing large-scale DWH/ ETL solutions and In-depth knowledge of data models/ structures.
- Familiarity with data visualization techniques and best practices for effective data communication.
- Strong SQL and Python, PySpark programming skills for data engineering.
- Strong GitHub skills.
- Documentation of critical artifacts such as Logical/Conceptual design, Source to Target mapping, System architecture etc.
- Problem-solving aptitude, with a willingness to work in a fast-paced product development environment and hands-on mentality to deliver innovative data solutions.
- Experience with working with an on-shore/off-shore model, with strong project management experience.
- Excellent communication and presentation skills to interact with stakeholders at all levels.
- Understanding data standardization practices in pharma domain, integrating Healthcare data, and security related to HIPAA is a plus.
- Experience with .Net preferred.
- Experience with data and system integration using RESTful APIs, web services, JSON and XML will be a plus.
- Experience with Master Data Management will be a plus.