Business Intelligence Solution Architect

13 Oct 2024

Vacancy expired!

Job Description:

The business intelligence (BI) and data warehouse (DW) Solution Architect will focus on delivering the vision of the organization through process, development, and lifecycle. You will work directly with stakeholders and team members to define, design, and deliver actionable insights while working with ETL developers and BI developers in an agile environment. Primary Job Duties :
  • Identify, publish and communicate strategic technology BI standards, frameworks, principles and roadmaps to be used throughout the IT organization.
  • Interview stakeholders and work closely with IT leadership to develop BI roadmap for success given project prioritization and budget.
  • Champion data quality, integrity, and reliability throughout the BI by designing and promoting best practices.
  • Develop, administer, and maintain reporting data models and semantic layer.
  • Design, develop and deploy Enterprise BI solutions that leverage common data architecture and data optimization approaches
  • Incorporate User Feedback to promote analytics self-service and drive adoption
  • Collaborate with Power Users to enable Analytics Agility, faster Report creation and insights
  • Create Training Materials and administer end-user training
  • Coordinate with user community to increase proficiency, standardized approaches, and empower the data literacy of the organization.
  • Administer and Monitor Power BI Service including usage, capacity, and performance tuning needs.
  • Ability to provision assistance to team members with issues needing technical expertise or complex systems and/or programming knowledge.
  • Provide on-the-job training for new or less experienced team members.
  • Provide technical training to external team members to foster stronger cross-departmental relations.
  • Educate and guide engineers in the vision and use cases of specific solutions within the Enterprise Architecture portfolio.

Requirements Experience and Requirements:
  • 5+ years of experience delivering business intelligence solutions
  • 5+ years of experience with OLTP and OLAP database models
  • Experience in a lead role engaging with key business stakeholders and IT teams to deliver large scale analytics solutions and projects
  • Strong problem solving, time management and organizational skills
  • Proven analytical thinking for translating data into informative visuals and reports.
  • Fluent in relational database concepts and flat file processing concepts
  • Must be knowledgeable in software development lifecycles/methodologies
  • A solid understanding of security models in Power BI and row level restrictions.
  • Exceptional customer service skills, including the ability to interact professionally with a diverse group of customers.
  • Experience in data modeling, designing data warehouses/data marts and reporting, dashboarding, and advanced analytics solutions
  • Has strong presentation and collaboration skills and can communicate all aspects of the job requirements, including the creation of formal documentation
  • Bachelor's Degree in related field or equivalent experience
  • Technical skills:
    • Database: Microsoft SQL Server, Oracle, SAP Hana, Azure SQL, Cosmos DB
    • ETL: SAP Data Services, SSIS, DataStage, Azure File Explorer
    • BI Technology: Microsoft Power BI, SAP Business Objects (BOBJ), SSRS, SSAS
Skills and abilities:
  • Effective oral, written, and interpersonal communication skills.
  • Effective presentation skills.
  • Collaborates and openly seeks and shares information across teams and departments.
  • Takes initiative to complete critical tasks and overcomes obstacles in a proactive manner.
  • Works well in a growing, fast-paced, entrepreneurial environment.
  • Keeps informed on the latest technological approaches and trends in his/her technical field.
  • Brings a work ethic that inspires your fellow team members to give their best.
  • Experience in DW concepts (Dimensional Modeling, Star, Snowflake schemas, Security and deployment, Dimensions/Facts tables, Logical and Physical data modeling)
  • Proficient in database design, data modeling for transactional, DW, data mart, and application solutions.

  • ID: #21052169
  • State: Texas Irving 75014 Irving USA
  • City: Irving
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2021-10-13
  • Deadline: 2021-11-20
  • Category: Architect/engineer/CAD