ACL Digital
Business Intelligence Data Specialist
ACL Digital, Schiller Park, Illinois, United States, 60176
Business Intelligence Data Specialist Remote Long Term Job Summary: The Business Intelligence Data Specialist will be responsible for the design, development and maintenance of various business intelligence and analytics solutions. These solutions will be essential in delivering enterprise-wide strategic, tactical, and operational analysis and reporting to both operational managers and corporate executives. Responsibilities: Translate business needs to technical specifications Design, develop, test, and deploy SQL Server Reporting Services (SSRS) and Power BI reports and dashboards to meet client needs Troubleshoot data integrity issues within existing data warehouse nalyze existing data sets in order to design and develop new data models Design, develop, and maintain ETL processes to build new data models and ensure data is accurate and current Collaborate with stakeholders to develop a strategic vision for their BI and analytic needs Collaborate with IT to identify and implement data management and protection solutions and processes for the business intelligence and analytics solutions Provide end-user support Create and maintain system documentation as changes are implemented Qualifications: Familiarity with Microsoft BI environment. (SQL Server, SSRS and/or Power BI) Understanding of developing and distributing Microsoft Power BI reports Strong understanding of data warehouse concepts, structures, and best practices Comfortable analyzing existing source data systems to design and develop new data models bility to work both collaboratively and individually Strong T-SQL skillset Experience with On-prem Power BI preferred Experience with SQL Server Reporting Services (SSRS) preferred Familiarity with Azure DevOps Experience in financial and/or operational reporting preferred Comfortable using ETL tools such as Azure Data Factory, Logic Apps, SSIS or Informatic Comfortable using a variety of data sources (SQL, text, XML, CSV, MS Azure, Flow, Logic Apps)