Enterprise Data Architect

About ACA:

ACA was founded in 2002 by four former SEC regulators and one former state regulator. The founders saw a need for investment advisers to receive expert guidance on existing and new regulations. Over the years, ACA has grown both organically and by acquisition to expand our GRC business and technology solutions. Our services now include GIPS standards verification, cybersecurity and technology risk, regulatory technology, ESG advisory, AML and financial crimes, financial and regulatory reporting, and Mirabella for establishing EU operations.

ACA is an equal opportunity employer that values diversity. We conduct our business without regard to actual or perceived age, race, color, religion, disability, caregiver, marital or partnership status, pregnancy (including childbirth, breastfeeding, or related medical conditions), ancestry, national origin and citizenship, sex, gender identity and expression, sexual orientation, sexual and reproductive health decisions, military or veteran status, creed, genetic predisposition, carrier status or any other category protected by federal, state and local law.

Position Summary:

As an Enterprise Architect at ACA you will be responsible for overseeing the development and use of data systems. You will discover efficient ways to organize, store, and analyze data with attention to security and confidentiality. A great asset for a data-driven company, your strategic planning and oversight will help us improve our operational efficiency and drive business growth.

Job Duties:

• Develop and implement data management strategies that align with company goals.

• Oversee the collection, storage, management, quality, and protection of data.
• Ensure data accuracy and accessibility and reduce data redundancy.
• Collaborate with IT teams and management to devise a data strategy that addresses industry requirements.
• Lead and mentor a team of data professionals
• Contribute to the design and development of the core Enterprise Data Services hub
• Work directly with internal business stakeholders to drive out requirements and gain alignment on solution options.
  
  

Education, Experience and Skills:

• Bachelor’s degree in Computer Science, Data Science or related field and a minimum of seven (7) years of experience OR a minimum of ten (10) years of applicable industry experience (if no bachelor’s degree)

• Knowledge of data modeling practices with experience building enterprise data solutions
• Experience designing and building reporting and dashboarding solutions
• Working understanding of Microsoft Azure cloud environment and applicable data technologies – Azure Data Factory, Event Hubs, Synapse etc.
• Willingness to learn and experiment with new technologies to provide best in class solutions
• Good communication skills – ability to discuss technical topics with business stakeholders
• Working experience to pull and push data from various APIs, including REST
• Good understanding of using Postman
• Working experience to read and write SQL, stored procedures and functions
• Good understanding and demonstrated experience with Azure Data Factory pipelines
• Good understanding and demonstrated experience with Azure data landscape.
• Experience with DAX and M query formations.
  
  

Preferred Education and Experience:

• Experience working in Power BI

• Experience building SSAS cubes, particularly tabular modeling
• C#, Python or other object-oriented programming experience a plus – used currently to write Azure
• Functions as needed
• AI/ML knowledge in support of long-term strategy
  
  

Required Skills and Attributes:

• Experienced in Data Modeling

• Experience with Azure Cloud and relevant data technologies
• Experience building reports and dashboards – preferably in Power BI.
• Ability to work directly with and communicate well with all levels of leadership and business partners.
• Must be comfortable balancing several projects at once and able to pivot as business need arise
  
  

Preferred Licenses and Certification(s):

• Microsoft Certification in Azure or Equivalent

• Data Science Certifications
• Data management Certification
  
  

Why join our team?

We are the leading governance, risk, and compliance (GRC) advisor in financial services. When you join ACA, you'll become part of a team whose unique combination of talent includes the industry's largest team of former regulators, compliance professionals, legal professionals, and GIPS® standards verifiers in the industry, along with practitioners in cybersecurity, ESG, and regulatory technology.

Our team enjoys an entrepreneurial work environment by offering innovative and tailored solutions for our clients. We encourage creative thinking and making the most of your experience at ACA by offering multiple career paths. We foster a culture of growth by focusing on continuous learning through inquiry and curiosity, and transparency. If you’re ready to be part of an award-winning, global team of thoughtful, talented, and committed professionals, you’ve come to the right place.