The IT Department of one of the fastest-growing accounting firms in the country is seeking a Data Engineer/API Integrator who possesses a strong technical skillset, is motivated by quality work and embraces a collaborative environment. This individual will have a direct impact on our firm’s mission of serving as a catalyst for those striving to achieve their highest potential.    

In this role, you will support data and application integration by developing and implementing data repositories and integration architectures, strategies, guidelines, standards and leading practices. The ideal candidate will also be expected to provide support on technical and architectural direction, methodology and design to support project initiatives. You will help develop data-driven process improvements to build and connect data repositories. This role will help support the Firm Innovation and data analytic initiatives through the implementation of data analytics, business intelligence and API technologies. 

What You’ll Do:  

Database Warehouse responsibilities:

• Consolidate and optimize available data warehouse infrastructure.
• Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients.
• Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked.
• Design and implement ETL processes and data architecture to ensure proper functioning of analytics lad, as well as client’s or third-party’s reporting environments and dashboard.
• Collaborate with business and technology stakeholders in ensuring data warehouse development and utilization.
• Carry out monitoring, tuning, and database performance analysis.
• Perform the design and extension of data marts, meta data and data models.

API responsibilities:

• Evaluate and select enterprise application integration technologies and solution development lifecycle methodologies.
• Ability to work closely with vendors, other IT team members and architecture governance technical team for solution development and design reviews.
• Work closely with the department stakeholders and must understand the short- and medium-term strategy for the business.
• With the help of the team, define and own the technical implementation.
• Work with the Team and Product Owner in shaping a product roadmap.
• Develop and maintain scalable data pipelines and builds out new API integrations.
• Contribute to technical discussions to decide upon approaches and tools for individual projects.
• Build infrastructure to unite large-scale systems to access and process data.
• Define APIs to empower fast and intuitive data identification, exploration and action.

Data Analytics Strategy responsibilities:

• Implement techniques and systems to monitor data quality.
• Perform data analysis required to troubleshoot data related issues.
• Define a firm data strategy.
• Develop Data reporting processes.
• Develop Firm wide data standardization processes.
• Develop Data Quality processes.
• Identify Data Analytics applications that can help support Innovation and transformational products.
• Be a data advocate and educate department on more advanced uses of data analytics with client services.
• Help drive data related education to the firm.

What We’re Looking For:   

• Excellent written and oral communication skills.
• Strong service skills with the ability to interact with all levels of management.
• Detail-oriented; strong planning and organization skills; ability to make decisions.
• Resourceful in recognizing technical problems and developing solutions.
• Strong problem solving and troubleshooting skills with the ability to exercise mature judgement.
• Knowledge, experience and best practices in working with data repositories, data warehousing, data lakes, and data marts.
• Awareness of current developments affecting area of expertise.

Your Qualifications:  

• Bachelor or Master’s degree in Computer Science, Engineering or equivalent field is required.
• 3-5 year’s experience in integrating, designing and building APIs.
• 3-5 year’s experience working in data engineering role.
• Hands-on experience using Python, JSON, and C+
• Expert level knowledge of using SQL to write complex, highly-optimized queries across large volumes of data.
• Experience with PowerBI is preferred.
• Accounting or Financial Industry experience preferred.

What You'll Do:

• Leverage critical thinking skills to resolve simple and complex technical issues
• Provide resolution to problems across various software and hardware platforms
• Read/write documentation involving system configurations and recommendations
• Follow a list of written or verbal directions to achieve a consistent end result
• Utilize a ticketing system to track problem resolution and time
• Perform other duties as assigned

What We're Looking For:

• Excellent troubleshooting ability to determine causes and effects and solve problems
• Ability to independently manage projects to completion
• Understanding of all aspects of LAN/WAN environments TCP/IP, subnet masks, routing, SMTP, DNS, and DHCP
• Support products/vendors in the Anders CPA core technology stack: Meraki, Dell, VMware, Nutanix, Cisco IOS, Azure, Mimecast and MSFT Compliance/DLP
• Proficient understanding of proper cyber security practices
• Ability to multi-task, work on multiple projects and adapt to changes quickly with attention to detail
• Working knowledge of Windows desktops/Laptops/servers
• Working knowledge of software support, testing, and configurations
• Desire to learn new skills and be responsible for self-development
• Interpersonal skills: such as telephony skills, communication skills, active listening and excellent client service
• Technical awareness: the ability to match resources to technical issues appropriately
• Excellent written & typing skills to ensure accurate entry of service request details
• Self-motivated with the ability to work in a fast-moving environment
• Knowledge and use of Microsoft 365 and Azure are a must
• In-depth knowledge of Microsoft Intune and Microsoft Enterprise Security (Endpoint, DLP, MDM, Cloud App Security)
• Knowledge of basic security software

Your Qualifications:

• 5 – 7 years of experience as a Help Desk/Desktop Support (Tier 1/2) technician or higher level
• Bachelors degree in Information Technology or a relevant field
• Azure Virtual Desktop experience is a plus
• Certifications Preferred: MSCA-0365, Network+, Security+, Azure AZ-104, CCNA certifications

What You’ll Do:  

• Meet with business users at all levels to listen to business cases and help identify solutions.
• Responsible for transitioning projects from needs assessment to implementation. 
• Document user requirements and business processes.
• Assist in managing data strategy in the Firms practice management software, Microsoft Dynamics CRM, SharePoint, and other integrated services.
• Understanding automation tools and light development to help automate manual processes.
• Assist in maintaining data integrity in applications and databases.
• Assist in managing vendor relationships.
• Develop ad hoc reports, visualizations, and analyses for stakeholders.
• Take ownership of projects (visualizations, updated processes, reports, etc.). Responsible for updating when needed, following up with stakeholders, continuously improving.
• Perform other duties as assigned.

What We’re Looking For:   

• You must enjoy being a productive independent operator who can employ critical thinking and problem solving but knows how to use the resources at their disposal to get the job done.
• Strong analytical skills with the ability to collect, organize, analyze, interpret, and visualize data from multiple sources with attention to detail and accuracy.
• Ability identify and resolve data related issues when they appear.
• Excellent verbal and written communication skills.
• Ability to communicate technical solutions and concepts to a broader audience.
• Strong Excel skills (data cleanup and analysis).

Your Qualifications:  

• Bachelor’s degree in a quantitative discipline preferred
• 2-4 years of professional, full-time data experience, this includes experience with:
  • Coding language, SQL preferred
  • BI tool, Power BI preferred
  • Excel
• Ideally will have some experience with Power Apps, Power Automate, and/or VBA