Data & Analytics Lead Engineer - Advanced Analytics

$104,471 - $208,282/Yr

Crowe - Dallas, TX

Full-time - Mid Level

Dallas, TX

Professional, Scientific, and Technical Services

About the position

As a Data and Analytics Lead Engineer at Crowe, you will provide critical solution development across a broad portfolio of external clients and industries. You will leverage your functional knowledge and execution skills in SQL, SSAS Tabular, Microsoft Fabric, Power BI, and other Microsoft BI stack products. Candidates with a strong client-facing, consulting background and business accounting/finance acumen are preferred. Your role will involve strong critical thinking and analytical skills, with a proven track record in executing solutions from planning to delivery. You will understand agile methodologies and be committed to the continuous improvement of your solutions. Joining the Advanced Analytics team at Crowe means becoming part of a group of synergistic, high-functioning problem solvers with extensive consulting and industry experience. This team is dedicated to helping clients solve complex business issues accurately, creatively, and expeditiously. As a member of the Data Analytics team, you will contribute meaningfully to uphold the team's dedication to “One Crowe.” Your success in this role will hinge on providing an excellent client experience, timely delivery, and effective communication. Specific responsibilities include performing business analysis duties such as scoping, documentation, and project management to establish an engagement blueprint. You will interface with subject matter experts to assess business intelligence requirements and execution strategies, rapidly develop diverse POCs from various data sources, and clean, transform, and blend large data sources while leveraging SQL EDW, M, and DAX best practices. You will also create visually stunning reports using tools like Power BI or Tableau, deploy and manage Power BI workspaces, and continuously improve processes with advancements in the MS BI platform.

Responsibilities

• Perform duties related to business analysis, such as scoping, documentation, project management, and related activities to establish an engagement blueprint.
• Interface and communicate with subject matter experts of varied backgrounds to adequately assess business intelligence requirements and execution strategy.
• Rapidly develop diverse POCs from various data sources and systems.
• Clean, transform, and blend large and disparate data sources while leveraging SQL EDW, M, and DAX best practices.
• Leverage Tabular Editor, ALM Toolkit, and DAX Studio to quickly and efficiently perform model operations across complex deliverables.
• Perform ad-hoc data discovery using tools such as Power BI, SQL, or Excel.
• Create visually stunning and salient reports using tools such as Power BI or Tableau.
• Deploy, provision, and manage Power BI workspaces and deliverables.
• Possess effective writing and communication skills for audiences of diverse business and technical backgrounds.
• Balance multiple projects with attention to detail while meeting deadlines.
• Continuously improve processes with advancements in the MS BI platform.

Requirements

• Master's or Bachelor's degree in a relevant field (such as Computer Science, Information Systems, Data Science, or a related discipline).
• 8+ years of experience in a data analyst, developer, architect, or similar position.
• 7+ years of advanced experience with DAX, M, SQL, and Power BI.
• 5+ years of experience in creating dashboards and deploying to clients.
• 3+ years of experience in Power BI Service delivery and Admin role and responsibility.
• 1.5+ years of experience in leveraging ETL SaaS tools (Talent, Stitch, Hevo, etc.,) or ADF Integration.
• Expert knowledge of creating and optimizing dimensional models.
• Strong leadership, team management, and communication skills.
• Ability to mentor and train junior ETL developers.
• Solid understanding of software development life cycle models as well as expert knowledge of both Agile and traditional project management principles and practices.
• Expert skills in Microsoft Excel and Outlook, strong skills in PowerPoint.
• Strong track record of developing high-quality models on-premise and/or in the cloud.
• Excellent client-facing and internal communication skills.
• Excellent written and verbal communication skills.
• Effectively managing multiple deliverables, clients, and projects in a fast-paced environment.
• Knowledge of programming languages like SQL, Python, R, or Java.
• Familiarity with data governance, data security, and compliance.
• Strong problem-solving skills and analytical thinking.

Nice-to-haves

• Experience with additional BI tools beyond Power BI and Tableau.
• Familiarity with cloud-based data solutions and architectures.
• Experience in a consulting environment.

Benefits

• Comprehensive benefits package including health insurance, dental insurance, and vision insurance.
• Opportunities for professional development and career growth.
• Inclusive culture that values diversity.
• Regular meetings with a Career Coach to guide career goals and aspirations.