BI Data Engineer

BI Data Engineer We are seeking a talented and experienced data engineer to join our Professional Services team. In this role, you will play a pivotal part in the full development life cycle, from conceptualization to implementation, delivering high-quality BI solutions to our clients. You will be responsible for creating scalable and repeatable solutions that can be tailored to meet the unique needs of each client.

Responsibilities: Consult with clients to understand their requirements and extend the QuickLaunch data model by identifying additional data sources. Design and develop ETL pipelines to efficiently extract, transform, and load data into the BI system. Utilize DAX to develop complex Tabular models that accurately represent the underlying data and support advanced analytics. Work closely with the development team to stay abreast of new products and technologies, providing front-line technical support when necessary. Serve as a subject matter expert, sharing knowledge and guiding clients and team members on best practices for implementing BI solutions. Ensure the delivery of high-quality services, maintaining our reputation for excellence in customer satisfaction.

Who You Are: Possess strong analytical, problem-solving, conceptual, communication, and organizational skills. Demonstrate a customer-centric approach with a focus on delivering effective solutions and achieving results. Display a career trajectory centered on reporting, business intelligence, and analytics applications. Thrive in a fast-paced, collaborative team environment. Bachelor’s degree or equivalent work experience is required, with a preference for disciplines such as Computer Science, MIS, Engineering, Business Administration, or related fields.

Technical Requirements: Proficiency in Advanced SQL across multiple platforms, including SQL Server, Oracle, DB2, Databricks, and Synapse, specializing in performance tuning and complex query optimization. Extensive experience with Databricks ETL/ELT methodologies, Delta Lake, SQL Warehouse, and Delta Sharing, with additional knowledge of AI/ML being advantageous. Expertise in SSIS or a third-party tool for ETL/ELT processes, including utilizing custom components. Fluency in Python

Bonus Points: Knowledge of Data Mart/Warehouse modeling, adept at integrating diverse data sources regardless of coupling. Proficient in SSAS/Power BI Tabular modeling and DAX language. Experience extracting data from ERP systems, ideally JD Edwards or Viewpoint Vista

About Us: Preferred Strategies (www.preferredstrategies.com) is an Employee-Owned (ESOP) dedicated to helping organizations turn their ERP (JD Edwards, NetSuite, and Viewpoint Vista), CRM (Salesforce), CPM (OneStream) data into decision-ready information. Our mission is to find companies who value data as much as we do, who align on vision, and who want to partner together on their data-driven journey. We are passionate about giving our clients the competitive advantage they need to make smarter business decisions and achieve their business goals. We have spent thousands of hours building a solution called QuickLaunch that enables customers to leverage best-in-class technologies like Power BI, Databricks, Azure Cloud, etc. with their ERP, CRM, and CPM data which becomes the framework and foundation of their Analytics Strategy. Come join our team and gain the opportunity to work with some of the world’s highest performing companies and talented people who share a common vision for the future of data. We seek people who thrive in a team-oriented and collaborative environment and are proud to have this represented by our Team Member Net Promoter Score (NPS) of 92 and a Customer NPS of 81. Working Location: Remote OR Santa Cruz County, CA office Estimated Compensation Range: $125,000-150,000