at Crowe LLP in Chicago, Illinois, United States
Job Description
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:
Overview
Crowe Global intends to upgrade its platform and approach to the management and delivery of its restricted list and conflict checks currently managed through the network's Member Portal. Crowe Global plans to implement a new technology platform that is to be used for the global restricted list ("entity management") and for global conflict checks ("conflict check requests"). The platform will hold restricted list data and be used to facilitate the origination of and response to negative and positive conflict of interest checks. The Platform will apply the appropriate regulatory rule sets/professional standards (e.g., IESBA, SEC, UK, etc.) configured for Crowe Global policies to entities. Efficient access to data, whether from the restricted list or circulation of conflict checks, will enable member firms and their personnel to determine whether there is a potential conflict or threat to independence. Crowe Global sees the implementation of a new restricted list and conflict check platform as a natural development of its commitment to quality management in all disciplines and the management and protection of its brand. Crowe Global's mission is to Work As One and the new platform is a critical strategic development to facilitate the integration and growth of the network.
The Role
The Data Specialist will create data assets to solve business challenges for the global restricted list and global conflict checking on the large-scale, multi-year, cross-border, global strategic initiative. Comprehensive build and testing of such products require ingesting and transforming data into formats that can be easily generated and analyzed. The Data Specialist will be responsible for expanding and optimizing the data collection, as well as optimizing data flow and collection across Crowe Global member firms. The ideal candidate is experienced with data migration and analysis and enjoys optimizing data systems and building them from the ground up.
Responsibilities
Create, maintain, and advise on optimal data pipeline architecture from data ingestion to target for various data initiatives.
Design and implement the needed ETL or ELT.
Experience leading data mapping, cleansing, and end-user validation is a plus.
Assemble large, complex data sets that meet functional / non-functional business requirements.
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, etc.
Create scripts that provide details about data quality, operational efficiency, and other critical metrics.
Work with stakeholders including the executives, data owners, and design teams to assist with data-related technical issues and support their data infrastructure needs.
Design and implement solutions that ensure adherence to the applicable regulations and contractual obligations.
Assist with applying and monitoring data quality metrics from the enterprise quality library on the key fields of datasets.
Develop scripts and processes to migrate data across platforms.
Act as an expert with all facets of the data life cycle.
Identify sensitive and regulated data elements within product schemas that are mandated to be de-identified in non-production environments.
Must be able to effectively interact with, present information to, and respond to questions from all levels of the organization.
Possesses strong problem-solving skills and is comfortable with ambiguity, creative thinking, and leading change.
Detail-oriented and highly accurate in data entry and analysis.
Results-oriented, diligent, and working with a sense of urgency.
Assertive, responsible for his/her own work (self-directed), having a strong affinity for defining work in deliverables, and willing to commit to deadlines.
Commitment:
Time Commitment: 50% - 100% (20-40 hours weekly)
Expected Project Duration: 2-3 years
Qualifications:
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
Experience performing root cause analysis on internal and external data and processes to answer specific... For full info follow application link.
EOE M/F/D/V
