Business Intelligence Analyst
E.R. Snell Contractor
- Snellville, GA
- Permanent
- Full-time
- Work to develop a data strategy focused on industry benchmarking and organizational KPI delivery
- Work to design the data architecture to support our business intelligence initiatives
- Gather requirements and design business intelligence reports and templates for our customers on a consultancy basis
- Provide implementation and technical training support for customers and project teams around business intelligence and data analytics
- Perform regular audits of data ETLs and data source reliability as well as troubleshooting any issues to ensure accuracy of subsequent reports which will influence business decisions
- Consult with our employees on business operations and performance objectives using data to provide insight into opportunities for improving their current processes, and delivering strategic solutions to optimize their operational efficacy
- Analyze and improve our existing templates, reports, and dashboards by re-engineering existing solutions and queries.
- Work with the data team to extract, transform, and load data from various sources, to develop functional and flexible dashboards that provide a holistic view of business performance and actionable insights for both internal team members and our customers
- Develop and maintain reports and dashboards using your business acumen and technical knowledge that help both our business and our customers to develop conclusive ideas to improve future operations
- Engage with internal departments and teams to streamline and standardize existing reports and increase efficiencies
- Excel and the MS Office 365 suite as well as significant exposure to Power BI, Tableau, or other related data visualization programs
- Experience extracting, cleaning, and summarizing data from SQL databases
- Exposure to SQL, Python, APIs, SSMS, SSRS, and DAX
- Degree in Management Information Systems, Data Analytics, Business Administration, Computer Information Systems or a field of study that showcases your data wrangling acumen.
- Ability to perform data analysis or business intelligence with a focus on data visualization and modeling.
- Experience in both designing descriptive and prescriptive analytical models and approaches to solving complex business problems
- Experience in developing and tuning complex machine learning models and data architectures to support those models long term.
- Experience with workflows and development best practices such as documentation, reproducibility, and data-governance as well as in project management and working with cross-functional teams to achieve business goals
- Understanding of the analytics capability within Salesforce or sufficient exposure to Salesforce
- Proven experience developing and building data visualization templates for use by different industries
- Strong knowledge or experience around database design and architecture; OLAP design knowledge is beneficial
- Understanding of ETL tools and techniques and how to perform extensive data manipulation
- Strong proficiency in SQL environments, in respect to data analysis, and equivalent expertise in visualization and reporting tools such as Tableau or Microsoft Power BI in a way that tells a story and drives decisions
- Working knowledge in R or Python and advanced knowledge in Excel
- Any experience in heavy civil construction is beneficial