BI TECHNICAL DEVELOPER/ARCHITECT

30-year-old Technology Project Management Consulting Firm is searching for a Technical Lead / Architect with BI/Data Warehouse technology experience for a full-time role.

ABOUT COMPANY

For over 30 years, this organization has been an industry leader providing Technology Project Management, Project Management and Project Control Solutions to their clients. Focusing in the Transportation, Utilities, Oil, Gas, Water and other Industries, their Professionals have worked on some of the largest Projects throughout the US.

ABOUT ROLE

The Technical Lead / Architect experienced with BI/Data Warehouse technology will be responsible for solution development and the technical design and build for the BI Project. The Technical Lead will work within the BI Team as described herein, taking direction from the ITS PM. The Technical Lead shall work as a team member to implement a robust BI-solution to be rolled out in multiple stages. This is an on-site role at Los Angeles Union Station.

Responsibilities will include, but are not limited to:

Work with the BI Project Team in defining a comprehensive technical solution design capable of satisfying Organization’s objectives and goals for the BI/Dashboard initiative and communicate the solution design to multiple audiences.

Team with other BI Project members to produce BI technical specifications for custom OBIEE/Power BI / Tableau configurations and data warehouse design to achieve BI solution objectives.

Produces detailed technical design documents to match the solution design specifications.

Completes/oversees the custom development and quality assurance efforts for BI configuration and custom development work.

Participates and lead, when needed, the BI Project meetings with the customer to gather requirements (functional and technical).

Provides quality reviews during development of BI solution designs through multiple project stages to ensure consistency.

Provides knowledge transfer to Organization’s IT staff.

Apply consulting and technical skills in the management of the entire project and tasks which may include:

Consulting with and advising the IT PM on planning, implementation methodology, scope definition, training, resource planning and other matters as needed to ensure a timely and successful completion of the different phases of the project.

Scoping and planning major business-driven BI Project activities and engagements.

Working with the PM, maintaining a mutually agreeable project work plan and timeline with key milestones.

Managing mixed teams to complete project work in accordance with established budget, work schedules and quality standards.

Identifying and resolving functional and technical issues critical to the project’s strategic and operational success.

PM shall update Organization’s Issue Tracking System.

Providing functional and technical content for project deliverables.

Attending technical meetings as required to discuss technical aspects of the project and reviewing comments on the documents submitted for approval. NOTE: When appropriate, these technical meetings shall be conducted as extensions to the progress meetings.

Developing conclusions and presenting/selling recommendations to senior business and IT management personnel.

Providing solution implementation assistance as required. Proposing and following “Industry best practices and methodologies” in all phases of the project.

Adapting materials from leading industry insights to present to clients

Managing stakeholder relationships and reporting project progress.

Leading, coaching, developing and supervising the efforts of assigned project staff.

Participates in the design of data architectures.

Designs, configures and builds databases that are used in relation with data architectures.

Maps data elements and translates data so that it can be shared among various application systems.

Assists in the development of strategies for data archive/recovery, database implementation and data acquisition.

Cleans and maintains data warehouses by restructuring and deleting old data.

Works with a database/data warehouse team to map data elements between various data storage technologies and defines ETL logic to move data between locations.

Develops detailed documentation for custom ETL data maps.

Develops OBIEE /FSG/other reports.

REQUIREMENTS

Experience with:

Oracle OBIEE (10 years’ experience or more)

Power BI (five years’ experience or more)

Tableau (three or more years’ experience) 10 years or more (combined) performing the below activities:

ETL technologies like (Oracle Data Integrator/Informatica/ etc.)

Data Modeling f. Ability to lead a client engagement team through the entire life cycle of a BI project.

Ability to facilitate the collection of key requirements and customer needs for an overall BI solution.

Ability to lead the preparation of a conceptual design for an overall BI solution.

Ability to lead the design and implementation of a BI solution using leading BI technology vendors.

Ability to effectively operate independently and in a team environment.

Exceptional understanding of data integration tools within targeted industries.

Familiarity with Oracle EBS data structure, tables, and reports.

Outstanding verbal and written communication skills

Microsoft products including SQL, SharePoint, etc.

Experience in meta-data management and data integration engines.

Knowledge of the entire software development process from design through deployment; Proven analytical and problem-solving traits.

Knowledge of the design, development and maintenance of various data models and their components.

Understanding of BI tools and technologies as well as the optimization of underlying relational and multi-dimensional databases.

Approximate Salary range $120,000 - $165,000 with potential bonus.

Disclaimer

The job description is only a summary of the typical functions of the job, not an exhaustive or comprehensive list of all possible responsibilities, tasks, and duties. The responsibilities, tasks, and duties of the jobholder might differ from those outlined in the job description and that other duties may be assigned. Duties, responsibilities and activities may change at any time with or without notice. SmartHire is not legally responsible for any change of job-holder's responsibilities or activities, by our clients, that differ from this job description.