Business Intelligence Engineer

November 4

Apply Now

Receive Emails with Similar Jobs

ASTEC

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 1972

Description

• Reporting to the Manager, Database and Reporting Services. • Deliver innovative BI solutions and reliable data marts. • Designs, builds, and deploys BI solutions for both internal and external customers. • Recognizes data trends and corrects data quality issues quickly. • Collaborates with IT peers and business partners. • Provides support for operational systems by troubleshooting and testing. • Maintains BI documentation and source system data mapping documentation. • Creates and maintains Business Intelligence documentation. • Performs continual remediation of BI systems to improve overall performance.

Requirements

• Strong analytical skills with ability to translate business needs to technical specifications. • Hands-On expertise with database management systems, online analytical processing (OLAP), and Extract, Transform, Load (ETL) framework. • High level of expertise in development/enhancement of ETL packages/processes using tools like Fivetran/DBT. • Custom reports using Google BigQuery, and dashboards using BI dashboard tools such as Sisense, Power BI, or Tableau. • Strong knowledge in developing SQL queries, stored procedures, functions, and views. • Experience working with data and platforms related to Sales, Operations, and Finance is preferred. • JSON/XML knowledge is required. • Experience with BigQuery, PostgreSQL, and Fivetran/DBT is required. • Experience with the legal/court system is preferred. • Experience with background screening is preferred. • Proficiency in MS Office (Outlook, Excel, Word) or similar software is required. • Relevant business management systems such as general ledger, HRIS, CRM, etc. is preferred.

Benefits

• 401(k) • Medical, dental and vision effective first day of employment • Paid time off • 8 company-paid holidays • Employee Assistance Program • Paid Bereavement • Pet Bereavement • Telecommuting Stipend • Professional development programs • Short-term and long-term disability benefits • Flexible spending/health savings accounts • Business casual attire • Employee referral bonus