Ferguson is looking to design, develop, implement and support critically important enterprise Business Intelligence (BI) solutions to turn data into knowledge.
Requirements
- Adept at SQL programming using Oracle, Microsoft SQL-Server T-SQL, SSIS and SSRS 2012+
- Solid understanding of Azure cloud infrastructure, and Azure SAAS (software as a service).
- In depth knowledge of the following technical tools: SQL Server Management Studio, SQL Server Integrated Services, and Power Apps.
- Experience with BI technologies (e.g. Microsoft Power BI, Oracle BI, SSRS, Power Apps, Power Automate) preferred
- Solid understanding of database concepts
- Experience in Data Modeling preferred
- Desire to learn a vast array of on-premises and cloud technologies
Responsibilities
- Design, build and deploy BI solutions as they relate to SQL development projects
- Create effective and informative visualizations, dashboards, and reports
- Interact and extract data from Data Warehouse using SQL and Azure Data Factory
- Create and maintain ETL processes for moving and transforming data
- Automating processes via scripts, e.g. PowerShell, Python
- Performing regression analysis using R
- Use machine learning techniques and algorithms to build predictive models and extract insights from that data
Other
- Gather user requirements and translate business needs to technical specifications
- Communicate findings and insights clearly and effectively to all levels in the organization (both technical and non-technical users)
- Translate high level requirements into interaction flows
- Excellent communicator with strong written and verbal communication, including technical writing skills
- BA in Computer Science, Information Systems, Engineering or related field
