BI Data Warehouse Architect | Technology (Remote)

FTI Consulting, Inc; New York (NY); Remote; USD 120,000 - 160,000; Full time

Job summary

A leading consulting firm is seeking a BI Data Warehouse Architect to design and maintain data warehouse solutions using Azure technologies. The role involves overseeing critical data pipelines and governance while contributing to impactful business decisions. Candidates should have extensive experience in data management, strong collaboration skills, and the ability to thrive in a dynamic environment.

Benefits

Comprehensive benefits package

Competitive total compensation

Generous paid time off

401(k) retirement savings plan

Flexible work arrangements

Professional development programs

Employee wellness platform

Qualifications

• 5+ years of experience in Data Warehouse, ETL, Business Intelligence solutions.
• 3+ years working with Azure Data Lake and Data Factory.
• Experience creating reporting and data visualization solutions.

Responsibilities

• Design and support Azure data warehouse pipelines using Azure Data Factory.
• Manage Data Lake ingestion and data source staging.
• Collaborate with IT and business users on data requirements.

Skills

Data Warehousing

ETL

Business Intelligence

Azure

Data Modeling

SQL

Power BI

Azure DevOps

Education

Bachelor's Degree

Degree in Information Systems, Computer Science, or related discipline

Tools

Azure Data Factory

Azure Databricks

Power BI

Job description

BI Data Warehouse Architect | Technology (Remote)

FTI Consulting is the leading global expert firm for organizations facing crisis and transformation. We work with many of the world’s top multinational corporations, law firms, banks and private equity firms on their most important issues to deliver impact that makes a difference. From resolving disputes, navigating crises, managing risk and optimizing performance, our teams respond rapidly to dynamic and complex situations.

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 BI Data Warehouse Architect is responsible for designing and maintaining the overall lifecycle, infrastructure and related services for Data Warehouse and BI solutions within a 24x7 environment utilized for key reporting, decision support, and analysis. This role’s core responsibilities will include managing Azure Data Factory pipelines, Data Lake storage, Databricks processing and the overall health of the Data Warehouse and BI implementations while monitoring cost as well as compliance related to global data governance regulations.

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
• 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
• Create ad-hoc and enterprise Power BI Solutions with Power BI Desktop/Service, Power Query, DAX (Data Analysis Expressions) language, data modeling, visualizations, and dashboards
• Actively review and improve Azure data warehouse code and pipelines
• Utilize Azure DevOps for source code management, feature/functionality documentation, task management, and bug/issue tracking/reporting
• Create logging and monitoring of new and existing pipelines
• Develop cost controls and IT governance utilities around operational tasks
• Collaborate with other IT infrastructure and development teams
• Help enforce systems engineering and DevOps standards and best practices
• Partner 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

• Bachelor’s Degree
• 5+ years of 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
• Ability to work an on-call support schedule if/when needed
• 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 related discipline
• Experience with Azure SQL, SQL Server, MySQL, Elasticsearch
• Experience with Spark SQL and Python scripting within Azure Databricks
• Experience creating reporting and data visualization solutions with Power BI
• Proficiency with Azure DevOps (ADO) services
• Experience working with APIs to develop custom application integrations
• Adept with source control methods and technologies
• Experience working within an Agile SDLC methodology and/or Scaled Agile Framework (SAFe)
• Experience with dimensional modeling as well as working knowledge of relational database design, logical data modeling and relational database management systems
• The ability to troubleshoot and resolve issues with a strong sense of urgency under minimal supervision
• Experience defining and documenting requirements for data extraction
• Ability to develop and maintain strong relationships with key stakeholders and other teams
• Azure, Databricks, and/or Microsoft certifications

#LI-DB1

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, Inc. is the leading global expert firm for organizations facing crisis and transformation, with more than 8,300 employees located in 34 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. The Company generated $3.49 billion in revenues during fiscal year 2023. In certain jurisdictions, FTI Consulting’s services are provided through distinct legal entities that are separately capitalized and independently managed. FTI Consulting is publicly traded on the New York Stock Exchange. 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.

Additional Information

• Exempt or Non-Exempt?: Exempt
• Employee Status: Regular

Compensation

Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

United States, District of Columbia, Washington

At FTI Consulting, our goal is to attract, hire, acquire, develop and, most importantly, retain the best and most talentedpeople in the world. As our company continues to grow, we remain focused on building and maintaining a strong cultureof diversity and inclusion. All qualified applicants will receive consideration for employment without regard to race,color, religion, creed, national origin or ancestry, gender, age, marital status, sexual orientation, status as a qualifiedindividual with a disability, status as a protected veteran, union affiliation, genetic information, sex, citizenshipstatus, or any other factor prohibited by law.