*This great opportunity will be onsite out of our Milwaukee, WI offices!*
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
-
Associate’s degree in Computer Science or Programming is required. Bachelor’s degree preferred. Extensive, demonstrated previous experience in the field may be considered in lieu of a degree.
-
2-4 years of applicable experience in database/data warehouse design and development is required
-
2-4 years of development and support experience in a manufacturing environment is preferred
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