FTI Consulting
Sr. Datawarehouse Engineer, Data Center | Technology | Multiple Locations
FTI Consulting, Pittsburgh, Pennsylvania, us, 15289
Who We Are
FTI Consulting is the world's leading expert-driven consulting firm. Over the last 40 years, FTI Consulting experts have served as the trusted advisor to Fortune 500 companies and the world's leading law and private equity firms when they are facing their greatest opportunities and challenges. Our strong performance and continued success are a direct reflection of the ambition, energy and commitment of our talented professionals across the globe to make a positive impact for our clients and communities.
At FTI Consulting, you'll work side-by side with leaders who have shaped history, helping solve the biggest challenges making headlines today. From day one, you'll be an integral part of a focused team where you can make a real impact. You'll be surrounded by an open, collaborative culture that embraces diversity, recognition, professional development and, most importantly, you.
Are you ready to make your impact?
About The Role
The Datawarehouse / Business Intelligence Developer is responsible for designing and maintaining the overall lifecycle of Datawarehouse / BI solutions, all related infrastructure and services, in a 24 x 7 environment for the purposes of reporting, decision support and analysis. Core responsibilities include managing Azure Data Factory pipelines, Data Lake storage, Databricks processing and the overall health of Datawarehouse / BI implementations while keeping a keen eye toward cost management and compliance with global data governance requirements. The DW/BI developer should be proficient with Azure DevOps and Agile programming methodologies, able to quickly gain an understanding of new and existing data feeds, define and document requirements for data extraction and integration of data from various data sources, and possess a strong understanding of Power BI and BI reporting. The ideal candidate will have the ability to troubleshoot and problem solve with a strong sense of urgency and minimal supervision.
The DW/BI Developer will have the ability to develop code effectively in a team environment, take on new technologies and concepts and manage multiple priorities simultaneously. Candidates will support fast-paced development teams and need to have excellent communication (written and verbal) with strong analytical and problem-solving skills.
What You'll DoDesign, Build, and Support Azure Data Warehouse pipelines using Azure Data Factory and Azure DatabricksDesign and construct Data Lake ingestion and staging of data sources for Analytics purposes using Azure Data FactoryProvide best practices and guidance regarding use of ELT/ETL, data modeling, and reporting deliverablesWork with technology and business users to define and document data requirements for new and existing data feedsActively review and improve azure data warehouse code and pipelinesCreate logging and monitoring of new and existing pipelinesUse Azure DevOps for source code management, feature/functionality documentation, task management, and bug/issue tracking/reportingDevelop cost controls and IT governance utilities around operational tasksMaintain an on-call schedule to support automation toolsCollaborate with other IT Infrastructure and application teamsEnforce Systems Engineering and DevOps standards and best practicesWork with key stakeholders in Project Management, Engineering, Development and QA to ensure high quality delivery of software projectsHow You'll Grow
We are committed to investing and supporting you in your professional development and we have developed a range of programs focused on fostering leadership, growth and development opportunities. We aim to promote continuous learning and individual skills development through on-the-job learning, self-guided professional development courses and certifications. You'll be assigned a dedicated coach to mentor, guide and support you through regular coaching sessions and serve as an advocate for your professional growth.
As you progress through your career at FTI Consulting, we offer tailored programs for critical professional milestones to ensure you are prepared and empowered to take on your next role.
What You Will Need To Succeed
Basic Qualifications
5+ years of overall developing and maintaining Datawarehouse, ETL and Business Intelligence solutions3+ years of provisioning, configuring, developing, implementing, and maintaining solutions in Azure Data Lake, Data Factory and DatabricksExperience with Spark, SQL and Python scripting within Azure DatabricksExperience with dimensional modelingApplicants must be currently authorized to work in the United States on a full-time basis; this position does not provide visa sponsorshipPreferred Qualifications
Degree in Information Systems, Computer Science, or equivalentCertifications in Azure, Databricks or MicrosoftExperience with Power BIExperience with Azure DevOps servicesProficient in source control methods and technologiesExperience working with APIs to develop custom application integrationsAzure SQL, SQL ServerComfortable working in an Agile programming methodologyScaled Agile Framework (SAFe) familiarityExperience with AWS DatabricksExperience with AWS Cloud Intelligence Dashboards#LI-Remote #LI-DB1#G5W7C9
Total Wellbeing
Our goal is to support the wellbeing of you and your families-physically, emotionally, and financially. We offer comprehensive benefits such as the following:
Competitive total compensation, including bonus earning potentialFull package of benefits plans, including medical, dental, and vision coverage along with life and disability insuranceGenerous paid time off and holidaysCompany matched 401(k) retirement savings planPotential for flexible work arrangementsGenerous paid parental leave with available planning tools, virtual expert coaching services and flex return support.Family care benefits, including back-up child/elder careEmployee wellness platformEmployee recognition programsPaid time off for volunteering in your communityCorporate matching for charitable donations most important to youMake an impact in our communities through company sponsored pro bono workProfessional development and certification programsFree in-office snacks and drinksFree smartphone and cellular plan (if applicable)FTI Perks & Discounts at retailers and businessesUpscale offices close to public transportation
About FTI Consulting
FTI Consulting is a global business advisory firm dedicated to helping clients with their most significant opportunities and challenges. With more than 8,000 employees located in 33 countries and territories, our broad and diverse bench of award-winning experts advise their clients when they are facing their most significant opportunities and challenges. At FTI Consulting, we embrace, cultivate and maintain a culture of diversity, inclusion & belonging, which are fundamental components to our core values. FTI Consulting is publicly traded on the New York Stock Exchange and has been recognized as one of the World's Best Management Consulting Firms by Forbes. For more information, visit www.fticonsulting.com and connect with us on Instagram and LinkedIn.
FTI Consulting is an equal opportunity employer and does not discriminate on the basis of race, color, national origin, ancestry, citizenship status, protected veteran status, religion, physical or mental disability, marital status, sex, sexual orientation, gender identity or expression, age, or any other basis protected by law, ordinance, or regulation.
Compensation Disclosure:
Actual compensation is determined based on a wide array of relevant factors including market considerations, business needs, and an individual's location, skills, level of experience, and qualifications.
FTI Consulting is the world's leading expert-driven consulting firm. Over the last 40 years, FTI Consulting experts have served as the trusted advisor to Fortune 500 companies and the world's leading law and private equity firms when they are facing their greatest opportunities and challenges. Our strong performance and continued success are a direct reflection of the ambition, energy and commitment of our talented professionals across the globe to make a positive impact for our clients and communities.
At FTI Consulting, you'll work side-by side with leaders who have shaped history, helping solve the biggest challenges making headlines today. From day one, you'll be an integral part of a focused team where you can make a real impact. You'll be surrounded by an open, collaborative culture that embraces diversity, recognition, professional development and, most importantly, you.
Are you ready to make your impact?
About The Role
The Datawarehouse / Business Intelligence Developer is responsible for designing and maintaining the overall lifecycle of Datawarehouse / BI solutions, all related infrastructure and services, in a 24 x 7 environment for the purposes of reporting, decision support and analysis. Core responsibilities include managing Azure Data Factory pipelines, Data Lake storage, Databricks processing and the overall health of Datawarehouse / BI implementations while keeping a keen eye toward cost management and compliance with global data governance requirements. The DW/BI developer should be proficient with Azure DevOps and Agile programming methodologies, able to quickly gain an understanding of new and existing data feeds, define and document requirements for data extraction and integration of data from various data sources, and possess a strong understanding of Power BI and BI reporting. The ideal candidate will have the ability to troubleshoot and problem solve with a strong sense of urgency and minimal supervision.
The DW/BI Developer will have the ability to develop code effectively in a team environment, take on new technologies and concepts and manage multiple priorities simultaneously. Candidates will support fast-paced development teams and need to have excellent communication (written and verbal) with strong analytical and problem-solving skills.
What You'll DoDesign, Build, and Support Azure Data Warehouse pipelines using Azure Data Factory and Azure DatabricksDesign and construct Data Lake ingestion and staging of data sources for Analytics purposes using Azure Data FactoryProvide best practices and guidance regarding use of ELT/ETL, data modeling, and reporting deliverablesWork with technology and business users to define and document data requirements for new and existing data feedsActively review and improve azure data warehouse code and pipelinesCreate logging and monitoring of new and existing pipelinesUse Azure DevOps for source code management, feature/functionality documentation, task management, and bug/issue tracking/reportingDevelop cost controls and IT governance utilities around operational tasksMaintain an on-call schedule to support automation toolsCollaborate with other IT Infrastructure and application teamsEnforce Systems Engineering and DevOps standards and best practicesWork with key stakeholders in Project Management, Engineering, Development and QA to ensure high quality delivery of software projectsHow You'll Grow
We are committed to investing and supporting you in your professional development and we have developed a range of programs focused on fostering leadership, growth and development opportunities. We aim to promote continuous learning and individual skills development through on-the-job learning, self-guided professional development courses and certifications. You'll be assigned a dedicated coach to mentor, guide and support you through regular coaching sessions and serve as an advocate for your professional growth.
As you progress through your career at FTI Consulting, we offer tailored programs for critical professional milestones to ensure you are prepared and empowered to take on your next role.
What You Will Need To Succeed
Basic Qualifications
5+ years of overall developing and maintaining Datawarehouse, ETL and Business Intelligence solutions3+ years of provisioning, configuring, developing, implementing, and maintaining solutions in Azure Data Lake, Data Factory and DatabricksExperience with Spark, SQL and Python scripting within Azure DatabricksExperience with dimensional modelingApplicants must be currently authorized to work in the United States on a full-time basis; this position does not provide visa sponsorshipPreferred Qualifications
Degree in Information Systems, Computer Science, or equivalentCertifications in Azure, Databricks or MicrosoftExperience with Power BIExperience with Azure DevOps servicesProficient in source control methods and technologiesExperience working with APIs to develop custom application integrationsAzure SQL, SQL ServerComfortable working in an Agile programming methodologyScaled Agile Framework (SAFe) familiarityExperience with AWS DatabricksExperience with AWS Cloud Intelligence Dashboards#LI-Remote #LI-DB1#G5W7C9
Total Wellbeing
Our goal is to support the wellbeing of you and your families-physically, emotionally, and financially. We offer comprehensive benefits such as the following:
Competitive total compensation, including bonus earning potentialFull package of benefits plans, including medical, dental, and vision coverage along with life and disability insuranceGenerous paid time off and holidaysCompany matched 401(k) retirement savings planPotential for flexible work arrangementsGenerous paid parental leave with available planning tools, virtual expert coaching services and flex return support.Family care benefits, including back-up child/elder careEmployee wellness platformEmployee recognition programsPaid time off for volunteering in your communityCorporate matching for charitable donations most important to youMake an impact in our communities through company sponsored pro bono workProfessional development and certification programsFree in-office snacks and drinksFree smartphone and cellular plan (if applicable)FTI Perks & Discounts at retailers and businessesUpscale offices close to public transportation
About FTI Consulting
FTI Consulting is a global business advisory firm dedicated to helping clients with their most significant opportunities and challenges. With more than 8,000 employees located in 33 countries and territories, our broad and diverse bench of award-winning experts advise their clients when they are facing their most significant opportunities and challenges. At FTI Consulting, we embrace, cultivate and maintain a culture of diversity, inclusion & belonging, which are fundamental components to our core values. FTI Consulting is publicly traded on the New York Stock Exchange and has been recognized as one of the World's Best Management Consulting Firms by Forbes. For more information, visit www.fticonsulting.com and connect with us on Instagram and LinkedIn.
FTI Consulting is an equal opportunity employer and does not discriminate on the basis of race, color, national origin, ancestry, citizenship status, protected veteran status, religion, physical or mental disability, marital status, sex, sexual orientation, gender identity or expression, age, or any other basis protected by law, ordinance, or regulation.
Compensation Disclosure:
Actual compensation is determined based on a wide array of relevant factors including market considerations, business needs, and an individual's location, skills, level of experience, and qualifications.