Signature Systems Group - Flower Mound, TX
posted 3 months ago
We are seeking a skilled and experienced IT Business Intelligence (BI) Developer to join our dynamic team at Signature Systems Group, LLC. The ideal candidate will be responsible for designing, developing, and maintaining business intelligence solutions that provide valuable insights into the organization's data. The BI Developer will collaborate with business stakeholders, analysts, and other IT professionals to understand requirements, design effective solutions, and ensure the successful implementation of BI projects. This role is crucial in transforming data into actionable insights that drive business decisions and improve operational efficiency. The BI Developer will engage in various tasks, including MS SQL Development, where they will design and implement database schemas, write and optimize SQL queries, and develop stored procedures, functions, and triggers. Ensuring data quality and consistency is paramount, and the developer will collaborate with application developers to integrate database solutions effectively. Additionally, the role involves SSAS Development, where the developer will maintain and optimize SQL Server Analysis Services solutions, including designing, deploying, and managing OLAP cubes and tabular models. Another key responsibility is ETL Development, where the developer will create and maintain Extract, Transform, Load (ETL) processes to integrate data from various sources into the data warehouse. Data Modeling is also a significant aspect of the role, requiring the design and implementation of data models to support business intelligence and analytics requirements for the Enterprise Data Warehouse (EDW). Performance Optimization is essential, as the developer will optimize queries and data processes to ensure efficient and timely access to information. The BI Developer will work closely with business stakeholders to gather requirements and understand their data and reporting needs. Collaboration with cross-functional teams, including business analysts, database administrators, and IT developers, is vital to deliver comprehensive BI solutions. Finally, the developer will be responsible for creating and maintaining documentation for BI solutions, including technical specifications, user guides, and best practices, ensuring that all stakeholders have access to necessary information.