The Role
Develop, maintain, and document process automation tools using VBA, Python, SQL, and Power BI. Collaborate with stakeholders to gather requirements, build user-focused solutions iteratively, debug issues, perform data profiling and root-cause analysis, create visualizations and reports, and support continuous process improvements and special projects.
Summary Generated by Built In
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.
Skills Required
- Intermediate to advanced VBA development for Excel, including UI and backend macro creation
- Intermediate to advanced Python software development
- Basic to intermediate SQL query development
- Power BI dashboard development and data visualization
- Proficient Microsoft Office Suite, especially Excel
- Experience with git or similar version control systems
- Ability to test, debug, and resolve issues in code independently
- Experience developing maintainable, well-documented, and commented code
- Ability to work with stakeholders to define requirements and iterate (Agile)
- Data profiling, root cause analysis, and preparing summary reports for management
- Strong analytical, time management, written and verbal communication skills
- Comfortable researching solutions independently and working both independently and in teams
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
WM is North America's leading provider of integrated environmental solutions. We partner with our customers and communities to manage and reduce waste from collection to disposal while recovering valuable resources and creating clean, renewable energy. We are on a quest for environmental performance, a mission to maximize resource value, while minimizing – and even eliminating – environmental impact so that both our economy and our environment can thrive. WM tailors its services to meet the needs of each customer group and to ensure consistent, superior service at the local level. Headquartered in Houston, the company serves nearly 20 million municipal, commercial, industrial, and residential customers through a network of 367 collection operations, 355 transfer stations, 273 active landfill disposal sites, 16 waste-to-energy plants, 104 recycling plants, and 111 beneficial-use landfill gas projects.
