Guidehouse
Data Warehouse Developer
Guidehouse, Phila, Pennsylvania, United States, 19117
Job Family:Software Development & Support
Travel Required:Up to 10%
Clearance Required:None
What You Will Do:
As an experienced data warehouse developer, you will be joining a collaborative IT data warehouse team as we bring Guidehouse data together to meet our business's reporting needs. You will apply your knowledge to analyze data, develop data flows, and build data models using Microsoft technology stacks and other tools as appropriate.Participate in development and maintenance of our corporate data warehouse and data lake as a member of our corporate data warehouse team.Develop, test, and maintain relational and multidimensional OLAP models.Perform complex data queries and business data analysis, including financial data.Understand internal needs and translate them to technical requirements.What You Will Need:
Requires a University Degree and minimum 4 years of prior relevant experience
OR
8 years of relevant experience in lieu of degree.4+ years of relevant professional experience as a Data Warehouse developer or engineer using Microsoft technologies.Ability to obtain a National Security Clearance or a U.S. Federal Government Public Trust.Experience developing SQL relational databases and optimizing complex queries.Experience developing semantic data models.Experience analyzing and modeling financial/ERP data.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:
B.S./B.A. in Computer Science, Information Systems, or similar computational discipline.Experience developing Azure Analysis Services tabular models.Experience with Power BI Premium advanced data modeling.Experience creating Power BI reports.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.Preference will be given to candidates who are located within 50 miles of a Guidehouse office.The annual salary range for this position is $100,200.00-$150,200.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 InsurancePersonal and Family Sick Time & Company Paid HolidaysPosition may be eligible for a discretionary variable incentive bonusParental Leave and Adoption Assistance401(k) Retirement PlanBasic Life & Supplemental LifeHealth Savings Account, Dental/Vision & Dependent Care Flexible Spending AccountsShort-Term & Long-Term DisabilityStudent Loan PayDownTuition Reimbursement, Personal Development & Learning OpportunitiesSkills Development & CertificationsEmployee Referral ProgramCorporate Sponsored Events & Community OutreachEmergency Back-Up Childcare ProgramMobility Stipend
About GuidehouseGuidehouse 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 [redacted] or via email at RecruitingA[redacted]. 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.
Travel Required:Up to 10%
Clearance Required:None
What You Will Do:
As an experienced data warehouse developer, you will be joining a collaborative IT data warehouse team as we bring Guidehouse data together to meet our business's reporting needs. You will apply your knowledge to analyze data, develop data flows, and build data models using Microsoft technology stacks and other tools as appropriate.Participate in development and maintenance of our corporate data warehouse and data lake as a member of our corporate data warehouse team.Develop, test, and maintain relational and multidimensional OLAP models.Perform complex data queries and business data analysis, including financial data.Understand internal needs and translate them to technical requirements.What You Will Need:
Requires a University Degree and minimum 4 years of prior relevant experience
OR
8 years of relevant experience in lieu of degree.4+ years of relevant professional experience as a Data Warehouse developer or engineer using Microsoft technologies.Ability to obtain a National Security Clearance or a U.S. Federal Government Public Trust.Experience developing SQL relational databases and optimizing complex queries.Experience developing semantic data models.Experience analyzing and modeling financial/ERP data.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:
B.S./B.A. in Computer Science, Information Systems, or similar computational discipline.Experience developing Azure Analysis Services tabular models.Experience with Power BI Premium advanced data modeling.Experience creating Power BI reports.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.Preference will be given to candidates who are located within 50 miles of a Guidehouse office.The annual salary range for this position is $100,200.00-$150,200.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 InsurancePersonal and Family Sick Time & Company Paid HolidaysPosition may be eligible for a discretionary variable incentive bonusParental Leave and Adoption Assistance401(k) Retirement PlanBasic Life & Supplemental LifeHealth Savings Account, Dental/Vision & Dependent Care Flexible Spending AccountsShort-Term & Long-Term DisabilityStudent Loan PayDownTuition Reimbursement, Personal Development & Learning OpportunitiesSkills Development & CertificationsEmployee Referral ProgramCorporate Sponsored Events & Community OutreachEmergency Back-Up Childcare ProgramMobility Stipend
About GuidehouseGuidehouse 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 [redacted] or via email at RecruitingA[redacted]. 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.