Business Intelligence Architect/Manager

Stage 3 has a diverse group of over 325 employees across the United States and Canada, all working to better our environment by recycling fluids and minimizing waste streams throughout numerous industries.  Stage 3 has been in business for over 12 years and is rapidly growing.  Our custom engineered solutions and team-based culture complement those who want to be part of a forward thinking and sustainability-based company that supports the health of our industries and our planet.  Stage 3 specializes in high quality solids control equipment designed for mud systems to effectively manage solids, reducing costs for the customer and providing limited or zero discharge solutions as necessary, but we don’t stop there. Additionally, Stage 3 uses a team of professionals to make intelligent and informed recommendations on how to best manage your job for efficiency and cost savings.
While our business has expanded, our mission remains to provide superior service and performance through:
Emphasis on Safety
Teamwork
Technology innovation
Operational integrity
Requirements
GENERAL DESCRIPTION:
The Business Intelligence Architect/Manager (BIM) is a key leadership role in the Information Technology Department that defines and implements standard ETL processes, report visualization standards, refresh schedules, role level security standards.  They will be responsible for leading a team of developers and administrators to clean and model data for use in the development of new reports for both internal and external customers. Serves as subject matter expert with in-depth knowledge of the complete business intelligence and analytics delivery lifecycle including data ingestion, integration, warehousing, data mart design, quality, governance, and information delivery through reports to Sales, Operations, Supply Chain, HR, HSE, Accounting, and the Executive teams.  
ESSENTIAL FUNCTIONS:  
 Organize and execute the daily backlogs of the Business Intelligence Team
Monitors, oversees, and holds employees accountable to performance expectations
Collaborate with all departments to provide actionable reports
Collaborate with development team to determine future development requirements and reporting needs
Through expert knowledge, translate high-level business requirements into data model designs (e.g., conceptual, logical, and physical), processes, and data assets that are well-defined, integrated, reusable, and trusted to empower analytics
Extract data from multiple data sources into dataflows to be used in creating models for reports
Conduct report inventory statistics, usage, scheduled refresh schedules
Make recommendations and implement approved architecture changes to improve overall performance
Maintain and organize the departmental JIRA Active Sprint and Backlog 
Full adherence to health and safety policy and procedures
Mentor technical developers in data architecture practices to propagate high-quality design, build, and processes to support the strategic data architecture direction
Lead complex support services with very little management input, including coordination of Data & Analytics initiatives, data warehouse application software support
Ensure daily operations meet and exceed daily performance expectations
Responsible for scheduling and approving supervised employee’s timecards and PTO requests
Technical Advisement of current and future DBA and JBID for internal promotion 
Demonstrate the role of a positive influence and change agent for compliance within our teams
REQUIRED KNOWLEDGE SKILLS AND ABILITIES:  
 Lead a SCRUM Team, and the SCRUM processes
Working knowledge of an organization’s core systems and their purpose including data assets, architecture, usage, and quality 
Ability to evaluate, develop, and implement leading business intelligence technologies and principles for data acquisition, transformation, integration, modeling, quality, security, governance, and visualization
Ability to analyze data and business processes (e.g., Operational, Financial, HR, HSE, etc) with business teams to develop requirements documentation
Ability to coach, motivate, develop, organize, engage, and retain a team of employees
Ability to visualize and document end-to-end business intelligence solutions based on data sources and analytic requirements for functional and technical business partners
Ability to champion strategic initiatives by identifying tangible project milestones with supporting tasks; identifying risks, dependencies, and prerequisites for an optimized workstream; managing expectations; and coordinating multiple teams to fulfill a common objective
Working knowledge of data modeling best practices (e.g., denormalization, star schema, snowflake) and data architecture constructs (e.g., data warehouses, operational dataflows, data marts, staging areas) to optimize analytics delivery and self-service discovery 
Working knowledge of ETL/ETL tools (e.g., DAX, M Query, and SQL Management Studio) and complex SQL programming 
Ability to manage enterprise-level vendor software upgrades by identifying, planning, and mitigating impacts on data repositories used for analytics and reporting
Able to communicate effectively with others
MINIMUM REQUIRED EDUCATION, CREDENTIALS, LICENSES & EXPERIENCE:
 Minimum of 10 years of experience in Business Intelligence, Data Warehousing, and Data Engineering disciplines in an enterprise IT environment 
Implementation and oversight of multiple enterprise data warehouses (custom-developed and vendor-packaged) in synchronization and support of organizational initiatives 
Implementation of integrated data model solutions spanning multiple subject areas and departments (e.g., Finance, Operations, HR, and Supply Chain) 
Optimization of data warehousing concepts including sustainability, performance, quality control, security, regulatory compliance, and data governance 
Working knowledge of database and ETL technologies, both custom-developed and vendor-packaged 
Experience conceptualizing, visualizing, and communicating complex solution designs with functional and technical audiences across all levels of the organization. 
Experience coordinating diverse project teams spanning business Subject Matter Experts, Developers, Database Administrators, Analysts, and IT Administrators 
NO AGENCY REFERRALS
EDUCATION: 
Bachelor’s degree in computer science, Information Technology, related field, or equivalent technical training and experience 
CERTIFICATION SUMMARY: 
Professional certifications are a plus, but not required
Benefits
Company Provided Benefits
Employee Health Insurance (100% Employer -paid)
Family Health Insurance (After 18 Months, 100% Employer Paid)
Life Insurance
Paid Time Off
Paid Holidays
Additional Available Benefits
Dental Insurance
Vision Insurance
Additional Life Insurance
Short Term Disability
Long Term Disability
401(K)