Business Intelligence Engineer
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 and maintains BI solutions and analytics platforms for internal and external customers, supports operational systems and business reporting, and works with IT peers and business partners to align services and solutions with business objectives. The position is remote within the United States or based in Asurint’s Cleveland, Ohio headquarters. Work is generally performed during normal Eastern Time Zone business hours, though work or meetings before or after those hours and occasional evening or weekend work may be required. Some travel, including occasional overnight travel, may be required.
Requirements
- 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 is required.
- Proficiency in MS Office (Outlook, Excel, Word) or similar software is required.
- Bachelor’s degree in computer science, information technology, or a related engineering field is required.
- Five to seven years of relevant experience is preferred.
- A driver’s license and a driving record satisfactory to the company’s liability insurance carrier are required if performing work-related driving.
Nice To Haves
- Expertise developing or enhancing ETL packages and processes using tools such as Fivetran or DBT, creating custom reports with Google BigQuery, and building dashboards with 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 or court system.
- Experience with background screening.
- Experience with relevant business management systems such as general ledger, HRIS, or CRM.
- Industry technology certifications.
Responsibilities
- Design, build, and deploy BI solutions for internal and external customers, and maintain and support data analytics platforms.
- Identify data trends and correct data quality issues quickly and permanently.
- Collaborate with IT peers and business partners on production support, service requests, and roadmap initiatives aligned with business objectives.
- Support operational systems through troubleshooting and testing, including PostgreSQL, BigQuery, and BI tools.
- Create database queries, stored procedures, functions, and views as needed.
- Share domain and technical expertise through mentorship and cross-training of 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.
Benefits
- Medical, dental, and vision insurance effective on the first day of employment
- 401(k) with employer match
- Paid time off
- 10 company-paid holidays
- Employee Assistance Program
- Wellness Program
- Paid bereavement leave
- 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 and health savings accounts
- Employee referral bonus
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
