Business Intelligence Developer

Summary

Join us at Idera as a Business Intelligence developer to maintain our internal corporate data warehouse and build out our business intelligence platform.

Requirements

• Five years or more experience performing data warehouse architecture development and management
• Exceptional experience with technologies such as SQL Server, as well as with ETL tools (primarily SSIS) and working knowledge of C#
• Exceptional experience developing code, testing for quality assurance, administering RDBMS, and monitoring of database
• High proficiency in dimensional modeling techniques and their applications
• Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel
• Several years working experience with any data visualization reporting tool (Tableau, PowerBI, Looker, YellowfinBI)
• Experience with Microsoft Azure and Amazon AWS computing platforms
• Strong experience with TSQL
• Strong experience with API interface to platforms like SalesForce, Hubspot, Stripe, etc

Responsibilities

• Have experience in the end-to-end process of gathering business requirements, creating ETL pipelines, writing SQL stored procedures, and creating the final data visualization reports and dashboards
• Have the ability to consolidate and optimize available data warehouse infrastructure
• Can conceive analytics and business intelligence platform architecture for internal clients
• Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked
• Design and implement ETL processes and data architecture to ensure proper functioning of analytics
• Carry out monitoring, tuning, and database performance analysis
• Ensure all data warehouse architecture codes are maintained in a version control system