BA Macro Position Indore – night shift Essential Duties + Develop process automation tools and processes using VBA Excel Macros, Python, SQL, PowerBI, and other tools as needed. + Enhance and maintain existing VBA Excel Macros, Python programs and other tools as needed. + Work with stakeholders to uncover all requirements and develop iteratively towards a user accepted product. + Develop tools that are easy to maintain and enhance over time. + Address and find solutions to bugs and issues in VBA Macros, Python programs, SQL queries, PowerBI dashboards, etc. in a timely manner. + Write documentation for new and existing process automation tools and processes. + Assists in uncovering issues, evaluates various courses of action, and promotes the best option for resolution. + Becomes aware on how to locate and define new process improvement opportunities + Acquires data from primary and secondary data sources and assists in analyzing and interpreting trends or patterns in complex data sets. + Effectively use data visualization, in summaries and or dashboards to enhance translation of data and findings. + Performs data profiling and root cause analysis to identify and understand anomalies + Aids in preparing reports on data summaries, changes, and trends for use by management. Works collaboratively to provide assessment and recommendations to management. + Works to help resolve issues arising from internal department functions, or as brought forth by internal or external customers to assigned department. + Tracks issues to resolution within department and in partnership with other groups. + Monitors overall workflow to ensure timely completion of projects and daily work requirements. + Assists with special projects within assigned department or as part of cross-functional teams as required or assigned. + Works as part of a team to determine areas of risk as new or changed processes are implemented. + Able to use a standard process to develop quality software from requirements to deployment. Use tracking software to log progress during each step. Other Skills: + Intermediate to Advanced development skill in VBA for Excel. Must be able to make moderately complex macros from start to finish using VBA including UI and backend. + Must be able to make understandable code with good comments and design in a way that promotes future enhancements, easy bug-fixing, and code re-use. + Requires intermediate to advanced skills in Microsoft Office Suite (Excel). + Intermediate to Advanced skills in Python software development. + Basic to intermediate skills in SQL query development. + Experience with git or similar version control system. + Able to test and debug code independently. + Able to design and build from a user perspective. + Able to develop software independently based on a set of requirements. + Able to design and build iteratively (Agile development). + Able to work with stakeholders to define clear requirements and test cases. + Comfortable researching unknown topics and finding solutions to programming problems independently. + Comfortable working independently and in a team environment. + Inquisitive nature and unafraid to ask questions. + Growth mindset (continuous learning). + Strong time management skills. + Strong analytical skills. + Comfortable with written and spoken communication skills. + Strong organizational and note-taking skills and a propensity for accuracy is crucial. Equal Opportunity Employer: Minority/Female/Disability/Veteran