Remote Data Engineer
Summary
Remote data engineer supporting a federal client: implements a SQL Server Analysis Services (SSAS) environment, migrates and redesigns reports, documents data models, and builds Power BI dashboards. Core stack is SQL, SSIS, SSAS, and Power BI, with Java/JavaScript and AWS/Azure experience required.
Trilogy Federal is looking for a remote Data Engineer with working knowledge of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and Power BI 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.
We are seeking an experienced candidate who has prior implementation skills to implement a functional SSAS environment. The selected candidate must have working knowledge of tabular and multidimensional data models, in addition to experience documenting logical and physical data models.
Primary Responsibilities:
- Implement a functional SSAS environment.
- Building and re-designing a set of reports that need to transition to an analysis services environment.
- Work with our customer’s technical team to identify initial requirements.
- Apply tabular, relational, and multidimensional data modeling methodologies.
- Transform raw data into meaningful business decisions and pre-aggregate data for optimal results.
- Document logical and physical data models.
- Document and update reporting environment data model
- Develop new reports based on customer requirements
Minimum Requirements:
- Minimum of 8 years of overall professional experience and bachelor’s degree
- Minimum of 6 years of experience with Java and JavaScript
- Minimum of 3 years of experience with SQL
- Define and develop new reporting and data queries using SQL, SSAS, and SSIS
- Experience building both star and snowflake schemas
- Experience building applications in Java
- Working knowledge of tabular, relational, and multidimensional data models
- Working knowledge of AWS and/or Azure cloud environments
- Experience building complex dashboards and reports with Power BI
- Expert-level understand of ETL, data pipeline, and data warehousing concepts
- Self-starter able to work independently and within a team
- Flexibility and the ability to react to rapidly changing requirements
- The ability to obtain a Public Trust clearance
Preferred Qualifications:
- Experience generating data models and analytics of a financial nature including budgeting, financial management, or personnel environment.
- Preferred VA experience but not required
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
Skills
As published by lever · 11 questions · 2 written answers
Basics
Resume/CV, Full name, Email, Phone, Current location, Current company, LinkedIn URL, GitHub or Portfolio URL
Short answers (1)
- Were you referred by a current Trilogy employee? If so, please share their name: optional
Pick from a list (8)
- What is your highest level of education? optional
- If offered a position with Trilogy Federal will you be able to provide documentation showing you are eligible to work in the United States on a full-time basis? optional
- Will you now or in the future require Trilogy Federal to sponsor an immigration case for an employment-based visa status? For example, H1-B or other employment-based immigration case? optional
- In order to be qualified for this position you must be able to pass a National Agency Check and Inquiries (NACI) background check including searches of records from past employers, schools attended, references, and local law enforcement authorities. Do you meet the eligibility requirements? optional
- What is your desired annual compensation (or hourly rate equivalent, for positions posted as hourly or temporary)? optional
- State in which you currently live optional
- In order to be qualified for this position you must hold active U.S. Citizenship OR Permanent Residency. Do you meet this eligibility requirement? optional
- Which cellular network provider do you currently use for your mobile phone (needed for phone interview scheduling): optional
Written answers (2)
- What certifications do you possess (please write "N/A" if applicable)?
- If other, please share which cellular network provider you use (N/A if listed above):