This position is responsible for design and maintenance of data warehousing structures, data management, various DataMart’s, business rules, various reports, dashboards, scoreboards, and other solutions to fulfill business intelligence requests. This role will work closely with different department leaders to design, develop and support business intelligence reports, scorecards, data structures, and dashboards.
Role and Responsibilities
- Identify ways to improve the IT department’s functions so they support our internal and external demands
Leads in the design of the technical and information architecture for the data warehouse, proposing holistic innovative solutions from a working comprehension of the “as is” functionality across the enterprise. This extends to all information structures (staging area, data lake, data marts, and operational data stores).
·Evaluate existing and new systems, applications and business process for opportunities, discrepancies, vulnerabilities and risk in support of continuous improvement
·Identify and develop best practices, policies and procedures to improve solution ability across the enterprise
·Contribute to the creations of the technology roadmap and ensure adherence to best practices in support of technology roadmap
·Evaluate and recommend tools, technologies, and processes to ensure the highest quality product platform
·Create and analyze benchmarks against industry to develop best practice across organization
Provide stakeholder management and provide leadership and supervision for enterprise solutions
Innovate and identify ways to reduce costs and improve business services to align to IT investments
Develop business process architecture models that ensures quality solutions that align to company strategies and goals
Develop and implement the appropriate governance to ensure the agreement and maintenance of the overall enterprise architecture and ensure that the process delivers strategic values
Consulting with internal and external clients to model enterprise-wide complex data structures including master data management
Participate in development and maintenance of the Business Intelligence solution & technologies, architecture and recommend solutions to business needs including creating structure where none exists for reporting/analytics database solutions using modern techniques and programming language
Works harmoniously in a cross-functional team comprised of managers, supervisors, business analysts, systems personnel and other developers in ensuring the delivery of BI solutions as planned, on time and within the budget
Develop and maintain the appropriate operational documentation for databases
Research, collect, validate, and collate data and information to design, direct, and support the development of accurate and meaningful business intelligence reports.
Qualifications and Education Requirements
- Bachelors Degree required. Masters preferred
- 10+ years' experience (5+ Leadership)
- Responsible for budgeting and financial impact of information technology on the business
- Determine criteria for assessing issues, opportunities, and performance
- Manage strategic direction around technology and product road mapping
- Utilize formal problem-solving tools and techniques to generate multiple potential solutions
- Strong written and oral communication skills
10+ years in related role in addition to a bachelor’s degree in Information Systems, Management Information Systems, Computer Science, Statistics or related field. Demonstrated experience can be exchanged for the degree.
5+ years of experience Databases (SQL Server), programming (SQL, SSIS, SSRS and SSAS) & Store Procedures
3+ years of experience with reporting packages (Power BI)
3+ year of experience Leading & providing technical guidance to the team
Minimum 3+ years’ experience in writing complex and performant queries in SQL.
Minimum 3+ years’ experience developing predictive models and machine learning solutions utilizing R or Python is preferred.
Minimum 3+ years’ Experience in implementing big data technologies like Hadoop, Spark is preferred but not required
Strong experience in solution design, integration architecture, and process improvement
Rich understanding of data architectural and design patterns including normalized, dimensional, data vault, and multi-dimensional approaches.
Researches and prototypes technical solutions for data warehouse architecture, ETL, cubes, analytics and cloud integration. Provides recommendations to Executive and IT leadership.
Ability to concisely document and express data architectures and standards that can be readily understood and applied by both IT leadership and developers.
Willingness to learn and experiment with technologies outside of his/her comfort area.
Excellent interpersonal skills and ability to work with all levels of personnel individually and within teams. Good communication skills, both verbal and written.
Excellent project, organization change and financial management skills.
Apply knowledge of Microsoft SQL server, supporting operating systems, transaction managers, database tools, utilities, gateways, and middleware to sustain operations.
Create or review technical design documentation to ensure the accurate development of reporting solutions.