Remote Data Engineer

This is a Fully Remote Job About Our Client:Trilogy Federal operates within the financial management, healthcare, and government industries, addressing complex business challenges through innovative and pragmatic solutions. The organization emphasizes a client-focused, collaborative approach that aims to deliver transformative results efficiently. About the Opportunity:The REMOTE DATA ENGINEER will support a federal client by implementing and maintaining data solutions that enable effective business decisions. This role involves creating and managing a functional SSAS environment, transitioning reporting systems, and developing data models and reports to enhance analytics capabilities. The position plays a key part in ensuring data environments are optimized and aligned with client requirements. Responsibilities:Implement a functional SQL Server Analysis Services (SSAS) environment.Build and redesign reports transitioning to the analysis services environment.Collaborate with the client’s technical team to gather initial requirements.Apply tabular, relational, and multidimensional data modeling methodologies.Transform raw data into actionable business insights and pre-aggregate data.Document logical and physical data models.Update documentation for the reporting environment data model.Develop new reports based on client needs. Requirements:At least 8 years of professional experience and a bachelor’s degree.Minimum 6 years of experience with JAVA and JavaScript.At least 3 years of experience with SQL.Ability to define and develop reports and data queries using SQL, SSAS, and SSIS.Experience building star and snowflake schemas.Working knowledge of tabular, relational, and multidimensional data models.Familiarity with AWS and/or Azure cloud platforms.Experience creating complex dashboards and reports using Power BI.Expert understanding of ETL, data pipelines, and data warehousing concepts.Self-motivated and able to work independently and collaboratively.Adaptability to rapidly changing requirements.Eligibility to obtain a Public Trust clearance. Preferred Qualifications:Experience with financial data modeling and analytics, including budgeting and financial management.Experience with the Department of Veterans Affairs (VA) environment is a plus but not required. Pay Range and Compensation Package:$115,000 to $130,000 per year, with compensation determined based on experience, location, education, and industry benchmarks. Benefits & Perks:Health, dental, and vision insurance plans.Optional Flexible Spending Account (FSA).Paid parental leave.Safe Harbor 401(k) plan with employer contributions fully vested from day one.Paid time off and 11 paid holidays.No-cost group term life and accidental death & dismemberment insurance, with optional supplemental coverage.Pet insurance.Monthly phone and internet stipend.Tuition and training reimbursement. Equal Opportunity Statement: Our client is an equal opportunity employer. They celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, or national origin. Note:TalentHop is a recruitment partner of this role. Please note that all employment decisions, including candidate assessment, interviews, hiring, compensation, and employment terms, are made exclusively by the hiring employer.