Business Intelligence Data Systems Architect

Job Description:
• Design, build, test, deploy, document, and maintain Power BI reporting solutions and semantic models, including the SQL queries, data pipelines, and dependent systems that power them—continuously assessing platform capabilities, performance, and governance.
• Work with IT Leadership, Informatics - Data Management, IT Operations and IT - Business Systems on researching, developing, testing, deploying and documenting new methods and tools for ingestion, processing, sending and sharing of data.
• Plan, coordinate and implement security measures (including regular audits) to safeguard information in reporting platforms and computer files against accidental or unauthorized damage, modification or disclosure.
• Specify users and user access levels for each segment of the reporting platforms, as needed.
• Select, develop and deploy code to monitor reporting platform performance
• Develop reference and workflow documents for documentation purposes.
• Revise agency definition of data as defined in data dictionary in regards to reporting and visualizations.

Requirements:
• Associate’s degree and a minimum four (4) years’ experience in one or more of the following areas: healthcare claims environment and reporting development
• demonstrated experience in n-tier development and support including Microsoft SQL database development including relational and star schema data warehouses
• ETL, including the following software and tools: Power BI, SQL Server 2008 R2 or above, Visual Studio Professional\Enterprise 2017 or above, Azure Dev Ops, AWS, SSMS, SSRS, SSAS, SSIS, Advanced SQL, C#, .NET, PowerShell
• Requires certification. Applicable certification(s) may be substituted to equivalent degree and experience requirements; OR Equivalent combination of education/experience
• Two-year degrees require certification
• Must have a valid driver’s license

Benefits:
• Health Insurance with no premium for employee coverage
• Flexible Spending Accounts
• 24 days of Paid Time Off (PTO) plus 12 paid holidays in your first year
• NC Local Government Retirement Pension (defined-benefit plan)
• 401k with 5% employer match and immediate vesting
• Public Service Loan Forgiveness (PSLF) qualifying employer
• Quarterly stipend for remote work supplies