🌎
This job posting isn't available in all website languages

*Sr BI/ETL Database Developer

📁
Information Technology
💼
YRC
Thanks for your interest in the *Sr BI/ETL Database Developer position. Unfortunately this position has been closed but you can search our 888 open jobs by clicking here.

MINIMUM REQUIREMENTS

  • Bachelor’s degree specializing in computer science or equivalent work experience required.
  • 7+ years of experience with data warehouse technical architectures, ETL/ ELT, reporting/analytic tools.
  • Strong background with scripting to drive automation.
  • Sound knowledge of traditional as well as agile software development methodologies.
  • Ability to apply Database Design Principles (OLTP).
  • Solve complex technical problems and mentor/support other technical staff on data modeling and ETL related issues.
  • Ensure that data designs follow architectural best practices and appropriate business rules and data structures are designed for flexibility to support future business needs.
  • Implement best practices, version control and deployment strategies to ensure product quality, agility, and recoverability.
  • Translate Business requirements into Data Requirements. Understand the data elements and their domains; understand relationships among those elements and interdependencies between models.
  • Strong ability to carry out research and innovation.
  • Develop Logical Data Models, Physical Data Models, and Data Element Dictionaries.
  • Develop and implement SQL scripts, Stored Procedures and ETL processes
  • SQL-based and NoSQL-based technologies.
  • Data warehousing solutions
  • Detailed design and build of the enterprise data warehouse and data marts from inception through production support.
  • Develop a quality framework to ensure delivery of high-quality data and analyses to stakeholders
  • Be an advocate for best practices while balancing business value and reasonable practicality
  • Highly effective working in a team as well as working independently.

PREFERRED QUALIFICATIONS

  • Strong SQL Server and Oracle experience.
  • Experience with Oracle/SQL replication implementation
  • Strong Microsoft Power BI experience.
  • Experience with Service Broker.
  • Experience with Data Warehousing, Data Lake and Data Marts
  • Experience with cloud architecture and data repositories.
  • Experience with AWS services including S3, Data-pipeline and other big data technologies.
  • Experience with one or more scripting language(s) such as PowerShell or Python.
  • Knowledge of Git or TFS as well as common branching strategies and workflows.
  • Expert knowledge on various Data modeling techniques: OLTP (normalized), ODS, EDW (dimensional).
  • Data modeling tools (e.g. UML, ERWin, Enterprise Architect and Visio).
  • Knowledge of Industry Data Models.
  • Experience with SSAS (Tabular and Multidimensional).
  • Working knowledge in the creation of data infrastructure - such as views, stored procedures, ETL usage, real-time/streaming data integration.
  • Knowledge in developing data models compliant with non-functional enterprise requirements, such as security and performance guidelines.
  • Deep understanding of data flow diagrams, system architecture diagrams, functional and system analysis.
  • Understanding and hands-on experience of the Data Architecture, Data Quality, and Data Profiling concepts.
  • Problem solving attitude, eagerness to learn new tools and technologies, and a proactive approach to daily activities.
  • Good oral and written communication skills.
  • Strong initiative and organization skills.
  • Demonstrated experience in project management.

WORKING CONDITIONS

 

This job operates in a professional office environment indoors. Routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines.

 

PHYSICAL DEMANDS

 

The position requires the ability to spend long hours sitting or standing while using office equipment and computers. Ability to perform repetitive tasks such as typing and keying. Occasional lifting, pushing/pulling, carrying 10 lbs of supplies and materials is required.


 

YRC Worldwide, along with all subsidiary companies, are an Equal Opportunity/Affirmative Action Employer

Activity Feed

6478
Job shares through YRC Worldwide
Someone applied to the Casual Dock position. About a minute ago
Someone applied to the Dock Worker position. About a minute ago
Someone applied to the Billing Clerk PT Evenings - $17.50/Hour position. 17 minutes ago
Someone applied to the Dock Worker position. 17 minutes ago
Someone applied to the CDL Training Academy (09.28.20 Mobile Academy Class) position. 30 minutes ago

Similar Listings

YRC

Overland Park, Kansas, United States

📁 Information Technology

YRC

Overland Park, Kansas, United States

📁 Information Technology

YRC

Overland Park, Kansas, United States

📁 Information Technology