We Light the Way
We are seeking a talented and enthusiastic individual to be a hands-on senior developer and thought leader for our Business Intelligence Team as we transform Acuity Brands analytics and migrate our BI platform to Azure and Power BI. This position will be responsible for development of our Azure data architecture using Data Factory, Data Bricks, Data Lake storage, and SQL DW. You will be responsible for executing Scrum development and delivery documentation as well as daily operational SLAs. This position may also have rotational responsibilities between projects and to support our daily and monthly operations.
WHAT YOU WILL DO
Manage individual projects priorities, deadlines and deliverables with your technical expertise while helping build a team and cultivate innovation.
Lead designs of major software components, systems, and features.
Work with Business Analysts, Data Architect, and Business to Design, develop, test, update data pipelines (ETL, replication, change data capture), and data profiling.
Mentor and train other team members on design techniques, coding standards, and agile etl development proceses.
Design and build data pipelines, data transformations, and data structures within the Azure Cloud platform
Collaborate with data/business analysts and end users from cross functional teams to ensure that data extracts, models, and reporting solutions meet reporting and analysis needs
Work within a daily Agile/Scrum process for sprints across projects and operations
Oversee and insure new development follows roadmap to build strategic data architecture
Manage operations processes to SLA s for BI solutions to deliver on-time information delivery
Keep abreast of new Azure and Power BI technologies & make recommendations on technology, process, and performance improvements
Bachelor s Degree in Computer Science, MIS, or other technical/analytical field (or equivalent experience)
Experience working multiple data integration or bi projects at the same time with competing priorities
Experience working with databases including proficiency in SQL coding across standard commercial databases (e.g Oracle, Teradata, MySQL etc).
Data Architecture and modeling experience
Experience with Python, SQL, Shell Scripting, Power Shell Scripting or C#
3+ years of BI experience designing, developing, and implementing reporting and analytics solutions
Additional Skills Desired
Experience with any of the following: Cloud IaaS/PaaS, Azure, O365, Cloud Integration etc.
Experience with distributed computing (i.e. Hadoop)
2+ years of working with Microsoft BI stack (SSIS, SSRS, SSAS, and T-SQL)
2+ years of experience building BI solutions in Azure (Data Factory, Data Lake, USQL, SQL DW, Data Bricks etc)
Strong MS SQL DBA or Spark experience and exposure with columnar indexed databases.
Strong experience with Python, Shell Scripting, or Power Shell Scripting
What's in it for you?
The chance to work on meaningful projects that drive company performance
4-Day work week (4-10, also 5-8 available, if preferred we are flexible)
Casual dress code
Creative and collaborative environment
Company paid sports leagues and wellness program
On-site game room (ping-pong, pool table, and Xbox)
And the ordinary benefits:
Health, Dental, Vision, Life, AD&D, 401K, HSA Accounts, Stock Purchase Plans
WHY IS ACUITY BRANDS A GREAT PLACE FOR BI ANALYTICS DEVELOPMENT?
Our team integrates and delivers information for performance monitoring across our company
Our company is a very profitable market leader and provides financial stability
You will work with highly talented, fun and supportive teams
You will be building leading edge BI technology with Power BI on MS Azure platforms and services
Equal Opportunity Employer/Minorities/Women/Veterans/Disabled/Sexual Orientation/Gender Identity
We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact (770) 922-9000.
Any unsolicited resumes sent to Acuity Brands from a third party, such as an Agency recruiter, including unsolicited resumes sent to an Acuity Brands mailing address, fax machine or email address, directly to Acuity Brands employees, or to Acuity Brands resume database will be considered Acuity Brands property. Acuity Brands will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume.
Acuity Brands will consider any candidate for whom an Agency has submitted an unsolicited resume to have been referred by the Agency free of any charges or fees. This includes any Agency that is an approved/engaged vendor, but does not have the appropriate approvals to be engaged on a search.