Data Engineer

Job Family: IT Architecture/Cloud Travel Required: Up to 10% Clearance Required: None What You Will Do: As an experienced data engineer, you will join a collaborative IT development team as we consolidate Guidehouse's data to meet our internal clients' business needs. You will use your expertise to build and maintain enterprise solutions involving 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 various disparate data sources. - Participate in developing and maintaining the corporate data warehouse. - Perform complex data queries and data analysis. - Understand internal needs and translate them into 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 for structured, semi-structured, and unstructured data sets. - Experience in 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 types of storage. - 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 various factors, such as skills, experience, 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 [email protected]. 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.