Sr. Data Analyst

Trilogy Federal provides financial management, information technology (IT) consulting, program management services, and strategic consulting to federal agencies. Trilogy has an extensive history helping federal clients achieve their most ambitious business modernization and optimization goals with the ability to deliver targeted subject matter expertise and full life cycle support.

Trilogy Federal, LLC. (Trilogy) is looking for a remote Senior Data Analyst to support a large Federal agency’s data analytics needs. The chosen candidate will have a working knowledge of SQL, PL/SQL, SQL Server Analysis Services (SSAS), and PowerBI to join our growing company and support our federal client.  Our ideal candidate will contribute effectively towards our team goals and ensure exceptional customer experience for our client and their employees. 

• Assist in conducting comparative, trend, and predictive analysis of variety of data and prepare comprehensive reports of the analysis that are useful in decision making, and communication.
• Must possess skillsets to work with large and complex data sets, multiple sources, and changing requirements.
• Design multi-dimensional systems using SSAS’s star schema that create simplicity in accessing diverse data to perform efficient and fast analysis on large amounts of data, uncover trends and make timelier, better-informed decisions. The designs must be flexible to accept data from multiple data sources with varying structures and compatible with existing sources and structures.  
• Build reports using PowerBI from the OLAP multi-dimensional databases.
• Adept at working with various data management systems and assist in designing scalable automated reporting processes that can deliver high quality reports efficiently and consistently. 

• Bachelor’s degree
• 8 years of relevant experience
• The ability to obtain a Public Trust Clearance
• Detailed understanding of Microsoft applications (Word, Excel, PowerPoint, Outlook, SharePoint) and their features/functions
• Experience with the following: Power BI, SQL, PL/SQL, Database design and ETL (data extraction, transform, and load), and an understanding of big data concepts.
• Strong analytical, problem-solving, communication, and facilitation skills.
• Experience with creating executive-level documentation and reports.
• Generally, understands IT System Development Life Cycle and Agile concepts.
• Possesses a solid understanding of IT architecture concepts.
• Ability to interface well with end-users and senior client stakeholders.
• Ability to prioritize and manage multiple tasks concurrently.
• Ability to work in a fast-paced and collaborative virtual environment.
• Detail-oriented consulting approach, with client service focus.
• Self-starter able to work independently and within a team.

• Possesses an advanced degree or credential (e.g., BIDA) in data analytics or business intelligence.
• Experience with Tableau
• VA or VHA experience
• Experience with or general understanding of VA data analytic platforms, repositories, or tools.

• Health, dental, and vision plans
• Optional FSA
• Safe Harbor 401(k) with employer contributions 100% vested from day 1
• Paid parental leave
• Paid time off and 11 paid holidays
• No cost group term life/AD&D plan, and optional supplemental coverage
• Pet insurance
• Monthly phone and internet stipend
• Tuition and training reimbursement

Regarding remote positions, Trilogy Federal is only able to offer virtual employment in the following states: Colorado, Connecticut, Delaware, D.C., Florida, Illinois, Indiana, Maryland, Massachusetts, New York, South Carolina, Texas, and Virginia.

Trilogy Federal is an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.