Business Intelligence/ETL Developer

Profile

Business Intelligence/ETL Developer
Requirements:
5 year Design / Develop ETL and data warehousing components
Design and develop database objects, stored procedures, views, functions, tables and triggers; ensure their stability, reliability, and performance
Develop ETL processes for data warehousing, data integration and data analytics.
Strong experience writing complex SQL queries.
8 years’ Experience with SQL and non-SQL Databases ( i.e. Postgress, MySQL, SQL Server, Mongo DB)
Data Analysis
Data Modeling, Data Warehouse, Data Warehouse Schemas
Experience/familiarity with reporting and visualization tools such as Pentaho, Tableau
API, structured an un-structured databases/datastores
Linux, MySQL, ORM, RDBMS, RESTful APIs
Python 3.6
Strong experience in Web Services and APIs in python Amazon Lambda development
Scripting MySQL Development Linking of Excel and other reporting tools
MySQL Experience
MongoDB
Assist with future data warehouse, ETL, and data science projects as we mature our data product offerings
Ability to work with project managers, business analysts and application developers, to quickly capture the major business functions and technology underpinnings to be able to design and implement tests of system functionality that exercise all critical inter-system integration points.
Nice to have:
Python, Authentication, Authorization
AWS Lambda Python Developer Software development
Strong experience with Excel
SharePoint
Agile familiarity
Create and maintain clear, detailed, and accurate metadata documentation.
Business Intelligence Reporting Requirements:
Designs, develops, and maintains business intelligence applications (reports, dashboards, scorecards).
Develops dashboards using tools such as Tableau, Pentaho, Power BI.
Provides feedback to the data warehouse build team to alert them to data issues or opportunities to expand the data warehouse to meet client expectations.
Assist DW team with building datamarts, cubes, ETL mapping or package updates in order to procure backend data sources and create efficiencies
Performs extensive unit testing of BI applications before handing off to QA.
Skills:
ETL
, Tableau
, Business Intelligence
, Data Warehousing
, Pentaho

Company info

Sign Up Now - SQLCrossing.com