Hybrid Enterprise Data Developer en Broad Institute

The group believes exceptional people produce exceptional products and services. We are committed to building the best team we can in service of the Institute's mission of "Accelerating the Understanding and Treatment of Disease." Our team of highly accomplished technical experts work with 1000’s of Broad researchers to create, scale, and run a wide range of technology solutions. We are always looking for committed, mission-driven individuals to bring new viewpoints, experiences, and creativity to the team. We are seeking driven candidates who are motivated to learn new technologies and are willing to take on challenges with enthusiasm! In this entry level reporting analyst role, you will work under the guidance of the Director of IT Financial Platform Architecture to bolster the overarching reporting strategy and operations at the . Your primary responsibilities will involve collaborating with a broad range of stake holders to collect, analyze and interpret complex data that will ultimately help our organization make informed business decisions. Collaborating closely with the Director and fellow team members, you will construct robust reporting structures optimized for swift data retrieval and storage to support enterprise reporting needs. Your capabilities:Curious and focused on iterative improvementsPossesses strong analytical and problem-solving abilitiesAble to effectively communicate with various stakeholders, including product managers, designers, and business analysts, to align the database with organizational requirements.Demonstrates an understanding of how data sets and queries can relate to business processesExperience creating technical and end-user documentationDevelop fast and performant database queriesAble to understand different data schemas, e.g. Star, Snowflake, etc.Follows best database development practicesCreative approach to solving problem solvingEffectively manage time and prioritize projects to meet established deadlinesWork independently as well as cooperatively in a team environment; communicate effectively, both verbally and in written form, with all levels of the organizationSolid functional knowledge and understanding of IT processes and data, including workflows Key role responsibilitiesCreate reports, dashboards and other data visualizations to communicate complex data insights to non-technical stakeholdersCollaborate with cross-functional teams to design and implement data-driven solutions to business problemsCreate robust documentation to support all aspects of the development process from specification to testing frameworksUtilize strong understanding of the SQL programming language to write complex queries that can retrieve, manipulate, or update dataOptimize large, complicated SQL statementsCreate robust testing frameworks for purposes of troubleshootingLeverage domain expertise and data / business / process analysis to inform and support solution designDesign and develop reports utilizing a variety of tools including SQLAssist staff with creation of queries to support their day-to-day responsibilities, as well as create ad hoc reports, as required.Minimum qualificationsBachelor’s degree in computer science, Information Systems, Business Administration or related fieldAt least 1 year experience coding in SQL (gained through coursework and/or professional work experience)Experience presenting data using data visualization tools like PowerBI, Tableau, etc.Experience in MS Excel (x-lookups, pivot tables, etc.) Preferred Qualifications:Previous professional experience gained through internship opportunitiesExposure to InformaticaFamiliarity with ERPs like SAP, Oracle, etc.Ability to code in PythonPrevious experience with modern relational databases (AWS, GCP, Snowflake)This role requires a hybrid work schedule with a requirement for 2 days a week in the office in Cambridge, MA and 3 days a week work from home. The Broad will not offer sponsorship for this role, both now and in the future. Solicitar ahora