BI Engineer (Data Warehouse)
Utilities/Energy company
Utilities/Energy company
Jacksonville, FL 32256
W-2 onlyPermanent Position27234 views
Jacksonville, FL 32256
Permanent Position
Questions?
Click to chat now!
Your Recruiter
Marshall Exline
Recruiter and Account Manager
This posting has been closed

We are looking for an IT Business Intelligence Engineer who is an innovative individual with a proven track record of building enterprise level platform components to support product development from multiple teams and lines of business. This role is expected to drive innovation through collaboration across our business to help push us to the next level. The team is embarking on a journey of building a new data lake platform using cloud native concepts and the latest tech stacks. This position is a highly visible role within the organization. Additionally, the candidate will work with modern data warehousing technologies such as Snowflake, Airflow, Docker and more. In this role you'll be working in tandem with BI & Reporting analysts and managers to assure that we have the right data at the right time to support our business needs. All of this in support of our “single source of truth” and continuing our progression up the analytics maturity curve towards pervasive predictive and prescriptive analytics. With us you'll collaborate with a creative, analytical and data-driven team to over 1500 employees in a culture that values innovation and teamwork.

RESPONSIBILITIES

  • Design and build reporting and analysis tools that will help streamline business and make reporting, analyzing, planning and forecasting more efficient.
  • Experience with database design, architecture and warehousing with a focus on process automation
  • 3+ years of experience in building ETL pipeline using Spark for moving data in/out of Data Lake
  • Working knowledge of cloud data platforms (Azure or Amazon). Preferably experience with Azure Data Lake, Data Warehouse, Synapse Analytics, Amazon Redshift, Data Factory, Logic Apps, Data Bricks, Advanced T-SQL, REST API concepts, Powershell, SSIS, PowerBI.
  • Experience in database design, architecture, and warehousing as well as building, implementation, and optimization of BI solutions/technologies.
  • Create ETL/ELT processes to move data between internal and external sources using APIs, ETL using technologies like Azure Data Factory, Loom Integrate or Matillion
  • Play an instrumental role supporting and managing the Data Warehouse strategy including fundamental understanding of Data Lakes, Data Catalogs, Hardware and Network Topology
  • Experience with Object-Oriented Programming Languages such as Python, JavaScript, Java, and/or C#
  • Experience using data reporting, BI, and visualization tools including preferably experience with SSRS, Data Studio, Power BI, Tableau.
  • Passionate about data and contributing to the growth of a data driven organization including conceptual knowledge of Algorithmic concepts, gathering data, Data Governance concepts.
  • Should be an excellent communicator and should possess excellent debugging skills and problem-solving skills. Ability to tackle complex problems with creative solutions when the path may not be clear.
  • Familiar with Standup, Sprint Planning, Backlog grooming, Demo, and all other Scrum Ceremonies.
  • Experience with real time data ingestion using Kafka.
  • Experience with CI/CD pipelines with Jenkins, Bitbucket, GitHub, etc.
  • Experience with Data Analysis.
  • Improves quality results by implementing unit, system and integration testing cycles.
  • Maintains product quality by designing and executing testing.
  • Present to Director IT reports weekly on progress as well as problems and solutions
  • Excellent oral, written, presentation and interpersonal communications skills; Ability to effectively exercise tact, discretion, judgment and diplomacy when interacting and/or negotiating with internal and external customers
  • Understanding of agile application development and software development life cycle concepts.
  • Working knowledge of current network hardware, protocols, and standards.
  • Experience in Microsoft Azure DevOps desirable
  • Experience in Power BI, MS Project, Visio, Workflows, Process Maps

Business Intelligence Development

  • Take a lead role in enhancements of core applications and contribute to development where required
  • Implement current industry standard tools & technologies to support development and maintenance of systems and business intelligence tools
  • Ensure planning, requirements analysis, designing, building and testing is performed to a high standard
  • Identify opportunities for process improvement through automated system integrations
  • Implement strategies for maintaining and securing corporate data with a focus on single source of truth to enable improved data warehousing and reporting capability

Strategic Focus

  • Develop systems with a focus on future proofing
  • Identify opportunities for reducing costs and increasing the value
  • Work collaboratively with the managers to identify opportunities for improvement
  • Facilitate informed strategic debate, planning & decision making with the management team
  • Provide high level strategic advice to the Senior Manager with supporting data and information

EDUCATION

  • Bachelor’s degree in IT or related field IT of education, training, and/or experience required.
  • 2-5 years of business intelligence data engineering experience, including large-scale complex data warehouses, data lakes OR equivalent experience

MINIMUM REQUIREMENTS

  • In-Depth understanding of data warehouse design (e.g. dimensional modelling)
  • Proficiency in Microsoft Office Products
  • Ability to work independently, with limited required direction and guidance.
  • Analytical and Problem-Solving Skills
  • Experience with Snowflake database is plus.

CORE COMPETENCIES

  • Leadership
  • Results-Driven
  • Builds Organizational Talent
  • Financial Business Acumen
  • Business Judgment
Skills
Skill Proficiency Years Experience Percent Used
ETL
Any100%
MS Azure
Any100%
Spark
Any100%
Business Intelligence
3 - 675%
Data Analysis
Any75%
Data Lakes
Any75%
Data Warehousing
Any75%
MS Power BI
Any75%
MS Project
Any75%
Snowflake
Any75%
SSRS
1 - 375%
Agile Methodology
Any25%
Azure Data Bricks
Any25%
Azure Data Catalog
Any25%
Azure Data Factory
Any25%
C#
Any25%
Continuous Deployment
Any25%
Continuous Integration
Any25%
Data Engineering
Any25%
Data Governance
Any25%
Database Design
Any25%
Database Maintenance
Any25%
Devops
Any25%
Docker Containers
Any25%
Java
Any25%
JavaScript
Any25%
Jenkins
Any25%
Microsoft Excel
Any25%
PowerShell
Any25%
Process Improvement
Any25%
Python
Any25%
REST
Any25%
Scrum
Any25%
SSIS
Any25%
Systems Integration
Any25%
T-SQL
Any25%
Tableau
Any25%