Business Intelligence Data Specialist

Business Intelligence Data Specialist

Location: Houston, TX/Remote

Duration: 12 Months

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.Troubleshoot data integrity issues within existing data warehouse.Analyze 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 reportsStrong understanding of data warehouse concepts, structures, and best practicesComfortable analyzing existing source data systems to design and develop new data models.Ability to work both collaboratively and individually.Strong T-SQL skillsetExperience with On-prem Power BI preferred.Experience with SQL Server Reporting Services (SSRS) preferred.Familiarity with Azure DevOpsExperience in financial and/or operational reporting preferred.Comfortable using ETL tools such as Azure Data Factory, Logic Apps, SSIS or InformaticaComfortable using a variety of data sources (SQL, text, XML, CSV, MS Azure, Flow, Logic Apps)