- Database Development
- Power BI
- Microsoft SQL Server
GreatAmerica is a national commercial equipment finance company dedicated to helping manufacturers, vendors and dealers be more successful and keep their customers for a lifetime. While GreatAmerica has grown to more than 600 team members, our entrepreneurial spirit remains and endless opportunities lie ahead. We have experienced unparalleled year over year growth since our founding in 1992.
GreatAmerica is structured in cross functional teams that allow individuals to make informed decisions that benefit the company and our customers. There is no doubt in our minds we are building the greatest company of its kind, offering the finest products and services available anywhere. When you are part of the GreatAmerica team, you are part of the future, part of an opportunity to grow professionally and to reach your potential while enjoying your work.
The Senior Business Analytics Database Engineer will facilitate the design, documentation and delivery of a data platform in support of business analytics at GreatAmerica. The ideal candidate will have a passion for driving business value via data by making high quality data readily accessible for data champions throughout the enterprise for analytical purposes. This position will work closely with the information technology team in the development and implementation of data management strategies at the enterprise level that deliver consistent business definitions and data quality.
Architect, implement and operate stable, scalable and highly performant data pipelines that cleanse, structure and integrate data sets from source systems and third party data structures available in a staging environment into a consumable and accessible format for end user analyses and reporting.
Migrate legacy reporting data structures to new data platform
Consult with information technology resources regarding source system data structures and changes to those structures to ensure consistent business definitions and data quality
Diagnose and resolve database access and performance issues
Support infrastructure related to analytic toolset such as Tableau
Promote the usage of data engineering and data management best practices across the enterprise
Mentor[CB2] and train team members on the appropriate usage of data marts and other data sources used in reporting and analytics.
Evolve processes and architecture by recommending new technologies.Knowledge of cloud technologies is a plus.
Promote a data driven culture throughout GreatAmerica via active participation in a data champion community utilized for knowledge and best practice sharing.
For all GreatAmerica team members: Honesty/Integrity, Customer Oriented, Accountability, Tenacious, Communication Skills (Oral & Written), Adaptability
For this position: Problem Solving, Systems Analysis, Self-Motivated, Technical Aptitude, Accuracy, Innovative, Detail Oriented
Education: Bachelor’s degree in computer science, information systems or related field
Experience: 4-8 years of database development experience with demonstrated experience planning, designing and delivering a pipeline for analytics. Experience working in an agile development environment a plus.
Skills and Abilities
Strong experience with Microsoft SQL and ability to write efficient code
Hands on experience supporting ETL processes. Familiarity with Informatica a plus.
Experience with data visualization tools such as Tableau, QlikView, Power BI etc.
Ability to analyze existing tools and databases and provide recommendations
Experience with data warehousing design and implementation
Experience in methodologies and processes for managing databases on premise as well as cloud solutions
Experience ensuring data quality across multiple datasets used for analytical purposes