Lead Spec - IT BI Developer

Required Skills

• Years of experience requirements are below based on the specific level.  Experience should include at least 5 years of experience developing traditional BI solutions within the Microsoft BI stack (MS SQL Server/SSIS/SSAS/SSRS) and at least 3 years of experience implementing modern BI Solutions in the MS Azure BI stack.
• Bachelor's degree from an accredited college or university in Computer Science, Computer Engineering, or a related field.
• Fluency in MS SQL query language, ability to write stored procedures, views, indexes, etc.
• Previous experience reporting and warehousing of IOT data.
• Understanding of cloud and distributed systems principles, including load balancing, networks, scaling, in-memory vs. disk.
• Proficient in developing and executing test scenarios including regression testing.
• Strong tracking, coordination and project planning skills
• Ability to identify and implement programing logic and/or application improvements
• Must be able to work on multiple simultaneous tasks with limited supervision
• Quick learner, motivated self-starter, team player
• Excellent customer service, interpersonal, verbal and written communication, and team collaboration skills
• Able to follow change management procedures and internal guidelines
• Strong time-management skills, initiative, commitment, and ability to work under pressure to meet tight deadlines while maintaining high quality standards and best practices
• Excellent analytical and problem solving skills, strong organizational skills, attention to detail.

Required experience is commensurate with the selected job level:

• The Senior IT Specialist level requires a Bachelor's degree or equivalent experience and 5-8 years of relevant job related experience
• The Lead IT Specialist level requires a Bachelor's degree or equivalent experience and 8+ years of relevant job related experience
• The Principal IT Specialist level requires a Bachelor's degree or equivalent experience and 10+ years of relevant job related experience.

Working Conditions:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

• Usually, normal office working conditions. 
• Must be able to remain in a stationary position 50% of the time due to prolonged periods of sitting or standing. 
• Occasional overnight travel may be required.  

Additional Preferred Skills

• Relevant industry experience such as crude, natural gas, NGL storage and/or other energy transportation.
• Visualization experience with Tableau or Power BI.
• Scrum/Agile certification or experience.
• Azure DevOps, JIRA, and/or Jenkins experience.
• Previous experience in DevOps, Web Development, or DBA teams.
• Experience with consuming and developing REST API, JSON, XML, and/or JavaScript.
• Experience warehousing or reporting against SCADA or other IOT solutions.
• Confidence in several programming languages such as R, Python, Scala, or Java, with the ability to pick up new languages and technologies quickly.
• Data Science/Advanced Analytics (ex: Predictive Analytics, Text Analytics, and analysis of unstructured data).
• Experience with large-scale, big data methods, such as Hadoop, Spark, Hive, Impala, or Storm.
• Data modeling with SAP BW on HANA with HANA Studio and HANA Views.
• ITIL Certification or experience using Remedy application is a plus.

• System administration skills with SSRS, Tableau, or Business Objects.