BI Data Warehouse Architect | Technology (Remote)
Job title: BI Data Warehouse Architect | Technology (Remote) in New York City, NY at FTI Consulting
Company: FTI Consulting
Job description: Who We AreFTI 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 RoleThe 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 GrowWe 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 SucceedBasic 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#LI-RemoteTotal WellbeingOur 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 ConsultingFTI 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 and connect with us on and .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
Job Family/Level: Op Level 3 - Director - Tier 1
Payroll Expense Type: Direct (Billable)
Employee Status: Regular
Compensation
Minimum Pay: 84500
Maximum Pay: 202000
Expected salary:
Location: New York City, NY
Apply for the job now!
Apply Now
Company: FTI Consulting
Job description: Who We AreFTI 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 RoleThe 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 GrowWe 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 SucceedBasic 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#LI-RemoteTotal WellbeingOur 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 ConsultingFTI 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 and connect with us on and .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
Job Family/Level: Op Level 3 - Director - Tier 1
Payroll Expense Type: Direct (Billable)
Employee Status: Regular
Compensation
Minimum Pay: 84500
Maximum Pay: 202000
Expected salary:
Location: New York City, NY
Apply for the job now!
Apply Now