Data & Analytics Lead Engineer - Data Engineering

Your Journey at Crowe Starts Here:

At Crowe, you have the opportunity to deliver innovative solutions to today's complex business issues. Crowe's accounting, consulting, and technology personnel are widely recognized for their in-depth expertise and understanding of sophisticated process frameworks and enabling technologies, along with their commitment to delivering measurable results that help clients build business value. Our focus on emerging technology solutions along with our commitment to internal career growth and exceptional client value has resulted in a firm that is routinely recognized as a "Best Place to Work." We are 75 years strong and still growing. Come grow with us!

Job Description:

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.

Specific responsibilities include but are not limited to the following:

• 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

Qualifications

• 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

Key Stakeholders This Role Interacts With:

Internal

• Senior BI Analyst
• Data Product Manager
• BI Architect / Senior Architect
• Data Engineers
• Analytics Developers (Power BI, Tableau)

External

• C-Suite executives, business leaders, and department heads
• Data Owners, Data Stewards
• Enterprise Information Management and Data Governance Team
• IT Staff - Architects, DBAs, Developers, etc

We expect the candidate to uphold Crowe's values of Care, Trust, Courage, and Stewardship. These values define who we are. We expect all of our people to act ethically and with integrity at all times.

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Crowe, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $104,471.00 to $208,282.00 per year.

Our Benefits:

At Crowe, we know that great people are what makes a great firm. We value our people and offer employees a comprehensive benefits package. Learn more about what working at Crowe can mean for you!

How You Can Grow:

We will nurture your talent in an inclusive culture that values diversity. You will have the chance to meet on a consistent basis with your Career Coach that will guide you in your career goals and aspirations. Learn more about where talent can prosper!

More about Crowe:

Crowe ( is one of the largest public accounting, consulting and technology firms in the United States. Crowe uses its deep industry expertise to provide audit services to public and private entities while also helping clients reach their goals with tax, advisory, risk and performance services. Crowe is recognized by many organizations as one of the country's best places to work. Crowe serves clients worldwide as an independent member of Crowe Global, one of the largest global accounting networks in the world. The network consists of more than 200 independent accounting and advisory services firms in more than 130 countries around the world.

Crowe LLP provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Crowe LLP does not accept unsolicited candidates, referrals or resumes from any staffing agency, recruiting service, sourcing entity or any other third-party paid service at any time. Any referrals, resumes or candidates submitted to Crowe, or any employee or owner of Crowe without a pre-existing agreement signed by both parties covering the submission will be considered the property of Crowe, and free of charge.