BI Engineer

About Aaron's: We are Aaron’s - an industry leader in the sales and lease-to-own retail industry known for quality brand names and superior customer service. We provide our team members the opportunity to reach their full potential in a team-oriented, high-energy, recognition-based environment with competitive pay and benefits. This is much more than a job – it is a career with purpose.  About Aaron's Tech: In recent years, we’ve been on a journey to transform our business model with technology. We're not the slow, old-fashioned retailer you think we are. We used to be, but those days are long gone. In fact, we don't even think of Aaron's as a retail company. Instead, we think of Aaron's as a technology company that happens to sell and lease furniture, electronics and appliances. This way of thinking has demanded a massive shift in who we hire, how we organize and lead our teams, and how we deliver our technology and services. It's simple: we hire smart people who are motivated by delivering big, impactful results, we point them at big problems to solve, and we get out of their way. We believe our technology team is unique and special, and after learning about us, we believe you will think so too. Find out more at http://tech.aarons.com/.

Summary:

As the BI Engineer Intermediate, you will play a pivotal role in developing, implementing, and supporting enterprise data solutions. Your expertise in various stages of project delivery and support will be crucial, encompassing requirements analysis, logical and physical design, implementation, testing, and deployment. The focus of your work will be on BI/Data Warehouse technologies, with in-depth experience using the Microsoft BI Stack, including SQL, SSIS, SSRS, and SSAS.

Duties and Responsibilities:

• Utilize data gathering, research, and analytical skills to derive insightful conclusions and devise effective solutions to meet user needs.
• Collaborate with cross-functional teams to ensure the successful delivery and support of data solutions.
• Produce well-written communication materials that summarize findings and support recommendations.
• Contribute to quality assurance and user acceptance testing strategies by creating test plans and actively participating in testing (Unit and UAT).

Education and Experience:

• You should have at least 3 years of experience in Business Intelligence.
• A BA/BS degree in computer science, information technology, engineering, or related fields is required.

Required Skills:

The ideal candidate for the BI Engineer Intermediate position should possess a proven understanding and expertise in various BI technologies. You must have demonstrated experience with the Microsoft BI stack, while exposure to other technologies like HaloBI, PowerBI, Tableau, Oracle, SAP BW, and SAP Business Objects will be advantageous.

Competency Requirements:

• A minimum of 3 years of experience in database design and integration with SQL Server databases.
• Proficiency in Relational Databases and SQL language.
• Experience with Extraction, Transformation, and Loading (ETL) processes using Microsoft SSIS.
• Knowledge of Analytics/OLAP Cube development with Microsoft SSAS.
• Ability to develop reports using PowerBI.
• Familiarity with project management methodologies and best practices, particularly Agile.
• Skills in query/solution performance tuning and optimization.
• Capable of troubleshooting and resolving incidents.
• Strong verbal and written communication skills.

Preferred Skills:

• Experience in Multi-Dimensional Expression (MDX) development.
• Understanding of Master Data Management concepts.
• Familiarity with heterogenous data integration methodologies, such as transmitting JSON/XML data via a REST API.
• Knowledge of C# programming.
• Exposure to cloud technologies like Azure, AWS, Snowflake, etc.

As the BI Engineer Intermediate, your role will be instrumental in ensuring the success of data-driven initiatives and the effective utilization of BI technologies within the organization. Your expertise in the Microsoft BI Stack and other related tools will be valuable assets in driving data solutions and supporting critical business needs.