Business Intelligence Engineer

Asurint•Cleveland, OH

3d•Remote

About The Position

The Business Intelligence Engineer delivers innovative business intelligence solutions and reliable, accurate data marts to support business growth and improve operational efficiency. The role designs, builds, deploys, maintains, and supports BI solutions and analytics platforms for internal and external customers. It works with IT peers and business partners on production support, service requests, and roadmap initiatives aligned with business objectives. The position is performed remotely within the United States or in Asurint’s Cleveland, Ohio headquarters office. The schedule is generally normal Eastern Time Zone business hours, but work, meetings, and events may occasionally be required before or after normal hours and on weekends or evenings. Some personal-vehicle travel and occasional overnight travel may be required. The role may involve off-site meetings in various settings.

Requirements

Bachelor’s degree in computer science, information technology, or a related engineering field.
Five to seven years of relevant experience is preferred.
Strong analytical skills and the ability to translate business needs into technical specifications.
Hands-on experience with database management systems, online analytical processing (OLAP), and ETL frameworks.
Knowledge of developing SQL queries, stored procedures, functions, and views.
JSON/XML knowledge.
Proficiency in MS Office (Outlook, Excel, Word) or similar software.
If performing work-related driving, a valid driver’s license and ability to maintain a driving record satisfactory to the company’s liability insurance carrier are required.
Ability to lift objects weighing less than 20 pounds and carry them 20 feet or less.
In a remote setting, ability to maintain a safe and secure work environment, arrange an ergonomically sound workspace, and maintain standard Internet speeds.

Nice To Haves

Expertise developing or enhancing ETL packages and processes using tools such as Fivetran/DBT.
Experience creating custom reports with Google BigQuery and dashboards with BI tools such as Sisense, Power BI, or Tableau.
Experience working with data and platforms related to Sales, Operations, and Finance.
Experience with BigQuery, PostgreSQL, and Fivetran/DBT.
Experience with the legal/court system.
Experience with background screening.
Experience with relevant business management systems such as general ledger, HRIS, or CRM.
Industry certifications in technology.

Responsibilities

Design, build, and deploy BI solutions for internal and external customers, and maintain and support data analytics platforms.
Identify data trends and quickly, completely, and permanently correct data quality issues.
Collaborate with IT peers and business partners on production support, service requests, and roadmap initiatives aligned with business objectives.
Troubleshoot and test operational systems, including PostgreSQL, BigQuery, and BI tools.
Create database queries, stored procedures, functions, and views as needed.
Share domain and technical expertise, including technical mentorship and cross-training for peers and team members.
Maintain BI documentation and source-system data-mapping documentation.
Follow the software development life cycle in development efforts.
Continually remediate BI systems and data structures to improve performance, data accuracy, integrity, and security.
Provide ad hoc reports when needed and self-service reporting is unavailable or not possible.
Perform other duties as required.