OneSource Technology, Inc.
Business Intelligence Engineer
OneSource Technology, Inc., Cleveland, Ohio, us, 44101
At Asurint, we're building a leading information-based technology company in Cleveland, Ohio. Asurint is on a mission to help our customers succeed by bringing innovation, flexibility and personal ownership to background screening - all while addressing the changing regulatory landscape. We measure our efforts by the success our customers enjoy and the positive onboarding experience of their employees. We are succeeding because they succeed.
Summary
Reporting to the Manager, Database and Reporting Services, the Business Intelligence Engineer's primary role is to deliver innovative BI solutions and reliable and accurate data marts that help drive business growth and make operations more efficient.
Responsibilities
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.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.Education: Bachelor's degree in computer science, information technology, or in a related engineering field is required. Master's degree is preferred.Certifications or licensure: Any industry certifications in the field of technology preferred. Driver's license and ability to maintain a driving record that is satisfactory to the company's liability insurance carrier is required.Years of relevant experience: 5 to 7 years is preferred.Years of experience supervising: None.Working Conditions
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 workings hours, and occasionally on weekends and evenings.Some travel by personal automobile and a valid driver's license is 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.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.Benefits
In exchange for your unique abilities, perspectives and teamwork, Asurint offers a competitive salary and an excellent benefit package - with options you can select according to your needs - which includes:
401(k)Medical, dental and vision effective first day of employmentPaid time off8 company-paid holidaysEmployee Assistance ProgramPaid BereavementPet BereavementTelecommuting StipendProfessional development programsShort-term and long-term disability benefitsFlexible spending/health savings accountsBusiness casual attireEmployee referral bonus
*Asurint is an equal opportunity employer. All applicants will be considered for employment without regard to race, color, religion, age, sex, national origin, disability status, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
Summary
Reporting to the Manager, Database and Reporting Services, the Business Intelligence Engineer's primary role is to deliver innovative BI solutions and reliable and accurate data marts that help drive business growth and make operations more efficient.
Responsibilities
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.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.Education: Bachelor's degree in computer science, information technology, or in a related engineering field is required. Master's degree is preferred.Certifications or licensure: Any industry certifications in the field of technology preferred. Driver's license and ability to maintain a driving record that is satisfactory to the company's liability insurance carrier is required.Years of relevant experience: 5 to 7 years is preferred.Years of experience supervising: None.Working Conditions
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 workings hours, and occasionally on weekends and evenings.Some travel by personal automobile and a valid driver's license is 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.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.Benefits
In exchange for your unique abilities, perspectives and teamwork, Asurint offers a competitive salary and an excellent benefit package - with options you can select according to your needs - which includes:
401(k)Medical, dental and vision effective first day of employmentPaid time off8 company-paid holidaysEmployee Assistance ProgramPaid BereavementPet BereavementTelecommuting StipendProfessional development programsShort-term and long-term disability benefitsFlexible spending/health savings accountsBusiness casual attireEmployee referral bonus
*Asurint is an equal opportunity employer. All applicants will be considered for employment without regard to race, color, religion, age, sex, national origin, disability status, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.