Job Description

Job Title: Business Intelligence Architect
Job Location: Anywhere in India (Work from home) Job Overview: The Business Intelligence Architect will be responsible for supporting the building of data-driven solutions that are critical to enterprise decision-making, operational support, and analytical insight. You will also provide leadership, direction, and planning with a primary focus on the design and implementation of analytic solutions including enterprise data warehouse, business intelligence, and analytics needs.
Job Duties and Responsibilities: Includes duties of Business Intelligence Architect:

• Define, design, and implement Business Intelligence (BI) and Data Warehouse (DW) strategies for operational, ad-hoc, and other BI-related solutions.
• Assist in the definition, documentation, and development of mapping rules for movement of data from disparate data sources and into the various components and subject areas of the BI environment.
• Create data models including robust data definitions, entity-relationship-attribute models, as well as dimensional models.
• Transition logical models to physical implementation of data structures.
• Design and architect enterprise BI systems from conceptual to physical implementation and operations
• Establish best patterns, practices, and standards as new technology arises.
• Define development and production infrastructure needs and best practices.
• Ability to move between high-level architectural review/design and the "roll up the sleeves" level of providing architectural oversight for BI delivery.
• Partner with Director to develop comprehensive implementation plans along with delivering the output as defined in the release plans.
• Provide hands-on data modeling (dimensional) for Data Warehouse and overall BI environment.
• Provide best practices and guidance regarding use of ETL, data modeling (relational and dimensional), and reporting deliverables.
• A good understanding of the design and development of complex business reports.
• Design and build complex relational data structures.
• Work with business analysts to understand requirements then identify, and design multiple solution options as well as determine and recommend a right-sized approach.

Supervisory Responsibilities:

• Mentor and lead all stages of design and development tasks performed by Business Intelligence Specialists.

Qualifications:

• Degree in Information Systems, Computer Science, or equivalent education and/or experience.
• Minimum 5-7 years experience in T-SQL programming.
• Minimum 5-7 years in ETL/ELT development, preferably some experience in Azure Data Factory or Synapse Workspace.
• Minimum 5-7 years of experience with Dimensional (Star Schema) Modeling in enterprise data warehousing systems, preferably some experience in Azure SQL Database or Azure Synapse Analytics.
• Minimum 5-7 years of experience in Report Development, preferably some experience in Power BI.
• Familiarity with data security, storage solutions, database virtualization, and replication.
• Ability to adapt to a fast-paced, ever-changing environment
• Ability to meet deadlines and attention to detail

#LI-XX1 The company will not accept unsolicited resumes from third party vendors.