General Purpose :
We are seeking motivated and talented strong AWS Redshit Experience with Business Intelligence and Datawarehouse experience who enjoys working with data and latest technologies to deliver compelling solutions that integrate disparate systems such as ERP, CRM, POS, Cloud business solutions, social media and emerging solutions data.
The candidate must have an in-depth understanding of the business environment and a curiosity to go beyond the obvious by delving into the source, definition and foundational roots of data element in order to create information.
The candidate must have a proven track record in architectural design and development, with a focus on planning, deploying and supporting enterprise-
level Business Intelligence implementations. Position Summary, Responsibilities and Expectations :
Candidate will be expected to be a self starter and quickly understand the requirements and detailed data ecosystem of the enterprise applications
Collaborate as part of a team representing the enterprise application, infrastructure (server, storage, networking, database,etc.
interface development, security
Create and champion recommendations, guidelines, practices, and design models for the enterprise data architecture. Create conceptual, logical and physical data models and determines the most appropriate method to represent the data for business consumption
Provide data solutions that are accurate, reliable, and ensure information is easily available to users for direct consumption or integration with other systems.
Educate and train clients to use the solution(s) as an analytical and exploratory tool
Architect and build the enterprise data warehouse and analytics platform
Primary technical owner of the business intelligence and analytics infrastructure and systems, responsible for the design, architecture and maintenance of those systems
Engage with Executive Committee members, Directors, Managers and Subject Matter Experts to discuss and assess their BI / Analytics needs
Act as project manager and business analyst to create project plans, establish business requirements and priorities, define key performance indicators and BI and data warehousing strategies.
Ensure new BI projects are carried out in a controlled manner and meet stakeholders expectations
Create and maintain BI program documentation, including policies, standards, baselines, guidelines and procedures; and incorporate the maintenance of this documentation into project life cycles.
Act as the primary owner for reviewing enhancements and change requests to existing BI solutions. Determine feasibility, establish timelines and manage expectations
Maximize the ongoing investment in BI technologies by evaluating available features and staying attuned to vendor announcements, upgrades and updates.
Ensure the BI infrastructure is maintained and updated as needed.
Act as the primary owner for reviewing data inconsistencies. Working with Subject Matter Experts for the data source, troubleshoot and perform root cause analysis as the primary investigator for all BI issues originating from these systems
Act as an in-house expert to mentor and assist technical staff in mastering techniques and best practices associated with : data modeling;
data warehouse, data lakes, and database design and optimization and related activities
Essential Skills and Experience :
Demonstratable examples of resourcefulness and experience working in a small team to lead and implement enterprise solutions
Proven track record of continuous learning and certifications are a plus
Excellent interpersonal and organization skills are essential
Need to have the ability to handle diverse situations, multiple projects and rapidly changing priorities
Needs to be a self-starter who requires minimal supervision and is passionate about solving complex business problems and recommend alternative solutions.
Ability to independently plan and manage tasks
Strong experience in information technology data analysis and architecture
Knowledge of both established and emerging data technologies, ability to identify when each can be effectively applied.
Ability to document the pros and cons of each and to make a final recommendation
Preferred knowledge of general roadmap of Business Intelligence
Ability to come up with the best solution for given requirements
Data profiling & Data mapping
Data modeling conceptual, logical, physical, and relational
Data cleansing and visualization Database design (logical and physical).
Dimensional modeling and abstraction layer concepts.
Understanding of modern data warehousing and big data tools and architectures.
Ability to provide reasonably accurate estimates for projects
Familiarity with Agile development methodologies
Preferred knowledge of Oracle ERP systems , Supply Chain Business Process
Preferred knowledge of dashboard design with a working knowledge of Tableau
10 years of experience in the Data Analytics and Architecture
Expert knowledge of AWS Redshift, Design & Develop ETL programs
Possess excellent communication, sharp analytical abilities, and proven design skills
Must be hands-on with Data Integration , Java , Python