Job Summary: The Business Intelligence Data Engineer will be responsible for the scripts and processes required to extract, transform, clean and move data and metadata so they can be loaded into a data warehouse, data mart or operational data store. Reads, analyzes and digests what the company wants to accomplish with its data, and designs the best possible ETL process. Remote position 

ESSENTIAL FUNCTIONS 

Business Requirements and Development

• Provide application analysis and data modeling design for data warehouse.

• Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.
• Proficient in the use of query and reporting analysis tools.
• Standardize data collection by developing methods for database design and validation reports.
• Work with business requirements to identify and understand source data systems; provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
• Develop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.

Additional Responsibilities

• Will assist in orientation, training, work assignment and checking of less experienced developers and analysts.
• Provide continuous improvement and implementation of ideas
• Accountable for properly following all IT standards, processes and methodologies as applicable including but not limited to Quality Assurance (QA),
• Other responsibilities and accountabilities may be assigned based on business and organization

MINIMUM QUALIFICATIONS

Education/Certification

• Four-year college or commensurate work experience.
• 3+ years - Knowledge of AWS Infrastructure including S3, Redshift,
• Expertise in SQL and relational databases. Experience with building multi-dimensional data models to serve as a foundation for future analyses
• Expert in ETL and/or other data manipulation languages such as Python

Preferred Qualifications

• Experience with predictive modeling, IoT, Machine Learning, and AI
• Strong analytic skills for working with unstructured datasets