Crowe - Dallas, TX

posted 2 months ago

Full-time - Mid Level
Dallas, TX
101-250 employees
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 retain a combination of functional knowledge and execution skills in leveraging SQL, SSAS, PySpark, Microsoft Fabric, and other Microsoft BI stack products. The ideal candidate will have a deep understanding of ETL processes and technologies, as well as experience with a variety of data sources. The Data and Analytics Lead Engineer will be responsible for designing, developing, and maintaining complex ETL pipelines that extract, transform, and load data into our client's data lake/warehouse. We prefer candidates with a strong client facing, consulting background and business accounting/finance acumen. Additionally, you have strong critical thinking and analytical skills with a proven track record in executing solutions from planning to delivery. You understand basic agile methodologies and are committed to the continuous improvement of your solutions. At Crowe, you will join the Data Engineering team comprised of synergistic, high-functioning problem solvers that have extensive consulting and industry experience to drive solutions from strategy to execution. The team thrives on helping clients solve their complex business issues accurately, creatively, and expeditiously. As a member of the Data Analytics team, you will provide meaningful firm-wide contributions that uphold the team's dedication to "One Crowe." We strive for an unparalleled client experience and look to you to promote our success. Providing an excellent client experience, timely delivery, and communication are critical elements to success in this role.

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
  • Identify & map source data in various commercial and custom systems
  • Design, develop, test and maintain complex ETL pipelines
  • Extract, transform, and load data from a variety of data sources
  • Possess effective writing and communication skills for audiences of diverse business and technical backgrounds
  • Work with data engineers and other stakeholders to define data requirements
  • Troubleshoot and debug complex ETL pipelines
  • Stay up-to-date on ETL technologies and best practices
  • Formulate development estimates (task, effort, dependencies, etc.)
  • Develop test cases and demonstrate results for assigned deliverables
  • Mentor and train junior ETL developers
  • Maintain and present daily/weekly status
  • Articulate project deliverable details and activities to client and project team members
  • Adapt to various industries and quickly learn the client's context, language, and jargon to clearly document and translate business requirements to development plans
  • 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
  • 5+ years of experience in ETL development
  • Deep understanding of ETL processes and technologies
  • Experience with a variety of data sources, including relational databases, flat files, and web APIs
  • Experience with Data Factory, SQL, T-SQL, Synapse, SSIS, Databricks, Python, Java, PySpark, C++ and other programming languages
  • Experience with data warehouse technologies, such as Hadoop, Hive, and Spark
  • Excellent problem-solving and debugging skills
  • 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 and the ability to blend them together in the right proportions to fit a project and business environment
  • Technical background, with understanding or hands-on experience in enterprise solutions for different industries
  • High-level knowledge of BI architecture or data warehousing
  • Excellent written and verbal communication skills
  • Effectively managing multiple deliverables, clients and projects in a fast-paced environment
  • Strong problem solving and analytical skills

Benefits

  • Comprehensive benefits package
  • Career coaching and guidance
  • Inclusive culture that values diversity
  • Opportunities for professional growth and development
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service