Colorado Technology Jobs

Colorado Jobs

Job Information

Sierra Nevada Corporation Sr. Business Intelligence Developer in Centennial, Colorado

The Business Intelligence (BI) Developer is responsible for working withBusiness Partners, Business Analysts, Project Managers, and other ITteams to ensure a tight fit between Business Intelligence/Analyticsenvironment, business requirements, and the Data Management platforms.The BI Developer is responsible for combining data from multiple sources intoBI-specific data models.The BI Developer designs, configures and manages the BI/Analytics toolsand environments, creates reports/dashboards, creates and delivers enduser training and documentation, and provides support to power users whodesign and author BI/Analytics content/reports/dashboards that enableend user decisions on behalf of their departmental colleagues.The successful candidate will be able to deep-dive into data to discoveractionable insights to support data-driven decisions. This position supportsData Science efforts including predictive/prescriptive analytics and AIanalysis of big data. The ideal candidate has a willingness to grow and learnwith an insatiable curiosity, and the ability to use critical thinkingskills to make analytic determinations.As SNC's corporate team we provide the company and its business areas withstrategic direction and business support spanning executive management,finance and accounting, operations, human resources, legal, IT,information security, facilities, marketing and communications.PRIMARY RESPONSIBILITIES INCLUDE:Create, modify, customize, and maintain BI/Analytics reports, reporttemplates, dashboards and content organization using Microsoft Power BI ontop of Cloud (AWS Redshift) and on-prem (SQL Server, SSAS).Maintain BI objects in legacy BI tools: SAP Crystal Reports 2016, SQLCrystal Reports Enterprise, SAP Web Intelligence, SAP Explorer,Cognos, Microsoft SQL Services Analysis Services, Microsoft DataGateway, and Microsoft Power BI.Develop SQL code, especially for ETL (Extract Transform Load) processes.Perform system maintenance activities on the server back end. Requiresreviewing error logs and user-reported errors. Must be able to manage systembackups and monitor server performance on a daily basis.Install, configure, deploy, maintain, and tune BI/Analyticsenvironments, including SAP Business Objects (BO) Enterprise,Microsoft Power BI Service, Microsoft Data Gateway, Microsoft SQL ServicesAnalysis Services, Cognos, and other extensions as necessary.Working knowledge of Windows Server and Active Directory, including serverconfiguration and application troubleshooting including Apache Tomcat and SAPBusiness Objects.Install, configure, deploy, and maintain the system of Analytics for ourBI/Analytics environments, currently using GB .and. Smith's 360.Audit and benchmark BI/Analytics tool functionality, security, access,rights, and performance. Troubleshoot issues as necessary while providingprofessional customer service.Ability to provide technical support and guidance to users and otheradministrators. Works closely with the systems administration team to resolveissues with server performance and user access.Support Data Science efforts using AI to analyze big data.Apply statistical and predictive modeling techniques to build, maintain,and improve decision systems.SKILLS REQUIRED:Requires a BA/BS in related field plus 6 years' experience.Demonstrated experience with visualization tools such as Power BI,Tableau, Cognos, etc.The ability to work with business SME is to translate business requirementsand KPIs into BI/Analytics models, views, reports, dashboards, andquery objects.Experience with cloud platforms such as Amazon Web Services (AWS) and/orAzure.Ability to write scripts for automating tasks including PowerShell andvbscript.Working knowledge of BI/Analytics tool architectures, functions,features, and customization options within the Microsoft Power BI, SQLServer Analysis Server, and Azure Analytics suites.Understanding of SQL-based relations and multidimensional designs.Strong problem solving and metadata skills.Required attr