Sr. Business Intelligence Developer
a0MaA000000XLQf.3
The Senior Business Intelligence Developer will be an integral part of an exciting journey to modernize our data and reporting platform to radically improve business intelligence and decision making. The developer will be responsible for working within the BI team to deliver end-to-end (data to reporting) solutions that meet current and new needs of the organization globally.As the Sr. BI Developer, some of your responsibilities will include:Maintain data warehouse and operational databases in MS SQL Server on premise, SQL Azure Cloud, and SnowflakeCreate and support data ETL across all internal and external data sourcesDesign, develop, and maintain business intelligence solutions (Power BI)Support delivery of reporting, ad hoc, and analytics requests via ad-hoc data pulls when neededUnderstand all Business Unit's unique businesses and their data to aid in the development of efficient data modelingCollaborate within cross functional teams to resolve complex systems, data & data flow issues to ensure data integrity.Partner with the Analytics team for continuous evolution and enrichment of BI solutionsEngage in master data management to ensure data quality, integrity, and securityWork with IT infrastructure to ensure the security and availability of data.Establish and manage BI technical processes to ensure that reports and dashboards are produced on schedule.Support and maintain project documentation such as business requirements, technical design, and mapping documents, data flow diagrams, report specifications etc. Requirements:5+ years of Information Technology experience with a strong focus on data warehousing and reporting solutions5+ years of experience with data modelling and ETL implementations5+ years of experience with developing applications, reports, and dashboardsExperience with business requirements gathering across cross-functional teamsExperience with report development using Power BIStrong knowledge of relational databases and writing SQL analytical queriesWorking knowledge of cloud data platforms (e.g., Azure, AWS, Snowflake) and ETL tools (e.g., SSIS, ADF, Matillion)Working knowledge of Master Data Management concepts and tools such as Syncari Pluses: Pharma Industry ExperienceFamiliarity with cloud data platformsKnowledge of Data Governance frameworks and best practices