For the given job description <<General Summary
The Sr Business Systems Database Software Engineer will be a key player in designing, implementing, and optimizing our data architecture to support our production, accounting, business intelligence, and financial reporting functions. This position will collaborate closely with cross-functional teams, including production, finance, technology and operations, to ensure seamless data integration and provide actionable insights for strategic decision-making.
Job Functions
Design, administer and maintain a robust and scalable data warehouse for our Solver-based Corporate Performance Management (CPM) system within the Microsoft Azure cloud environment.Utilize domain knowledge of production tracking tools such as ShotGrid and Ftrack to streamline data collection and analysis processes, feeding into the data warehouse.Manage Azure based SQL databases, ensure data integrity, performance and security for both the data warehouse and other relevant databases.Develop and optimize Python APIs to facilitate efficient and secure data access and retrieval from the data warehouse.Collaborate with Accounting and Finance departments to gather, transform and integrate financial data into the data warehouse architecture for accurate financial and operational reporting.Build comprehensive and insightful financial and operational reports, leveraging the data warehouse.Create and implement well-organized data collection processes and thoughtful schema taxonomies to ensure data accuracy, consistency and ease of reporting.Take a hands-on approach in a green space to build new financial and operational reporting processes and operations that span various departments and workflows.Provide ongoing support and troubleshooting for data-related issues, ensuring data quality and availability for reporting purposes.
Qualifications
5+ years of professional experience in Computer Science, Information Technology, Finance or a related field as a Database Architect, Database Engineer or similar role.Proficiency in Microsoft Azure services and architecture, with experience in designing and implementing cloud-based data warehousing solutions, required.Strong working knowledge of SQL databases, data modeling, and performance optimization techniques.Proven experience developing Python APIs for data retrieval and integration.Demonstrated ability to collaborate effectively with cross-functional teams, including production, finance, technology and operations departments.Expertise in working with production tracking tools such as ShotGrid and Ftrack.Advanced skills in Microsoft Excel for building financial and operational reports.Excellent problem-solving skills and the ability to navigate complex business and financial requirements.Strong communication skills, both written and verbal, with the ability to convey technical concepts to non-technical stakeholders.Self-motivated, detail-oriented and adaptable to changing business needs.A passion for continuous learning and a proactive attitude towards exploring advanced topics and emerging technologies.
Physical Demands and Work Environment
The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Physical demands: While performing the duties of this job, the employee is required to walk; stand; sit; use hands to operate standard office equipment; reach with hands and arms; balance; stoop; talk or hear both in person and by telephone. The employee must lift andor move up to 15 pounds. Vision abilities include close vision, distance vision, and the ability to adjust focus.Work environment: While performing the duties of this job, the employee works under typical office conditions and is exposed to variable indoor temperatures. The noise level is usually quiet or moderate.
Location
On-site in Hillsboro, OR  and also eligible for hybrid work  Remote Eligible.
Salary
Salary Is Commensurate With Skills And Experience.
Disclaimer
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified.
Please review our EMPLOYMENT DISCLAIMER and MATERIALS SUBMISSION AGREEMENT.>> the resume: <<Professional SummaryTo achieve a responsible position that gives me a chance to apply my innovative skills and knowledge. I aim to be a valuable member of the team that works dynamically towards success and growth of organization. Strong Knowledge in Electronics and computer Engineering background with 1+ experience as Automotive Embedded Software Engineer. Good Knowledge in simulation tools such as MATLAB and Simulink. Thorough Knowledge in CAN Communication and Basic knowledge in AUTOSAR Architecture. Familiar with Version control systems such as SVN, IBM Synergy, Clear case and requirements analysis tools such as Doors. Worked on all phases of V model software development and Version control systems. Communicated with the other Engineering personnel to coordinate the interrelated design and assure project completion. Coordinating with software and target teams to find bugs, testing debug build.
SkillsGuest servicesInventory control proceduresMerchandising expertiseLoss preventionCash register operationsProduct promotions
EducationNorthwestern Polytechnic University,CA.Expected inJan'16––M.S:Electrical and Computer Engineering-GPA:3.6Electrical and Computer Engineering 3.6Jawaharlal Nehru Institute of Technology,Expected inMay'14––Bachelors:Electronics and communication Engineering-GPA:3.4Electronics and communication Engineering 3.4
Work HistoryOneblood-Embedded SoftwareDeland,,India01/2016-07/2016Responsible for developing Safety and Engine related software.Special focus on areas such as CAN protocols.Embedded software component development for Engine ECU, and maintenance of existing software components.Supported all phases of the software development process (V - Model).Understand and negotiate specifications, designed and implemented code, created documents and descriptions maintained existing software.Stored, retrieved and manipulated data for close analysis of system capabilities.Prepared detailed reports concerning project specifications and activities.Worked effectively with design teams to ensure software solutions elevated client side experience.Defense Electronics Research Laboratory DLRL-Project TraineeCity,STATE,India11/2012-04/2013Undergone a training program in Industrial Automation, which gives a hands on experience in 8051 programming, AVR programming for Embedded Systems applications, Digital logic and Electronic Control, using commonly used transducers, sensors and output devices and components in automation and controlling.Projects Fault Management, TCS, India Responsible for development and testing of Fault management module.It contains the list of all the faults that a system can have.Fault Management basic functionality is to store the faults (current & previous ignition cycles) in EEPROM.It also supports clearing of the particular fault and also clearing of entire fault memory based on     the customer requirement.Event Data Recorder, TCS, India Responsible for development and testing of accident recorder modules.It is utilized to store the information identified with vehicle (e.g.Vehicle speed, Buckle switch status, Brake status, Airbag sensors) amid accident through CAN communication protocol Monitoring Various ECU's for Engine control, TCS, India Safety and preventive measures for engine ECU (Electronic Control Unit) are mainly considered.Different inputs from various modules like cruise control, Adaptive cruise control, Acceleration pedal etc.are considered and monitored.Concentrates on the security levels (Levels defines the cautions to be taken based on the priority of module failures) provided for different modules (driver safety is mainly considered).In critical cases pre-defined values are loaded for safety purpose.Drive by wire - electronic throttle valve system" on Altera DE2 FPGA board Programmed and configured Altera DE2 board to implement a "drive by wire - electronic throttle valve system.Interfaced Accelerator position sensor, Throttle position sensor, Throttle actuator motor (used a Servo Motor), relays, LEDs & LCD present on the board to the NIOS II software and to the NIOS II microprocessor present with in the Altera Cyclone II FPGA IC on the DE2 board Simulated the modules in Modelsim and synthesize on Altera Quartus II software.Accident avoidance system An Arduino based accident prevention using higher end alert mechanisms, which prevents the accidents by alerting the driver when he/she falls asleep.Project involves Arduino Uno - Atmega 328 Microcontroller to measure and counts the eye blink using IR sensor.It gets trigger from the sensor information to identify an accident.JNTU-H-Lab Assistant,,IndiaCurrent-CurrentMicroprocessor, Analog and Digital Communications.Hands on experience in Microprocessor, Analog and Digital Communications and E-Cad Laboratories.Monitor the lab setups and guide the students for the effective usage of labs.
SkillsDreamweaver, Assembly language, Automation, basic, C, C++, Cad, CSS, LCD, DOORS, Embedded Systems, focus, HTML, PHP, Java, Labview, logic, Mac OS, MATLAB, memory, Microprocessor, Microsoft Office, Office 3.0, SharePoint, Windows XP, Office Automation, Operating Systems, Programming, protocols, PSPICE, requirement, Safety, software development, switch, UNIX, Verilog, VHDL, Vista>>. The result is, No Fit

Fit assessment: No Fit