Senior Accounting Architecture Analyst

Service Center

CSCS TX

We are looking for a Senior Accounting Architecture Analyst with expertise in SQL, Microsoft’s Power Platform, and Python to join our dynamic team. The ideal candidate will be instrumental in architecting new data solutions, optimizing existing ones, and supporting Accounting-related requirements while providing insightful analytics. This role requires a proactive individual who can collaborate effectively with the entire Accounting department, IT, and other business units. 

The work will involve developing and supporting complex data solutions while solving key business opportunities. The primary focus will be on SQL, Python, data modeling, and additional responsibilities within BI tools, RPA tools like Power Automate, ETL processes, and ensuring data integrity. 

Essential Job Duties: 

• Act as a solutions architect for the Accounting department, supporting projects and change management initiatives across key project owners (Accounting, Operations, IT, Internal Controls, etc.) 

• Act as an internal consultant to the Accounting department with a high level of care to stakeholder needs and requirements. 

• Design, develop, and optimize SQL queries and cloud-based solutions to support Accounting initiatives. 

• Assist in designing, implementing, and maintaining complex BI solutions using SQL, Snowflake, PowerBI Semantic Models, Excel Power Pivot, etc. 

• Create and maintain reporting tools, PowerApps, and Power Automate workflows for improvement opportunities, and process change requests as needed. 

• Develop and maintain ETL processes to support data integration and transformation needs across the organization. 

• Manage Accounting tools, accounting reporting, and data analytics systems while ensuring governance, security, consistency, integrity, and accuracy of all end-user data. 

• Provide ongoing support and training to end-users, ensuring effective utilization of data tools and resources. 

• Participate in system maintenance, upgrades, and integration projects, ensuring minimal disruption to business operations. 

Education, Experience, and Skills for Success: 

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field; or equivalent work experience. 

• Master’s degree in Computer Science, MSBA, MBA, MIS, or PhD is a plus. 

• 5 years of experience in data analysis, with a strong focus on PowerBI Semantic Modelli