Crowe
Lead Data Engineer – Financial Data, Compliance & Business Intelligence
Crowe, San Francisco, California, United States, 94199
Lead Data Engineer – Financial Data, Compliance & Business Intelligence
Job Description: We are looking for an experienced ETL Engineer to join our Data Engineering team. The ideal candidate will have a strong understanding of ETL processes and technologies, as well as experience with a variety of data sources. The ETL developer will be responsible for designing, developing, and maintaining ETL pipelines that extract, transform, and load data into our data warehouse. 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.
Additionally, you will work as part of a team of problem solvers with extensive consulting and industry experience, helping our clients solve their complex business issues from strategy to execution.
Responsibilities
Identify & map source data in various commercial and custom systems
Design, develop, test and maintain ETL pipelines
Extract, transform, and load data from a variety of data sources
Work with data engineers and other stakeholders to define data requirements
Troubleshoot and debug 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
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
Maintain a professional presence and be ready to interact with the client at all times
Qualifications
Bachelor's degree in computer science, information technology, or a related field
3+ years of experience in ETL development
Hands-on experience with Bank Secrecy Act (BSA), Financial Audits, or Anti-Money Laundering (AML) regulations and compliance requirements
Previous consulting experience or experience working with external clients
Strong understanding of ETL processes and technologies
Experience with a variety of data sources, including relational databases, flat files, and web APIs
Experience with Python, Java, or another programming language
Experience with data warehouse technologies, such as Azure, AWS, and Snowflake
Excellent problem-solving and debugging skills
Strong communication and teamwork skills
Solid understanding of software development life cycle models and Agile and traditional project management principles
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
Ability to manage multiple deliverables, clients and projects in a fast-paced environment
Strong problem solving and analytical skills
Certifications (Preferred)
Certifications in BI (ETL tools, visualization tools, cloud architectures) are expected
Certifications such as CAMS (Certified Anti-Money Laundering Specialist), CFE (Certified Fraud Examiner)
Key Stakeholders This Role Interacts With
Internal: Senior BI Analyst; Data Product Manager; BI Architect / Senior Architect; Data Engineers; Report Developer (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
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.
In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. Crowe is not sponsoring for work authorization at this time.
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. A reasonable estimate of the current range is $104,500.00 - $208,300.00 per year.
Our Benefits & Growth Your exceptional people experience starts here. At Crowe, we know that great people are what makes a great firm. We care about our people and offer employees a comprehensive total rewards package. Learn more about what working at Crowe can mean for you!
More about Crowe Crowe (www.crowe.com) is one of the largest public accounting, consulting and technology firms in the United States. Crowe serves clients worldwide as an independent member of Crowe Global, with a network of firms in more than 130 countries. Crowe LLP is an equal opportunity employer and prohibits discrimination and harassment of any type.
Note We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with applicable state and local laws. Please visit our webpage to see notices of state and local Ban-the-Box laws where applicable.
#J-18808-Ljbffr
Additionally, you will work as part of a team of problem solvers with extensive consulting and industry experience, helping our clients solve their complex business issues from strategy to execution.
Responsibilities
Identify & map source data in various commercial and custom systems
Design, develop, test and maintain ETL pipelines
Extract, transform, and load data from a variety of data sources
Work with data engineers and other stakeholders to define data requirements
Troubleshoot and debug 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
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
Maintain a professional presence and be ready to interact with the client at all times
Qualifications
Bachelor's degree in computer science, information technology, or a related field
3+ years of experience in ETL development
Hands-on experience with Bank Secrecy Act (BSA), Financial Audits, or Anti-Money Laundering (AML) regulations and compliance requirements
Previous consulting experience or experience working with external clients
Strong understanding of ETL processes and technologies
Experience with a variety of data sources, including relational databases, flat files, and web APIs
Experience with Python, Java, or another programming language
Experience with data warehouse technologies, such as Azure, AWS, and Snowflake
Excellent problem-solving and debugging skills
Strong communication and teamwork skills
Solid understanding of software development life cycle models and Agile and traditional project management principles
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
Ability to manage multiple deliverables, clients and projects in a fast-paced environment
Strong problem solving and analytical skills
Certifications (Preferred)
Certifications in BI (ETL tools, visualization tools, cloud architectures) are expected
Certifications such as CAMS (Certified Anti-Money Laundering Specialist), CFE (Certified Fraud Examiner)
Key Stakeholders This Role Interacts With
Internal: Senior BI Analyst; Data Product Manager; BI Architect / Senior Architect; Data Engineers; Report Developer (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
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.
In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. Crowe is not sponsoring for work authorization at this time.
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. A reasonable estimate of the current range is $104,500.00 - $208,300.00 per year.
Our Benefits & Growth Your exceptional people experience starts here. At Crowe, we know that great people are what makes a great firm. We care about our people and offer employees a comprehensive total rewards package. Learn more about what working at Crowe can mean for you!
More about Crowe Crowe (www.crowe.com) is one of the largest public accounting, consulting and technology firms in the United States. Crowe serves clients worldwide as an independent member of Crowe Global, with a network of firms in more than 130 countries. Crowe LLP is an equal opportunity employer and prohibits discrimination and harassment of any type.
Note We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with applicable state and local laws. Please visit our webpage to see notices of state and local Ban-the-Box laws where applicable.
#J-18808-Ljbffr