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 own built 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 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
Data Specialist creates 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 an experienced data wrangler who enjoys optimizing data systems and building them from the ground up. They must be self-directed and comfortable supporting the data needs across multiple teams, systems, and products.
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.
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, re-designing infrastructure for greater scalability, etc.
Build the infrastructure required for optimal extraction, transformation, and loading of data (structured and semi-structured) from a wide variety of data sources using SQL and Azure technologies.
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 and advise product development teams on data modeling.
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.
Possess strong problem-solving skills and comfortable with ambiguity, creative thinking and leading change.
Detail oriented. Highly accurate in data entry and analysis.
Results-oriented, diligent, and work 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%
Target Start Date: April 2024
Expected 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 building and optimizing 'big data' data pipelines, architectures, and data sets.
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Strong analytic skills related to working with structured and semi-structured datasets.
Build processes supporting data transformation, data structures, metadata, dependency and workload management.
A successful history of manipulating, processing, and extracting value from large, disconnected datasets.
Working knowledge of message queuing, stream processing, and highly scalable high volume data stores.
Strong project management and organizational skills.
Experience supporting and working with cross-functional teams in a dynamic environment.
Requirements:
5+ years of experience in a Data Engineer role, and has attained a bachelor's degree in computer science, statistics, informatics, information systems or another quantitative field.
Deep experience with MS SQL, SSIS and Azure technologies (must have).
Deep experience with object-oriented/object function scripting languages: Shell, PowerShell, Python, JavaScript, C#, etc. (must have).
Exposure to synthetic data generation tools, methods, and architectures. (nice to have)
Experience with NoSQL databases, including Azure Cosmos DB, Redis and MongoDB (nice to have).
Experience with high volume data tools: Azure Blob Storage, Azure Data Lake, HDFS etc. (nice to have).
Experience with data de-identification tools, like Redgate Data Masker, etc. (nice to have).
Strong problem solving and analytical skills.
Ability to take part in audio and/or video conferencing & virtual whiteboarding with geographically dispersed teams.
Collaborative nature to partner with diverse set of stakeholders.
Experience working on international projects across the globe dealing with various time zones and understanding local customs is a plus.
As required, ability to work overtime during peak project periods.
Key positions with which this position interfaces:
Crowe Global Program Director
Crowe Global project resources and subject matter experts
Crowe Global project contractors
Crowe Global member firm leaders
Crowe Global Conflicts Service Center Director
Crowe Global Data team members
Crowe Global Conflicts team members
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 $62,115.00 to $135,353.00.
Our Benefits:
At Crowe, we know that great peopleare 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 (www.crowe.com) 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.
EOE M/F/D/V
