Job Description
The Broad IT Services (BITS) 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 believe that a diverse and inclusive community is essential to achieving our mission. 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!
Your Charter
As an Enterprise Data Developer, you will work under the guidance of the Director of Enterprise Reporting to bolster the overarching reporting strategy and operations at the Broad Institute. Your primary responsibilities will involve crafting, implementing, and maintaining an Enterprise Reporting framework and generating reports. Collaborating closely with the Director and fellow team members, you will construct robust database structures optimized for swift data retrieval and storage to support enterprise reporting needs.
Technical Skills:
Strong understanding of the SQL programming language to write complex queries that can retrieve, manipulate, or update data
Experience optimizing large complicated SQL statements
Strong Knowledge of Database Management Systems (DBMS)
Previous experience with modern relational databases (AWS, GCP, Snowflake)
Knowledge of best practices when dealing with relational databases
Analyzes, assesses and tests data controls and data systems to ensure quality and risk compliance standards are met.
Supports and interacts with various functional areas on multi-domain remediation efforts.
Leverages domain expertise and data / business / process analysis to inform and support solution design
Capable of troubleshooting common database issues
Familiar with tools that can aid with profiling server resource usage and optimizing it
Understanding of code versioning tools such as Github
Preferred Coding Skills:
Experience with ANSI SQL required
Experience with GitHub preferred
Experience with dbt preferred
Capabilities:
Develops tools and processes used to maintain a common, organization-wide data standard.
Develop fast and performant database queries
Demonstrates an understanding of how data sets and queries can relate to business processes
Able to understand different data schemas, e.g. Star, Snowflake, etc.
Follows best database design and development practices
Stays up-to-date with all relevant data security procedures and complies with all applicable data protection legislation.
Experience creating technical and end-user documentation
Technically curious and focused on iterative improvements
Possesses strong analytical and problem-solving abilities.
Able to effectively communicate with various stakeholders, including product managers, designers, and business analysts, to align the database with organizational requirements.
Data Integrity & Reporting:
Design and develop reports utilizing a variety of tools including ANSI SQL and dbt
Assist staff with creation of queries to support their day to day responsibilities, as well as create adhoc reports, as required.
Qualifications
Bachelor's Degree in Computer Science, Information Systems, or related field preferred but not required
2+ years development experience
Previous experience as a report developer preferred
Solid functional knowledge and understanding of IT processes and data, including workflows
Effectively manage time and prioritize projects to meet established deadlines
Work independently as well as cooperatively in a team environment; communicate effectively, both verbally and in written form, with all levels of the organization
Creative approach to solving problems
#LI-HYBRID
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
Check out this video for a look into our community!