What are the responsibilities and job description for the Business Intelligence Technical Lead/HYBRID position at MSC?
**Applicants must be authorized to work in the U.S. At this time, we are unable to sponsor or take over sponsorship of an employment Visa for this position.**
Brief Position Summary
The BI Technical Lead will build data frameworks and design the business intelligence data architecture across the enterprise. This role will be the guide for architectural principles and standards around information delivery and data integrations. The BI technical lead will also lead the business intelligence development group and build a strong foundation for data accessibility. Additionally, this role will drive business intelligence platform roadmap and enhancements to enable services and features for our significant user base on our BI platforms.
Duties And Responsibilities
What You Need:
The salary range represented is based on similar roles in comparable industries, and the cost of labor in respective cities. Actual compensation is based on the candidate s relevant experience, education requirements and peer pay equity. The Company reserves the right to modify the range as market conditions change.
Brief Position Summary
The BI Technical Lead will build data frameworks and design the business intelligence data architecture across the enterprise. This role will be the guide for architectural principles and standards around information delivery and data integrations. The BI technical lead will also lead the business intelligence development group and build a strong foundation for data accessibility. Additionally, this role will drive business intelligence platform roadmap and enhancements to enable services and features for our significant user base on our BI platforms.
Duties And Responsibilities
- Owns business intelligence solution architecture, design, development, and implementation.
- Provides technical leadership and guidance to BI Developers, including implementation and design frameworks and patterns to deliver data quickly.
- Performs metadata modeling and develop complex integrated data sets from disparate data sources with an expert utilization of SQL or BI platforms.
- Builds and maintains schema objects and abstraction layer on top of various, changing enterprise data assets.
- Interprets and assists in designing normalized and dimensional data modeling as well as experience implementing metadata solutions, and bi-temporal data models.
- Manages and prioritizes workload of BI Developers by coordinating incoming work assignments with appropriate associates to deliver on overall design.
- Enables BI platform features and enhancements for specific to our end user needs on the business intelligence platforms.
- Collaborate with business intelligence vendors on future upgrades and enhancement requests to enable the BI platform services.
- Collaborates with business users to define requirements and reporting specifications and provide technical report assistance.
- Automating processes and frameworks with a focus on reuse and speed to deliver new data insights.
- Create and maintain all documentation regarding Sales Operations procedures and policies. Communicate any process or policy changes to field sales organization to include attendance on district conference calls to train associates.
- Fosters the MSC Culture in the department and throughout the company to ensure fulfillment of MSC s vision and unity of purpose.
- Participation in special projects and performs additional duties as required.
What You Need:
- Bachelor s Degree in Computer Science, Information Technology, Systems Analysis or a related study.
- Minimum 7 years of experience working with high volume data infrastructure with exposure to database design/structures, Data Modelling, ETL/ELT design patterns, and datamart structures (star, data schemas, etc.)
- Minimum 5 years of experience integrating data into overall business intelligence models and semantic models.
- Minimum 5 years designing overall business intelligence data architecture and delivering on data integration into the overall BI models.
- Minimum 4 years of experience leading BI developers and implementing overall data design.
- Minimum 4 years managing BI platforms (Looker, tableau, Alteryx) defining a feature roadmap for these services.
- Experience with Looker and Look ML, Alteryx, Tableau business intelligence platforms
- Experience managing overall data architecture in Erwin
- Advanced SQL knowledge and experience implementing optimized design for performant BI
- Strong knowledge of software development processes and procedures for agile development
- Expertise in data integration into semantic reporting models from multiple source systems
- Experience on with big query and the Google data platform
- A valid driver s license may be required.
- Position may require up to 10% of travel
- This position may require access to International Traffic in Arms Regulations Information ( ITAR ) and/or Controlled Unclassified Information ( CUI )
The salary range represented is based on similar roles in comparable industries, and the cost of labor in respective cities. Actual compensation is based on the candidate s relevant experience, education requirements and peer pay equity. The Company reserves the right to modify the range as market conditions change.
Salary : $93,590 - $147,070