Business Intelligence Data Architect

  • FL-436, Orlando, FL, USA
  • Contract

Company Description

CompuGain is an Information Technology and Business Consulting firm providing project-based solutions, software solutions, and professional staffing services. 


Job Description

Job Description:
The Cloud Business Intelligence (BI) Data Architect works closely with information technology and business leaders/partners to define, develop and implement the data architecture for enterprise data. This includes working closely with business users to define data requirements, developing the data architecture design, creating logical data models, and implementing and optimizing the physical data models. The Cloud BI Architect will also assist in defining and documenting the technical architecture of the business intelligence platform, including the physical components and their functionality. This position requires experience and technical expertise in the structure, care, and feeding of a multi-zone data lake and cloud-based data warehouse. This position will have broad knowledge of data sources, data integration and data flow. The Cloud BI Architect is a champion for data analysis and logical data modeling and provides technical mentoring to other IT staff to support skills development. The Cloud BI Architect will play a critical role in the successful movement of current BI and analytics platforms to the new Cloud infrastructure, as well as ensuring ongoing support to ensure accuracy and value.

Data Management
Developing and maintaining enterprise data strategies and roadmaps
Developing and maintaining guest/customer data management strategies, models and designs
Work closely with business users to interpret the data needs of the business and translate those to logical / physical data models and data designs
Detailed design and QA of data integration, including advanced SQL analysis
Guide specification of target zone of the Data Lake and determination and specification of transformations between data tiers
Guide and oversee data warehouse structures and platform using industry best practices
Assist in development and implementation of plans for movement of on-premise Oracle EDW to a cloud-based EDW (i.e. Snowflake)
Determine/implement best practices for sharing cloud-based data with external partners
Partner with enterprise architecture team and application teams to determine best practices and solutions
Design and implementation of cloud-based ELT
Document data management processes and mentor other IT staff to develop data analysis and modeling skills
Monitor Cloud data usage to help optimize data consumption and cost

Data Quality and Governance
Contribute to the establishment of a Data Governance Practice. Participate in the creation of standards and processes that maintain the quality of data domains
Conduct discovery, perform root cause analysis, and make recommendations for the remediation of data quality issues
Design and recommend data policies and governance structures and control frameworks for the ongoing management of data
Define, maintain and report on data quality metrics


Minimum of 9 plus years of experience in creating logical and physical data models; demonstrated experience with relational and star schema data modeling
Minimum of 3 plus years of experience with Cloud BI implementation and architecture
Expertise using data modeling tools; excellent advanced SQL skills required
Superior business analysis and problem-solving skills
Knowledge of business intelligence best practice processes, tools, standards and practices
Strong analytical and conceptual design skills
Experience with big data, semi-structured data
Experience with BI tools and visual reporting platforms from an architecture standpoint
Familiarity working with one major cloud based data and analytics platform implementation - AWS, Microsoft Azure, or Google Cloud
Demonstrated experience and success in facilitation and definition of reporting and analytics business requirements
Experience with/knowledge of canonical models and enterprise data architectural standards, with a long-term outlook

BS / BA in Computer Science, Business, Mathematics or Engineering

Attention to detail and commitment to quality
Exceptional verbal and written communications skills, with an ability to express complex technical concepts in business terms
Must have excellent client-facing skills; solid teamwork and interpersonal skills; strong ability to work independently when appropriate
Ability to manage multiple assignments and projects simultaneously with a track record of project completion

Experience in development of reporting and analytics business capabilities, strategy and roadmap
Demonstrated competency in accurately identifying the scope of work and preparing thorough, accurate and detailed schedule estimates
Experience in migrating from on-premise enterprise data warehouse to cloud-based
Experience implementing a data lake
Experience with/involvement in data governance
Knowledge of restaurant or retail business
Advanced degree preferred

Regards Jagdish

Additional Information

All your information will be kept confidential according to EEO guidelines.