BI Architect

Architect Application/Product IV

Minimum Education and Experience

Does this position have any direct reports?

No

Is travel required for this position?

Minimal

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Work with business users and stakeholders to define and analyze problems and provide optimal technical solutions.
• Translate business needs into technical specifications and design functional BI solutions.
• Present architecture and solutions to executive-level.
• Adhere to industry best-practices in all phases of design and architecture of the solution.
• Ensure the robustness and reliability of BI solutions during development, testing, and maintenance.
• Document all aspects of the BI system for future upgrades and maintenance.
• Provide guidance to ensure data governance, security, and compliance best practices in the architecture.

REQUIRED SKILLS & QUALIFICATIONS

TECHNICAL SKILLS:

• Data Modeling:

  Expertise in dimensional modeling, normalization/denormalization and other data modeling techniques

• ETL Processes:

  Proficiency in extract, transform, and load (ETL) processes.

• SQL and Database Design:

  Strong SQL coding skills and knowledge of database design principles.

• BI Platforms:

  Experience with any of BI platforms preferably Power BI

• Data Warehousing:

  Knowledge of data warehousing concepts and tools

• Cloud Services:

  Experience with cloud platforms such as AWS, Azure, and Google Cloud

• Data Governance:

  Understanding of data governance and data quality management

• Scripting Languages:

  Proficiency in scripting languages like Python, R, or Java

MINIMUM QUALIFICATIONS

• 8 + years of end-to-end design and architecture of enterprise level data platform and reporting/analytical solutions.
• 5+ years of expertise in real-time and batch reporting, analytical solution architecture.
• 4+ years of experience with PowerBI, Tableau or similar technology solutions

ADDITIONAL QUALIFICATIONS

• 8 + years of experience with Dimensional modeling and data lake design methodologies.
• 8+ years of experience with Relational and Non-relational databases (e.g. SQL Server, Cosmos, etc.)
• Experience with working with business stakeholders, requirements & use case analysis.
• Strong communication and collaboration skills with creative problem-solving skills.

PREFERRED QUALIFICATIONS

• Bachelor's degree in computer science or equivalent work experience.
• Experience with Agile/Scrum methodology.
• Experience with tax and accounting domain a plus.
• Azure Data Engineer certification a plus.