Lead Business Intelligence and Analytics Architect - Federal

• The Lead Business Intelligence Architect will be responsible for database architecture, design, and implementation for the new Federal EAP Data Warehouse.
• The ideal candidate will thrive in collaborative environments, capable of managing a dynamic data environment still in infancy with significant growth soon.
• The candidate should have experience architecting modern business intelligence products using cloud-native development strategies in AWS Redshift / S3.  Medallion architecture experience is a plus.
• This person will be responsible for ingestion strategies, storage strategies, data model design, and data processing logic, while ensuring that our solution adheres to broader Magellan Data principles and architectures.
• This candidate should have experience with Tableau Reporting and Tableau Data Sources, understanding the impact of data warehouse design on Tableau Data Source design.
• The candidate will lead and mentor other developers, providing leadership to our data team and guidance and coaching towards best practices and consistent solution approaches.
• Above all else, the candidate will act as a servant leader, supporting the development team and the organization with authenticity, integrity, and empathy.

This position is responsible for providing the guidance and vision to identify the enterprise core technologies necessary to drive consistent and valuable Business Intelligence (BI) solutions. This role leads tactical business initiatives and formulates a design plan that factors technology investments and risks while providing value to the company. The position manages the technological components for business plans ensuring compliance with existing enterprise regulations while addressing any security risks. The role has oversight for the efficient use BI resources to reduce costs and ongoing maintenance.

• Define the Business Intelligence (BI) technology strategy for implementing enterprise, self-service architectures.
• Collaborate with IT in the building and maintaining  enterprise Information Flow models and Reference Data Management strategy.
• Partner with cross-functional business leads and teams to deliver on strategic data and analytics initiatives.
• Work directly with BI architects to align domain solutions to the enterprise architecture and solve integration problems across multiple systems.
• Influence the BI team to apply industry and domain best practices, methodologies and processes for Data Governance.
• Coordinate the training and communication of Information architecture across the company.
• Identify business opportunities for applying leading and emerging information technologies at Magellan and drive and develop framework ensuring business smart resource allocation.
• Drive successful installations, configuration, performance tuning and Qlik environment optimization.
• Lead analysis, design and development of Qlik framework and client-facing applications and assist customers with capacity planning for Qlik environment scalability.
• Recommend standard design patterns commonly used in Hadoop-based deployments.
• Research, evaluate and adapt to new technologies and help project trends for future.

Other Job Requirements

Responsibilities

Bachelor’s degree and 10+ years of experience as Business Intelligence/Analytics Architect or higher degree (Masters/Ph.D.) with 7+ years experience as a BI/analytics architect.
May consider additional experience in lieu of degree,
Experience leading and implementing enterprise-scale data model and analytical systems.
Strong business and IT background to architect software, hardware, network or any IT solution that gives the best results to the business.
The ability to translate business issues / requirements and objectives into technical solutions.
Strong knowledge of IT business processes and practices & skilled in partnering with internal customers at all levels to define problems, identify solutions, and be a change agent to promote positive change in the organization.
Proficiency in Big Data, Cloud & Hadoop-related tools and technologies.
Proficiency with Business Intelligence technology, data modeling and cube design (Tableau, Qlik, PowerBI, Cognos, MicroStrategy, Business Objects, SSAS).
Knowledge of distributed systems, complex data pipelines and data transformation concepts.
Strong history and track record of completing quality projects on time, as well as coaching and mentoring others to success.
Requires strong analytical, conceptual and problem-solving abilities.
Ability to manage multiple priorities, and assess and adjust quickly to changing priorities. 
Must possess combination of technical depth, written/verbal communication and client m