Data Services Expert

Summary

Join Tria Federal, a leading IT and Advisory services provider, as a Data Services Expert. This role involves managing the development and deployment of distributed relational databases and associated Business Intelligence (BI) systems. You will collaborate with clients to develop reporting systems, solve organizational problems through data analysis and visualization, and provide data warehouse expertise. The ideal candidate will have extensive experience with Microsoft SQL Server stack, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS), as well as experience with Microsoft Power BI. Understanding of Navy Working Capital Fund (WCF) accounting principles and experience with IBM Cognos and other OLAP tools are also preferred. This is a remote position requiring US citizenship and the ability to obtain and maintain a Secret Clearance.

Requirements

• Minimum of five years in the development and deployment of distributed relational databases and associated Business Intelligence (BI) systems
• Minimum of five years of experience with the Microsoft SQL server stack, Microsoft Structured Query Language (MSSQL), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS)
• Minimum of five years securing a SQL environment in accordance with DISA Security Technical Implementation Guidelines (STIGs)
• Minimum of five years SQL Server configuration management, optimization, administration, development in client/server architecture, business object modeling and relational database design using MS SQL Server
• Minimum of three years of experience with Microsoft Power BI

Responsibilities

• The Data Services Expert works collaboratively with the client to develop reporting systems that provide accessible information for decision-making
• The Data Services Expert uses the data platform and associated databases to solve organizational problems through reports, analysis, and data visualization
• They will also provide data warehouse expertise with an emphasis on data design, access, usage, security, and quality of information assets
• They will design and develop technical requirements, deployment documents, and other supporting mechanisms for soliciting and documenting business requirements
• The candidate works collaboratively on project teams, systems and data analysis, design, development, integration, and enhancement activities, as well as related maintenance and more complex production support
• The candidate builds and modify database tables and views and optimize SQL queries, indexes
• The candidate contributes to the creation and maintenance of reporting best practices and standards
• The candidate monitors and triages report development request queue tickets
• The candidate review reporting requests, release plans, and enhancement requests for impact and prioritization

Preferred Qualifications

• Experience with IBM Cognos and other On-Line Analytical Processing (OLAP) tools
• Understanding of Navy Working Capital Fund (WCF) accounting principles and generation of reports / OLAP analysis from WCF funding and cost information
• Experience leading and designing Service Oriented Architecture (SOA) based application
• Experience in Navy Security and RMF requirements implementation and their impacts to overall software architecture

Benefits

• We offer a top-tier benefits package to invest in your physical, mental, and financial health and wellness so that you can be your best self - at work and in life
• At Tria, we are growth-minded, entrepreneurial in spirit, and committed to fostering a culture of inclusion and opportunity for all
• Whatever your background, your role, your department, or stage in your professional journey, here you will have opportunities to learn new skills, seize new challenges, and advance your career as we grow