IDERA - Austin, TX
posted 3 months ago
Idera is seeking a talented and motivated Business Intelligence Developer to maintain our internal corporate data warehouse and further develop our business intelligence platform. This role is crucial for making key business decisions within one of the fastest-growing software companies. The successful candidate will drive the design and development of our business intelligence delivery systems, ensuring that our data infrastructure is robust and efficient. In this position, you will be responsible for the end-to-end process of gathering business requirements, creating ETL pipelines, writing SQL stored procedures, and developing final data visualization reports and dashboards. You will also need to consolidate and optimize the available data warehouse infrastructure, conceive analytics and business intelligence platform architecture for internal clients, and design and implement ETL procedures for data intake from both internal and external sources. Ensuring data verification and quality checks will be a key part of your responsibilities, along with monitoring, tuning, and performing database performance analysis. Additionally, you will maintain all data warehouse architecture codes in a version control system. The ideal candidate will have at least five years of experience in data warehouse architecture development and management, with exceptional skills in SQL Server and ETL tools, primarily SSIS. A strong working knowledge of C# is also required. You should be proficient in dimensional modeling techniques and possess strong analytical, consultative, and communication skills. Experience with data visualization reporting tools such as Tableau, PowerBI, Looker, or YellowfinBI is essential, along with familiarity with Microsoft Azure and Amazon AWS computing platforms. Strong experience with TSQL and API interfaces to platforms like SalesForce, Hubspot, and Stripe is also necessary.