Job Family
IT Architecture/Cloud
Travel Required
Up to 10%
Clearance Required
None
What You Will Do
As an experienced data engineer, you will be joining a collaborative IT development team as we bring together Guidehouse's data to address our internal clients’ business needs. You will apply your knowledge to build and support enterprise solutions spanning ETL/ELT, process automation, data modeling, and BI reporting with Microsoft's data and BI technology stacks.
- Develop, test, and maintain scalable ETL pipelines to ingest data from multiple disparate data sources.
- Participate in development and maintenance of the corporate data warehouse.
- Perform complex data queries and data analysis.
- Understand internal needs and translate them to technical requirements.
What You Will Need
- B.S./B.A. in Computer Science, Information Systems, or similar computational discipline.
- 3+ years of relevant professional experience as a data engineer using Microsoft/Azure technologies.
- Experience developing complex ETLs with Azure Data Factory and SSIS against structured, semi-structured, and unstructured data sets.
- Experience developing SQL relational databases and optimizing complex queries.
- Experience developing semantic data models, data cleansing, and segmentation techniques.
- Understanding of relational databases, columnar data warehouses, data lakes, and other storage types.
- Excellent analytical and problem-solving skills.
- Good written and verbal communication skills.
- Ability to work independently as well as collaborate within a team environment.
What Would Be Nice To Have
- Experience using Power BI.
- Experience using Azure Analysis Services.
- Experience using Azure Synapse Analytics.
- Experience using Spark or Databricks.
- Experience with source code version control technologies such as Git and Azure DevOps.
- Well versed with data structures and algorithms.
- Understanding of the software development lifecycle.
- Experience interacting with end-users to understand and document business and functional requirements.
The annual salary range for this position is $73,400.00-$110,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.
What We Offer
Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.
Benefits Include
- Medical, Rx, Dental & Vision Insurance
- Personal and Family Sick Time & Company Paid Holidays
- Position may be eligible for a discretionary variable incentive bonus
- Parental Leave and Adoption Assistance
- 401(k) Retirement Plan
- Basic Life & Supplemental Life
- Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
- Short-Term & Long-Term Disability
- Student Loan PayDown
- Tuition Reimbursement, Personal Development & Learning Opportunities
- Skills Development & Certifications
- Employee Referral Program
- Corporate Sponsored Events & Community Outreach
- Emergency Back-Up Childcare Program
- Mobility Stipend
About Guidehouse
Guidehouse is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation.
Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.
If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.
Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.
#J-18808-Ljbffr