[Hiring] Business Intelligence Engineer @One Source Technology LLC

Role Description

The Business Intelligence Engineer is responsible for delivering innovative BI solutions and reliable and accurate data marts that help drive business growth and make operations more efficient.

• Designs, builds, and deploys BI solutions for both internal and external customers and maintains and supports data analytics platforms.
• Recognizes data trends and corrects data quality issues quickly, completely, and permanently.
• Collaborates with IT peers and business partners to focus on production support, service requests, and roadmap initiatives to ensure a balanced delivery of services and solutions aligned with business objectives.
• Provides support for operational systems by troubleshooting and testing (PostgreSQL, BigQuery, BI tools).
• Creates database queries, stored procedures, functions, and views as needed.
• Shares domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Maintains BI documentation and source system data mapping documentation.
• Follows the software development life cycle in all development efforts.
• Creates and maintains Business Intelligence documentation.
• Performs continual remediation of BI systems and data structures to improve overall performance as well as data accuracy, integrity, and security.
• Provides ad hoc reports as needed/identified in support of the business where self-service is not available/possible.
• Other duties as required.

Qualifications

• Strong analytical skills with ability to translate business needs to technical specifications.
• Hands-on experience 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 is preferred.
• 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 preferred.
• 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.
• Education: Bachelor’s degree in computer science, information technology, or in a related engineering field is required.
• Certifications or licensure: Any industry certifications in the field of technology preferred.
• Years of relevant experience: 5 to 7 years is preferred.
• Years of experience supervising: None.

Requirements

• The work environment involves everyday risks or discomforts that require normal safety precautions typical of offices, including the need for general safe workplace practices with office equipment and computers, avoidance of trips and falls, and observance of fire regulations.
• This position is performed remotely within the United States or in an office setting in the Cleveland, Ohio headquarters, although off-site meetings in various settings may occur.
• Inside Asurint’s office environment, the noise level is usually quiet to moderate.
• In a remote setting, the employee is responsible for maintaining a safe and secure work environment, for arranging the off-site workspace in an ergonomically sound manner, and for maintaining standard Internet speeds in order to work effectively.
• In a remote setting, the employee is required to ensure that all equipment and records that are the property of Asurint but have been relocated to the off-site workplace, are maintained in a safe and secure manner and are used only for business purposes.
• The schedule is generally normal Eastern Time Zone business hours (unless otherwise communicated based on position or working location), although the employee may be required to perform work, attend meetings and events before or after normal working hours, and occasionally on weekends and evenings.
• Some travel by personal automobile and a valid driver’s license may be required. Occasional overnight travel may be required.
• Ability to lift light objects (less than 20 pounds) and carry them short distances (20 feet or less) is required.

Benefits

• Medical, dental and vision effective first day of employment.
• 401(k) with employer match.
• Paid time off.
• 10 company-paid holidays.
• Employee Assistance Program.
• Wellness Program.
• Paid Bereavement.
• Pet Bereavement.
• Pet Insurance.
• Volunteer time off.
• Telecommuting Stipend.
• Professional development programs.
• Short-term disability.
• Company-paid long-term disability.
• Company-paid life insurance.
• Flexible spending/health savings accounts.
• Employee referral bonus.