Cloud Business Intelligence Engineer

Cloud BI, advanced SQL, AWS, Microsoft Azure, or Google Cloud
Full Time
$120,000 - $140,000
Work from home available

Job Description

*This position is available for remote start until the current Covid situation is under control, there after our client will require the hired individual to be onsite in Orlando, FL. 

Managers Notes:

  • Minimum 9 years of experience in creating logical and physical data models; demonstrated experience with relational and star schema data modeling, and the different methodologies
  • 3 years’ experience with Cloud BI implementation and architecture
  • Advanced SQL skills
  • Candidates should have experience designing and building on Oracle platforms
  • Experience with Informatica is “nice to have”
  • Strong data warehouse experience, this position requires heavy data analysis and data quality
  • Familiarity working with major cloud based data and analytics platform implementation (either AWS or Azure would be preferred) would be nice to have
  • Even though this person will be working as an “Individual Contributor”, it is important that this person also have strong leadership, mentoring, and customer service skills

Job Description:

CLOUD BUSINESS INTELLIGENCE ENGINEER

The Cloud BI Engineer works cross-functionally to define develop and implement the data architecture for our enterprise data. This includes working closely with business users to define data requirements, develop the data architecture design, create logical data models, implement and optimize the physical data models. The Cloud BI Engineer will also assist in defining and documenting the technical architecture of the business intelligence platform, including the physical components and their functionality. This position will have broad knowledge of data sources, data integration and data flow. The Cloud BI Engineer will play a critical role in the successful migration of current BI and analytics platforms to our new Cloud infrastructure, as well as ensuring ongoing support to ensure accuracy and value.

ROLES AND RESPONSIBILITIES:

Architecture

-Develop and maintain enterprise data strategies and roadmaps

-Work closely with users to interpret the data needs of the business and translate to logical / physical data models and designs

-Guide design of target zone of the Data Lake and determine specification of transformations between data tiers

-Designs, builds and oversees the deployment and operation of technology architecture, solutions and software to capture, manage, store and utilize structured and unstructured data from internal and external sources.

-Assist in the development and implementation of our migration from on-prem Oracle EDW to a cloud-based EDW (i.e. Snowflake)

-Partner with enterprise architecture team and application teams to determine best practices and solutions

 

Data Engineering

-Evaluate and conduct POC on new technologies for fit in data ecosystem; be able to clearly communicate learnings to broader team

-Design and develop cloud-based data pipelines, ELT, storage solutions, and workflows that are optimized for speed, fault-tolerance, and scalability

-Define robust data schemas for the rapid intake and processing of customer data with diverse structures

 

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 our data domains

-Conduct discovery, perform root cause analysis, and make recommendations for the remediation of data quality issues

-Design and recommend data policies, governance structures, and control frameworks for the ongoing management of data

-Define, maintain and report on data quality metrics

 

 

 

REQUIRED TECHNICAL SKILLS:

-Minimum of 9 years of experience in creating logical and physical data models; demonstrated experience with relational and star schema data modeling

-Minimum of 3 years of experience with Cloud BI implementation and architecture

-Expertise using data modeling tools; excellent advanced SQL skills required

-Experience designing, building, and maintaining highly distributed or event-driven systems

-Knowledge of business intelligence tools, standards and best practices

-Strong analytical and conceptual design skills

-Experience with big data, semi-structured data

-Experience with database and data warehouse services in Snowflake and experience with SQL and NoSQL databases

-Relevant software engineering experience (Python, Scala and Java) in a data-focused role

-Familiarity working with one major cloud based implementation - AWS, Microsoft Azure, or Google Cloud

 

REQUIRED EDUCATION:

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

 

OTHER KEY QUALIFICATIONS:

-Strong analytical skills with ability to collect, organize, analyze, and disseminate information with an attention to detail and accuracy

-Exceptional verbal and written communications skills, with an ability to express complex concepts in simple 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

 

PREFERRED SKILLS AND EXPERIENCE:

-Experience in migrating from on-premise enterprise data warehouse to cloud-based

-Experience in development of reporting and analytics business capabilities, strategy and roadmap

-Demonstrated competency in accurately scoping and estimating work

-Experience with/knowledge of canonical models and enterprise data architectural standards, with a long-term outlook

-Familiar with concepts of Operational Data Store (ODS) and its role in overall ecosystem

-Experience with/involvement in data governance

-Knowledge of restaurant or retail business

-Advanced degree preferred

Dice Id : 10447565
Position Id : CLDFL
Originally Posted : 9 months ago
Have a Job? Post it

Similar Positions

Google Cloud Platform Data Engineer
  • Apex Systems
  • Orlando, FL, USA
Cloud Data Engineer - VIRTUAL/REMOTE
  • Publix
  • Lakeland, FL, USA
Data Engineer
  • Apex Systems
  • Orlando, FL, USA
SENIOR PROGRAMMER ANALYST - ENTERPRISE DATA WAREHOUSE
  • TITAN TECHNOLOGIES
  • Orlando, FL, USA
Big Data Analytics Engineer
  • Berean Group International, Inc.
  • Melbourne, FL, USA