Sr. Datawarehouse Engineer, Data Center | Technology | Multiple Locations
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 Do
- Design, Build, and Support Azure Data Warehouse pipelines using Azure Data Factory and Azure Databricks
- Design and construct Data Lake ingestion and staging of data sources for Analytics purposes using Azure Data Factory
- Provide best practices and guidance regarding use of ELT/ETL, data modeling, and reporting deliverables
- Work with technology and business users to define and document data requirements for new and existing data feeds
- Actively review and improve azure data warehouse code and pipelines
- Create logging and monitoring of new and existing pipelines
- Use Azure DevOps for source code management, feature/functionality documentation, task management, and bug/issue tracking/reporting
- Develop cost controls and IT governance utilities around operational tasks
- Maintain an on-call schedule to support automation tools
- Collaborate with other IT Infrastructure and application teams
- Enforce Systems Engineering and DevOps standards and best practices
- Work with key stakeholders in Project Management, Engineering, Development and QA to ensure high quality delivery of software projects
How 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 solutions
- 3+ years of provisioning, configuring, developing, implementing, and maintaining solutions in Azure Data Lake, Data Factory and Databricks
- Experience with Spark, SQL and Python scripting within Azure Databricks
- Experience with dimensional modeling
- Applicants must be currently authorized to work in the United States on a full-time basis; this position does not provide visa sponsorship
Preferred Qualifications
- Degree in Information Systems, Computer Science, or equivalent
- Certifications in Azure, Databricks or Microsoft
- Experience with Power BI
- Experience with Azure DevOps services
- Proficient in source control methods and technologies
- Experience working with APIs to develop custom application integrations
- Azure SQL, SQL Server
- Comfortable working in an Agile programming methodology
- Scaled Agile Framework (SAFe) familiarity
- Experience with AWS Databricks
- Experience 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 potential
- Full package of benefits plans, including medical, dental, and vision coverage along with life and disability insurance
- Generous paid time off and holidays
- Company matched 401(k) retirement savings plan
- Potential for flexible work arrangements
- Generous paid parental leave with available planning tools, virtual expert coaching services and flex return support.
- Family care benefits, including back-up child/elder care
- Employee wellness platform
- Employee recognition programs
- Paid time off for volunteering in your community
- Corporate matching for charitable donations most important to you
- Make an impact in our communities through company sponsored pro bono work
- Professional development and certification programs
- Free in-office snacks and drinks
- Free smartphone and cellular plan (if applicable)
- FTI Perks & Discounts at retailers and businesses
- Upscale 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.
