Business Intelligence Engineer

This is a fully remote position, open to applicants in Ohio.

📋 Description

• Design, develop, and implement BI solutions for both internal and external clients.

• Maintain and provide support for data analytics platforms.

• Identify data trends and swiftly, thoroughly, and permanently resolve data quality issues.

• Collaborate with IT colleagues and business stakeholders on production support, service requests, and roadmap initiatives.

• Troubleshoot and evaluate operational systems, including PostgreSQL, BigQuery, and BI tools.

• Develop database queries, stored procedures, functions, and views.

• Offer technical guidance and cross-training to peers and team members.

• Keep BI documentation and source system data mapping documentation up to date.

• Adhere to the software development life cycle throughout development activities.

• Improve performance, accuracy, integrity, and security by remediating BI systems and data structures.

• Generate ad hoc reports when self-service options are unavailable or impractical.

• Perform additional duties as needed.

⛳️ Requirements

• Strong analytical abilities with a knack for converting business requirements into technical specifications.

• Practical experience with database management systems, online analytical processing (OLAP), and Extract, Transform, Load (ETL) frameworks.

• Advanced expertise in the development and enhancement of ETL packages/processes using tools like Fivetran/DBT.

• Experience in creating custom reports utilizing Google BigQuery.

• Experience in developing dashboards with BI dashboard tools such as Sisense, Power BI, or Tableau is preferred.

• Proficiency in crafting SQL queries, stored procedures, functions, and views.

• Experience with data and platforms relevant to Sales, Operations, and Finance is preferred.

• Knowledge of JSON/XML is required.

• Familiarity with BigQuery, PostgreSQL, and Fivetran/DBT is preferred.

• Previous experience within the legal/court system is preferred.

• Experience in background screening is preferred.

• Proficiency in MS Office (Outlook, Excel, Word) or equivalent software is required.

• Understanding of business management systems, such as general ledger, HRIS, and CRM, is preferred.

• A bachelor’s degree in computer science, information technology, or a related engineering discipline is required.

• Industry certifications in technology are preferred.

• A valid driver’s license and a satisfactory driving record are required if driving is part of the job.

• 5 to 7 years of relevant experience is preferred.

• Ability to work during normal Eastern Time Zone business hours.

• Some travel in a personal vehicle and occasional overnight travel may be necessary.

• Capability to lift light items (under 20 pounds) and carry them short distances (20 feet or less) is required.

🏝️ Benefits

• Medical, dental, and vision coverage effective from the first day of employment.

• 401(k) plan with employer matching.

• Paid time off.

• 10 company-paid holidays.

• Employee Assistance Program.

• Wellness Program.

• Paid Bereavement leave.

• Pet Bereavement leave.

• Pet Insurance.

• Volunteer time off.

• Telecommuting Stipend.

• Professional development opportunities.

• Short-term disability coverage.

• Company-paid long-term disability insurance.

• Company-paid life insurance.

• Flexible spending/health savings accounts.

• Employee referral bonus.