Job Duties:
Create, develop and support Business Intelligence initiatives (Integrate, Reporting and Analytics) using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), C#, Visual Studio, Azure, and Power BI. Define the ETL architecture for the work streams and create the technical design documents. Deliver advanced and complex reporting solutions including Dashboards, Analytical Reporting using SSAS and Power BI. Automate Database and SSIS Package deployments using Azure DevOps by creating CI/CD Pipelines and use Script task in SSIS to write custom code in C#. Write stored procedures, packages, functions, views in T-SQL and develop monitoring alerts via Unix shell scripts. Will work in Weddington, NC and/or various client sites throughout the U.S. Must be willing to travel and/or relocate.