Ad/Director, Data Warehousing And Reporting

We are seeking a hands-on Director of Data Warehousing and Reporting to join our Data Strategy and Analytics team reporting to the Sr. Director of Data Strategy and Analytics. The successful candidate will be responsible for the maintenance, development, and optimization of our data warehousing infrastructure, as well as maintaining and enhancing the Analytical layer and downstream BI platforms. This individual will play a crucial role in ensuring the integrity, accuracy, accessibility, and reliability of our data assets, while also enabling our teams to extract actionable insights to support informed decision-making across the organization.

This position reports to the Sr. Director of Data Strategy and Analytics.

Position Responsibilities:

Data Warehousing Management:

• Oversee the design, implementation, and maintenance of the organization's data warehouse, ensuring scalability, performance, and reliability.

• Maintain and enhance Madrigals Analytical layer (HCP, HCO, Payor, Patient, and Geo) in support of reporting and BI needs.

• Define and enforce data governance policies and procedures to ensure data integrity, security, and compliance

• Lead efforts to optimize data architecture and infrastructure to support evolving business needs and emerging technologies.

Reporting and BI Development:

• Collaborate with stakeholders and the Director of Analytics to understand reporting requirements and develop a reporting layer to support BI development

• Responsible for building and maintaining BI reports, dashboards, and analytics solutions.

• Ensure that BI tools and technologies are effectively utilized to empower stakeholders to make data-driven decisions.

Cross-Functional Collaboration:

• Work cross-functionally within the Commercial Strategy and Analytics team to foster a Data-driven culture through data literacy and self-service analytics

• Support the Director of analytics in Collaborating with key stakeholders to identify opportunities for leveraging data and systems to help drive strategy and performance monitoring

Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or a related field; advanced degree preferred.

• 8+ years of experience in data warehousing, business intelligence, or related roles, with at least 2 years in a leadership capacity.

• Prior experience in BI development preferred, including designing and implementing BI solutions, developing reports and dashboards, and optimizing BI performance.

• Deep understanding of data warehousing concepts, methodologies, and technologies, including ETL processes, data modeling, and dimensional modeling.

• Proficiency in SQL, data visualization tools (e.g., Tableau, Power BI), and BI platforms (e.g., Snowflake, Redshift, BigQuery).

• Experience with Veeva Nitro a plus

• Strong analytical and problem-solving skills, with the ability to translate complex business requirements into technical solutions.

• Excellent communication and interpersonal skills, with the ability to effectively engage with stakeholders at all levels of the organization.

Madrigal is an Equal Opportunity Employer. All employment is decided on the basis of qualifications, merit, and business need. Applicants will receive consideration for employment without regard to race, ethnicity, color, religion, sex gender identity, sexual orientation, national origin, age, disability, protected veteran or disabled status, or other characteristic protected by applicable federal, state, or local law.

Unsolicited resumes from agencies should not be forwarded to Madrigal. Madrigal will not be responsible for any fees arising from the use of resumes through this source. Madrigal will only pay a fee to agencies if a formal agreement between Madrigal and the agency has been established.

Please be aware that we are currently receiving numerous reports of individuals misrepresenting themselves as Madrigal Pharmaceuticals' Hiring Managers, seeking to engage with job candidates through fraudulent online advertisements or job posting sites. These unauthorized individuals are using Madrigal's name and logo in an attempt to solicit up-front fees and obtain personal information from interested job candidates. Please know that Madrigal does not conduct interviews via text or in chat rooms; conduct interviews via Skype, RingCentral or solely via telephone; charge candidates an advance fee of any kind (e.g., fees for purchasing equipment); nor does it offer positions of employment without undergoing a thorough recruiting process. Interviews with Madrigal are conducted via the Zoom platform.

Please also note that any correspondence with regard to employment would come from an authorized madrigalpharma.com email address or from an email address from one of our trusted search firm partners. We are aware that incorrect/fraudulent email addresses, with Madrigal misspelled, have been utilized in these most recent fraud attempts. If you receive unsolicited employment offers from people claiming to work for Madrigal we recommend that you: do not respond to their questions; do not open any attachments; and do not click on any hyperlinks.