Under limited supervision, complete large high complexity projects. Lead development efforts for assigned subject area, develop, document, and implement technical designs. Communicate with the customers, management, and team.
Responsible for review, design, analysis, new development, and modification of the systems. Responsible for the optimization and performance improvements of the new and existing code base. Responsibility include design and development of the batch and near-real time data integration processes, Business Intelligent (BI) solutions, development in heterogeneous databases environment, navigation through complex systems configuration.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Ensure accuracy and integrity of the data and applications through analysis, coding, writing clear documentation and problem resolution.
Analyze data structures content and ensure performance validity.
Design, code, test, and implement data integration solutions using modern techniques and programming language.
Design, code, test, and implements BI solutions, including report, dashboards, notifications, in support of the business requirements.
Provide high-level database development assistance in creating specific applications for businesses.
Participate in research and apply innovation at all levels of the software development process.
Work on multiple projects simultaneously and manage competing priorities.
Work harmoniously in a cross-functional teams including IT and business resources.
Function as technical lead and Subject Matter Expert (SME) on assigned projects.
Perform the role of the principal designer responsible for complex systems and their subsystems employing deep knowledge of current technology and tools, as well as relevant systems that are already existing.
Act as a coach or mentor to less experienced team members.
Provide excellent customer service by responding to and assisting with resolving issues and system outages.
Partake in production support activities and processes.
Lead development standards reviews and renovation efforts.
Adaptability - Maintaining effectiveness when experiencing major changes in work responsibilities or environment (e.g., people, processes, structure, or culture); adjusting effectively to change by exploring the benefits, trying new approaches, and collaborating with others to make the change successful.
Building Trusting Relationships - Using appropriate interpersonal styles to establish effective relationships with customers and internal partners; interacting with others in a way that promotes openness and trust and gives them confidence in one’s intentions.
Collaborating - Working cooperatively with others to help a team or work group achieve its goals.
Communication - Conveying information and ideas clearly and concisely to individuals or groups in an engaging manner that help them understand and retain the message; listening actively to others.
Continuous Learning - Actively identifying new areas for learning; regularly creating and taking advantage of learning opportunities; using newly gained knowledge and skill on the job and learning through their application.
Initiating Action - Taking prompt action to accomplish work goals; taking action to achieve results beyond what is required; being proactive.
Work Standards - Setting high standards of performance for self and others; assuming responsibility and accountability for successfully completing assignments or tasks; self-imposing standards of excellence rather than having standards imposed.
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 and, scripting.
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.
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.
Experience with SSAS (Tabular and Multidimensional).
Oracle and SQL Server experience is a plus.
Experience with Oracle/SQL replication implementation
Strong Microsoft Power BI experience.
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.
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.
Experience with Service Broker.
This job operates in a professional office environment indoors. Routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines.
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 is an Equal Opportunity/Affirmative Action Employer
Minorities/Females/Persons with Disabilities/Protected Veterans