Steelesolutions Milwaukee , WI 53201
Posted 2 weeks ago
Summary
Under direction of the IT Director, this position is responsible for handling the delivery of data and information relating to business intelligence of the organization. This individual will work in a team environment to design, develop and maintain data warehouse and analytics architecture to meet the Steele Solutions' analysis and reporting needs.
Essential Duties and Responsibilities
Consolidates and optimizes available data warehouse infrastructure
Conceives analytics and business intelligence platform architecture for clients, including internal and third-party clients
Designs and implements ETL (Extract, Transform, Load) procedures for intake of data from both internal and outside sources; as well as ensures data is verified and quality is checked
Designs and implements ETL processes and data architecture to ensure proper functioning of analytics, as well as client's or third-party's reporting environments and dashboard
Collaborates with business and technology stakeholders in ensuring data warehouse architecture development and utilization
Carries out monitoring, tuning, and database performance analysis
Performs the design and extension of data marts, meta data, and data models
Ensure all data warehouse architecture codes are maintained in a version control system.
Problem solving and root cause analysis. The ability to recognize a symptom and then fix a systematic problem
Independently completes project activity as delegated by the project leader. Projects can be either product/process improvement or production design process improvement. Contributes ideas for further improvements.
Interfaces with other departments regularly in completing routine work
Qualifications: Education and/or Experience
Technical Skills
Experience with SQL Server 2016 and above required
SSIS knowledge required
SSRS reporting software knowledge required
SQL DB replication required
Knowledge of Power BI / Tableau / End user reporting tools necessary
C# knowledge preferred
VB .Net preferred
Other Skills
Provide mentorship to the IT team across all sites with guidance, advice, support, etc.
Detailed orientation
Self-reliant and project driven
Ability to communicate and update stakeholders up to executive level
Able to works independently to solve problems, but using good judgment in seeking guidance where appropriate. Interfaces with other departments regularly in completing routine work Text
Typical work requires an understanding of manufacturing processes, familiarity with Engineering information and data
Steelesolutions