Sr. Business Intelligence Developer
About The Position
Uline, Inc. seeks a Sr. Business Intelligence Developer in Pleasant Prairie, WI to conduct business intelligence analysis. Design and develop enterprise and departmental business intelligence and data warehousing backend solutions. Conduct unit testing on peer developed code. Troubleshoot to identify data issues and resolutions including fixing data discrepancies, resolving performance issues, addressing missing or duplicate data, correcting data type mismatches, and improving data quality through cleansing and validation. Conduct code review in the development of tasks. Collaborate across business teams to gather and document business intelligence information. Design, implement, and test data warehouse applications in partnership with project leads, business analysts, and end-users. Utilize database platforms including SQL Server, Oracle, and DB2. Write T-SQL queries and perform database performance tuning. Design and implement data engineering processes to support business analytics and reporting. Develop and execute unit, system, performance, and regression testing on data integration mappings using Informatica PowerCenter. Create Source to Target Mapping Specifications for data integration development. Uphold established coding standards, perform code reviews, and improve standards to ensure compliance.
Requirements
- Bachelor’s degree in Computer Engineering or a related technical field
- 5 progressive years of data engineering experience
- At least five years of experience in Designing and implementing data integration framework using Informatica PowerCenter
- At least five years of experience in Writing T-SQL queries and performing database performance tuning
- At least five years of experience in Troubleshooting to identify data issues and resolutions including fixing data discrepancies, resolving performance issues, addressing missing or duplicate data, correcting data type mismatches, and improving data quality through cleansing and validation
- At least five years of experience with Database platforms including SQL Server, Oracle, and DB2
Responsibilities
- Conduct business intelligence analysis.
- Design and develop enterprise and departmental business intelligence and data warehousing backend solutions.
- Conduct unit testing on peer developed code.
- Troubleshoot to identify data issues and resolutions including fixing data discrepancies, resolving performance issues, addressing missing or duplicate data, correcting data type mismatches, and improving data quality through cleansing and validation.
- Conduct code review in the development of tasks.
- Collaborate across business teams to gather and document business intelligence information.
- Design, implement, and test data warehouse applications in partnership with project leads, business analysts, and end-users.
- Utilize database platforms including SQL Server, Oracle, and DB2.
- Write T-SQL queries and perform database performance tuning.
- Design and implement data engineering processes to support business analytics and reporting.
- Develop and execute unit, system, performance, and regression testing on data integration mappings using Informatica PowerCenter.
- Create Source to Target Mapping Specifications for data integration development.
- Uphold established coding standards, perform code reviews, and improve standards to ensure compliance.
Benefits
- exceptional benefits and perks
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Number of Employees
1,001-5,000 employees
