Senior SQL Developer

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 Senior SQL Developer to support a large Federal agency’s data analytics needs. The chosen candidate must have related experience with the Veterans Health Administration (VHA).

Primary Responsibilities:

• Assist in conducting comparative, trend, and predictive analysis of a 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
• Utilize SQL and PL/SQL to create, develop, and maintain databases
• Build reports using Power BI 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

Minimum Requirements:

• Master's degree
• 10+ years of related experience
• Experience with the following: Power BI, SQL and PL/SQL, Database design and ETL (data extraction, transform, and load), and an understanding of big data concepts
• Proficient experience creating, developing, and maintaining SQL databases
• Experience with the Veterans Health Administration (VHA) is required
• The ability to obtain a Public Trust Clearance
• Detailed understanding of Microsoft applications (Word, Excel, PowerPoint, Outlook, SharePoint) and their features/functions
• Strong analytical, problem-solving, communication, and facilitation skills
• Experience with creating executive-level documentation and reports
• General understanding of 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 with the ability to work independently and within a team

Preferred Qualifications:

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

Benefits (including but not limited to):

• Health, dental, and vision plans
• Optional FSA
• Paid parental leave
• Safe Harbor 401(k) with employer contributions 100% vested from day 1
• 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

$135,000 - $140,000 a year

This range is not a guarantee of compensation or salary, as Trilogy Federal conducts an individual equity review for every candidate based on experience, location, education, industry experience, and comparisons to internal pay bands. In addition to salary, Trilogy offers robust benefits including medical/dental/vision insurance coverage, 401(k) match, paid holidays, paid time off, tuition reimbursement, and a very supportive work/life balance.

Regarding remote positions, Trilogy Federal is able to offer virtual employment in the following states: Colorado, Connecticut, D.C., Florida, Georgia, Illinois, Maryland, 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.