SSAB
Data Warehouse Developer Analyst
SSAB, Axis, Alabama, United States, 36505
SSAB is one of the largest North American producers of steel plate and coil, serving many industrial markets including energy, construction, agriculture and transportation. SSAB operates five state of the art facilities strategically located in key regions across the U.S.SSAB has nearly 1,200 highly skilled employees in the U.S. Jobs at SSAB range from machine operators and sales people to advanced engineers and corporate professionals in HR, finance and more. SSAB offers challenging careers and comprehensive benefit program designed to keep employees and their families healthy and secure.
Position Purpose
The Data Warehouse and Reporting Developer analysts primary role is to develop, test and implement database programs, reports and cubes as assigned by the Data Architect/Manager. The secondary role is to assist with the planning, execution, and monitoring of data flow between databases servers, and troubleshooting of all activities relating to a variety of Data Warehouse processes. Proven communication skills, problem-solving skills, and data integration experience are critical to successful performance.
Essential Functions
Assist in the design of data systems in collaboration with the data architecture manager, architects, analysts, application developers, project managers and system owners.Develop, test, implement and maintain Data Warehouse/BI components including but not limited to:Extract/Transform/Load (ETL) PackagesViews, Stored Procedures, FunctionsDatabase Schema Changes (under direction of Data Architect/Manager)Report and Cube Development/Maintenance
Monitor SQL job flows providing support when required on a rotational basis (after hours).Assist in the planning and testing of database refreshes and upgrades with the DBA.Create test processes in order to identify and remedy potential problem areas.Liaise with source system teams and end users to address data related issues.Build relationships with IT and user teams to gain an understanding of different data requirements and functionality.Office presence requiredRegular and reliable attendanceQUALIFICATIONSEducation
Required:
Four-year college diploma or university degree in computer science or computer engineering.Required Knowledge & Experience
Proven experience with project requirements analysis, technical requirements, business process mapping and data source to target mapping in a data warehouse environment.2-3 years of experienceProven SQL experience designing, developing and deploying schema changes, reports, queries, stored procedures and functions (Microsoft SQL 2008 required, 2012 a plus).ETL package development and maintenance in a data warehouse/reporting environment.Experience developing end user reports and data quality reports/audits.Understand SQL Server security principles as they apply to database objects, reports and cubes.Excellent oral and interpersonal communication skills.Outstanding writing and documentation skills.Ability to communicate ideas in both technical and user-friendly language.Ability to troubleshoot data and integration issues.Highly self-motivated and directed, with keen attention to detail and quality.Able to prioritize and execute tasks in a timely manner, and at times high-pressure environment.Experience working in a team-oriented, collaborative environment.Preferred:
Visual Studio (Business Intelligence/Database) and TFS experience including deployment methods and package versioningExperience with SSAS cube development (SQL 2012 a plus) and Excel Pivot tablesSome MDX and DAX exposure is a plusUnderstanding of Tableau or other Business Intelligence toolsetsUnderstanding of SAP ERP systemsFamiliarity with MDM principlesInformatica experience is a plusExperience working with global teams and systems is a plusSUPERVISORY RESPONSIBILITIES / DIRECT REPORTS
This position has no supervisory responsibilities.
WORK ENVIRONMENT AND PHYSICAL DEMANDS
The employee is constantly required to:
Sit and work at a desk
The employee is frequently required to:
Stand and walk, and may alternate sitting and standing as needed
Balance, stoop, kneel, crouch, crawl, climb
Twist at waist level
Reach above shoulder level, at waist/desk level, and below waist/desk level
Finger with right hand, left hand, and both hands (fine motor)
Feel with right hand, left hand, and both hands (sensing temperatures and textures)
The employee is occasionally required to:
Push, pull, lift and/or carry up to 50 pounds
The employee is required to:
Talk person to person, on the phone, and in group settings as needed
Hear in person, on the phone, and in group settings as needed
Possess near, midrange, far, peripheral, and depth perception vision
POSITION TYPE/EXPECTED HOURS OF WORK/TRAVEL REQUIREMENTS
Position is full time, non-exemptOn call availability for deployments, critical break/fix issues, and month end processing as requiredExtended hours including evenings and weekends may be required to meet project deadlines or provide services outside normal operating hoursAbility to travel domestically and internationally if required for support roleOTHER DUTIES
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that may be required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.
SSAB's vision is a stronger, lighter and more sustainable world.SSAB's values form the guiding principals of our company.They shape our culture and characteristics. They serve as a compass for our actions and behavior, and describe what we stand for. Values guide us daily in making the right choices and doing the right things.
SSAB's values are:
Driven - Together we create valueTrue - Do what is rightAhead - Future in mindOther details
Job Family AmericasPay Type SalaryTravel Required NoRequired Education Bachelor's Degree
Apply Now
Position Purpose
The Data Warehouse and Reporting Developer analysts primary role is to develop, test and implement database programs, reports and cubes as assigned by the Data Architect/Manager. The secondary role is to assist with the planning, execution, and monitoring of data flow between databases servers, and troubleshooting of all activities relating to a variety of Data Warehouse processes. Proven communication skills, problem-solving skills, and data integration experience are critical to successful performance.
Essential Functions
Assist in the design of data systems in collaboration with the data architecture manager, architects, analysts, application developers, project managers and system owners.Develop, test, implement and maintain Data Warehouse/BI components including but not limited to:Extract/Transform/Load (ETL) PackagesViews, Stored Procedures, FunctionsDatabase Schema Changes (under direction of Data Architect/Manager)Report and Cube Development/Maintenance
Monitor SQL job flows providing support when required on a rotational basis (after hours).Assist in the planning and testing of database refreshes and upgrades with the DBA.Create test processes in order to identify and remedy potential problem areas.Liaise with source system teams and end users to address data related issues.Build relationships with IT and user teams to gain an understanding of different data requirements and functionality.Office presence requiredRegular and reliable attendanceQUALIFICATIONSEducation
Required:
Four-year college diploma or university degree in computer science or computer engineering.Required Knowledge & Experience
Proven experience with project requirements analysis, technical requirements, business process mapping and data source to target mapping in a data warehouse environment.2-3 years of experienceProven SQL experience designing, developing and deploying schema changes, reports, queries, stored procedures and functions (Microsoft SQL 2008 required, 2012 a plus).ETL package development and maintenance in a data warehouse/reporting environment.Experience developing end user reports and data quality reports/audits.Understand SQL Server security principles as they apply to database objects, reports and cubes.Excellent oral and interpersonal communication skills.Outstanding writing and documentation skills.Ability to communicate ideas in both technical and user-friendly language.Ability to troubleshoot data and integration issues.Highly self-motivated and directed, with keen attention to detail and quality.Able to prioritize and execute tasks in a timely manner, and at times high-pressure environment.Experience working in a team-oriented, collaborative environment.Preferred:
Visual Studio (Business Intelligence/Database) and TFS experience including deployment methods and package versioningExperience with SSAS cube development (SQL 2012 a plus) and Excel Pivot tablesSome MDX and DAX exposure is a plusUnderstanding of Tableau or other Business Intelligence toolsetsUnderstanding of SAP ERP systemsFamiliarity with MDM principlesInformatica experience is a plusExperience working with global teams and systems is a plusSUPERVISORY RESPONSIBILITIES / DIRECT REPORTS
This position has no supervisory responsibilities.
WORK ENVIRONMENT AND PHYSICAL DEMANDS
The employee is constantly required to:
Sit and work at a desk
The employee is frequently required to:
Stand and walk, and may alternate sitting and standing as needed
Balance, stoop, kneel, crouch, crawl, climb
Twist at waist level
Reach above shoulder level, at waist/desk level, and below waist/desk level
Finger with right hand, left hand, and both hands (fine motor)
Feel with right hand, left hand, and both hands (sensing temperatures and textures)
The employee is occasionally required to:
Push, pull, lift and/or carry up to 50 pounds
The employee is required to:
Talk person to person, on the phone, and in group settings as needed
Hear in person, on the phone, and in group settings as needed
Possess near, midrange, far, peripheral, and depth perception vision
POSITION TYPE/EXPECTED HOURS OF WORK/TRAVEL REQUIREMENTS
Position is full time, non-exemptOn call availability for deployments, critical break/fix issues, and month end processing as requiredExtended hours including evenings and weekends may be required to meet project deadlines or provide services outside normal operating hoursAbility to travel domestically and internationally if required for support roleOTHER DUTIES
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that may be required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.
SSAB's vision is a stronger, lighter and more sustainable world.SSAB's values form the guiding principals of our company.They shape our culture and characteristics. They serve as a compass for our actions and behavior, and describe what we stand for. Values guide us daily in making the right choices and doing the right things.
SSAB's values are:
Driven - Together we create valueTrue - Do what is rightAhead - Future in mindOther details
Job Family AmericasPay Type SalaryTravel Required NoRequired Education Bachelor's Degree
Apply Now