Robert Half Corporation Jobs

Job Information

Robert Half Sr. Enterprise Data Warehouse Engineer in CLEVELAND, Ohio

Description Essential Functions

• Translate business requirements into a star/snowflake schema data model

• Design and develop ETL processes to support population of the Enterprise Data Warehouse and general data movement needs

• Design, develop, and implement key reporting artifacts

• Support implemented DW/BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues

• Evolve the Enterprise Data Warehouse by working with IT management to develop a strategic roadmap for Data Warehousing and BI

• Work to empower business users to gain access to key data to allow them to report and analyze business information

• Establish and ensure compliance to database standards through the entire development life cycle

• Mentors DW/BI staff and provides feedback and guidance

• Plans complex DW/BI implementations and serves as Project Lead

• Other job-related duties as assigned

• Meet all compliance requirements

Knowledge, Skills & Abilities

• Strong analytical skills to solve and model complex business requirements

• Expert Level understanding of BI Best Practices/Methodologies, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques

• Ability to collaborate on a team with infrastructure, BI report development and business analyst resources, and clearly communicate solutions to both technical and non-technical audiences

• Knowledge of DW/BI user security design and management

• Ability to monitor performance of and tune complex DW and BI processes

• The ability to duplicate data on different servers using replication process

• Knowledge of RDBMS concepts, stored procedures and triggers

• Self-starter, with great analytical and communication skills

• Responsibilities for defining, altering, deleting, binding and managing database objects such as databases, table-spaces, partitions, tables, indexes, views, plans, and packages

• Project leadership/management skills

• Must be a team player

• Strong Microsoft SQL Server BI stack (Database, SSIS, SSAS, SSRS) skills

Education and Experience

• Bachelor’Microsoft Degree in Computer Science or other technical discipline or equivalent combination of education and experience

• 5+ years of experience in a complex data warehouse environment

• Hands-on Data warehousing project experience and experience in full life cycle Business Intelligence development, implementation, tuning and support

• Experience extracting reporting/analytics requirements from business users Requirements Microsoft SQL Server, SSIS SSRS, ETL - Extract Transform Load, Data Warehousing

Technology Doesn't Change the World, People Do.®

Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

Robert Half puts you in the best position to succeed by advocating on your behalf and promoting you to employers. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity – even on the go. Download the Robert Half app (https://www.roberthalf.com/mobile) and get 1-tap apply, instant notifications for AI-matched jobs, and more.

Questions? Call your local office at 1.888.490.4429. Robert Half will consider qualified applicants with criminal histories in a manner consistent with the requirements of the San Francisco Fair Chance Ordinance. All applicants applying for U.S. job openings must be authorized to work in the United States. Benefits are available to temporary professionals. Visit https://roberthalf.gobenefits.net/ for more information.

© 2022 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking “Apply Now,” you’re agreeing to Robert Half’s Terms of Use (https://www.roberthalf.com/terms-of-use) .

DirectEmployers