McLane is one of the largest and most stable supply chain services leaders in the United States. We've been at the forefront of delivering retail and restaurant solutions for convenience stores, mass merchants, drug stores, and chain restaurants for over 125 years. Our vision is to be an agile, innovative, and unified supply chain partner that delivers a superior customer experience, improves the lives of our teammates and community, and produces best-in-class returns. The Principal Solutions Architect puts you front and center with stakeholders, solving interesting challenges, with Microsoft's data and analytics tech stack. The Principal Solutions Architect will be a PowerBI expert that can build bridges between technology and organizational goals. Drive the discovery, design, and execution of a wide variety of analytical technology solutions. Provide technical expertise responding to disruptive analytical technologies and solving unique and complex problems. This is a hybrid position which will require the candidate to report and work from the office three days a week. Therefore, interested candidates should be within a 50-minute radius from Temple, TX.
BENEFITS: - Day 1 Benefits available: medical, dental, and vision insurance, FSA/HSA and company-paid life insurance.
- Get paid early. Get paid fast.
- 401(k) with annual company match.
- Paid holidays, Responsible Off (RTO), college tuition reimbursement, and more!
ESSENTIAL JOB FUNCTIONS / PRINCIPAL ACCOUNTABILITIES: - Design end to end analytical workflows, including overall architecture, capabilities, platforms, tools, and governing processes.
- Develop complex dimensional data models using Power BI, Produce actionable metrics using advanced DAX skills
- Use Power Query to transform and load data to create compelling data visualizations with Power BI
- Create, maintain, and communicate positioning and go-forward strategies for analytical capabilities and tools.
- Define and improve best practices, guidelines, and integration with other enterprise solutions.
- Review analytic solutions for re-usability, scalability, synergy opportunities and alignment to defined best practices and guidelines.
- Create and evolve analytic technology roadmap, to align with continuously evolving business needs.
- Collaborate with governance leader to ensure architectural alignment to enterprise governance requirements and inform of implementation feasibility.
- Monitor technology trends and perform discovery of any new tools and capabilities of interest.
- Benchmark analytic capabilities with industry analysts and other companies.
- Own strategic technology relationships with technology vendors and external communities/partners.
- Lead education and training for analytics community.
- Perform other duties as assigned.
MINIMUM SKILLS AND QUALIFICATION REQUIREMENTS: - Bachelor's degree in computer science, statistics, engineering, or a related field.
- Seven or more years demonstrating a high degree of proficiency in designing and developing complex, high-quality analytical solutions on cloud and other modern data platforms and tools.
- Five or more years in a Data Architecture role designing data and analytics solution architectures, detailed workflows, data modeling, applying data engineering and architecture best practices, and governance guidelines and advising on necessary technologies.
- Experience with designing and maintaining data warehouses and/or data lakes with big data technologies such as Spark/Databricks, or distributed databases, like Redshift and Snowflake, and experience with housing, accessing, and transforming data in a variety of relational databases.
- Experience in building data pipelines and deploying/maintaining them following modern DE best practices. (e.g., DBT, Airflow, Spark, Python OSS Data Ecosystem)
- Knowledge of Software Engineering fundamentals and software development tooling (e.g., Git, CI/CD, JIRA) and familiarity with the Linux operating system and the Bash/Z shell.
- Experience with cloud database technologies (e.g., Azure) and developing solutions on cloud computing services and infrastructure in the data and analytics space.
- Basic familiarity with BI tools. (e.g., Alteryx, Tableau, Power BI, Looker)
- Expertise in ELT and data analysis, SQL primarily.
- Conceptual knowledge of data and analytics, such as dimensional modelling, reporting tools, data governance, and structured and unstructured data.
- Ability to work with customer's business requirements to create best-case solutions.
- Ability to communicate vision to both technical and leadership audiences.
- Ability to building demos and proof of concepts.
- Ability to act as a consultant on architecture and implementation.
WORKING CONDITIONS: Candidates may be subject to a background check and drug screen, in accordance with applicable laws. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.